It is more a philosophic question which part of the software should do automatic casting. Fact is, postgresql doesn't do it any more and breaks s9y.
Perhaps I might help getting s9y running on pgsql - simply as I want to use both of them in future.
Question is if you should build a small Framework with object-oriented methods. So you can declare most of the SQL-Statements for all databases. Those who differ are overwritten in a database-specific include. So you have to explicitly load a database-specific driver for your database. I really can't imagine a good/fast solution otherwise.
On the other hand there are some lets call it "mysql-Emulation" funktions available for pgsql. As far as I know openx.org works with this. (but I doubt this might help with casts).
Holger Mitterwald am um :
It is more a philosophic question which part of the software should do automatic casting. Fact is, postgresql doesn't do it any more and breaks s9y.
Perhaps I might help getting s9y running on pgsql - simply as I want to use both of them in future.
Question is if you should build a small Framework with object-oriented methods. So you can declare most of the SQL-Statements for all databases. Those who differ are overwritten in a database-specific include. So you have to explicitly load a database-specific driver for your database. I really can't imagine a good/fast solution otherwise.
On the other hand there are some lets call it "mysql-Emulation" funktions available for pgsql. As far as I know openx.org works with this. (but I doubt this might help with casts).
AO am um :
Garvin - the TLD / forum seems to be down / unavailable. AO
Garvin am um :
Thanks a lot. Will contact jannis.