UKUbeydullah Keleşinubeyd.dev·3d ago · 7 min readRanked Search on SQLiteDeutsche Post does not hire Postboten. Not in its job titles, anyway — the postal-delivery listings are titled "Zusteller" or "Fachkraft Postdienstleistungen", and the word every German speaker would 00
BBearlyStableinbearlystable.hashnode.dev·Jul 31 · 4 min readI got tired of paying for AI NPCs, so I built my own runtime - now it's more than thatI've always liked the idea of NPCs that actually remember things — not scripted dialogue trees, but characters that hold a real sense of who they are, what happened to them, and what they believe, acr10
LSLack Studioinopen-ide.hashnode.dev·Jul 30 · 7 min readSQLite in the Browser – No Installation RequiredRun SQLite in Your Browser – No Installation Required In the realm of embedded databases, the ability to execute SQLite queries directly within a web browser presents a significant advantage, eliminat00
KRKishore Rinkishorecybersec.hashnode.dev·Jul 25 · 6 min readWhat Is SQL Injection? How It Works and How to Prevent ItIntroduction Whether it's usernames, passwords, financial transactions, and customer records, web apps store an incredible quantity of information each day. A lot of these applications utilize databas10
JSJaival Sutharinjaivalsuthar.hashnode.dev·Jul 23 · 9 min readBuilding a Local LLM Benchmark Harness with TypeScript, Ollama & SQLiteLocal LLMs are easier than ever to run, but they're surprisingly hard to benchmark fairly. The first number most people look at is tokens per second. In practice, that number is influenced by everythi00
LDLakshay Dhoundiyalinlakshaydhoundiyal.hashnode.dev·Jul 15 · 8 min readHow WhatsApp Stores, Deletes, and Protects Billions of Messages?Every day, billions of WhatsApp messages travel across the internet in just a few seconds. 📱 But have you ever wondered where WhatsApp messages are actually stored, whether WhatsApp saves every messa20
JJacksoninrecalso.hashnode.dev·Jul 12 · 8 min readHybrid search on-device: why we index every filename with SQLite FTS5 and embed only what mattersThe bug report that killed our "just use embeddings" plan A user knows the file exists. They typed its name. They can picture the icon. And the semantic search we shipped confidently returned four the00
ASAnkan Sahainblog.ankan.in·Jul 12 · 8 min readThe Week My Database Learned to Defend ItselfHow AxioDBCloud went from an open TCP socket to a TLS-encrypted, authenticated, pooled, and AI-drivable system in seven days. There is a specific kind of discomfort that comes from looking at your ow00
AGAgneeva Guhaindebug-perf.hashnode.dev·Jul 6 · 15 min readBuilding a Vector Database - A Study in Optimization and Performance - Part 0 The rapid adoption of machine learning has introduced a shift in how databases manage and query data. Traditional databases (relational or document-based) excel at exact matching—finding a row where u00
SSSidharth Shambuinshambu2k.hashnode.dev·Jul 2 · 7 min readBuilding a Personal Health Dashboard from Samsung Health DataI've had my reliable Samsung Galaxy Watch 4 now for almost 5 years and have been wearing it daily, even when I am asleep. As a result, it has collected a lot of health data. My parents (who live 10 ti00
