postgresforeverything.com Open in urlscan Pro
2606:4700:3036::ac43:cf4d  Public Scan

Form analysis
0 forms found in the DOM

Text Content

POSTGRES FOR EVERYTHING

Unlock the full potential of PostgreSQL to streamline your technology stack.
Explore tailored solutions for various use cases, transforming how you develop
and deploy applications.

Caching

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.

Message Queue

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

Data Warehouse

Use Postgres with Timescale as a data warehouse

In-memory OLAP

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

Store JSON documents

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

Cron Demon

Use Postgres as a cron demon to take actions at certain times, like sending
mails, with pg_cron adding events to a message queue

Geospacial queries

Use Postgres for Geospacial queries

Fulltext Search

Use Postgres for Fulltext Search instead of Elastic

Generate and return JSON without backend

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

With auditing

Use Postgres with auditing with pgaudit

Deliver GraphQL

Use Postgres with a GraphQL adapter to deliver GraphQL if needed


ATTRIBUTION

All insights and technical guidance are derived from the article "Just Use
Postgres for Everything" by Stephan Schmidt, originally published on Amazing
CTO. For more details, visit the original article


CONTRIBUTION

If you would like to submit your use case please send me an email

--------------------------------------------------------------------------------

Made by Anton
Support this website