Page 1 of 1
Free DataBase Context
Posted: Mon Sep 08, 2003 8:23 pm
by d-m
I'd like to know with is the best free data base that you use.
MySql or Postgres
I use both, depens of the use, and of the client

Posted: Mon Sep 08, 2003 8:51 pm
by m3mn0n
Have not used Postgre yet because I've never needed to yet.
I'll get around to it one of these days...heh
Posted: Mon Sep 08, 2003 10:14 pm
by nigma
I am wondering what the advantage (if any) to using Postgre over mySQL?
Posted: Mon Sep 08, 2003 10:45 pm
by nielsene
PostGreSQL is designed as a Object Relational Database Management System that strives for a very high level of compliance with the SQL specs. MySQL is very non-compliant and is typically willing to trade off features for speed. For some people thats a fine trade.
Some of the features PostGreSQL offers that I beleive are lacking/weak in MySQL:
user defined types, functions, aggregates, operators
from clause join syntax
views, rules, triggers
integrity constraints (more complicated than simple foreign key ones)
All of these are features I use daily. Some of them have no reasonable workaround other than implementing in application code things that a DBMS should do for you.
Generally speaking an out of box install of PostGreSQL under-preforms MySQL when using non-transaction tables in MySQL and doing read only.
If you use MySQL's transaction tables and have moderate updates/insert/deletes the difference in preformance tends to become much less. If you allow expert "tuners" to help you configure your DB the difference normally vanishes.
Posted: Mon Sep 08, 2003 11:04 pm
by nigma
Thank you very much! I apreciate your very understandable explanation.
Posted: Tue Sep 09, 2003 12:15 am
by RobertStout
MySQL, although I may give the other a try eventually.