Overall Satisfaction with Oracle Database
The Engineering and Business Intelligence teams use Oracle Database as their primary data store. The Oracle Databases serves as a data warehouse that powers all of our applications. Oracle Database is very reliable and performant. With its many features, it can easily be queried in a SQL client or connected to any application (Java in our case).
- Great SQL client that allows for advanced querying.
- Extensive support for stored procedures, functions, materialized views, windowing functions, and other useful SQL operations.
- Stable. Oracle Database has been around for many years and has a large developer community.
- High performing and reliable Database means fewer database problems (we only needed a single DBA).
- Oracle certifications are fairly common and can be an easy way to filter and identify quality SQL developers. Saves time in the search process.
- Vast amounts of Oracle community forums and blogs provide easy and accessible support for various issues.
Oracle Database is as good as any of the other relational databases I've used. The main reason why I would personally choose to use MySQL or Postgres over Oracle is that those options are free, and provide the same functionality. Today there are so many options that make it easy to setup and manage a DB (ie: Amazon RDS), so getting a lower costing DB makes a lot of sense to me.