From Dev.to Community
Tech Articles
Curated developer articles, tutorials, and guides — auto-updated hourly
Paris Moschovakos4d ago • 5 min read
One SQLite query took Apple Mail automation from 10s to 0.1ms
I run my work email through an AI assistant. The mailbox is a CERN mailbox, 298,986 messages across....
#sqlite#macos#applescript#showdev
0 0
Syed Anzar5d ago • 7 min read
Your Agent's Memory Is a Lie: A Durable, Queryable Memory Layer for Local LLM Agents
Stop using self.memory = [] for your LLM agent. Build durable, semantic memory with SQLite + sqlite-...
#aiagents#python#llm#sqlite
1 0
David Liu6d ago • 5 min read
I've Built RAG Infrastructure Several Times. Last Week Was the First Time I Actually Benchmarked It.
I have a confession, and I suspect I'm not alone in it: I've built RAG infrastructure multiple times...
#ai#go#sqlite#opensource
1 0
Chad Priest5d ago • 4 min read
SQLite FTS5 quietly ANDs your search terms
Our search box returned zero results for any sentence longer than four words. The bug wasn't ranking...
#sqlite#search#debugging#javascript
0 0
Casey ZhangAug 24, 2026 • 5 min read
Crash-Proof Batch LLM Processing: A SQLite Job Queue on a Free Server
Three thousand lines in, the process died. Not with a Python traceback — with a silent OOM kill. The...
#sqlite#llm#python#devops
0 0
Chad Priest5d ago • 5 min read
Your isolated test lab isn't isolated: 3 rows, 8 daemons
My failure-injection harness wrote to the live database, health-checked a stranger's process, and le...
#testing#debugging#sqlite#devops
0 0
Anupam Patil5d ago • 4 min read
Queryable Executables: Revolutionizing Software with Embedded Intelligence
Queryable executables are changing the way developers design software. Applications can now interpre...
#queryableexecutables#embeddedintelligence#sqlite#redbean
1 0
hiro@2d ago • 3 min read
Cloudflare D1 has no BEGIN TRANSACTION, so I tested its limits and batch API
This article is an English translation of the original Japanese article. Cloudflare D1 is commonly....
#cloudflare#d1#sqlite#database
0 0
Avelina AI3d ago • 3 min read
Four typed memory layers beat one vector store (for personal AI assistants)
Most "give your AI a memory" posts stop at the same place: embed everything, throw it in a vector...
#ai#architecture#sqlite#selfhosted
1 0
Oaida Adrian5d ago • 3 min read
Building a Romanian Business Registry API: 4.2M Companies as Queryable JSON
Turning Romania's official ONRC open-data dump into a fast, free JSON API — SQLite FTS5, diacritic-i...
#python#sqlite#api#datascience
0 0
vmodal_aiAug 24, 2026 • 2 min read
Building an Offline-First Robot Control SDK for Android
Learn how to build an offline-first Android SDK for robotics using Room database, SQLite persistence...
#android#kotlin#room#sqlite
0 0
Dakota HuangAug 24, 2026 • 4 min read
Your Model Call Is a Job, Not a Request: An Outbox Queue for Free Endpoints
A synchronous model call is a bet. You bet the endpoint stays up. You bet it answers fast. Free...
#node#sqlite#ai#tutorial
0 0
Dakota Huang6d ago • 5 min read
Log the Decision, Not Just the Response
A free model endpoint returns text. It does not return context. When the output is wrong, you need.....
#ai#python#sqlite#tutorial
0 0
Yahia Hammadieh5d ago • 2 min read
Social Link Vault AI (Mobile & Architecture Focus)
Most bookmark and read-it-later tools suffer from the same pattern: bloated web dashboards, heavy...
#flutter#mobile#sqlite#showdev
0 0
Paul Crinigan6d ago • 3 min read
Building a Self-Hosted Workflow Engine on PHP and SQLite
Most workflow automation lives on somebody else's server. That is fine until you are moving customer...
#php#automation#sqlite#webdev
1 0
ccarcaci4d ago • 2 min read
Introducing litevolve: versioned SQLite migrations for Bun, Node, and Deno
https://github.com/ccarcaci/litevolve Just published litevolve, a small migration runner for SQLite...
#sqlite#bunjs#node#deno
0 0
Chad Priest2d ago • 5 min read
Your source-trust score is grading the pipe, not the source
Two records about one announcement, two different dates, both stored at trust_mult 1.0. The trust mu...
#rag#sqlite#ai#debugging
0 0
rinat kozin5d ago • 8 min read
redb 3.7.1: props search up to 100x faster. An alternative to EF Core, or a companion to it
Query cost did not depend on what you searched for: the filter sat above GROUP BY. Now the cut...
#dotnet#sql#postgres#sqlite
0 0
soyAug 23, 2026 • 3 min read
SQLite Forum Discusses Optimized Build for Verified 1.59X Speedup
A recent discussion on the SQLite forum highlights community efforts leading to an optimized SQLite....
#sqlite#database#performance#opensource
0 0
soyAug 24, 2026 • 3 min read
SQLite Executables: Appending Databases for Single-File Distribution
A novel pattern has emerged for application distribution, leveraging SQLite's capabilities to embed ...
#sqlite#database#programming#opensource
0 0
qing4d ago • 4 min read
Build a Finance Tracker App with Python and SQLite
Build a Finance Tracker App with Python and SQLite tags: python, finance, sqlite,...
#python#finance#sqlite#tutorial
0 0