[wp-hackers] GSoC Proposal: Multiple RDBMS support

[Joseph Scott]

On Mar 30, 2008, at 4:30 PM, Olexandr Melnyk wrote:

> I'm aware of two
> MySQLisms used by WordPress. One are fulltext indexes, which aren't
> really MySQL-specific, as I have pointed above, but have
> a more varying
> syntax for lookups among databases than other common SQL statements.
>
> Another are enum columns, which on other databases can be replaced by
> varchars with appropriate domains. Abstracting this shouldn't  
> affect any
> code, except for the table creation SQL dump.


Without suggesting that this is a good idea or not, another issue you  
are going to run into is DBs that use auto_increment style fields  
versus others that use sequences.  This makes how you get unique IDs  
when doing an insert a challenge.  Not impossible to over come, just  
something to be aware of.

--
Joseph Scott
joseph at randomnetworks.com
http://joseph.randomnetworks.com/