SQL

via Rust Weekly 🦀 (@rust_discussions@mastodon.social): Building a dynamically-linked plugin system in Rust

Micah Wylde walks through how Arroyo, a real-time SQL engine, supports user-defined functions in a language that really wants to produce static binaries. He weighs scripting languages, out-of-process RPC, and Wasm before landing on dynamically-linked shared libraries with a C ABI, then digs into the details of designing safe FFI types and interfaces. A great read if you’ve ever wondered how to make a Rust program extensible at runtime.

via Axel Rauschmayer (@rauschma@fosstodon.org): Two projects that sync in-browser SQLite databases with servers:

SQLSync is a collaborative, offline-first wrapper around SQLite that syncs web application state between users, devices, and the edge. Written in Rust and compiled to WASM, it brings reactive query subscriptions and automatic conflict resolution to local-first apps without requiring you to hand-roll a sync layer.

via Kevin Stewart: Tracking Application-Level Consistency with LiteFS · The Fly Blog

via Rust Trending: kawasin73 / prsqlite: Pure Rust implementation of SQLite ★42

via Rust Trending: PRQL / prql: PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement ★7931

via Rust Trending: cube-js / cube: 📊 Cube — The Semantic Layer for Building Data Applications ★15832

via Rust Trending: launchbadge / sqlx: 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, SQLite, and MSSQL. ★9239

via Rust Weekly: GQL: A new SQL like query language for .git files written in Rust

via Rust Trending: getdozer / dozer: Connect any data source, combine them in real-time and instantly get low-latency Data APIs. All with just a simple configuration! ★633

via Rust Trending: MaterializeInc / materialize: Materialize is a fast, distributed SQL database built on streaming internals. ★4966