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.
max(x) uses the index, max(x) FILTER (where ...) scans the table
daniel_pertu profile

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

#postgres #performance #database #webdev
Comments
4 min read
Engineering a Governed Trading-Desk Control Plane with Databricks Lakeflow Designer and Connect - Hong Kong Databricks FSI Community Day 2026
martindd profile

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

#architecture #data #database
Comments
4 min read
Your Demo Dashboard Is Not a Funnel: Auditing Synthetic Events in ClickHouse
sensorflow profile

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

#analytics #database #sql #opensource
Comments
5 min read
A per-order margin ledger: reconciling what you quoted against what the carrier billed
fulfillnexa profile
life

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

#backend #database #sql
Comments
4 min read
Spend an Hour Looking at the Real Data
asael_shinder_9f53bdca840 profile

Spend an Hour Looking at the Real Data

#asaelshinder #learning #data #database
Comments
2 min read
ON DELETE SET NULL vs CASCADE vs RESTRICT in PostgreSQL: Which to Use
tbson87 profile

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

#postgres #database #sql #webdev
Comments
8 min read
A PostgreSQL Role That Reads the Schema but Not the Data: What to Grant
tbson87 profile

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

#postgres #database #security #sql
Comments
8 min read
Database MCP Server: Should an AI Agent Run SQL or Only Read the Schema?
tbson87 profile

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

#ai #postgres #database #security
Comments
7 min read
Every step was correct. The student still got refunded twice.
alt-f6 profile

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

#postgres #database #testing #typescript
Comments 10
6 min read
CedarDB brings its new online data management service
hacksgr profile

CedarDB brings its new online data management service

#cedardb #postgres #database #cloud
Comments
2 min read
I Tried to Make Natural Language a SQL Predicate. The Numbers Said No.
yudeeswaran profile

I Tried to Make Natural Language a SQL Predicate. The Numbers Said No.

#machinelearning #ai #database #python
Comments
7 min read
SQL Window Functions Explained
sguantai profile

SQL Window Functions Explained

#beginners #database #sql #tutorial
Comments
4 min read
"A second operation was started on this context" — the EF Core bug that only shows up under load
developerimranahmed profile

"A second operation was started on this context" — the EF Core bug that only shows up under load

#csharp #database #debugging #dotnet
Comments 1
3 min read
5 Lessons I Learned Building API-Driven Fintech Products
jayden_cristian profile

5 Lessons I Learned Building API-Driven Fintech Products

#webdev #api #database
Comments
2 min read
The three-object CRM data model that ends your data silos
alexboissonneault profile

The three-object CRM data model that ends your data silos

#crm #database #revops #saas
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.