rqlite 8.27: loadable SQLite extensions support
Rqlite version 8.27.0 allows loading SQLite extensions at startup, enhancing functionality with shared libraries. Users can integrate extensions easily, opening new use cases for advanced database features and community contributions.
Read original article
Rqlite version 8.27.0 introduces support for loading SQLite extensions at startup, enhancing its functionality significantly. Rqlite, a distributed relational database built on the Raft consensus protocol and utilizing SQLite as its storage engine, can now incorporate shared libraries or DLLs that add features like user-defined functions and virtual tables. This capability allows users to extend the database's core functionalities. For instance, users can easily load curated SQLite extensions from the sqlean project or implement a Vector Search extension. The process involves downloading the extension and specifying its path when launching rqlite. This new feature opens up various use cases, including advanced cryptographic functions and specialized text processing. The rqlite community is encouraged to explore the extensive library of available SQLite extensions and contribute to its development. Detailed instructions for using these extensions can be found in the official documentation, and community engagement is facilitated through the rqlite Slack channel.
- Rqlite 8.27.0 supports loading SQLite extensions at startup.
- Users can enhance rqlite's functionality with shared libraries or DLLs.
- Extensions can be easily integrated by specifying their path during launch.
- The update opens new use cases for advanced database functionalities.
- Community contributions and exploration of available extensions are encouraged.
Related
DuckDB Community Extensions
The DuckDB team launched the DuckDB Community Extensions repository for easy extension installation. Users benefit from a simplified process, while developers can streamline publication tasks. Security measures include code vetting options.
First Contact with SQLite
The article explores surprising aspects of SQLite, like limitations in altering columns and data types. It notes the recent jsonb support and handling date/time values, praising SQLite's streaming features but favoring PostgreSQL.
SQLite-vec v0.1.0: a vector search SQLite extension that runs everywhere
sqlite-vec v0.1.0 is a new SQLite extension for vector search, supporting multiple programming languages and operating systems. It focuses on brute-force search, with future updates planned for ANN indexing.
SQLite vector search extension that runs anywhere
sqlite-vec is an SQLite extension for fast vector search, supporting float, int8, and binary vectors. It is compatible with multiple platforms and easy to install across various programming languages.
Building rqlite 9.0: Cutting disk usage by half
Rqlite 9.0 will reduce disk usage by 50% using Referential Snapshotting, eliminating duplicate snapshots, improving snapshotting speed, and enhancing node restart times while focusing on SQLite WAL management and upgrades.
1 commentsRelated
DuckDB Community Extensions
The DuckDB team launched the DuckDB Community Extensions repository for easy extension installation. Users benefit from a simplified process, while developers can streamline publication tasks. Security measures include code vetting options.
First Contact with SQLite
The article explores surprising aspects of SQLite, like limitations in altering columns and data types. It notes the recent jsonb support and handling date/time values, praising SQLite's streaming features but favoring PostgreSQL.
SQLite-vec v0.1.0: a vector search SQLite extension that runs everywhere
sqlite-vec v0.1.0 is a new SQLite extension for vector search, supporting multiple programming languages and operating systems. It focuses on brute-force search, with future updates planned for ANN indexing.
SQLite vector search extension that runs anywhere
sqlite-vec is an SQLite extension for fast vector search, supporting float, int8, and binary vectors. It is compatible with multiple platforms and easy to install across various programming languages.
Building rqlite 9.0: Cutting disk usage by half
Rqlite 9.0 will reduce disk usage by 50% using Referential Snapshotting, eliminating duplicate snapshots, improving snapshotting speed, and enhancing node restart times while focusing on SQLite WAL management and upgrades.