Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
Advanced search

203 Posts in 191 Topics- by 2976 Members - Latest Member: sollurseses
« previous next »
Pages: [1]
Print
Author Topic: Which database is better  (Read 359 times)
titleless
Jr. Member
**
Offline Offline

Posts: 61



View Profile
« on: June 03, 2009, 02:00:45 AM »
MSSQL is more advanced with views, triggers, procedures, etc....


If you use MySQL, go with 5 or greater because views, procs are now in. But I think that's not as mature as MSSQL is on this.
And it's important to use innodb engine rather than myisam to ensure relational integrity between tables/data and to achieve transactions and a better concurency to the tables.

In my opinion PostgreSQL is better thant MySQL for enterprise class databases on the features side and the views, procs, trigggers are roughly tested because postgresql have these functionnalities since a long time ago.

For ordinary websites, forums, cms.. just go with mysql, for rock solid open source with PostgreSQL, and....... rock rock rock solid: oracle!
Logged
Pages: [1]
Print
« previous next »
Jump to: