DEV Community

#postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Building a POS System Using Node.js and PostgreSQL

Building a POS System Using Node.js and PostgreSQL

Comments
3 min read
Forgekit: An Open-Source Next.js AI Starter Kit with RAG and pgvector

Forgekit: An Open-Source Next.js AI Starter Kit with RAG and pgvector

Comments
11 min read
Supabase Backups and Point-in-Time Recovery: What Each Plan Includes, What It Costs, and a Restore Drill You Can Run on the Free Plan

Supabase Backups and Point-in-Time Recovery: What Each Plan Includes, What It Costs, and a Restore Drill You Can Run on the Free Plan

1
Comments 1
6 min read
Five production bugs from running a 20-language AI song generator on Next.js

Five production bugs from running a 20-language AI song generator on Next.js

Comments
4 min read
Pagination That Skips Rows Is an Off-by-One in the Data Model

Pagination That Skips Rows Is an Off-by-One in the Data Model

Comments
3 min read
Postgres NOTIFY Is a Doorbell, Not a Queue: Build a Worker That Survives kill -9

Postgres NOTIFY Is a Doorbell, Not a Queue: Build a Worker That Survives kill -9

3
Comments 4
9 min read
Database Indexing – Part 5: Sequential Scan vs. Index Scan vs. Bitmap Index Scan in PostgreSQL

Database Indexing – Part 5: Sequential Scan vs. Index Scan vs. Bitmap Index Scan in PostgreSQL

Comments
6 min read
ERP Development: Sync Your App and ERP With a Postgres Outbox

ERP Development: Sync Your App and ERP With a Postgres Outbox

Comments
6 min read
A tamper-evident audit log in PostgreSQL with hash chains and HMAC

A tamper-evident audit log in PostgreSQL with hash chains and HMAC

2
Comments 3
6 min read
The Interval Is Still the Thing: Booking Cottages with Range Types in .NET 10

The Interval Is Still the Thing: Booking Cottages with Range Types in .NET 10

Comments
8 min read
Is the Supabase anon key safe in your frontend? What actually protects your data

Is the Supabase anon key safe in your frontend? What actually protects your data

Comments
6 min read
RLS was enabled and tenants could still read each other's data — the SECURITY DEFINER hole, and the query that catches it

RLS was enabled and tenants could still read each other's data — the SECURITY DEFINER hole, and the query that catches it

Comments
2 min read
Our plan limits have no counter column, the rows are the count, and a refund is a DELETE

Our plan limits have no counter column, the rows are the count, and a refund is a DELETE

Comments
7 min read
cache() memoises a function, not a query, so our two wrappers over one row by id fetched it twice

cache() memoises a function, not a query, so our two wrappers over one row by id fetched it twice

Comments
5 min read
Filtering Data in SQL: A Beginner’s Guide to WHERE, AND, LIKE, and Other Operators

Filtering Data in SQL: A Beginner’s Guide to WHERE, AND, LIKE, and Other Operators

1
Comments 1
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.