Operating Systems > Linux and UNIX

Databases

<< < (2/2)

Master of Reality:
http://www.devshed.com/Server_Side/MySQL/Intro/page2.html
http://www.devshed.com/Server_Side/Administration/Database/page6.html
are two good pages i was looking at.

dbl221:
MySQL does not support foreign keys and therefor it does not enforce referential integrity...use postgresql...On the plus side MySQL is soooo fast.

Master of Reality:
I wonder if the Webmaster still uses MySQL for this forum.

badkarma:
Since about version 7.0 the speed of PostgreSQL has greatly improved. Also it can handle a lot more concurrent connections then MySQL. If you need simple web backend low query intensitive DB support use MySQL. If you plan on doing any serious DB work, use Postgres.....

voidmain:
Very true Karma.  I generally use PostgreSQL wherever possible because it is more robust. But there is one application in particular that I use MySQL for and that is for my "snort" IDS database. For some reason MySQL greatly outperforms PostgreSQL with when it comes to using "acid" to use/view the database when the database starts getting large (hundreds of thousands of records). But PostgreSQL is much more like the big boys...

Navigation

[0] Message Index

[*] Previous page