Rick Shelton wrote: > I currently have PHP installed with PostgreSQL support. > I need to fast-track a project. The fastest way is to follow > examples from a book using PHP and MySQL. > > Are there any differences between writing complex > PHP code for MySQL and PostgreSQL? > Or should I just install MySQL and reinstall PHP? > > thanks > ~rick
Hi, Yes there are quite a few differences between Postgresql and MySQL in syntax, SQL implementation (PGSQL is fully ACID compliant whereas MySQL is apparently not), and in stored and procedures triggers to note just a few areas. Abstracting the db layer is always a good idea; look in the PEAR or PECL repositories - there are couple of excellent abstraction libraries which mean you will only need to change one define in a config file to change the db platform; assuming your actual syntax is portable of course :-) If you aren't doing anything too complex with your SQL then you will "probably" be safe, but they are quite different beasts so take care when testing between db architectures (especially at the extremes of inputs like zero & null handling, and length of types are sometimes not the same between platforms, e.g. BIGINT...) Hope this helps a bit and of course YMMV. Alan -- http://linuxfromscratch.org/mailman/listinfo/blfs-support FAQ: http://www.linuxfromscratch.org/blfs/faq.html Unsubscribe: See the above information page
