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.
Use INSERT WITH CHECK and UPDATE USING to allow owner-on-create but block owner transfers

Use INSERT WITH CHECK and UPDATE USING to allow owner-on-create but block owner transfers

Comments
4 min read
Choosing a Database Isolation Strategy for Your First SaaS

Choosing a Database Isolation Strategy for Your First SaaS

Comments
3 min read
Why Your AI Coding Agents Suffer from Amnesia (And How I Fixed It with SQLite + ONNX)

Why Your AI Coding Agents Suffer from Amnesia (And How I Fixed It with SQLite + ONNX)

5
Comments
1 min read
Modelling a shared inbox: why the message is the primary key, not the conversation

Modelling a shared inbox: why the message is the primary key, not the conversation

Comments
2 min read
13 minutos de risco e um alerta calibrado para o desastre

13 minutos de risco e um alerta calibrado para o desastre

1
Comments
2 min read
5 Common SQL Mistakes: WHERE, ORDER BY, AND/OR, and Top 3 Queries

5 Common SQL Mistakes: WHERE, ORDER BY, AND/OR, and Top 3 Queries

Comments
3 min read
Building a pricing-first filter for 4,300 AI tools (and what the data looks like)

Building a pricing-first filter for 4,300 AI tools (and what the data looks like)

Comments
4 min read
VIDRAFT NL2SQL Engine Scores 83.80 on BIRD Mini-Dev, Above the Current #1, and Opens a Public Demo

VIDRAFT NL2SQL Engine Scores 83.80 on BIRD Mini-Dev, Above the Current #1, and Opens a Public Demo

Comments
3 min read
Database Indexing – Part 6: How Does PostgreSQL Decide Which Index to Use?

Database Indexing – Part 6: How Does PostgreSQL Decide Which Index to Use?

Comments
4 min read
Three Errors You Actually Hit Connecting Actions to GCP

Three Errors You Actually Hit Connecting Actions to GCP

1
Comments 1
4 min read
Apache Data Lakehouse Weekly: October 21-28, 2026

Apache Data Lakehouse Weekly: October 21-28, 2026

Comments
29 min read
TIL: Why `initnodedatamap` Is Required in GBase Database(GBase 8a)

TIL: Why `initnodedatamap` Is Required in GBase Database(GBase 8a)

2
Comments
3 min read
How to Install GBase Database(GBase 8a) on a Single-Node Cluster: A Step-by-Step Guide

How to Install GBase Database(GBase 8a) on a Single-Node Cluster: A Step-by-Step Guide

2
Comments 1
3 min read
TIL: What `p 1 d 0` Means in a GBase Database(GBase 8a) Single-Node Cluster

TIL: What `p 1 d 0` Means in a GBase Database(GBase 8a) Single-Node Cluster

2
Comments
4 min read
PostgreSQL 19 Release Candidate: What Shipped, What Was Cut, How to Upgrade

PostgreSQL 19 Release Candidate: What Shipped, What Was Cut, How to Upgrade

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