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.
Processing 1 Million Events Per Day Without Breaking the Bank (Or Your Database)
le_beltagy profile

Processing 1 Million Events Per Day Without Breaking the Bank (Or Your Database)

#performance #database #scalability #optimization
6
Comments 3
3 min read
Apache Data Lakehouse Weekly: July 11 to July 18, 2026
alexmercedcoder profile

Apache Data Lakehouse Weekly: July 11 to July 18, 2026

#news #database #dataengineering #opensource
1
Comments
25 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
I built a Postgres migration linter that simulates your migration instead of pattern-matching SQL
d_security profile

I built a Postgres migration linter that simulates your migration instead of pattern-matching SQL

#rust #postgres #database #opensource
1
Comments 2
5 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
SQL - Order By, Limit and Offset
aliduyar profile

SQL - Order By, Limit and Offset

#sql #database #orderby #beginners
Comments
1 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
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
SQL Basics Explained: DDL, DML, Filtering, and CASE WHEN
itsweshy profile

SQL Basics Explained: DDL, DML, Filtering, and CASE WHEN

#beginners #database #sql
2
Comments 2
4 min read
QuickBooks API Integration Guide for Developers
ilshadyx profile

QuickBooks API Integration Guide for Developers

#quickbooks #postgres #database #api
Comments
8 min read
Dynamic SOQL Without Getting Burned
praveenlavu profile

Dynamic SOQL Without Getting Burned

#backend #database #security #sql
Comments
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.