Articles by Tag #sqlite
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
Stop Refreshing Weather Sites: Automate Alerts with Python and Playwright
Learn how to scrape live weather data, store it in SQLite, and receive automatic...
Moving from PostgreSQL to SQLite in Django: Handling Locale-Aware Sorting
TL;DR Migrating from PostgreSQL to SQLite in production is now a realistic option — even...
Deploy TanStack Start with SQLite to Your Own Server
This guide walks you through deploying a TanStack Start application with SQLite database to your own...
I solved the local database problem, so I built a tool
I hit a massive pain point in my day-to-day work—and once I solved it for myself, I couldn’t not...
FastAPI, Furious Tests: The Need for Speed
A no-nonsense guide to making your test suite so fast, it'll make The Flash jealous by Shahar...
Fixing Claude Code's Concurrent Session Problem: Implementing Memory MCP with SQLite WAL Mode
The Problem Have you ever seen this error while running multiple Claude Code...
Quick Snippets — A Small Tool for Big Focus
Built for developers who hate interrupting their flow. Future update here dev-dialect When you're...
Choosing the Right Storage Solution
When building a house hunting app in React Native, one of the first architectural decisions you'll...
UUID’s in Rails + SQLite shouldn’t be this hard (so I built a gem)
tl;dr — If you just want UUIDs or ULIDs working in your Rails + SQLite app: # Gemfile gem...
The Long Echo Toolkit: Preserving Your Digital Life
Three CLI tools for preserving your digital intellectual life: conversations, bookmarks, and books. Built on the same resilient architecture with reading queues, semantic search, and LLM integration.
Bringing True SQLite to the Browser with OPFS 🚀
Stop fighting with localStorage limits and complex IndexedDB wrappers. If you need a real relational...
Simple Tweaks That Make SQLite Lookup Faster – Part 1
Today I encountered issues with FreeDevTools online (a free, open-source hub where developers can...
SQLite Database: A Complete Guide for Developers (Architecture, Internals, and Everything You Must Know)
SQLite is one of the most widely deployed database engines in the world. It powers mobile apps,...
Remember to set the frequency for replication to Litestream!
Curious about how I ended up with an invoice nearing $100 for conducting over 20 million Class A...
Persisting data in Rust with Heave
As a developer, I often find myself working on small personal projects where I need a quick and easy...
Code. Gleam, SQLite and concurrent transactions walked to a bar
Hi! Gleam + SQLite is a nice choice for a side-project. But when this project grows and demands...
💾 Why I Chose SQLite for My Startup — The Most Underrated Database You're Probably Ignoring
Why Kinsly's backend runs on SQLite instead of Postgres or MySQL — a practical explanation of how WAL mode, PRAGMAs, and Go integration make SQLite a powerful, underrated choice for startups.
Embedded Intelligence: How SQLite-vec Delivers Fast, Local Vector Search for AI.
An experience with SQLite as a vector database Introduction - Embedded Intelligence:...
The Zero-Rent Architecture: Designing for the Swartland Farmer
The field is deep in the Swartland, two hours outside of Cape Town. It is 34 degrees Celsius, the air...
Quick Rails Tip: Change Database Adapter
The magic command Rails introduced a command a while back that simplifies database adapter...
Dev Snippet — A Local-First Markdown Editor That Thinks With You
Free. Offline. No Cloud. No Tracking. Just pure, high-performance knowledge crafting. After nine...
Introducing PdfParse: Transform Documents into Structured Databases
Launch announcement for PdfParse - a novel, robust, and affordable platform for extracting structured data from PDFs with automatic data normalization and SQLite database generation.
From WAL to WASM - High-Performance Local-First Sync with Postgres & SQLite
The maturation of WebAssembly (WASM) and emerging browser storage primitives have shifted the web...
Building High-Performance Time Series on SQLite with Go: UUIDv7, sqlc, and libSQL
A practical, end-to-end guide to implementing production-grade time series on SQLite/libSQL using...
How to Create ER Diagrams for SQLite with a Free Tool
If you're working with a SQLite database, one of the best ways to understand how it's built is to...
sqlx4k — first stable release of a high-performance, non-blocking DB driver for Kotlin Multiplatform
Hey Kotlin folks! I’m excited to share the first stable release of sqlx4k — a high-performance,...
PocketMCP: Running a Local-First MCP Server
I wanted a simple way to make my personal documents searchable and accessible directly from VS Code...
YouTube-Video-Manager-with-SQLite3
A simple Python CLI app to manage YouTube video data using SQLite3. Supports adding, listing,...
A Quest to Find the Fastest Search Stack
Recently I was tasked with implementing search in a large eCommerce application. While researching...
I built a search engine for $22/month. Here's the stack.
I spent 25 years in IT, including building federal systems that processed millions of loans on...