Porting Oracle to PostgreSQL/MySQL

[andreela]

Hello,

In our company we're planning from to move from Oracle to someother database, preferably PostgreSQL or MySQL. Which one do you'll advise us to use. Our database is quite large. Any suggestion will be appreciated.

Thanks,

[shu]

I personally think PostgreSQL is the better choice. Not only it offer superior functionalities, it has better standard compliance, concurrency, and yes, even speed! Why would anyone developing a serious database choose MySQL is beyond my understanding.

[chriskl]

If you are porting from Oracle, then you REALLY need to choose PostgreSQL. MySQL does not have stored procedures, subselects, triggers, views, domains, schemas, FK's that cascade, and lots more.

There is information on porting from Oracle to PostgreSQL here:

http://techdocs.postgresql.org/#convertfrom

Cheers,

Chris

[andreela]

Thank you both for your valuable suggestions.

[[deleted]]

I can only agree with the other guys, PostgreSQL is your only option because MySQL does not yet even support subqueries.

[jim_keller]

I'm probably beating a dead horse here but I would say Postgres as well. I personally use mySQL because of its speed, but for people who are used to the functionality of Oracle, Postgres will be your best choice.

[[deleted]]

What kind of applications do you build that make you say that mysql is faster than postgresql?

And are you talking about the overall application speed or just the queries (because the queries have to be so very simple that they can only be be fast)