MYSQL vs POSTGRESQL

Hi Scott, I do understand your comment very well. I always do a bit of reading before doing anything (but not always enough). I believe Postgre is better in several ways. I read about the differences between the 2 SQL's and the "ACID" test. I also understand the difference in the way the two handle transactions. I selected MySQL only because the first use I have only needs a relatively small and not very critical database and I already have an application to start with that requires PHP and MySQL. This is all part of a learning curve. I'm planning to dump M$ Windoze completely from my small company before end of this year. First, I'll get something in place quickly and later I go back and improve. Thanks again for your advice, Joe J Fazenda wrote: > I've been through installing/configuring Linux, KDE, FTP (had small > problem I fixed myself), PHP (major screw-up) and next step will be > MySQL. Cool. Glad to hear you've had so much success in so little time. I'd recommend PostgreSQL over MySQL. People say that it is more difficult to install, but I don't think that's fair at all. And it's a much more solid database - it comes much, much closer to the definition of relational database used by the guy who invented the term. (Do a search for Codd's twelve rules if you want more information.) That probably won't mean much to you for a while, but it doesn't interfere (another common misconception - that having a correct structure makes it harder to use or significantly less efficient) and will eventually help you create a much more solid system. > Many thanks for you assistance and for your time, JF Glad to help. Scott