The Database Dev

Database migrations failing? Here is how to fix the dreaded Alembic NotNullViolation error without tearing your hair out (or dropping your tables). { author: @realcuddi } dev.to/cuddi/that-dre…

Discover the simple 1=1 WHERE trick in SQL to streamline query testing and toggle conditions faster. { author: @bdavidxyz } #DEVCommunity #Database dev.to/bdavidxyz/wher…

Sampling data without indexes in MongoDB lets you scan a random subset, group by fields and get stats before tuning performance. { author: @FranckPachot } #DEVCommunity #Database dev.to/franckpachot/s…

See how SPL simplifies per-minute window stats compared to nested SQL: fills gaps, tracks start/end, and computes min/max with less code. { author: @esProc_Desktop } #DEVCommunity #Database dev.to/judith677/stat…

6 Postgres beginner mistakes and how to avoid them — from vacuum use and closing connections to primary keys, query efficiency and backups #DEVCommunity #Database dev.to/engroso/6-comm…

Transform MongoDB data pipelines with esProc SPL - run SQL-style queries on nested documents and slash aggregation code by 90% #DEVCommunity #Database dev.to/serina_8340/es…

PostgreSQL GROUP BY on JSONB fields still triggers index scans, no index-only scan like a B-Tree on a separate column. Read on to see why. { author: @FranckPachot } #DEVCommunity #Database dev.to/franckpachot/n…

See how a few secondary indexes in MongoDB let you run new queries on an existing document model without changing the schema. { author: @FranckPachot } #DEVCommunity #Database dev.to/franckpachot/i…

Build a B-Tree index using equality, sort and range keys on top-level fields. It cuts reads, speeds up MongoDB queries with one index. { author: @FranckPachot } #DEVCommunity #Database dev.to/franckpachot/b…

DynamoDB conditional writes let you enforce rules like unique keys, rate limits and idempotency in one atomic, serverless operation. { author: @ScorpionEdge } #DEVCommunity #Database dev.to/urielbitton/us…

See how embedding vs referencing in MongoDB shapes your data structure and how virtual links in DbSchema bring clarity to your collections #DEVCommunity #Database dev.to/roxana_haidine…

Comparing SQL and NoSQL schema design: fixed tables vs flexible documents, strict rules vs adaptable data, vertical vs horizontal scaling. #DEVCommunity #Database dev.to/roxana_haidine…

Your database may be the real bottleneck—too much in-DB processing slows your app. Move logic to the app layer and keep the DB lean. { author: @athreyac4 } #DEVCommunity #Database dev.to/lovestaco/busy…

When SQL and stored procedures slow to a crawl, tuning can only go so far. Learn why some queries stall and when to look beyond SQL. { author: @esProc_SPL } #DEVCommunity #Database dev.to/esproc_spl/wha…

Sketch your database schema offline from anywhere, then sync changes with a visual diff when you’re back online. No live DB risks. #DEVCommunity #Database dev.to/roxana_haidine…

Speed up your Rails app with Mongoid Query Cache—enable middleware or wrap code in cache blocks to cut redundant MongoDB queries and speed requests. #DEVCommunity #Database dev.to/mongodb/boost-…

PostgreSQL 18 beta adds async I/O, timestamped UUIDs, more detailed EXPLAIN output, deferred NOT NULL checks, and simpler upgrades #DEVCommunity #Database dev.to/bytebase/whats…

Comprehensive database question bank covering architecture, ER model, SQL, normalization, security and more – a tool for exam prep #DEVCommunity #Database dev.to/aniruddhadak/d…

WiseJSON is a lightweight embedded JSON database for Node.js: no server, WAL & checkpoints, fsync safety and CLI support for local data. #DEVCommunity #Database dev.to/xzdes/wisejson…

SELECT * offers speed and convenience but can hurt performance and readability. Is it time to switch to explicit columns in production? #DEVCommunity #Database dev.to/codeliner/do-y…