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.
The Search Box Is the Most Expensive Feature Nobody Asked For

The Search Box Is the Most Expensive Feature Nobody Asked For

Comments
6 min read
From Animation Storyboards to Adaptive Credit Intelligence: A Southeast Asia Liquid Clustering - Hong Kong Databricks FSI Community Day 2026

From Animation Storyboards to Adaptive Credit Intelligence: A Southeast Asia Liquid Clustering - Hong Kong Databricks FSI Community Day 2026

5
Comments
4 min read
Changing a Column Type in SQLite: The Table Rebuild and What It Deletes

Changing a Column Type in SQLite: The Table Rebuild and What It Deletes

Comments
8 min read
Engineering a Governed Asia FX Carry Platform with Databricks Lakeflow - Hong Kong Databricks FSI Community Day 2026

Engineering a Governed Asia FX Carry Platform with Databricks Lakeflow - Hong Kong Databricks FSI Community Day 2026

Comments
4 min read
Your Agent's JSON File Will Break. Here's When.

Your Agent's JSON File Will Break. Here's When.

Comments
3 min read
max(x) uses the index, max(x) FILTER (where ...) scans the table

max(x) uses the index, max(x) FILTER (where ...) scans the table

Comments
4 min read
Engineering a Governed Trading-Desk Control Plane with Databricks Lakeflow Designer and Connect - Hong Kong Databricks FSI Community Day 2026

Engineering a Governed Trading-Desk Control Plane with Databricks Lakeflow Designer and Connect - Hong Kong Databricks FSI Community Day 2026

Comments
4 min read
Your Demo Dashboard Is Not a Funnel: Auditing Synthetic Events in ClickHouse

Your Demo Dashboard Is Not a Funnel: Auditing Synthetic Events in ClickHouse

Comments
5 min read
A per-order margin ledger: reconciling what you quoted against what the carrier billed

A per-order margin ledger: reconciling what you quoted against what the carrier billed

Comments
4 min read
Spend an Hour Looking at the Real Data

Spend an Hour Looking at the Real Data

Comments
2 min read
Database MCP Server: Should an AI Agent Run SQL or Only Read the Schema?

Database MCP Server: Should an AI Agent Run SQL or Only Read the Schema?

Comments
7 min read
A PostgreSQL Role That Reads the Schema but Not the Data: What to Grant

A PostgreSQL Role That Reads the Schema but Not the Data: What to Grant

Comments
8 min read
ON DELETE SET NULL vs CASCADE vs RESTRICT in PostgreSQL: Which to Use

ON DELETE SET NULL vs CASCADE vs RESTRICT in PostgreSQL: Which to Use

Comments
8 min read
Every step was correct. The student still got refunded twice.

Every step was correct. The student still got refunded twice.

Comments 10
6 min read
CedarDB brings its new online data management service

CedarDB brings its new online data management service

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