On 3/12/07, Alan Lord <[EMAIL PROTECTED]> wrote: > 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 >
thanks for your input! between these responses and some further research, i think i'll keep the system as is, no new software, follow the examples from the book, and just be _really_ careful about the db-specific calls. this is only for an academic project, so the database interaction shouldn't be too involved, just enough to demonstrate proper usage. of course, in a production environment i'd be hounding anything that looked like an expert for weeks on end. thanks again. -- http://linuxfromscratch.org/mailman/listinfo/blfs-support FAQ: http://www.linuxfromscratch.org/blfs/faq.html Unsubscribe: See the above information page
