PostgreSQL
The advanced open-source relational database.
Overview
PostgreSQL is a powerful, reliable and standards-compliant relational database that has been developed for over 30 years. It is known for data integrity, rich SQL features and extensibility, and runs everything from small applications to very large systems.
It supports JSON, full-text search, window functions, replication and extensions such as PostGIS, making it a strong default choice for new projects.
Where it is used
- Web and mobile application back-ends
- Data warehousing and analytics
- Geospatial data (with PostGIS)
- Replacing commercial databases
Run PostgreSQL with Docker
docker run --name pg -e POSTGRES_PASSWORD=change-me -p 5432:5432 -d postgres
docker exec -it pg psql -U postgresWhat you will cover
The key topics and features of PostgreSQL
ACID Compliance
Reliable transactions and data integrity.
JSON Support
Store and query JSON documents alongside relational data.
Full-Text Search
Built-in text searching capabilities.
Extensions
PostGIS, pg_trgm, TimescaleDB and many more.
Replication
High availability and read scaling.
Performance
Advanced indexing and a capable query planner.