|
|
|
|
|
by ksherlock
4823 days ago
|
|
I started with MySQL and switched to Postgres. pl/sql, triggers, stored procedures, etc were the main thing at the time (this was before MySQL 5). It seems like Postgres gives you more power and flexibility at the expense of slightly more work. Consider an auto-incrementing column. in MySQL, you just create it as AUTO_INCREMENT. In postgres, you need to create a sequence generator table (which is actually no extra work if you create the column with a type of serial). But with postgres, you can have multiple auto incrementing columns in a table. MySQL is limited to 1 AUTO_INCREMENT per table. |
|