PostgreSQL
Enterprise-grade open source relational database
21.9k stars 5.9k forks last commit first released
Actively maintained
Last commit 26 Aug 2026.
PostgreSQL is a powerful open source object-relational database management system focused on standards compliance, correctness, and extensibility. It supports advanced SQL features while providing a mature foundation for transactional and analytical workloads.
Key Features
- ACID transactions with concurrency control and robust crash recovery
- Advanced SQL support including constraints, foreign keys, triggers, views, and window functions
- Extensibility via custom data types, functions, operators, and extensions
- Rich indexing options (including B-tree, GiST, GIN, BRIN) and full-text search
- Replication features including streaming replication and logical replication
- Security features such as role-based access control and fine-grained privileges
Use Cases
- Primary relational database for web and business applications
- Geospatial and location-aware systems (commonly via PostGIS)
- Data warehousing and analytics workloads requiring strong SQL capabilities
PostgreSQL is widely used in production for its reliability, performance, and extensible architecture. It fits both small deployments and large-scale systems where data integrity and advanced querying are critical.
Categories:
Tags:
Tech Stack:
Similar to PostgreSQL
MySQL
Open source relational database management system
MySQL is an open source relational database for SQL-based transactional and analytical workloads, supporting replication, high availability, and clustering options.
Bytebase
Database DevSecOps platform for schema change and access governance
Open-source database DevSecOps tool for managing schema migrations, SQL review, audit logging, access control, and data masking across multiple databases.
CloudBeaver
Web-based database manager for SQL and NoSQL data sources
CloudBeaver is an open-source, web-based database manager for teams, offering a browser SQL editor, data browsing/editing, and administration for many databases.
NocoDB
No-code spreadsheet interface for SQL databases with APIs
Open-source Airtable alternative that turns Postgres/MySQL/SQLite into a no-code spreadsheet UI with views, permissions, integrations, and REST APIs.
ClickHouse
Fast open-source columnar database for real-time analytics.
Open-source OLAP database designed for real-time analytics at scale.
Teable
Spreadsheet-like database app builder for PostgreSQL
Teable is an Airtable alternative for building database apps with a spreadsheet UI, multiple views, real-time collaboration, and a plugin system, backed by PostgreSQL.