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.

Where the coverage comes from

The 50 sources publishing most on Data, Databases & Streaming over the last 30 days, out of 839 articles in the feed. Click a source for its articles on this topic and its profile.

  1. 1 @Thepracticaldev dev.to 501 articles 51+ min ago 97%
  2. 2 Medium medium.com 95 articles 3+ hour ago 72%
  3. 3 @Hackernoon hackernoon.com 27 articles 1+ day ago 100%
  4. 4 Oracle Blogs blogs.oracle.com 19 articles 2+ day ago 89%
  5. 5 @Dzoneinc dzone.com 12 articles 1+ day ago 100%
  6. 6 @Glevd benchlm.ai 7 articles 4+ day ago 0%
  7. 7 i-programmer.info 7 articles 2+ day ago 0%
  8. 8 Tech Insider tech-insider.org 7 articles 2+ day ago 0%
  9. 9 Laravel News laravel-news.com 6 articles 1+ week ago 83%
  10. 10 Infoq infoq.com 5 articles 2+ week ago 80% 1
  11. 11 Infoworld infoworld.com 4 articles 3+ day ago 100%
  12. 12 stork.ai 4 articles 1+ week ago 50%

In the feed right now

Tags
People
Places
Organizations

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 Community
dev.to > rahmanfrr > recursive-ctes-how-sql-secretly-learned-to-loop-457f

Recursive CTEs: How SQL Secretly Learned to Loop

51+ min ago   (454+ words) Ask a SQL query to find "all employees under this manager," and things get ugly fast if you don't know how many levels deep the org chart goes. A regular join handles one level. Two joins handle two levels. Nobody's…...

DEV Community
dev.to > ashish_sinha_5241c7673d93 > i-described-1245-tables-with-an-llm-and-retrieval-got-worse-58a

I described 1,245 tables with an LLM and retrieval got worse

3+ hour, 20+ min ago   (1126+ words) The cataloguing step is supposed to be the easy win. You have a schema whose tables are called ecm_template_link and v_pmpm, your users ask questions in English, and the gap between those two vocabularies is why retrieval misses. So you point a…...

DEV Community
dev.to > ashish_sinha_5241c7673d93 > every-text-to-sql-benchmark-score-youve-seen-was-measured-without-access-control-37h

Every text-to-SQL benchmark score you've seen was measured without access control

3+ hour, 20+ min ago   (955+ words) Spider, BIRD, LiveSQLBench. If you have evaluated a text-to-SQL system in the last five years you have quoted a number from one of them. All three ask the same question: given a schema and an English question, does the system…...

DEV Community
dev.to > lucy_anyango_d6aa9788c23a > data-relationships-data-modelling-schemas-and-joins-in-power-bi-1hkp

Data Relationships, Data Modelling Schemas, and Joins in Power BI.

4+ hour, 21+ min ago   (1280+ words) Data Modelling in Power BI What Data Modelling Means in Power BI Data modelling... Tagged with analytics, data, database....

DEV Community
dev.to > someshp > oracle-integration-cloud-integration-patterns-fnc

Oracle Integration Cloud Integration Patterns

4+ hour, 11+ min ago   (162+ words) Twelve reusable patterns, real-world examples, and implementation guidance for Oracle Integration... Tagged with architecture, cloud, software....

Medium
medium.com > @umeshcapg > the-database-connection-pool-was-configured-with-50-connections-so-why-did-the-20th-request-time-e559f67397cb

The database connection pool was configured with 50 connections, so why did the 20th request time…

3+ hour, 34+ min ago   (30+ words) The database connection pool was configured with 50 connections, so why did the 20th request time out? Understanding how parallel database queries inside a single HTTP request can exhaust your …...

Medium
medium.com > @sumit-paul > our-users-phones-were-the-backup-rebuilding-a-lost-database-from-app-caches-8c4d78dffc35

Our users’ phones were the backup: rebuilding a lost database from app caches

4+ hour, 21+ min ago   (223+ words) How expired cache entries on readers’ devices, server logs, and a year-old dump were merged back into MongoDB without …...

Medium
medium.com > @harshithgowdakt > vanilla-postgresql-vs-amazon-aurora-postgresql-7d383e80c68e

Vanilla PostgreSQL vs Amazon Aurora PostgreSQL

4+ hour, 56+ min ago   (1187+ words) At the application level, Amazon Aurora PostgreSQL looks like PostgreSQL. You connect with PostgreSQL drivers, run SQL, use transactions, indexes, MVCC. Underneath, it is a different database architecture. One sentence explains most of the difference: Vanilla PostgreSQL couples the database engine…...

Medium
medium.com > @rhutu.takle > ienumerable-vs-iqueryable-in-c-04df15b52729

IEnumerable vs. IQueryable in C#

5+ hour, 24+ min ago   (429+ words) This distinction sounds simple stated this way, but it has real, concrete consequences for where computation happens, how much data crosses the network, what C# expressions are even legal to write, and a specific, common class of bug that this…...

Medium
medium.com > @mohitdaxini75 > pattern-007-moving-rolling-windows-in-sql-39f153cd9027

Pattern #007: Moving / Rolling Windows in SQL

5+ hour, 18+ min ago   (33+ words) How to calculate what happened over the last N days — without confusing it with a running total A product manager asks: “What was our average daily …...