sqlite

Tag

Cards List
#sqlite

sqlite-utils 4.1

Simon Willison's Blog ↗ · 2026-07-11 Cached

sqlite-utils 4.1 introduces minor features including --code for Python code blocks, --type for column type overrides, and strict mode support, continuing its evolution as a SQLite CLI utility.

0 favorites 0 likes
#sqlite

Prefer Strict Tables in SQLite

Hacker News Top ↗ · 2026-07-11 Cached

SQLite's strict tables enforce rigid typing to prevent common datatype mistakes. The article explains how to use them and their pros and cons.

0 favorites 0 likes
#sqlite

Show HN: Earth Game – An offline CLI for turning life goals into quests

Hacker News Top ↗ · 2026-07-11 Cached

Earth Game is a private, offline CLI tool that helps users turn life goals into quests, manage tasks, and review progress, using Python's standard library and SQLite with no external dependencies.

0 favorites 0 likes
#sqlite

Why we're moving off Cloudflare Durable Objects

Hacker News Top ↗ · 2026-07-09 Cached

Wire, a platform for AI agent context containers, is migrating from Cloudflare Durable Objects to a custom runtime on Fly Machines due to structural limits: vector index separation, compute-data colocation, placement flexibility, and lack of self-hosting. The new architecture improves latency and enables dedicated capacity.

0 favorites 0 likes
#sqlite

sqlite-utils 4.0, now with database schema migrations

Simon Willison's Blog ↗ · 2026-07-07 Cached

sqlite-utils 4.0 introduces database schema migrations, nested transactions, and compound foreign keys, making it easier to manage SQLite database schema changes programmatically.

0 favorites 0 likes
#sqlite

sqlite-migrate 0.2

Simon Willison's Blog ↗ · 2026-07-07 Cached

sqlite-migrate 0.2 is a minor release of a Python tool for managing SQLite database migrations, adding new features and improvements.

0 favorites 0 likes
#sqlite

sqlite-utils 4.0rc3

Simon Willison's Blog ↗ · 2026-07-06 Cached

sqlite-utils 4.0rc3 is a release candidate with new features including compound foreign key introspection and case-insensitive column matching.

0 favorites 0 likes
#sqlite

@Jolyne_AI: A pure local solution for adding "long-term memory" to AI Agents: Mnemosyne (built for Hermes Agent). Under the hood, it uses SQLite with <1ms query latency, runs fully offline, zero cost, zero dependencies, and you control your privacy. GitHub: https://gi…

X AI KOLs Timeline ↗ · 2026-07-05 Cached

Introducing Mnemosyne, a purely local, SQLite-based long-term memory solution for Hermes Agent, featuring ultra-low latency, offline operation, zero cost, and privacy control.

0 favorites 0 likes
#sqlite

Extralite 3.0.0 Released

Lobsters Hottest ↗ · 2026-07-03 Cached

Extralite 3.0.0, a fast Ruby SQLite wrapper, introduces object graph transforms and modern defaults for database interaction.

0 favorites 0 likes
#sqlite

Show HN: ctx – Search the coding agent history already on your machine

Hacker News Top ↗ · 2026-07-02 Cached

ctx is an open-source CLI tool that indexes coding agent sessions locally into SQLite, enabling fast search of past discussions, decisions, and failed attempts to save tokens and improve agent performance.

0 favorites 0 likes
#sqlite

@huihoo: In this discussion about SQLite, you can also dive deeper into SQLite. WeChat's mobile database framework WCDB built on SQLite and SQLCipher https://github.com/Tencent/wcdb DB Browser for…

X AI KOLs Timeline ↗ · 2026-07-02 Cached

Introduces WeChat's mobile database framework WCDB built on SQLite and SQLCipher, and recommends related learning resources.

0 favorites 0 likes
#sqlite

Hunting a 16-year-old SQLite WAL bug with TLA+

Hacker News Top ↗ · 2026-06-30 Cached

Canonical's dqlite team used TLA+ to model and understand a 16-year-old SQLite bug in WAL checkpointing that can cause database corruption, then verified whether dqlite is affected.

0 favorites 0 likes
#sqlite

Show HN: PMB – local memory for coding agents that shows if it is used

Hacker News Top ↗ · 2026-06-29 Cached

PMB is a local-first memory system for AI coding agents that stores decisions, lessons, and project facts in a SQLite file on your disk. It integrates with Claude Code, Cursor, Codex, and Zed via MCP, providing fast recall without cloud dependencies.

0 favorites 0 likes
#sqlite

@itsharmanjot: FOUR AI CLIs ARE NOW TALKING TO EACH OTHER THROUGH A SINGLE SQLITE FILE. Claude Code. Gemini CLI. Codex CLI. OpenCode. …

X AI KOLs Timeline ↗ · 2026-06-29 Cached

Squad is an open-source Rust tool that lets four major AI CLIs (Claude Code, Gemini CLI, Codex CLI, OpenCode) collaborate on the same codebase through a single SQLite file, with no daemon or server required.

0 favorites 0 likes
#sqlite

@NFTCPS: Multiple AI agents working together? Finally someone pulled it off with the most down-to-earth approach. squad, a command-line tool written in Rust, lets Claude Code, Gemini CLI, Codex, and OpenCode — these CLI agents — sit at the same table and collaborate.…

X AI KOLs Timeline ↗ · 2026-06-29 Cached

squad is a command-line tool written in Rust that enables collaboration among multiple AI CLI agents (such as Claude Code, Gemini CLI, etc.) via shell commands and an SQLite database, without requiring a background daemon.

0 favorites 0 likes
#sqlite

How to corrupt an SQLite database file

Hacker News Top ↗ · 2026-06-26 Cached

This article from SQLite's official documentation explains the various ways an SQLite database can become corrupted, such as file overwrites by rogue processes, misuse of file descriptors, and unsafe backup procedures, along with mitigation strategies.

0 favorites 0 likes
#sqlite

SQLite improving performance with pre-sort

Hacker News Top ↗ · 2026-06-26 Cached

This article demonstrates that pre-sorting random data before inserting into SQLite can improve insert performance by 2-3x, by leveraging the B+ Tree's ordered nature and reducing page splits.

0 favorites 0 likes
#sqlite

@QingQ77: A desktop application based on Tauri 2 + React + Rust + SQLite that automatically converts long videos or audio into vertical short videos and uses AI to evaluate the viral potential of clips. https://github.com/JayWebtech/autoshorts……

X AI KOLs Timeline ↗ · 2026-06-25 Cached

AutoShorts is an open-source desktop application based on Tauri 2 + React + Rust + SQLite that can automatically convert long videos or audio into vertical short videos, and uses AI (supporting DeepSeek, Claude, or local Ollama) to evaluate the viral potential of clips. It supports multiple platforms.

0 favorites 0 likes
#sqlite

simonw/browser-compat-db

Simon Willison's Blog ↗ · 2026-06-24 Cached

Simon Willison created a tool to convert Mozilla's browser compatibility data into a downloadable SQLite database, hosted with open CORS headers for easy exploration via Datasette Lite.

0 favorites 0 likes
#sqlite

I'm building an ambient memory agent that watches my screen all day, and its memory lives in SQLite instead of the model. Come tell me where it breaks.

Reddit r/AI_Agents ↗ · 2026-06-23

The author describes building an ambient memory agent that runs locally on a Mac, watching the screen and optionally audio, OCRs/transcribes everything into structured Markdown in an Obsidian vault, with SQLite as the source of truth. They invite feedback on design choices like using SQLite over vector/graph DB, cost, and durability of such systems.

0 favorites 0 likes
← Previous
Next →
← Back to home

Submit Feedback