Tweeting out the best #database, #mongodb, #postgres, #sql posts from https://teapawt.net/t.co/Pu4g7qJwvW š Powered by the @ThePracticalDev
Joined April 2019
- Tweets3.6K
- Following0
- Followers3.7K
- Likes0
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-dreaded-alā¦
Discover the simple 1=1 WHERE trick in SQL to streamline query testing and toggle conditions faster.
{ author: @bdavidxyz } #DEVCommunity #Database
dev.to/bdavidxyz/where-1-1-iā¦
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/samplingā¦
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/statistics-ā¦
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-common-postā¦
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/esproc-spā¦
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/no-indexā¦
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/indexingā¦
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-tree-fā¦
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/using-conā¦
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_haidiner/mongoā¦
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_haidiner/sql-vā¦
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-databaā¦
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/what-shoulā¦
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_haidiner/desigā¦
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-ruby-onā¦
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-new-inā¦
Comprehensive database question bank covering architecture, ER model, SQL, normalization, security and more ā a tool for exam prep #DEVCommunity #Database
dev.to/aniruddhadak/databaseā¦
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-embeddā¦
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-you-use-ā¦
