DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Building a "Sell Anything" Product Catalog in Postgres: JSONB + a Typed Shadow Index

Building a "Sell Anything" Product Catalog in Postgres: JSONB + a Typed Shadow Index

1
Comments 1
6 min read
Cutting RAG Token Bloat: Compression Before Retrieval in Production Pipelines

Cutting RAG Token Bloat: Compression Before Retrieval in Production Pipelines

1
Comments 1
4 min read
TIL: Map the Node Roles Before Installing GBase Database

TIL: Map the Node Roles Before Installing GBase Database

2
Comments
4 min read
GBase Database Installation Errors: 5 Package and License Problems and How to Fix Them

GBase Database Installation Errors: 5 Package and License Problems and How to Fix Them

2
Comments
5 min read
GBase Database Commercial Installation: A Step-by-Step Guide to License Loading

GBase Database Commercial Installation: A Step-by-Step Guide to License Loading

2
Comments
5 min read
TIL: GBase Database Cluster Shows `close` After Installation? Check the License First

TIL: GBase Database Cluster Shows `close` After Installation? Check the License First

2
Comments
5 min read
JSONB, Dynamic Columns, or a Search Engine — How Do You Store Tenant-Defined Fields?

JSONB, Dynamic Columns, or a Search Engine — How Do You Store Tenant-Defined Fields?

1
Comments 4
2 min read
Stop Indexing Boolean Columns in PostgreSQL. Do This Instead.

Stop Indexing Boolean Columns in PostgreSQL. Do This Instead.

7
Comments 2
3 min read
pg_dump on Supabase: "query would be affected by row-level security policy"

pg_dump on Supabase: "query would be affected by row-level security policy"

Comments
2 min read
Performance Engineering: Measure Before You Optimize

Performance Engineering: Measure Before You Optimize

Comments
8 min read
Best erwin Data Modeler Alternatives: SQLDBM, ER/Studio & Hackolade Compared

Best erwin Data Modeler Alternatives: SQLDBM, ER/Studio & Hackolade Compared

Comments
10 min read
Your database says "saved" before it touches the table. Here's why that's safe.

Your database says "saved" before it touches the table. Here's why that's safe.

1
Comments 1
5 min read
SQL for Beginners

SQL for Beginners

Comments
4 min read
ChatGPT serves 800 million users from one Postgres primary. Here's how 🐘

ChatGPT serves 800 million users from one Postgres primary. Here's how 🐘

10
Comments
3 min read
Lalibela's builders carved downward. Some of your deploys are the same

Lalibela's builders carved downward. Some of your deploys are the same

Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.