JavaScript API framework with ORM, migrations and vectors

The magical JavaScript API framework with ORM, migrations and vectors

Fast, Simple and a cost effective tool to replicate data from Postgres to Data Warehouses, Queues and Storage - GitHub - PeerDB-io/peerdb: Fast, Simple and a cost effective tool to replicate data f...

How we migrated from storing attachments as base64 strings in postgres to an Object Storage system

pgJQ: Use jq in Postgres. Contribute to Florents-Tselai/pgJQ development by creating an account on GitHub.

Have you seen this legendary SQL iceberg meme? Let's talk about it while wearing our PostgreSQL hat!

Build reactive, realtime, local-first apps directly on Postgres.

Local-first sync layer for web and mobile apps. Build reactive, realtime, local-first apps directly on Postgres. - GitHub - electric-sql/electric: Local-first sync layer for web and mobile apps. Bu...

Working with data at rest is where Postgres shines. But what about when you need data in motion? What about when you need to trigger a workflow based on changes to a table? Fortunately, Postgres comes with a lot of options to make this happen.

I recently had someone ask me why the COPY command is more performant than INSERT INTO. While coming up with an answer, I discovered I was starting from a deficient: I didn’t know how COPY works under the hood. Trying to come up with an answer was at best a guess. Through this post, I hope to narrow that knowledge gap and help myself and others get a deeper understanding of my favorite database.

In this four-part series, learn how to fine-tune your PostgreSQL database for performance as your data and query volume grow—starting with properly sizing your CPU and memory.

Hydra: Column-oriented Postgres. Add scalable analytics to your project in minutes.

Analytics Database For Modern SaaS. Column-oriented Postgres. Query billions of rows instantly without making code changes.

Build fast, scalable PostgreSQL and Rails apps. Solve data growth, quality, and reliability challenges, for workloads from consumer Internet to enterprise SaaS.

Replicate postgres to SQLite on the edge. Contribute to zknill/sqledge development by creating an account on GitHub.

A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.

Execute SQL now and get the results later. Contribute to tembo-io/pg_later development by creating an account on GitHub.

Introducing pg_later: Asynchronous Queries for Postgres, Inspired by Snowflake

How we got struck by 5–year–old implementation Recently we discovered that we were wrong on computing lock key for acquiring advisory locks. It was already covered as an update to article about building read models, but we thought that telling the whole story behind the issue could be interesting for you.

A PostgreSQL Docker container that automatically upgrades your database

Increase performance in pgvector by using embedding vectors with fewer dimensions

Tembo is the Postgres developer platform for building every application and data service. Collapse the database sprawl of the modern data stack with a unified developer platform.

A Language Server for Postgres. Contribute to supabase/postgres_lsp development by creating an account on GitHub.

PLJS - Javascript Language Plugin for PostreSQL. Contribute to plv8/pljs development by creating an account on GitHub.

Authors: Brad Nicholson, Andrew Tanner, Marco Montagna

PostgreSQL (Postgres), is a powerful relational database that can store a wide range of data types and data structures. When it comes to storing graph data structures we might reach for a database marketed for that use case like Neo4J or Dgraph. Hold your horses! While Postgres is not generally thou...

PostgreSQL provides the necessary building blocks for you to combine and create your own search engine for full-text search. Let's see how far we can take it.