zombiezen/go-sqlite is a Go library providing low-level bindings to SQLite 3 using the CGo-free modernc.org/sqlite implementation. It offers direct access to SQLite features including connection management, statement execution, blob I/O streaming, online backup API, user-defined functions (scalar and aggregate), session API for changesets, virtual table support, and schema migration tools. The architecture follows a modular design with core sqlite package for basic operations, sqlitex for extended utilities (connection pooling, execution helpers), sqlitefile for blob-backed buffers, and sqlitemigration for schema migrations. The library is safe for concurrent use through connection pooling and proper error handling, with comprehensive test coverage demonstrating its reliability.
SpacetimeDB is a real-time database system that enables developers to upload application logic directly into the database as modules, eliminating the need for traditional backend servers. Clients connect directly to the database using language-specific SDKs (Rust, C#, TypeScript, C++, Unreal) and receive real-time updates when data changes. The system features a Rust-based core server, WebSocket-based synchronization, ACID transactions, and a code generation system that creates language bindings from module definitions. Notable features include schema evolution capabilities, scheduled procedures, and row-level security. The entire backend of MMORPG BitCraft Online runs as a single SpacetimeDB module, demonstrating its capacity for complex, high-performance applications.
Blackbird is a lightweight, asynchronous SQLite wrapper and model layer for Swift applications. It provides a type-safe persistence layer using Swift concurrency and Codable, with automatic schema migrations, key-path-based querying, caching, change notifications, and SwiftUI integration. The library avoids external dependencies and focuses on developer experience over raw performance, using Swift's type system for compile-time safety. While primarily designed as a reusable framework for local data storage in Apple platform apps, it includes advanced features like full-text search with highlighting and transactional support. The codebase shows evidence of active maintenance but relies on some Swift internals that may pose future compatibility risks.