Oracle聽vs聽PostgreSQL

Need advice about which tool to choose?Ask the StackShare community!

Oracle

1.9K
1.5K
+ 1
109
PostgreSQL

78.8K
63.7K
+ 1
3.5K
Add tool

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.

Decisions about Oracle and PostgreSQL
Micha Mail盲nder
CEO & Co-Founder at Dechea | 14 upvotes 路 30.9K views

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.

See more
Daniel Moya
Data Engineer at Dimensigon | 4 upvotes 路 269.9K views

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.

See more
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Oracle
Pros of PostgreSQL
  • 42
    Reliable
  • 32
    Enterprise
  • 15
    High Availability
  • 5
    Hard to maintain
  • 5
    Expensive
  • 4
    Maintainable
  • 3
    Hard to use
  • 3
    High complexity
  • 754
    Relational database
  • 508
    High availability
  • 435
    Enterprise class database
  • 379
    Sql
  • 303
    Sql + nosql
  • 171
    Great community
  • 145
    Easy to setup
  • 130
    Heroku
  • 128
    Secure by default
  • 112
    Postgis
  • 48
    Supports Key-Value
  • 46
    Great JSON support
  • 32
    Cross platform
  • 30
    Extensible
  • 26
    Replication
  • 24
    Triggers
  • 22
    Rollback
  • 21
    Multiversion concurrency control
  • 20
    Open source
  • 17
    Heroku Add-on
  • 14
    Stable, Simple and Good Performance
  • 13
    Powerful
  • 12
    Lets be serious, what other SQL DB would you go for?
  • 9
    Good documentation
  • 7
    Scalable
  • 7
    Intelligent optimizer
  • 6
    Reliable
  • 6
    Transactional DDL
  • 6
    Modern
  • 5
    Free
  • 5
    One stop solution for all things sql no matter the os
  • 4
    Relational database with MVCC
  • 3
    Faster Development
  • 3
    Full-Text Search
  • 3
    Developer friendly
  • 2
    Excellent source code
  • 2
    search
  • 2
    Great DB for Transactional system or Application
  • 1
    Full-text
  • 1
    Free version
  • 1
    Open-source
  • 1
    Text

Sign up to add or upvote prosMake informed product decisions

Cons of Oracle
Cons of PostgreSQL
  • 13
    Expensive
  • 9
    Table/index bloatings

Sign up to add or upvote consMake informed product decisions

- No public GitHub repository available -

What is Oracle?

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.

What is PostgreSQL?

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.

Need advice about which tool to choose?Ask the StackShare community!

Jobs that mention Oracle and PostgreSQL as a desired skillset
CBRE
United States of America Texas Richardson
CBRE
United Kingdom of Great Britain and Northern Ireland England London
CBRE
United States of America Texas Richardson
CBRE
United States of America Texas Richardson
What companies use Oracle?
What companies use PostgreSQL?
See which teams inside your own company are using Oracle or PostgreSQL.
Sign up for StackShare EnterpriseLearn More

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with Oracle?
What tools integrate with PostgreSQL?

Sign up to get full access to all the tool integrationsMake informed product decisions

Blog Posts

Dec 8 2020 at 5:50PM

DigitalOcean

GitHubMySQLPostgreSQL+11
2
2110
Nov 20 2019 at 3:38AM

OneSignal

PostgreSQLRedisRuby+8
8
4201
Jul 9 2019 at 7:22PM

Blue Medora

DockerPostgreSQLNew Relic+8
11
1905
What are some alternatives to Oracle and PostgreSQL?
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
Workday
Workday is a leading provider of enterprise cloud applications for human resources and finance. Founded in 2005, Workday delivers human capital management, financial management, and analytics applications designed for the world鈥檚 largest organizations. Hundreds of companies, ranging from medium-sized businesses to Fortune 50 enterprises, have selected Workday.
Prophet
Prophet is a procedure for forecasting time series data. It is based on an additive model where non-linear trends are fit with yearly and weekly seasonality, plus holidays. It works best with daily periodicity data with at least one year of historical data. Prophet is robust to missing data, shifts in the trend, and large outliers.
IBM DB2
DB2 for Linux, UNIX, and Windows is optimized to deliver industry-leading performance across multiple workloads, while lowering administration, storage, development, and server costs.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
See all alternatives