LDLakshay Dhoundiyalinlakshaydhoundiyal.hashnode.dev·3d ago · 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 messa10
JJacksoninrecalso.hashnode.dev·6d ago · 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
SSSupun Sriyanandainsupun.hashnode.dev·Jul 2 · 8 min readWhy SQLite is Perfect for Edge Device Data LoggingMost embedded Linux projects do not need a database server. They need something that stores data reliably when the network is down, survives a power cut, does not eat RAM, and requires zero administra00
BBeckyinbeckybuilds.hashnode.dev·Jun 29 · 15 min readDesigning a Generation Pipeline — A 4-Axis Content Model, Queue-Based Scheduling, 3-Layer AttributionAn engineering log of building a Threads marketing agent, split into two parts. Part 1: The data-acquisition layer — a crawler designed around an anti-bot threat model (TLS fingerprint · CDP detectio00
HHelperXinhelperx.hashnode.dev·Jun 8 · 7 min readSQLite in Production: Why We Chose It Over Postgres for a Multi-Tenant SaaS"You're using SQLite in production? For a SaaS?" — every developer who hears about our stack. Yes. And after a year of running it with hundreds of active accounts, I'd make the same choice again. Here00
JVJason Vertreesinjvertrees.hashnode.dev·Jun 5 · 4 min readWhy SQLite Bans AI Contributions: A Case Study in Open-Source Quality EngineeringSimon Willison noted this week that SQLite continues to maintain a policy that is unusual in modern open source: the project does not accept code contributions generated by AI agents. The policy has b00
CPChauncey Peltoninblog.seniorjunior.io·Jun 2 · 5 min readThat which has been learned is not easily forgottenThe next step after switching over to Hashnode was to fix the links on the old portfolio / blog site. Thinking about what that would require me to do gave me that feeling of, "I don't want to have to 00
