| Re: Postgre support and more |
| by Mithrandir on 2003/11/26 13:01:57 Quote:
True - that can cause big problems. Quote: the module.sql file modules provide is MySQL only, so we have to find a way to translate this file or provide a generic schema format that would be translated to "native" sql, etc.... Isn't that the responsibility of the module developer? Of course it is good with some guidelines and genereal help - but the responsibility should lie with the module developer, if he wants his module to support other databases. |
| Re: Postgre support and more |
| by skalpa on 2003/11/25 22:57:18 Well it's more or less about this, but there are a lot of things to consider. Different DB systems aren't exactly using the same SQL syntax, they also differ in the way they handle blob columns, some features aren't supported by all of them, the module.sql file modules provide is MySQL only, so we have to find a way to translate this file or provide a generic schema format that would be translated to "native" sql, etc....  I've been deeply looking at ADOdb lately (it's a db abstraction layer that handles all those kind of things) but it has a real effect on performance, so I'm still searching for the best thing we could implement. And it's not a question of minutes  Skalpa.> |
| Re: Postgre support and more |
| by Per4orm on 2003/11/25 21:43:42 I'm not sure if it's all as simple as that, to be honest. I know for example that the MySql and Postgre versions of PhpMyAdsNew are distributed as seperate applications and not one application with two different databases. I'm not sure what the restrictions are, but it's deffo worth looking into. |
| Postgre support and more |
| by Mithrandir on 2003/11/25 21:39:50 Maybe this is just a stupid question, but will it be very hard to make XOOPS compatible with Postgre and more databases? Weeding through the PHP manual, I find functions for Postgre and Oracle side-by-side with MySQL functions. Isn't it "just" a matter of making a PostgreDatabase to extend the Database class? What am I overlooking? |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|