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
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
Federation and the Lakehouse: Two Roads to Unified Data Access, and How to Know Which One to Take
alexmercedcoder profile

Federation and the Lakehouse: Two Roads to Unified Data Access, and How to Know Which One to Take

#architecture #data #database #dataengineering
Comments 1
21 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
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
Deep Dive into GBase 8a MPP Distributed Query Execution
michaelfv profile

Deep Dive into GBase 8a MPP Distributed Query Execution

#gbase #database #数据库 #performance
2
Comments
3 min read
GBase 8a Table Design in Practice: Choosing Distribution Keys, Partitions, and Replicated Tables
michaelfv profile

GBase 8a Table Design in Practice: Choosing Distribution Keys, Partitions, and Replicated Tables

#gbase #database #数据库 #performance
2
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.