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.
Eight window-function tricks beyond LAG and ROW_NUMBER

Eight window-function tricks beyond LAG and ROW_NUMBER

Comments
6 min read
Every AI database answer needs a source trail

Every AI database answer needs a source trail

Comments
1 min read
Database Connection Pooling: We Benchmarked 7 Strategies So You Don’t Have To

Database Connection Pooling: We Benchmarked 7 Strategies So You Don’t Have To

Comments
8 min read
Breakdown Database

Breakdown Database

Comments
1 min read
Why your AI agent can't tell when two sources are lying to each other — and what I built to fix it

Why your AI agent can't tell when two sources are lying to each other — and what I built to fix it

Comments 1
4 min read
The N+1 Query Problem

The N+1 Query Problem

Comments 4
2 min read
Build a Notes App with ctrodb, Tailwind CSS, and Vanilla JavaScript

Build a Notes App with ctrodb, Tailwind CSS, and Vanilla JavaScript

1
Comments
7 min read
BigQuery, Snowflake, Redshift, Databricks, Fabric: where each one silently inflates your bill

BigQuery, Snowflake, Redshift, Databricks, Fabric: where each one silently inflates your bill

Comments
11 min read
React State Management Without Redux or Zustand

React State Management Without Redux or Zustand

6
Comments
2 min read
Turso: A Rust Rewrite of SQLite. Setup Guide and Whether It's Worth Your Time

Turso: A Rust Rewrite of SQLite. Setup Guide and Whether It's Worth Your Time

11
Comments 2
5 min read
Approaches to tenancy in Postgres

Approaches to tenancy in Postgres

1
Comments 1
12 min read
How I Used Redis to Stop My Football Web App From Hammering the Database

How I Used Redis to Stop My Football Web App From Hammering the Database

Comments
5 min read
Building Translation Management Systems: Technical Architecture for Legal Document Processing

Building Translation Management Systems: Technical Architecture for Legal Document Processing

Comments
5 min read
Apache Fluss: Architecting the Streaming-First Persistent Data Stack

Apache Fluss: Architecting the Streaming-First Persistent Data Stack

Comments
3 min read
PHP Performance Optimization: OPcache, PHP-FPM, Caching & Profiling

PHP Performance Optimization: OPcache, PHP-FPM, Caching & Profiling

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