Data, Databases & Streaming

1+ hour, 54+ 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…...

1+ hour, 58+ 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…...

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

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

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

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

3+ hour, 52+ 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…...

1+ hour, 46+ 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 …...

1+ hour, 43+ 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 …...

6+ hour, 21+ 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…...