Postgres can do more than you think

Transform Postgres into a distributed database — so you can achieve high performance at any scale with citus

Separate storage and compute to have autoscaling, code-like database branching, and scale to zero with neon (src)

Use Electric (src) to stream PostgreSQL changes to clients with shape-based, partial replication

Embed Postgres in browser with real-time and reactive bindings using PGlite (src) or instant (src)

Create Business intelligence and give everyone ability to work with data using Metabase (src) or evidence (src)

Use Postgres as alternative to Airtable to organize, render and integrate your data with NocoDB (src), appsmith (src), Baserow (src), or Teable (src)

Create SVG graphics with pg_svg

Render HTML or automatically build a UI on top of SQL queries using SQLPage (src), pg_render, plmustache, or Omnigres (src)

Stream/Replicate data from Postgres to Data Warehouses, Queues and Storage engines with PeerDB (src)

Listen to change events on your Postgres tables to perform appropriate actions using SQL notify, Walex, or debezium (src)

Serve a fully RESTful API from any existing PostgreSQL database with PostgREST (src)

Work with PDFs in an ACID-compliant way using pgpdf (src)

Store encrypted secrets and other data in your database with Supabase Vault

Store and handle JSON Web Tokens with pgjwt

Eliminate the need for separate systems and data transfers. Perform ML operations directly on your data where it resides. With PostgresML (src)

If you need a publish/subscribe or job server at any point in your project, try using Postgres

Instantly spin up an unlimited number of Postgres databases that run directly in your browser with database-build

If you need to make an HTTP requests from your SQL you can use pgsql-http or pg_net

Use Alternative Query Languages in Postgres with plprql (src) or pg_graphql

Use Postgres with foreign data via wrappers (src)

Use Postgres for Graph Data with Apache Age or Gel (src)

Use Postgres as NoSQL database with FerretDB or Microsoft DocumentDB

Also: Pongo (src), dox

Use Postgres as Column Oriented database with Hydra Columnar or cstore_fdw or ParadeDB pg_analytics and pg_lakehouse

Use Postgres with a GraphQL adapter to deliver GraphQL if needed. Also: PostGraphile, hasura (src)

Use Postgres for auditing with pgaudit (src)

Also: temporal_tables, supa_audit, pgMemento

Use Postgres to generate JSON in the database, write no server side code and directly give it to the API

Use Postgres for Fulltext Search instead of Elastic.

Also: ParadeDB (src), pgvector, Torus: seamlessly integrates search into Elixir (Ecto) (src), Postgres Full Text Search

Use Postgres for Geospatial queries (src)

Use Postgres as a cron daemon to take actions at certain times, like sending mails, with pg_cron or pg_timetable (src)

Use Postgres with JSONB to store Json documents in a database, search and index them - instead of Mongo

Use Postgres with pg_analytics as an in memory OLAP with Apache Datafusion

Use Postgres with TimescaleDB (src) as a time-series database

Use Postgres as a message queue with SKIP LOCKED instead of Kafka (if you only need a message queue). Or as a job queue in Go with River.

Also: Choose Postgres queue technology, PGMQ (src)

Use Postgres for caching instead of Redis with UNLOGGED tables and TEXT as a JSON data type. Use stored procedures to add and enforce an expiry date for the data just like in Redis.

Also: You Don't Need a Dedicated Cache Service, readyset (src)