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.
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
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
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
Why Big Tech is Migrating from Traditional Databases to NewSQL
dinhphu2k1gif profile

Why Big Tech is Migrating from Traditional Databases to NewSQL

#bigdata #dataengineering #database #sql
1
Comments
1 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
Understanding The Concept Of ElasticSearch
winnerx0 profile
Winner

Understanding The Concept Of ElasticSearch

#backend #beginners #database #tutorial
1
Comments 1
2 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
PgPool2 & PostgreSQL — Bypass SCRAM entirely, use MD5
arn-ob profile
Arnob

PgPool2 & PostgreSQL — Bypass SCRAM entirely, use MD5

#database #postgres #security #tutorial
Comments
2 min read
Extended RUM in DocumentDB extension for PostgreSQL: Efficient ESR (Equality, Sort, Range) Queries
franckpachot profile

Extended RUM in DocumentDB extension for PostgreSQL: Efficient ESR (Equality, Sort, Range) Queries

#postgres #sql #document #database
Comments
7 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
Automating Oracle EBS Data Entry - A Consultant's Guide to Faster Data Loading
john_head_e12f64b1282314a profile

Automating Oracle EBS Data Entry - A Consultant's Guide to Faster Data Loading

#automation #software #database #data
1
Comments
6 min read
DuckDB 1.5.2 & DuckLake v1.0 Debut, Plus Embedded SQLite in Scripting Engines
soytuber profile
soy

DuckDB 1.5.2 & DuckLake v1.0 Debut, Plus Embedded SQLite in Scripting Engines

#database #sql #sqlite
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.