#SQLite AI assistant
103 related articles
·7 min
Spec-Driven Development: Andrew Ng Teaches You to Master AI Coding Agents Efficiently
Andrew Ng partners with JetBrains on a new course systematically teaching Spec-Driven Development. By writing high-quality specs, developers can precisely control AI coding agents, eliminate context decay, and boost intent fidelity.
Read more →
·7 min
Rowboat: An Open-Source, Local-First Alternative to Claude Desktop
Rowboat is an open-source, local-first AI desktop client positioned as a Claude Desktop alternative. Local data storage and fully transparent code help developers control privacy and workflows.
Read more →
·7 min
A Complete Guide to LangGraph's Core Concepts: The Framework of Choice for Enterprise Agent Development
An in-depth analysis of LangGraph's core concepts: short-term and long-term storage mechanisms, its differences from LangChain, the MIT open-source license, and private deployment solutions for enterprise Agent development.
Read more →
·4 min
ctx: An Open-Source Tool for Searching Your Local AI Coding Assistant History
ctx is a local-first open-source tool that lets developers search and reuse conversation history from Claude Code, Cursor, and GitHub Copilot without uploading data to the cloud.
Read more →
·7 min
The C Readability Crisis: Engineering Reflections Behind Clever Tricks
Why do C programmers keep creating readability disasters? An in-depth look at macro abuse, fancy pointer tricks, and over-nesting—and how coding standards, static analysis, and code review protect maintainability.
Read more →
·3 min
Connecting an Open-Source AI Assistant to OpenClaw: A Complete Local Agent Setup Guide
Step-by-step guide to connecting an open-source AI assistant to OpenClaw: install Robust AI, configure gateway address, obtain API Key, and build a local AI agent with persistent memory.
Read more →
Claude Leads sqlite-utils 4.0 Developm…
·2 min
Claude Leads sqlite-utils 4.0 Development for $149: A Real-World Look at AI Programming
Simon Willison reveals sqlite-utils 4.0 was mostly written by Claude for $149.25. A deep dive into this AI-led development experiment and what it means for developers.
Read more →
·3 min
Cursor in Action: A Complete Guide to Building Python Projects with AI from Scratch
Learn how to build a Python student management system from scratch using Cursor AI — covering Agent/Ask/Manual modes, Claude model selection, auto error fixing, and environment setup.
Read more →
·4 min
AI Agent Memory System Architecture Breakdown: A Practical Selection Guide from 16 Open-Source Projects
Deep analysis of memory system architectures across 16 open-source AI Agent projects including Hermes, Goose, NanoClaw, and Deerflow, covering FTS5 vs vector search, multi-tenant isolation, and LLM auto-extraction.
Read more →
·4 min
Deep Dive into Hermes Agent Architecture: Loop Mechanism, Memory System, and Gateway Design
Deep dive into Hermes Agent's core architecture: Agent Loop mechanism, three-layer memory system (Markdown/SQLite/external), Gateway multi-platform integration, context compression, and Cron jobs.
Read more →
·3 min
Cursor AI Coding Tool: A Complete Beginner's Guide with Hands-On Tutorial
A complete beginner's guide to Cursor AI: installation, interface, three conversation modes, model selection, and a hands-on demo building a student management system from scratch.
Read more →
·2 min
AI-Generated Deployment Docs + Cloudflare in Practice: The Full MokerSaaS Launch Workflow
How MokerSaaS used AI tool Cosmo to auto-generate Cloudflare deployment docs, then followed the document-driven workflow to bundle, deploy, and launch.
Read more →
·4 min
Learn to Code with AI from Scratch: A Complete Learning Path from Beginner to Deployment
A complete learning path for coding with AI from scratch — from concepts and environment setup to using Cursor, Claude, and other AI tools to build and deploy your first project.
Read more →
·3 min
Xiaomi Open-Sources MiMo Code: Cross-Session Memory System Tackles AI Coding's Amnesia Problem
Xiaomi open-sources MiMo Code with SQLite FTS5-powered cross-session memory, solving AI coding assistants' context loss. Supports multi-Agent collaboration, million-line codebases, and OpenAI-compatible APIs.
Read more →
·3 min
Cloudflare Acquires VoidZero: How the Vite Ecosystem Changing Hands Reshapes the Cloud Development Landscape
Deep analysis of Cloudflare's VoidZero acquisition: why the Vite ecosystem is key, how it fixes Cloudflare's DX gap, and what it means for cloud platform competition in the AI Agent era.
Read more →
·2 min
Simon Willison Updates WebRTC Voice Tool: Now Supports Document Context Conversations and GPT-Realtime-2
Simon Willison updates his OpenAI WebRTC voice tool with document context support and GPT-Realtime-2, enabling low-latency voice conversations grounded in specific documents.
Read more →
·2 min
Xiaomi MiMo Code Goes Open Source: How Cross-Session Memory Is Changing AI Programming Collaboration
Xiaomi's MiMo Code is an open-source terminal programming Agent with cross-session memory and multi-Agent collaboration. Explore its memory system, self-evolution mechanism, and how it differs from Claude Code.
Read more →
·4 min
Complete Beginner's Guide to Cursor AI: Three Modes Explained with Hands-On Demo
Learn Cursor AI editor setup, Agent/Ask/Manual modes, model selection tips, and build a full student management system from scratch in this step-by-step guide.
Read more →
·3 min
Vibe Coding in Practice: Building a GPS Check-in App from Scratch with AI — A Complete Walkthrough
A detailed guide to the four-step document-driven Vibe Coding method: from requirements docs to code generation, building a GPS check-in app with AI from scratch.
Read more →
Tutorials·3 min
Cursor Beginner's Guide: Four AI Modes & Hands-On Project Demo
A detailed guide to Cursor AI's download, installation, interface layout, four AI modes (Agent/Plan/Debug/Ask), and a hands-on demo showing how beginners can generate complete projects using natural language.
Read more →