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.
Subqueries & CTEs: Breaking Complex Queries into Steps
fidel_okumu profile

Subqueries & CTEs: Breaking Complex Queries into Steps

#backend #database #sql #tutorial
1
Comments
2 min read
Database-per-Service is a Trap: Try Logical Schemas
nainikmehta profile

Database-per-Service is a Trap: Try Logical Schemas

#microservices #architecture #database #backend
2
Comments
3 min read
DDL and DML in PostgreSQL: Cleaning 286 Messy Hotel Bookings.
leahkivuti profile

DDL and DML in PostgreSQL: Cleaning 286 Messy Hotel Bookings.

#postgres #database #beginners #sql
Comments
8 min read
Building a Resilient Public Website with Azure Storage: High Availability, Soft Delete, and Blob Versioning in Action
sudaisib profile

Building a Resilient Public Website with Azure Storage: High Availability, Soft Delete, and Blob Versioning in Action

#cloudstorage #azure #cloudcomputing #database
5
Comments
5 min read
I Built a Distributed KV Store in Python. Here's What Broke and Why You Should Build One Too.
bharqav profile

I Built a Distributed KV Store in Python. Here's What Broke and Why You Should Build One Too.

#architecture #backend #database #python
Comments 1
9 min read
SQL Joins in PostgreSQL: Patients, Doctors, and the Rows That Go Missing
leahkivuti profile

SQL Joins in PostgreSQL: Patients, Doctors, and the Rows That Go Missing

#sql #postgres #database #beginners
Comments
7 min read
Building an agent harness that survives production
anya_summers_a5881a3d01ce profile

Building an agent harness that survives production

#agentskills #agents #ai #database
Comments
19 min read
Still Writing Slow SQL Queries? 10 Ways to Improve Performance
qodors profile
qodors

Still Writing Slow SQL Queries? 10 Ways to Improve Performance

#sql #database #webdev #performance
Comments
5 min read
DuckDB vs Pandas: Why Your Analytics Script Runs 10x Faster After One Switch
veilanalytics profile

DuckDB vs Pandas: Why Your Analytics Script Runs 10x Faster After One Switch

#python #database #datascience #performance
Comments 3
3 min read
SUBQUERIES and CTEs
elizabeth_njoroge_7c850b9 profile

SUBQUERIES and CTEs

#database #learning #sql #tutorial
Comments
1 min read
A dependency-free snapshot dashboard: http.server + sqlite3, and the ALTER TABLE trap
takahiro_hashito_a1f3f0dc profile

A dependency-free snapshot dashboard: http.server + sqlite3, and the ALTER TABLE trap

#python #database #webdev
Comments 1
5 min read
Your backfill is a photograph
enderyentar profile

Your backfill is a photograph

#postgres #sql #migrations #database
Comments
5 min read
Why I Stopped "Cleaning" Bad Data and Started Flagging It Instead
uttrai262005 profile

Why I Stopped "Cleaning" Bad Data and Started Flagging It Instead

#backend #database #programming #softwaredevelopment
1
Comments 1
4 min read
NicheDB 0.2.0: the domain layer, counted daily
chovy profile
chovy

NicheDB 0.2.0: the domain layer, counted daily

#api #cli #database #softwaredevelopment
Comments
3 min read
Why Full-Stack Developers Should Care More About Relational Data Modeling Than Frontend Frameworks
lucas_ventavele profile

Why Full-Stack Developers Should Care More About Relational Data Modeling Than Frontend Frameworks

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