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
fixelsmith profile

Eight window-function tricks beyond LAG and ROW_NUMBER

#sql #analytics #frauddetection #database
Comments
6 min read
Every AI database answer needs a source trail
mads_hansen_27b33ebfee4c9 profile

Every AI database answer needs a source trail

#mcp #database #ai #postgres
Comments
1 min read
Database Connection Pooling: We Benchmarked 7 Strategies So You Don’t Have To
speed_engineer profile

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

#architecture #backend #database #performance
Comments
8 min read
Breakdown Database
ariscandra profile

Breakdown Database

#architecture #backend #database #systemdesign
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
falinapterus profile

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

#showdev #agents #database #rag
Comments 1
4 min read
The N+1 Query Problem
hasan-dev profile

The N+1 Query Problem

#rails #database #performance #interview
Comments 4
2 min read
Your Repository Isn't a Repository, It's a DAO
gabrielanhaia profile

Your Repository Isn't a Repository, It's a DAO

#php #architecture #hexagonal #database
Comments
9 min read
EF Core Named query filters
karenpayneoregon profile

EF Core Named query filters

#news #csharp #database #dotnet
1
Comments
3 min read
DuckDB EC2 Optimization, Postgres FDW Pushdown, SQLite NetBeans Connectivity
soytuber profile
soy

DuckDB EC2 Optimization, Postgres FDW Pushdown, SQLite NetBeans Connectivity

#database #sql #sqlite
1
Comments
4 min read
BigQuery, Snowflake, Redshift, Databricks, Fabric: where each one silently inflates your bill
engineersguide profile

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

#cloud #database #devops #dataengineering
Comments
11 min read
Approaches to tenancy in Postgres
meg528 profile

Approaches to tenancy in Postgres

#postgres #planetscale #webdev #database
1
Comments 1
12 min read
Building Translation Management Systems: Technical Architecture for Legal Document Processing
diogoheleno profile

Building Translation Management Systems: Technical Architecture for Legal Document Processing

#webdev #i18n #architecture #database
Comments
5 min read
Apache Fluss: Architecting the Streaming-First Persistent Data Stack
abhirajadhikary06 profile

Apache Fluss: Architecting the Streaming-First Persistent Data Stack

#architecture #database #dataengineering #systemdesign
Comments
3 min read
PHP Performance Optimization: OPcache, PHP-FPM, Caching & Profiling
safdarwahid profile

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

#backend #database #performance #php
Comments
8 min read
[🗄️DataBase] N+1 Query Problem
qq5yu profile

[🗄️DataBase] N+1 Query Problem

#database #backend #learning #webdev
3
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.