DRDaksh Ramrakhyaniindaksh-codes.hashnode.dev·Aug 20 · 4 min readWhat I Learned Building Backups for a Local, LAN-Based SQLite AppI build and maintain a billing and invoice system that runs entirely on a client's local network — no cloud, no internet dependency. One PC hosts the app, other PCs on the same WiFi connect to it thro00
JMJeremy Morganinjeremymorgan.dev·Aug 10 · 18 min readSQL to Cypher - 10 Queries You Already KnowIn March 2016, npm removed an 11-line package called left-pad. Within minutes, builds began failing across the JavaScript ecosystem. It broke thousands of projects, including tools like Babel. Many de32TF
UKUbeydullah Keleşinubeyd.dev·Aug 5 · 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 messa40
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
