Interesting read: Why PostgreSQL instead of MySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

User avatar
nathanr
Forum Contributor
Posts: 200
Joined: Wed Jun 07, 2006 5:46 pm

Post by nathanr »

ReverendDexter wrote:
superdezign wrote:PHP's growth has been pretty similar.
I never said I liked PHP, either :wink:
when compared to.... (thinks best of a bad bunch) - so far I've been through asp, perl, coldfusion, python and perl on the scripting side.. python+php being favs, c# is also rather nice in my opinion
User avatar
CoderGoblin
DevNet Resident
Posts: 1425
Joined: Tue Mar 16, 2004 10:03 am
Location: Aachen, Germany

Post by CoderGoblin »

nathanr wrote:I can see uses for postgre's increment's that run completely seperate to a table, thus allowing an auto_inc over say 5 tables, useful for doing merge tables etc.. this said though, I've got sites with 2000 queries a second being executed, and mysql holds up fine (after a bit of tweaking to get write/read locks working okay..)
One of our main applications for the firm I work for uses this functionality a lot. It is extremely useful to have something like categories/products/attributes as different tables but using the same sequence, even if not the same fieldname. You can join all the things mentioned to something like a "translation" table without having to worry about duplicate ids.

One of my major gripes (and bear in mind all this .... design for everything, usage of PDO, ADODB to handle both MySQL and Postgres etc), is the need to get the next sequence number prior to object creation rather than getting it after. I believe there is a bug outstanding in postgres PDO relating to this.

As an aside doing full text searching with postgres is easy once you get to grips with it although it is an additional module and no "specific table type" required.

I must admit an awful lot comes down to what you are used to. In my mind however (and for those of us who are old enough to remember...) I bear in mind Betamax vs VHS video... Betamax better quality viewing.... VHS had market share....
Post Reply