LLei Vertri7h ago · 5 min readWhen Windows Hides Extensions, Users Drop the Wrong File — and Your Error Message Makes It WorseI build a browser tool that opens Audacity projects. Modern projects (.aup3 / .aup4) are SQLite databases. While Audacity has one open, SQLite keeps a write-ahead log beside it: <name>.aup4-wal. That leivertri.hashnode.dev
AAtlas Data3d ago · 7 min readBuild a small job-market tracker with Google Jobs, Python and SQLiteGoogle Jobs (the job panel you get when you search "data engineer jobs in Austin") pulls together postings from LinkedIn, ZipRecruiter, company career sites, Glassdoor and many smaller boards. That maatlasdata.hashnode.dev
WWaqas Shahid3d ago · 2 min readSQLite Explained: The Database That Lives Inside Your AppIntroduction Most databases (MySQL, PostgreSQL) are servers: a separate program your app connects to over a network. SQLite, created by D. Richard Hipp in 2000, is the opposite: a complete relational practicaldevblog.hashnode.dev
Sstamp IQ4d ago · 4 min readEngineering Edge-Resilient Event Registration for Saudi Mega-EventsWhen engineering an event registration platform for Saudi Vision 2030 mega-exhibitions, standard cloud-native architecture becomes a critical liability. If you are deploying check-in infrastructure atstampiqhashnodedev.hashnode.dev
JJasper Smith4d ago · 7 min readCredit packs + subscriptions in one wallet: expiring credits in SQLite without a cleanup cronWhen I added monthly plans to my AI video app, I already had one-time credit packs. Users who buy a pack keep those credits forever. Users who subscribe get a fresh batch every billing period that exp12PPjaspertech.hashnode.dev
Sstamp IQ5d ago · 4 min readArchitecting an Enterprise Event Registration Platform for Saudi Mega-EventsWhen engineering an event registration platform for mega-summits in Saudi Arabia, developers face two distinct battlegrounds: the physical venue infrastructure and the digital frontend performance. Atstampiqhashnodedev.hashnode.dev
RRONI DAS6d ago · 9 min readOne Database Node Was Left Alive. It Said 420 Rows. The Real Number Was 421.The last node standing in our test cluster was asked one question: how many rows are in this table? It answered 420. A few seconds earlier, the cluster had confirmed write number 421. Nothing was broksystemdesignacademy.hashnode.dev
LLocate NextOct 23 · 24 min readHow to Merge Skip Trace Results Back into Your Property List with SQLite and PythonYou pulled an absentee owner list or a tax-delinquent list and sent it out for skip tracing. The return file that comes back rarely lines up one-to-one with your list. One owner has four phones, anothlocatenext.hashnode.dev
RRowflareOct 23 · 5 min readWhat load tests changed in our open-source Airtable alternative on Durable ObjectsOriginally published on the Rowflare docs. Rowflare is an open-source (AGPL-3.0) Airtable alternative. The whole app is one Cloudflare Worker plus one Durable Object class: every base gets its own Durrowflare.hashnode.dev
Sstamp IQOct 23 · 4 min readBuilding an Event Reporting Platform with Live Dashboards at the EdgeWhen designing infrastructure for the GCC event management software market, standard cloud-first architecture has a fatal flaw: physical crowd density destroys local network integrity. If you are taskstampiqhashnodedev.hashnode.dev
