Data, Databases & Streaming

Relational & NoSQL databases, search, caches, streams, ETL/ELT, and analytics stacks.

  • 7 Subtopics
  • 15 Tracked terms
  • Last 30 days Feed window
Search within this topic Ask AI about this topic All topics

Inside Data, Databases & Streaming

Relational (SQL) Postgres/MySQL/SQLite tuning, HA/DR, indexing, and query planning. NoSQL & NewSQL Document, key-value, columnar, search, and distributed SQL engines. Search & Relevance Engineering Full-text search, ranking, synonyms, vectors, and hybrid retrieval patterns. Caching & Edge Data KV stores, CDNs, edge runtimes, and latency-first data patterns. Streaming & Queues Event streaming, pub/sub, backpressure, and consumer groups at scale. ORMs & Migrations Type-safe models, schema diffs, seed data, and multi-tenant strategies. Data Engineering & Analytics Pipelines, orchestration, dbt, warehouses, BI, and governance/lineage.

What this topic collects on

An article joins this feed when it matches these terms. Each one is also a search of its own.

Latest in Data, Databases & Streaming


dev.to > milkyway008 > your-agents-sqlite-state-db-keeps-corrupting-what-actually-causes-it-and-how-to-recover-the-data-55hd

Your agent's SQLite state DB keeps corrupting: what actually causes it, and how to recover the data

46+ min ago   (974+ words) I run an agent that keeps its entire brain in one local SQLite file. Three weeks ago it came back with database disk image is malformed, and I did the first thing most of us do: deleted the -shm sidecar,…...


dev.to > codenameone > faster-maps-chasing-swiss-speed-pl7

Faster Maps: Chasing Swiss Speed

1+ hour, 38+ min ago   (974+ words) ParparVM fixes pathological map misses and extends tagged boxed values. Probe counts, allocation coverage, and regressions show where ordinary Java collections became cheaper. Tagged with java, mobile, android, ios....


dev.to > devanshu_patil > a-fast-vps-is-useless-if-you-cant-explain-why-its-slow-40jo

A Fast VPS Is Useless If You Can't Explain Why It's Slow

2+ hour, 49+ min ago   (492+ words) One of the most useful habits I've picked up from running applications on my own VPS is this: Don't optimize based on feelings. Measure the request. When a website feels slow, it's tempting to immediately blame the server. Maybe the…...


dev.to > seolith > building-foxyinvoice-chapter-4-multi-tenancy-data-security-the-vault-l79

Building FoxyInvoice — Chapter 4: Multi-tenancy & data security — the vault

2+ hour, 53+ min ago   (314+ words) This series is written in the open, from a real production system. This chapter is the vault: identity, isolation, authorization, and the tests that prove it holds. [All chapters and diagrams live in the public repo.] Solo developers imagine hackers....


dev.to > joseph_mwangi_3ae1f57a132 > window-functions-vs-aggregate-functions-in-sql-a-beginner-friendly-guide-i72

Window Functions vs Aggregate Functions in SQL: A Beginner-Friendly Guide

4+ hour ago   (884+ words) If you have written SQL for more than a week, you have used SUM(), AVG() or COUNT(). They are the... Tagged with beginners, database, sql, tutorial....


dev.to > paganini2008 > easyjpa-type-safe-dynamic-queries-in-three-lines-not-thirty-542e

EasyJPA: Type-Safe Dynamic Queries in Three Lines, Not Thirty

4+ hour, 40+ min ago   (617+ words) Every query is a lambda. Every join has a name. Not a single JPQL string. Here is the whole pitch in one screenshot's worth of code. Same query. Same type safety. Same generated SQL. Step 1 — add the dependency. The current…...


dev.to > nainikmehta > cache-stampede-mitigation-stale-while-revalidate-coalescing-268e

Cache Stampede Mitigation: Stale‑While‑Revalidate & Coalescing

4+ hour, 50+ min ago   (295+ words) Cache stampedes (aka thundering herds) happen when a popular cache entry expires and hundreds or thousands of concurrent requests race to rebuild it. The result: your origin gets hammered, latency spikes, retries amplify the load, and the whole service can…...


dev.to > mercie_wahome_819901ac530 > power-bi-data-modelling-relationships-and-joins-pij

Power BI: Data Modelling, Relationships and Joins

5+ hour, 17+ min ago   (49+ words) Introduction When I first approached a health dataset in Power BI, I was more interested... Tagged with analytics, data, database, learning....


analyticsinsight.net > data-science > what-is-vectorization-in-data-science-how-it-speeds-up-statistical-computing

What is Vectorization in Data Science? How it Speeds Up Statistical Computing

1+ day, 19+ hour ago   (761+ words) Vectorization replaces manual, element-by-element loops with operations that run across entire arrays at once. The speed gain comes from compiled code, CPU features like SIMD, and better memory access, not from shorter syntax alone. The technique has limits: dependent calculations,…...


medium.com > @roshniichharampatil > sql-detectives-solving-business-mysteries-one-query-at-a-time-7a067007370f

SQL Detectives: Solving Business Mysteries One Query At a Time

1+ hour, 15+ min ago   (707+ words) Introduction The Question That Started It All Every journey starts with a question. Mine was this — how do companies understand all …...