Free DataBase Context

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply

In your opinion with is the best free data base ? Why!??

MySql
8
89%
Postgres
1
11%
 
Total votes: 9

User avatar
d-m
Forum Commoner
Posts: 31
Joined: Fri Aug 29, 2003 4:24 pm
Location: Rio de Janeiro - RJ - Brasil

Free DataBase Context

Post 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 :lol:
Last edited by d-m on Tue Sep 09, 2003 9:26 am, edited 3 times in total.
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post 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
User avatar
nigma
DevNet Resident
Posts: 1094
Joined: Sat Jan 25, 2003 1:49 am

Post by nigma »

I am wondering what the advantage (if any) to using Postgre over mySQL?
User avatar
nielsene
DevNet Resident
Posts: 1834
Joined: Fri Aug 16, 2002 8:57 am
Location: Watertown, MA

Post 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.
User avatar
nigma
DevNet Resident
Posts: 1094
Joined: Sat Jan 25, 2003 1:49 am

Post by nigma »

Thank you very much! I apreciate your very understandable explanation.
User avatar
RobertStout
Forum Commoner
Posts: 32
Joined: Wed Sep 03, 2003 5:21 pm
Location: Your backyard.

Post by RobertStout »

MySQL, although I may give the other a try eventually.
Post Reply