Each database provides slightly different column types. SQLite doesn't really care on the front end (though internally the declared type of a column has an influence), but DB platforms do. This has to be taken into account of in the declared schema for the platform. Even with PDO, some SQL is unavoidable. Each platform speaks a slightly different dialect. The connection.php file contains the methods to translate code into the dialect appropriate for that platform. Habari generally uses MySQL-speak when SQL is necessary, then translates that to each platform's dialect. Each platform also has a different way to connect to the DB. These connection differences also have to be taken into account, which they are in the platforms connect.php file. Finally, there is the matter of upgrading. Compare the MySQL upgrade scripts directory to that for SQLite. You'll see major differences. The same thing needs to be done for each supported platform.
The background work that Postgres needs to make it work with the basic table schema in version 0.6 hasn't been done. Rick On Apr 8, 6:10 am, Eugene Wee <[email protected]> wrote: > Hi, > > On Wed, Apr 8, 2009 at 4:11 PM, Andy C <[email protected]> wrote: > > > I'm curious about this. As I understand it, Habari uses PHP Data > > Objects (PDO) as an abstraction layer for 'database independence'. > > > Obviously each supported DB platform needs to have hooks in the > > installer process and a schema/upgrade files to be actively maintained > > but shouldn't anything that uses PDO to manipulate data in the > > database work for all database platforms. Isn't that the whole point ? > > PDO provides a consistent interface in PHP for working with databases. > It does not provide database abstraction, so differences in SQL > dialect between database vendors still needs to be dealt with. > > Regards, > Eugene Wee --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/habari-dev -~----------~----~----~----~------~----~------~--~---
