2 ms·

oracle is great, has lots of great tools, and seems to be pretty solid. It is also ridiculously expensive. I have found Postgres to be essentially equal to it

by cmollis 11y ago

oracle is great, has lots of great tools, and seems to be pretty solid. It is also ridiculously expensive. I have found Postgres to be essentially equal to it in terms of programmability (triggers, stored procedures) and.. it's free. It keeps getting better.. lots of larger scale startups use it (like instagram), and is essentially eating Oracle.. particularly where Oracle plays best (at the fortune 100 corporate level). Most of my clients have plans to migrate to it, or are actively doing that. I've used Mysql for smaller stuff and it's ok..why use it when you have postgres. The license is better anyway. Haven't used MSSQL in years, but it's very good (on Windows).

thorin 11y ago
Oracle XE is good, free and still pretty good but you are limited to small(ish) amounts of data. You can do most of your testing and dev with it though. There are a number of options such as Standard One which offer pretty cheap licenses for most of the functionality you'd need to compete with Postgres and MSSql. That said, I've had great experiences with Postres and MSSql too, it's just that I learnt all my core db stuff from Oracle 7 and moved on from there. I haven't bothered with mysql for some time. I think I'd always go for Postgres in preference. MSSQL and Oracle have many advantages when working in coporate/enterprise environments and you probably won't have to worry about licensing costs so much then!