Need advice about which tool to choose?Ask the StackShare community!
Oracle vs PostgreSQL: What are the differences?
Developers describe Oracle as "An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism". Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database. On the other hand, PostgreSQL is detailed as "A powerful, open source object-relational database system". PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
Oracle and PostgreSQL can be categorized as "Databases" tools.
"Reliable" is the top reason why over 36 developers like Oracle, while over 744 developers mention "Relational database" as the leading cause for choosing PostgreSQL.
PostgreSQL is an open source tool with 5.44K GitHub stars and 1.8K GitHub forks. Here's a link to PostgreSQL's open source repository on GitHub.
Uber Technologies, Spotify, and Netflix are some of the popular companies that use PostgreSQL, whereas Oracle is used by Netflix, ebay, and LinkedIn. PostgreSQL has a broader approval, being mentioned in 2739 company stacks & 2169 developers stacks; compared to Oracle, which is listed in 106 company stacks and 92 developer stacks.
Fauna is a serverless database where you store data as JSON. Also, you have build in a HTTP GraphQL interface with a full authentication & authorization layer. That means you can skip your Backend and call it directly from the Frontend. With the power, that you can write data transformation function within Fauna with her own language called FQL, we're getting a blazing fast application.
Also, Fauna takes care about scaling and backups (All data are sharded on three different locations on the globe). That means we can fully focus on writing business logic and don't have to worry anymore about infrastructure.
We have chosen Tibero over Oracle because we want to offer a PL/SQL-as-a-Service that the users can deploy in any Cloud without concerns from our website at some standard cost. With Oracle Database, developers would have to worry about what they implement and the related costs of each feature but the licensing model from Tibero is just 1 price and we have all features included, so we don't have to worry and developers using our SQLaaS neither. PostgreSQL would be open source. We have chosen Tibero over Oracle because we want to offer a PL/SQL that you can deploy in any Cloud without concerns. PostgreSQL would be the open source option but we need to offer an SQLaaS with encryption and more enterprise features in the background and best value option we have found, it was Tibero Database for PL/SQL-based applications.
Pros of Oracle
- Reliable42
- Enterprise32
- High Availability15
- Hard to maintain5
- Expensive5
- Maintainable4
- Hard to use3
- High complexity3
Pros of PostgreSQL
- Relational database754
- High availability508
- Enterprise class database435
- Sql379
- Sql + nosql303
- Great community171
- Easy to setup145
- Heroku130
- Secure by default128
- Postgis112
- Supports Key-Value48
- Great JSON support46
- Cross platform32
- Extensible30
- Replication26
- Triggers24
- Rollback22
- Multiversion concurrency control21
- Open source20
- Heroku Add-on17
- Stable, Simple and Good Performance14
- Powerful13
- Lets be serious, what other SQL DB would you go for?12
- Good documentation9
- Scalable7
- Intelligent optimizer7
- Reliable6
- Transactional DDL6
- Modern6
- Free5
- One stop solution for all things sql no matter the os5
- Relational database with MVCC4
- Faster Development3
- Full-Text Search3
- Developer friendly3
- Excellent source code2
- search2
- Great DB for Transactional system or Application2
- Full-text1
- Free version1
- Open-source1
- Text1
Sign up to add or upvote prosMake informed product decisions
Cons of Oracle
- Expensive13
Cons of PostgreSQL
- Table/index bloatings9