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.
Database Index: Why Queries Become Slow as Data Grows

Database Index: Why Queries Become Slow as Data Grows

5
Comments
3 min read
Serverless Bill Shock: Tracking Edge Function and Database Expirations (Vercel, Supabase, Netlify, Neon)

Serverless Bill Shock: Tracking Edge Function and Database Expirations (Vercel, Supabase, Netlify, Neon)

Comments
10 min read
Schema Linting vs Migration Linting: Which Database Problems Each One Can See

Schema Linting vs Migration Linting: Which Database Problems Each One Can See

Comments
11 min read
Your SQLite Upgrade Test Should Include the Crash Between Two Writes

Your SQLite Upgrade Test Should Include the Crash Between Two Writes

Comments
4 min read
Backups That You Don't Restore Aren't Backups: A Weekly Restore Drill

Backups That You Don't Restore Aren't Backups: A Weekly Restore Drill

Comments 1
6 min read
Snowflake Cortex Analyst vs Databricks Genie: Where Warehouse-Native AI Stops

Snowflake Cortex Analyst vs Databricks Genie: Where Warehouse-Native AI Stops

2
Comments
2 min read
"Money we gave back to shoppers" matches no table name. Four searches find it anyway.

"Money we gave back to shoppers" matches no table name. Four searches find it anyway.

Comments
4 min read
Advanced SQL: Mastering CTEs and Window Functions

Advanced SQL: Mastering CTEs and Window Functions

Comments
3 min read
Implement Paging,Top N and All query using JooqTemplate

Implement Paging,Top N and All query using JooqTemplate

Comments
1 min read
Data definition language and data manipulation language

Data definition language and data manipulation language

2
Comments
2 min read
Learn PostgreSQL extensibility through a gloriously bad idea: MM/DD/YYYY native datatype and GiST index

Learn PostgreSQL extensibility through a gloriously bad idea: MM/DD/YYYY native datatype and GiST index

2
Comments
16 min read
What is a database view?

What is a database view?

1
Comments
2 min read
Why AI-Generated Migrations Need a Different Gate Than Code Patches

Why AI-Generated Migrations Need a Different Gate Than Code Patches

Comments 1
4 min read
Replay AI-Generated Migrations Against a Throwaway Database Before You Merge Them

Replay AI-Generated Migrations Against a Throwaway Database Before You Merge Them

Comments
5 min read
Singleton: il pattern piĂą odiato ha le sue ragioni

Singleton: il pattern piĂą odiato ha le sue ragioni

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