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 Optimization Techniques for High-Traffic Laravel Applications

Database Optimization Techniques for High-Traffic Laravel Applications

Comments
4 min read
QN : Ingest and transform data in a lakehouse

QN : Ingest and transform data in a lakehouse

Comments
2 min read
DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem

DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem

Comments
4 min read
Update record using JooqTemplate

Update record using JooqTemplate

Comments
1 min read
Retention cohort analysis with plain SQL

Retention cohort analysis with plain SQL

Comments
2 min read
PostgreSQL 22013 Error: Causes and Solutions Complete Guide

PostgreSQL 22013 Error: Causes and Solutions Complete Guide

1
Comments
3 min read
Self-Host Postgres or Use Supabase? Here's How to Decide

Self-Host Postgres or Use Supabase? Here's How to Decide

Comments
3 min read
T-SQL patterns that break when you migrate SQL Server to PostgreSQL (and where they hide in Java/C#)

T-SQL patterns that break when you migrate SQL Server to PostgreSQL (and where they hide in Java/C#)

Comments
1 min read
Best Practices for Database Schema Migrations in Large Systems

Best Practices for Database Schema Migrations in Large Systems

Comments
1 min read
From Clean CSVs to Production‑Shaped Data: A Practical Guide for Academic ML and Data Engineering

From Clean CSVs to Production‑Shaped Data: A Practical Guide for Academic ML and Data Engineering

Comments
5 min read
I Built a Write-Ahead Log in Pure Python and Finally Understood How Databases Survive Crashes

I Built a Write-Ahead Log in Pure Python and Finally Understood How Databases Survive Crashes

Comments
7 min read
I Built a Columnar File Format in Pure Python — a tiny, readable Parquet

I Built a Columnar File Format in Pure Python — a tiny, readable Parquet

Comments
6 min read
Why Big Tech is Migrating from Traditional Databases to NewSQL

Why Big Tech is Migrating from Traditional Databases to NewSQL

1
Comments
1 min read
Day 14 of #100DaysOfClickHouse: Understanding Nodes, Shards, and Replicas

Day 14 of #100DaysOfClickHouse: Understanding Nodes, Shards, and Replicas

3
Comments
3 min read
Understanding The Concept Of ElasticSearch

Understanding The Concept Of ElasticSearch

1
Comments 1
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.