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.
You've Tuned the Queries and It's Still Slow — Now Change the Data Model
danewu profile

You've Tuned the Queries and It's Still Slow — Now Change the Data Model

#rails #performance #database #postgres
Comments
7 min read
PostgreSQL HA Risks, Replication Internals, & Rapid Branching
soytuber profile
soy

PostgreSQL HA Risks, Replication Internals, & Rapid Branching

#database #sql #sqlite
Comments
3 min read
PostgreSQL 2200S Error: Causes and Solutions Complete Guide
dbmserror profile

PostgreSQL 2200S Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql
Comments
3 min read
Oracle ORA-00909 Error: Causes and Solutions Complete Guide
dbmserror profile

Oracle ORA-00909 Error: Causes and Solutions Complete Guide

#oracle #database #dba #sql
Comments
3 min read
Your Hand-Rolled Two-Phase Commit Between Two Databases Isn't Atomic
mattia_armas profile

Your Hand-Rolled Two-Phase Commit Between Two Databases Isn't Atomic

#database #backend #dotnet #architecture
Comments
3 min read
How to Choose the Right SQL Database for Your Project
rajatdh27 profile

How to Choose the Right SQL Database for Your Project

#sql #database #beginners #webdev
Comments
5 min read
Database Sharding Explained With Real Examples: How Apps Scale Beyond a Single Database
abdullahmubin profile

Database Sharding Explained With Real Examples: How Apps Scale Beyond a Single Database

#database #systemdesign #backend #architecture
Comments
4 min read
Database Indexes Explained Simply: Why Some Queries Take 1ms and Others Take 10 Seconds
abdullahmubin profile

Database Indexes Explained Simply: Why Some Queries Take 1ms and Others Take 10 Seconds

#database #performance #backend #architecture
Comments
4 min read
SQL - Order By, Limit and Offset
aliduyar profile

SQL - Order By, Limit and Offset

#sql #database #orderby #beginners
Comments
1 min read
Dynamic Column Updates in EF Core Without Hand-Rolling SQL Injection
mattia_armas profile

Dynamic Column Updates in EF Core Without Hand-Rolling SQL Injection

#dotnet #sql #api #database
Comments
3 min read
Postgres or ClickHouse? Row vs Column Storage, and When Each Wins
mattia_armas profile

Postgres or ClickHouse? Row vs Column Storage, and When Each Wins

#postgres #clickhouse #database #sql
Comments
3 min read
QuickBooks API Integration Guide for Developers
ilshadyx profile

QuickBooks API Integration Guide for Developers

#quickbooks #postgres #database #api
Comments
8 min read
PostgreSQL 2200N Error: Causes and Solutions Complete Guide
dbmserror profile

PostgreSQL 2200N Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql
Comments
3 min read
How we cut our Dagster Cloud bill by 60% by collapsing our dbt assets
osquarski profile

How we cut our Dagster Cloud bill by 60% by collapsing our dbt assets

#tutorial #devops #database
Comments
3 min read
I Fixed a 5s Database Bottleneck with CDC Dual-Writes
quarktimes profile

I Fixed a 5s Database Bottleneck with CDC Dual-Writes

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