sqlite
Coverage of sqlite in the Nexus archive.
- After rewriting SQLite in Rust, Turso turns its sights on Postgres
Turso, a cloud database provider, has rewritten SQLite in Rust and is now developing a Postgres-compatible implementation using the same virtual machine architecture. The company aims to support multiple database frontends, including MySQL and Redis, by building a modern, reliable core for cloud-native applications.
- SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers
The article discusses optimizing SQLite performance in production environments through WAL mode, concurrency, and VFS layers. It is hosted on the Micrologics.org blog and linked to a Hacker News discussion with 7 points and no comments.
- Nul Characters in Strings in SQLite
SQLite allows NUL characters in strings, which may affect data handling. The official documentation provides details on this feature.
- SQLite should have (Rust-style) editions
The article proposes that SQLite adopt Rust-style editions to introduce new features and changes. It highlights the discussion on Hacker News with 28 points and 13 comments.
- Prefer Strict Tables in SQLite
The article advocates for using SQLite's strict tables to enforce data integrity and structure. It includes a Hacker News discussion with 26 points and 4 comments, indicating some community engagement.
- sqlite: A CGo-free port of SQLite/SQLite3
The article introduces a CGo-free port of SQLite/SQLite3, developed by cznic and hosted on GitLab. It has received 18 points and 3 comments on Hacker News, indicating some community engagement.
- The perils of UUID primary keys in SQLite
The article discusses the performance issues caused by using UUID primary keys in SQLite databases, highlighting inefficiencies compared to integer keys. It references a Hacker News comment thread with limited engagement.
- Show HN: Mnemo – local-first AI memory layer for any LLM (Rust, SQLite,petgraph)
Mnemo is a local-first AI memory layer compatible with any large language model (LLM), developed using Rust, SQLite, and petgraph. It was shared on Hacker News with 9 upvotes and 1 comment.
- SQLite is all you need for durable workflows
The article argues that SQLite is sufficient for durable workflows, highlighting its reliability and simplicity. It links to a blog post and Hacker News discussion where the topic is explored further.
- HeidiSQL – Lightweight MariaDB, MySQL, SQL Server, PostgreSQL and SQLite Manager
HeidiSQL is a lightweight database management tool supporting MariaDB, MySQL, SQL Server, PostgreSQL, and SQLite. The article provides links to its GitHub repository and Hacker News discussion, which has 14 points and 3 comments.
- Sieve – scans Cursor/Claude chat history for leaked API keys
Sieve is a tool that scans Cursor and Claude chat history for leaked API keys, flags exposed keys by severity, and redacts them in-place. It covers various AI coding tools and stores fingerprints in Keychain. The tool aims to fill the gap in standard secret scanners that only scan git repos.
- Replacing a 3 GB SQLite db with a 10 MB FST (finite state transducer) binary
The article discusses replacing a 3 GB SQLite database with a 10 MB FST binary, achieving significant storage reduction. The original article is available at https://til.andrew-quinn.me/posts/replacing-a-3-gb-sqlite-database-with-a-7-mb-fst-finite-state-trandsucer-binary/. The post has 30 points and 1 comment on Hacker News.
- SQLite Is a Library of Congress Recommended Storage Format
The Library of Congress recommends SQLite as a storage format. This endorsement is significant for data preservation and accessibility. SQLite is a self-contained, file-based database system.
- Show HN: Let – Offline-first life events tracker (React Native, SQLite)
The article discusses Let, an offline-first life events tracker built with React Native and SQLite, available on GitHub. It has received 6 points and 1 comment on Hacker News. The project is open-source and accessible via its GitHub repository.
- Durable queues, streams, pub/sub, and a cron scheduler – inside your SQLite file
The article introduces new features in SQLite, including durable queues, streams, pub/sub systems, and a cron scheduler, enabling advanced data management and scheduling within a single SQLite file. These enhancements expand SQLite's capabilities beyond traditional lightweight database use.
- Show HN: A Karpathy-style LLM wiki your agents maintain (Markdown and Git)
A new AI agent wiki system using markdown and Git as the source of truth, featuring BM25 and SQLite indexing, private notebooks, shared team wikis, and automated linting. The project, part of the WUPHF collaborative office, emphasizes durability and canonical knowledge management for AI agents.
- Show HN: Honker – Postgres NOTIFY/LISTEN Semantics for SQLite
Honker is a project that implements Postgres' NOTIFY/LISTEN semantics for SQLite, enabling real-time database communication features typically found in PostgreSQL. The project was shared on Hacker News by developer russellromney and has received moderate engagement.
- Mozilla launches Thunderbolt AI client with focus on self-hosted infrastructure
Mozilla has launched Thunderbolt AI client, a front-end solution for self-hosted AI infrastructure, leveraging the Haystack open-source framework. It allows integration with ACP-compatible agents and OpenAI-compatible APIs, including services like Claude, Codex, and DeepSeek, while emphasizing data control and security through local storage and encryption.
- Show HN: Pardonned.com – A searchable database of US Pardons
Pardonned.com is a searchable database of US pardons created to verify claims inspired by Liz Oyer's videos. The project uses Playwright, SQLite, and Astro to build a static website with open-source code on GitHub.