Toby Er... MySQL supports transactions as well (with InnoDB tables) but Diggy is right postgresql is more fully featured IIRC foreign keys/subselects etc etc. It can run on Windows but needs quite a bit of setup... http://www.ejip.net/faq/postgresql_win_setup_faq.jsp Cheers Rich
-----Original Message----- From: toby z [mailto:[EMAIL PROTECTED]] Sent: 28 November 2002 09:50 To: Diggy Bell; [EMAIL PROTECTED] Subject: Re: [PHP-WIN] Re: help with db selection with php ............. thnx a million diggy pardon my ignorance ..... i think postgre only works with freebsd, unix,linx or solaris can it work with windows ????? 2ndly how much will i get to pay fo it if i get to pay ..... (rite now im searchin thru http://www.pgsql.com/ .... :$) 3rd i ve to get an alternative for visual practice developed in fox pro so i guess i HAVE to run what ever i run on windows 4th can freebird work with windows .... i think it works with interbase what can i do ?????? plz tell ..... thnx a zillion again ....... lost as ever toby ..... --- Diggy Bell <[EMAIL PROTECTED]> wrote: > Toby, > > Either MySQL or PostgreSQL are good database alternatives. I'm > more of a > hardcore database person so I prefer PostgreSQL because of it's > support for > transactions. I've also found the SQL grammar in PostgreSQL to be > a little > more standard. Another option would be the Firebird project > (http://firebird.sourceforge.net/). It was originally the > Interbase product > from Borland. > > Coming from FoxPro, either database is going to be a nice step up > in the > world. The main thing to keep in mind is that you'll have to pay a > bit more > attention to some of the standard database things like > normalization and > referential integrity. > > > -- > William D. 'Diggy' Bell > Principal > DB Software Development > http://www.dbsoftdev.com > > "Toby z" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > > > > ok guyz i need some inside info ..... > > > > plz help me with: > > > > > > 1. if i ve to conver a db in foxpro to mysql or sql which one > should > > i preffer to use with php and y ???? > > > > > > 2. and while im converting the foxpro db to mysql what will i ve > to > > loose ???? the common pitfalls ...... > > > > > > 3. there aint no foreign keys in mysql then what can i do about > > cascading updates, deletes and all > > > > > > 5. n finally do i have anyother choice of open source database > > (cheapest if not completely free) for this conversion ????? > > > > > > > > id be eternally gratefull if anyone cud guide me thru this ...... > > > > > > thnx a billion zillion guyz ..... > > > > toby ...... > > > > > > __________________________________________________ > > Do You Yahoo!? > > Everything you'll ever need on one web page > > from News and Sport to Email and Music Charts > > http://uk.my.yahoo.com > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
