PostgreSQL logo

PostgreSQL

A powerful, open source object-relational database system
95.5K
80K
+ 1
3.5K

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.
PostgreSQL is a tool in the Databases category of a tech stack.
PostgreSQL is an open source tool with 14.5K GitHub stars and 4.3K GitHub forks. Here’s a link to PostgreSQL's open source repository on GitHub

Who uses PostgreSQL?

Companies
6511 companies reportedly use PostgreSQL in their tech stacks, including Uber, Netflix, and Instagram.

Developers
85919 developers on StackShare have stated that they use PostgreSQL.

PostgreSQL Integrations

Datadog, Slick, Amazon DynamoDB, JSON, and Entity Framework are some of the popular tools that integrate with PostgreSQL. Here's a list of all 434 tools that integrate with PostgreSQL.
Pros of PostgreSQL
762
Relational database
510
High availability
439
Enterprise class database
383
Sql
304
Sql + nosql
173
Great community
147
Easy to setup
131
Heroku
130
Secure by default
113
Postgis
50
Supports Key-Value
48
Great JSON support
34
Cross platform
32
Extensible
28
Replication
26
Triggers
23
Rollback
22
Multiversion concurrency control
21
Open source
18
Heroku Add-on
17
Stable, Simple and Good Performance
15
Powerful
13
Lets be serious, what other SQL DB would you go for?
11
Good documentation
8
Intelligent optimizer
8
Free
8
Scalable
8
Reliable
7
Transactional DDL
7
Modern
6
One stop solution for all things sql no matter the os
5
Relational database with MVCC
5
Faster Development
4
Developer friendly
4
Full-Text Search
3
Free version
3
Great DB for Transactional system or Application
3
Relational datanbase
3
search
3
Open-source
3
Excellent source code
2
Full-text
2
Text
0
Native
Decisions about PostgreSQL

Here are some stack decisions, common use cases and reviews by companies and developers who chose PostgreSQL in their tech stack.

Needs advice
on
ExpressJSExpressJSNext.jsNext.js
and
PostgreSQLPostgreSQL

Hello, I am building a website for a school that's used by students to find Zoom meeting links, view their marks, and check course materials. It is also used by the teachers to put the meeting links, students' marks, and course materials.

I created a similar website using HTML, CSS, PHP, and MySQL. Now I want to implement this project using some frameworks: Next.js, ExpressJS and use PostgreSQL instead of MYSQL

I want to have some advice on whether these are enough to implement my project

See more
Needs advice
on
ExpressJSExpressJS
and
Next.jsNext.js

Hello, I am building a website for a school that's used by students to find Zoom meeting links, view their marks, and check course materials. It is also used by the teachers to put the meeting links, students' marks, and course materials.

I created a similar website using HTML, CSS, PHP, and MySQL. Now I want to implement this project using some frameworks: Next.js, ExpressJS and use PostgreSQL instead of MYSQL

I want to have some advice on whether these are enough to implement my project.

See more
dagim debebe
Needs advice
on
ExpressJSExpressJSReactReact
and
React NativeReact Native

Hi,

I am a student and a junior developer who is a graduating candidate in comp sci major. I am about to start building my final year project which is a real-time messaging application for software developers to Enhance Knowledge Exchange and Problem Solving. It is mainly a chat application with more enhanced features. I am planning to use React and React Native for the frontend and cross-platform mobile apps, Node.js and ExpressJS for the backend, GraphQL for fetching and manipulating data from the backend and PostgreSQL for the database, and finally Socket.IO for the real-time chatting and communication. I would highly appreciate it if anyone here with experience in building similar apps to tell me if I made a good choice or suggest better tech stacks.

Thanks in advance.

See more
Needs advice
on
PostgreSQLPostgreSQL
and
PrestoPresto

Hello experts,

I am trying to get a comprehensive list of the differences in syntax between Presto and PostgreSQL.

Is there an official documentation where I can find it? Is one a subset of another (as in all commands of presto are in Postgres or vice versa)?

See more
Needs advice
on
HerokuHeroku
and
PythonAnywherePythonAnywhere

I am a Business Analyst, and just completed my Python course and need to start work on a website. I need to host my site, and I am considering Heroku, PythonAnywhere, or GoDaddy (I have purchased a domain from godaddy). For the site, I will be using Python, HTML, CSS, JavaScript, Django, and db MySQL to start with and then move to PostgreSQL.

See more
Needs advice
on
GolangGolangKotlinKotlin
and
TypeScriptTypeScript

I want to try out backend development by making a somewhat simple finance tracker web app and intend to use PostgreSQL, but I have very little knowledge of the area and would like to know which language and accompanying framework would be best suited.

My preferences would be between Kotlin (I already know Java) and Golang or TypeScript, but other recommendations are welcome.

I also know a bit of Rust from doing Advent of Code with it, but I would instead use something easier for now.

See more

Blog Posts

Dec 8 2020 at 5:50PM

DigitalOcean

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

OneSignal

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

Blue Medora

DockerPostgreSQLNew Relic+8
11
2335

PostgreSQL Alternatives & Comparisons

What are some alternatives to 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.
MariaDB
Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry. MariaDB is designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance.
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.
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.
SQLite
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
See all alternatives

PostgreSQL's Followers
79990 developers follow PostgreSQL to keep up with related blogs and decisions.