#Python SQLite
125 related articles
·3 min
Self-Hosted Family Calendar Solutions Compared: Homeflow, Nextcloud, and Lightweight Alternatives
Compare self-hosted family calendar solutions including Homeflow, Nextcloud, Radicale, and Vikunja across CalDAV compatibility, multi-user management, and task integration.
Read more →
·4 min
G.I.A.ac: An AI Architect That Generates Working Apps from a Single Sentence
G.I.A.ac (General Intelligence Architect) is an AI architect tool that generates runnable apps from a single sentence. Deep dive into its positioning, competitive landscape, target users, and core challenges.
Read more →
·3 min
Building Your Own Email Archiving Tool: Breaking Free from Single-Provider Dependency and Reclaiming Data Sovereignty
Learn how to build your own email archiving tool using Maildir format and metadata separation to break free from Gmail/Outlook dependency and reclaim data sovereignty.
Read more →
·3 min
Hammer: An Offline-First Open-Source Novel Writing App with Docker Self-Hosted Sync
Hammer is an offline-first open-source novel writing app using Markdown plain text storage with multi-platform support. Deploy a self-hosted sync server in five minutes via Docker.
Read more →
·3 min
Hammer: An Offline-First Open-Source Novel Writing App with Docker Self-Hosted Sync
Hammer is an offline-first open-source novel writing app using Markdown plain text. Deploy a self-hosted sync server in minutes with Docker for cross-device sync and web publishing.
Read more →
·4 min
Project Rai-chan Technical Breakdown: A Complete Guide to Building a Fully Local AI Companion
Deep dive into Project Rai-chan's tech stack: Ollama+Gemma local LLM, Unity rendering, VOICEVOX speech synthesis, and more — exploring the technical path for local AI companions.
Read more →
·4 min
What It Feels Like When Production Actually Runs Like Localhost
Why does production never match local? This article analyzes root causes like config gaps and dependency drift, and explores how Docker, Twelve-Factor App, and IaC practices bridge the dev-prod divide.
Read more →
·4 min
Self-Contained Portable Python Distributions: Saying Goodbye to Environment Configuration Nightmares
Deep dive into self-contained portable Python distributions: how python-build-standalone uses static linking and path relocation for zero-dependency deployment, and how modern tools like uv leverage this technology.
Read more →
·4 min
Underrated Self-Hosting Gems: A Roundup of Niche but Powerful Open-Source Tools
Discover underrated niche self-hosted open-source tools across bookmarks, passwords, document archiving, knowledge bases, and dashboards, with deployment tips.
Read more →
·3 min
Cursor + Claude in Action: Building a Python Student Management System from Scratch with AI
A step-by-step guide to building a Python student management system from scratch using the AI editor Cursor with Claude. Covers Agent, Ask, and Manual modes, model selection, and the full workflow.
Read more →
sqlite-utils 4.1 Released: The --code …
·7 min
sqlite-utils 4.1 Released: The --code Option, Type Overrides, and AI-Assisted Development in Practice
sqlite-utils 4.1 brings practical new features: the --code option for generating rows with Python, field type overrides fixing leading-zero ZIP codes, STRICT table mode switching, drop-index, and more. A deep dive into each design and the AI-assisted dev workflow.
Read more →
sqlite-utils 4.1 Released: The --code …
·7 min
sqlite-utils 4.1 Released: The --code Option, Type Overrides, and AI-Assisted Development in Practice
sqlite-utils 4.1 brings practical new features: the --code option for generating rows via Python, type overrides to solve ZIP-code leading-zero loss, STRICT table mode switching, drop-index, and more. A deep dive into the design and AI-assisted dev workflow.
Read more →
GitHub Daily · July 24: Agentic Tools …
·3 min
GitHub Daily · July 24: Agentic Tools Blossom Everywhere, From CMS to Databases Embracing AI
GitHub Trending July 24: Agentic capabilities go from concept to standard, with Instatic and Chat2DB embedding AI deeply into CMS and database clients.
Read more →
GitHub Daily · July 24: Agentic Tools …
·3 min
GitHub Daily · July 24: Agentic Tools Blossom Everywhere, from CMS to Databases Embracing AI
GitHub Trending July 24: Agentic capabilities go from concept to standard feature. Instatic and Chat2DB deeply integrate AI into CMS and database clients, while dive-into-llms remains the go-to Chinese LLM tutorial.
Read more →
·8 min
LangChain Crash Course: A Complete Roadmap from Zero to Agent Development
A systematic roadmap from LangChain and LangGraph to multi-agent development, covering RAG, Tool Calling, MCP, and more, helping developers break into AI app development.
Read more →
·6 min
30-Minute Hands-On: Building a Working AI Agent from Scratch
Skip the dry theory and get hands-on! This article demonstrates step by step how to build a working AI Agent from scratch in 30 minutes using AI coding tools—covering the agent skeleton, tool system, memory mechanism, Flask web UI, and DeepSeek API integration.
Read more →
·3 min
LangChain v1.3 Hands-On Tutorial: Deep Dive into Agents, RAG, and Local Model Deployment
Deep dive into LangChain v1.3: compare LangChain, LangGraph, and DeepAgent paradigms, explore RAG pipelines, multi-agent systems, and local LLM deployment for enterprise AI apps.
Read more →
·3 min
SQLite STRICT Tables Explained: The Type Enforcement Debate and Best Practices
Deep dive into SQLite STRICT tables: is flexible typing a feature or flaw? Covers the author's stance, type vs. validation debate, Turso alternatives, and best practices for type-safe database design.
Read more →
Deep Dives
Deep Dive into AI Agent Skill Design: …
·3 min
Deep Dive into AI Agent Skill Design: Engineering Practices from Anthropic and Perplexity
A deep dive into Skill design philosophy from Anthropic's Claude Code team and Perplexity's Agent team, covering the Tax Test, Gotchas Flywheel, progressive disclosure, and Eval-First practices for building high-quality AI Agent skill systems.
Read more →
sqlite-utils 4.1.1: Fix for Silent Dat…
·2 min
sqlite-utils 4.1.1: Fix for Silent Data Loss Risk in Foreign Key Transactions
sqlite-utils 4.1.1 fixes a silent data loss risk in table.transform() caused by foreign key cascade actions inside transactions, introducing a TransactionError fail-fast mechanism.
Read more →