Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2009-05-15 15:34:13
- zam3858
- New Member
- Registered: 2009-05-15
- Posts: 4
I'm in a competition to get TextPattern running on MSSQL and IIS
Yes it’s funky, I know. :)
It’s a competition to get an applications with limited or no support for IIS/MSSQL to run on those stuffs. I was assigned to TextPattern and so for 14 days, I’d get to work on TextPattern. it’s at http://lamp2win.com if anybody is curious.
I’m trying to stick to Txp’s development style (architecture n code) but at the same time i noticed that there is no support for other DB. I could be wrong, I was just assigned today and had about 30 minutes or so to look at the code. So I’m wondering if you guys have any thought on how you think it should be done. I’m thinking of putting a DB abstraction inside TextPattern (something i can try to coin up in 2 weeks) or maybe, a simple if-else here n there. I don’t know.
Another reason for posting here is to see if there’s anybody might be interested/need for TextPattern to run on MSSQL+IIS setup. If there is, that’ll be an extra motivation for me to get it up n running.
Thanks everyone.
Offline
Re: I'm in a competition to get TextPattern running on MSSQL and IIS
zam3858 wrote:
I’m thinking of putting a DB abstraction inside TextPattern (something i can try to coin up in 2 weeks) or maybe, a simple if-else here n there.
In keeping with Textpattern’s speed, I would venture to say that PDO would be the best choice for an abstraction layer.
RM 2000 equates to 563.44 dollars, seems like a cheap way to bring LAMP projects over to Windows.
We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make
Offline
#3 2009-05-15 16:10:05
- net-carver
- Archived Plugin Author
- Registered: 2006-03-08
- Posts: 1,648
Re: I'm in a competition to get TextPattern running on MSSQL and IIS
zam3858
Some work was done on DB abstraction in the Crockery branch of the Txp code. I’ve not looked at it myself but that might help.
— Steve
Offline
Re: I'm in a competition to get TextPattern running on MSSQL and IIS
Not sure if it’s any use, but I had good success with ADODB. It might be a bit heavyweight, though you could only include the bits you need I suppose. The good news is that most (if not all) of the database processing in TXP is done in one file so it’s pretty easy to drop in the library support.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
#5 2009-05-16 07:46:13
- zam3858
- New Member
- Registered: 2009-05-15
- Posts: 4
Re: I'm in a competition to get TextPattern running on MSSQL and IIS
Thanks everyone! I will first look into crockery(thanks net-carver) and then PDO (thanks hcgtv). ADODB is cool and there is a lighter version of it I think. but i’ll try to keep textpattern’s dependency to a minimum.
btw hcgtv, USD560 is cheap but there’s always the intangible rewards. but for USD560 you can help a programmer get a pretty decent lunch for about 200++ days. ;)
thanks again!
Last edited by zam3858 (2009-05-16 07:47:26)
Offline
#6 2009-05-16 08:16:37
- net-carver
- Archived Plugin Author
- Registered: 2006-03-08
- Posts: 1,648
Re: I'm in a competition to get TextPattern running on MSSQL and IIS
zam3858 wrote:
Thanks everyone!
You’re welcome. Hope you manage to get this done btw.
…for USD560 you can help a programmer get a pretty decent lunch for about 200++ days. ;)
Ya, jika programmer itu tinggal di Malaysia! ;)
— Steve
Offline
#7 2009-05-18 03:59:27
- zam3858
- New Member
- Registered: 2009-05-15
- Posts: 4
Re: I'm in a competition to get TextPattern running on MSSQL and IIS
Ya, jika programmer itu tinggal di Malaysia! ;)
had a good surprise and laugh on this one. “intangible rewards”. :)
Offline
#8 2009-05-18 05:09:36
- net-carver
- Archived Plugin Author
- Registered: 2006-03-08
- Posts: 1,648
Re: I'm in a competition to get TextPattern running on MSSQL and IIS
zam3858
When will you know the competition results? Are you based KL side?
— Steve
Offline
#9 2009-05-18 07:04:00
- zam3858
- New Member
- Registered: 2009-05-15
- Posts: 4
Re: I'm in a competition to get TextPattern running on MSSQL and IIS
The results will be out in 30th May.
And yes I’m working in KL, Ampang area. Are you coming down here for OSCON?
Offline
#10 2009-05-18 12:51:24
- net-carver
- Archived Plugin Author
- Registered: 2006-03-08
- Posts: 1,648
Re: I'm in a competition to get TextPattern running on MSSQL and IIS
zam3858 wrote:
Are you coming down here for OSCON?
Hmmm, that’s a thought. I need to go to Jalan Ampang as it happens, probably that week too. Will let you know if I book for it.
— Steve
Offline