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.
Retention cohort analysis with plain SQL
zenovay profile

Retention cohort analysis with plain SQL

#sql #analytics #database #webdev
Comments
2 min read
PostgreSQL 22013 Error: Causes and Solutions Complete Guide
dbmserror profile

PostgreSQL 22013 Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql
1
Comments
3 min read
T-SQL patterns that break when you migrate SQL Server to PostgreSQL (and where they hide in Java/C#)
tacioalves profile

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

#backend #database #postgres #sql
Comments
1 min read
Self-Host Postgres or Use Supabase? Here's How to Decide
pavel-hostim profile
Pavel

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

#postgres #supabase #database #devops
Comments
3 min read
The Vector Database Index for RAG (2026)
srijan_paudel_d9837a5d8fd profile

The Vector Database Index for RAG (2026)

#ai #database #rag #machinelearning
Comments
2 min read
Best Practices for Database Schema Migrations in Large Systems
jefersoneiji profile

Best Practices for Database Schema Migrations in Large Systems

#softwareengineering #database #migrations #devops
Comments
1 min read
QL AI Database Solutions: Building a Text-to-SQL Pipeline You Can Actually Run
diego_fabrizioandianava profile

QL AI Database Solutions: Building a Text-to-SQL Pipeline You Can Actually Run

#ai #sql #python #database
Comments 1
5 min read
From Clean CSVs to Production‑Shaped Data: A Practical Guide for Academic ML and Data Engineering
jitendra_devabhaktuni_0f1 profile

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

#ai #database #datascience #dataengineering
Comments
5 min read
I Built a Write-Ahead Log in Pure Python and Finally Understood How Databases Survive Crashes
hajirufai profile

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

#python #database #dataengineering #programming
Comments
7 min read
I Built a Columnar File Format in Pure Python — a tiny, readable Parquet
hajirufai profile

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

#python #dataengineering #database #programming
Comments
6 min read
Day 14 of #100DaysOfClickHouse: Understanding Nodes, Shards, and Replicas
kanishga_subramani_49ad73 profile

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

#clickhouse #devops #analytics #database
3
Comments
3 min read
From Individual Sandbox to Multiplayer: Group Rooms, Linked Servers, and Gamification in T-SQL Online
abdiel_ortega_5866744e706 profile

From Individual Sandbox to Multiplayer: Group Rooms, Linked Servers, and Gamification in T-SQL Online

#showdev #database #sql #webdev
1
Comments
1 min read
When PostgreSQL Isn't the Right Fit: Recognizing Workloads That Need Different Architecture
tigerdata_dev profile

When PostgreSQL Isn't the Right Fit: Recognizing Workloads That Need Different Architecture

#postgres #database #architecture #developers
Comments
6 min read
GBase 8a Table Design and Modeling: Choosing Data Types, Partitions, Distribution Keys, and Replicated Tables
michaelfv profile

GBase 8a Table Design and Modeling: Choosing Data Types, Partitions, Distribution Keys, and Replicated Tables

#gbase #database #数据库 #performance
2
Comments
3 min read
How to Pick the Perfect Database Without Losing Your Mind
gauravbytes profile

How to Pick the Perfect Database Without Losing Your Mind

#database #webdev #architecture #systemdesign
Comments
8 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.