Database Page 54 - DEV Community

Skip to content

DEV Community

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Cristian Carlos dos Santos

Oct 6

Querying CSV and Parquet exports inside a SQL IDE with DuckDB

#sql #duckdb #opensource #database

2 min read

Usman Khan

Oct 6

Zero-Downtime Database Migrations: Shadow Tables, Dual-Writing, and Schema Expansion

#database #postgres #devops #architecture

4 min read

Oct 6

Scheduled app blocks in Kotlin: day bitmasks, overnight windows, and a Flow that wakes on time

#android #kotlin #coroutines #database

8 min read

Syed Anzar

Oct 6

How SQLite WAL Mode Actually Works: The 3 Files, Shared Memory, and Lock-Free Reads

#sqlite #database #programming #performance

9 min read

subashthiruppathy

Oct 6

Optimizing High-Volume Financial Ledger Queries in PostgreSQL

#postgres #database #performance #sql

2 min read

Darshan Turakhia

Oct 6

How a Zero-Downtime Table Swap Silently Dropped Orders From Postgres Logical Replication for 91 Hours

#database #postgres #backend #programming

6 min read

nils44344

Oct 7

prisma generate not working: "No command registered" (Prisma 8)

#prisma #npm #node #database

5 min read

Sam

Oct 6

ALTER COLUMN failed because one or more objects access this column

#sql #database #dotnet #webdev

4 min read

Frank Boucher ☁

Oct 7

I Built My First VS Code Extension: Meet Rainbow SQL

#vscode #productivity #sql #database

3 min read

yuanke215

Oct 6

Stop Storing IP Addresses as Strings: The Integer Trick That Makes Your Queries 10x Faster

#database #devops #performance #python

4 min read

life

Oct 6

Shelf life is a column you query, not a number you decrement

#database #ecommerce #inventory #design

5 min read

Oct 6

Building a Webhook Queue on PostgreSQL: Why We Ditched Redis for Shopify Webhook Processing

#architecture #backend #database #postgres

12 min read

DataDriven

Oct 6

DuckLake 1.0 and Iceberg 1.11: What a Data Engineer Should Know

#dataengineering #database #career #interview

9 min read

Oct 6

Database Schema Diagram Tool: 5 Ways to Visualize PostgreSQL

#postgres #database #tutorial

3 min read

Oct 6

UUIDv7 and the end of the random primary key

#postgres #database #performance #schemadesign

9 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.