Become a sponsor to Alex Garcia
I have created more than a dozen open-sourced SQLite extensions that add new functions to SQLite, that make working with data easier! These include sqlite-regex
for fast regular expression functions, sqlite-xsv
for an extremely fast CSV parser, sqlite-http
for making HTTP requests from SQLite, sqlite-vss
that adds fast vector search to SQLite, and many more!
My work isn't tied to just SQLite extensions either - my sqlite-loadable-rs
project is a Rust library that makes it easier to write safe and performant SQLite extension with Rust. My blog on SQLite shares many tutorials, guides, and my thoughts on many SQLite topics and extensions that are out there. I'm actively working on making SQLite extensions easier to install for more people, including Making SQLite extensions pip install-able for Python developers.
I have many plans for dozens of future SQLite extensions, including:
sqlite-python
, for creating loadable SQLite extensions in Pythonsqlite-parquet
, for directly querying Parquet filessqlite-docs
, a tool for documenting tables and columns in your database with in-line SQL commentssqlite-geo
, an extension (a ~80% replacement for spatialite)sqlite-qjs
, for creating loadable SQLite extension in Javascript based on QuickJS- Making SQLite extensions npm install'able, Deno compatible, and gem install'able!
Any sponsorships help me develop these new extensions, tooling, and tutorials! I strongly believe SQLite extensions can be a simple and performant solution for many data tasks out there, and any help you can give would be greatly appreciated!
Featured work
-
asg017/sqlite-vss
A SQLite extension for efficient vector search, based on Faiss!
C++ 1,750 -
asg017/sqlite-loadable-rs
A framework for writing fast and performant SQLite extensions in Rust
Rust 357 -
asg017/sqlite-html
A SQLite extension for querying, manipulating, and creating HTML elements.
Go 375 -
asg017/sqlite-http
A SQLite extension for making HTTP requests purely in SQL
Go 229 -
asg017/sqlite-lines
A SQLite extension for reading large files line-by-line (NDJSON, logs, txt, etc.)
C 392 -
asg017/sqlite-regex
A fast regular expression SQLite extension, written in Rust
Rust 174