The Database Dev

Tweeting out the best #database, #mongodb, #postgres, #sql posts from 📁

Powered by the @ThePracticalDev

[The Database Dev @TheDatabaseDev]

Database migrations failing? Here is how to fix the dreaded Alembic NotNullViolation error without tearing your hair out (or dropping your tables).

{ author: @realcuddi }

https://t.co/X7IihWZuKL

[The Database Dev @TheDatabaseDev]

Discover the simple 1=1 WHERE trick in SQL to streamline query testing and toggle conditions faster.

{ author: @bdavidxyz } #DEVCommunity #Database
https://t.co/7A2bERkWMM

[The Database Dev @TheDatabaseDev]

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
https://t.co/iWBrrzoqGX

[The Database Dev @TheDatabaseDev]

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
https://t.co/lGVG7D7xTK

[The Database Dev @TheDatabaseDev]

6 Postgres beginner mistakes and how to avoid them — from vacuum use and closing connections to primary keys, query efficiency and backups #DEVCommunity #Database
https://t.co/bVfHjATZYl

[The Database Dev @TheDatabaseDev]

Transform MongoDB data pipelines with esProc SPL - run SQL-style queries on nested documents and slash aggregation code by 90% #DEVCommunity #Database
https://t.co/UkzyoRapXj

[The Database Dev @TheDatabaseDev]

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
https://t.co/tsVqKYTkix

[The Database Dev @TheDatabaseDev]

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
https://t.co/i2wRdULqjJ

[The Database Dev @TheDatabaseDev]

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
https://t.co/DOxNDQWh0e

[The Database Dev @TheDatabaseDev]

DynamoDB conditional writes let you enforce rules like unique keys, rate limits and idempotency in one atomic, serverless operation.

{ author: @ScorpionEdge } #DEVCommunity #Database
https://t.co/jfCHgoDkvg

[The Database Dev @TheDatabaseDev]

See how embedding vs referencing in MongoDB shapes your data structure and how virtual links in DbSchema bring clarity to your collections #DEVCommunity #Database
https://t.co/ELkCb7HuN3

[The Database Dev @TheDatabaseDev]

Comparing SQL and NoSQL schema design: fixed tables vs flexible documents, strict rules vs adaptable data, vertical vs horizontal scaling. #DEVCommunity #Database
https://t.co/ag839d9Q7e

[The Database Dev @TheDatabaseDev]

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
https://t.co/KxaILPpWF4

[The Database Dev @TheDatabaseDev]

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
https://t.co/ps2Cxk8aaZ

[The Database Dev @TheDatabaseDev]

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
https://t.co/sox9dC7JSd

[The Database Dev @TheDatabaseDev]

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
https://t.co/mKRoxYpVQF

[The Database Dev @TheDatabaseDev]

PostgreSQL 18 beta adds async I/O, timestamped UUIDs, more detailed EXPLAIN output, deferred NOT NULL checks, and simpler upgrades #DEVCommunity #Database
https://t.co/mMVu5D9wq5

[The Database Dev @TheDatabaseDev]

Comprehensive database question bank covering architecture, ER model, SQL, normalization, security and more – a tool for exam prep #DEVCommunity #Database
https://t.co/sc86Bl7Uhj

[The Database Dev @TheDatabaseDev]

WiseJSON is a lightweight embedded JSON database for Node.js: no server, WAL & checkpoints, fsync safety and CLI support for local data. #DEVCommunity #Database
https://t.co/qaAlFzpak7

[The Database Dev @TheDatabaseDev]

SELECT * offers speed and convenience but can hurt performance and readability. Is it time to switch to explicit columns in production? #DEVCommunity #Database
https://t.co/tiqmtfImzM