Data, Databases & Streaming

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

  • 7 Subtopics
  • 15 Tracked terms
  • Last 30 days Feed window

Inside Data, Databases & Streaming

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 > gokulnathp > ai-agent-memory-sliding-windows-summaries-and-vector-storage-4mo9

AI Agent Memory: Sliding Windows, Summaries, and Vector Storage

44+ min ago   (623+ words) The agent we built in Post #4 has one big problem — the moment the script ends, it forgets everything. Next time you run it, it starts from zero. No memory of past conversations, no retained facts, nothing. For a quick experiment…...

DEV Community
dev.to > gouranga-das-khulna > distributed-locks-4148

Distributed Locks

48+ min ago   (110+ words) One-liner: A distributed lock ensures that only one node in a cluster can perform a critical operation at a time — preventing race conditions across services. In a single-server world, a mutex or semaphore handles concurrency. But in distributed systems: Classic…...

DEV Community
dev.to > mislam-dev > day-8-relational-database-101-postgresql-internals-j9c

Day 8 - Relational Database 101 - PostgreSQL Internals

1+ hour, 27+ min ago   (1576+ words) একবার একটু technological দিকে আসি, আপনি যখন Facebook বা LinkedIn-এ কাউকে message করেন তখন সেটা সরাসরি তার কাছে send হয়। Reason হচ্ছে আপনারা connected। এখানে আপনি directly message ত…...

DEV Community
dev.to > jones_chen_592558a62a5c44 > treating-one-day-as-a-system-primitive-1eba

Treating “one day” as a system primitive

1+ hour, 48+ min ago   (165+ words) For most AI apps, the unit of time is a request. A user sends a message, the model responds, and the workflow ends. Cogweald is designed around a different primitive: one real day. Each world can advance by at most…...

DEV Community
dev.to > megapixel99 > when-a-zero-parameter-cache-overtakes-a-transformer-37c6

When a Zero-Parameter Cache Overtakes a Transformer

1+ hour, 48+ min ago   (574+ words) The question this series exists to answer, put in a form that can be measured: a transformer sees a fixed 64-token window, a count table over the current document sees the whole document, and as documents get longer, how much…...

DEV Community
dev.to > khg5293 > why-parameterized-queries-matter-for-sql-security-1iem

Why Parameterized Queries Matter for SQL Security

1+ hour, 48+ min ago   (559+ words) SQL injection is one of the classic examples of what can happen when an application mixes user input directly into a database query. The underlying problem is simple. The application expects data. The database may interpret part of that data…...

DEV Community
dev.to > rahmanfrr > recursive-ctes-how-sql-secretly-learned-to-loop-457f

Recursive CTEs: How SQL Secretly Learned to Loop

2+ hour, 42+ 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…...

Medium
medium.com > @alakov.ilia > explain-describes-a-query-production-is-everything-else-thats-running-6b307b63c330

EXPLAIN Describes a Query. Production Is Everything Else That’s Running.

37+ min ago   (1398+ words) A while back I wrote about migrating a terabyte of banking data from Oracle to PostgreSQL with no downtime. The part people …...

Medium
medium.com > @ashrayadhikari > i-replaced-chroma-qdrant-and-pinecone-with-a-sqlite-file-1ae5210c85d4

I Replaced Chroma, Qdrant, and Pinecone With a SQLite File

33+ min ago   (165+ words) I needed a vector DB that didn’t require a daemon. SQLite was already there. Every RAG tutorial starts the same way. Step one: install …...

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

5+ hour, 12+ 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…...