PostgreSQL is the unsung hero of database engines, soundly trouncing mySQL in almost every aspect.
Resources
| Category | Date | Link | Notes |
|---|---|---|---|
| Extensions | 2023 | pgvector | Open-source vector similarity search for Postgres |
| 2016 | cstore_fdw | a columnar store that supports the ORC format |
|
| Libraries | 2024 | Pongo | a library that treats PostgreSQL as a MongoDB-like document database |
| Ports | pglite | Lightweight Postgres packaged as WASM for the browser |
|
| Tools | 2025 | kuvasz-streamer | a lightweight open source CDC service that enables high performance, low latency replication. |
| Mathesar | a spreadsheet-like interface to work with Postgres databases |
||
| 2016 | pev | a query plan visualizer |