Welcome to Geeklog, Anonymous Friday, September 22 2023 @ 09:03 pm EDT

Comments for What Database System do you prefer?

What Database System do you prefer? | 10 comments | Create New Account

The following comments are owned by whomever posted them. This site is not responsible for what they say.

Postgres vs MySql

Authored by: Anonymous (Anonymous User) on Thursday, December 06 2001 @ 01:04 pm EST

As someone else mentioned, many people start with MySQL and 'grow into' Postgres..

I have had that experience. Initially, PG seemed to have too much unneeded complexity, the configuration was a bit more esoteric (hey we are talking DBMS's here :-) and many of the non-INSERT/UPDATE/SELECT commands were different.

But things like transactions are actually massively more useful that some MySQL advocates would make out. You don't need to be writing a banking application to make transactions extremely useful. Sequences also are a lot more useful than AUTO INCREMENT.

Interesting reading on the pros and cons can be found in this PHPBuilder article. Keep in mind that since that article, many improvements have happened to postgres, including the abolishment of the 8K row limit (I beleive) and stability is now rock-solid. Performance is now right up there too.

I still have lots of respect for MySQL, and I'm using it for my current DB-Driven project. It's speedy, lightweight, and in this particular case it does everything I need.

Postgres vs MySql

Authored by: Anonymous (Anonymous User) on Saturday, December 08 2001 @ 11:20 am EST

yeah dure

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks