Archive

Welcome to the 4th issue of this SQLite newsletter! Apologies for the 10-month long delay since the last issue, but I’ve open sourced many new projects and I’m excited to share with you all!

As a reminder — this is a newsletter created by Alex Garcia about SQLite. New extensions, tools, guides, best practices, and more. There will be new issue roughly every month.

This month: A recap of many new extensions and tooling I have released recently, including:

• sqlite-ecosystem, a collection of 12 open source SQLite extensions
• Distributing extensions on pip/npm/gem/deno.land/x for easy installing
• sqlite-loadable-rs, a framework for writing SQLite extensions in Rust
• sqlite-vss, an extension for vector search in SQLite

Welcome to the 3rd issue of this SQLite newsletter! Big thanks to all of you who have subscribed, and I hope you continue to find this useful!

As a reminder - this is a newsletter created by Alex Garcia about SQLite - new tools, guides, best practices, and other stuff. There is at most 1 email per week, with many gaps in between.

This week: sqlite-http, an extension for making HTTP requests, all in SQLite! Check out the project on Github to learn more, our try it in your browser in the blogpost, Introducing sqlite-http: A SQLite extension for making HTTP requests .

Similar to sqlite-html from last week, it's written in Go, made possible with Riyaz Ali's SQLite Go library.

Hello all! Welcome to the 2nd issue of this SQLite newsletter. Big thanks to all of you who have subscribed, and I hope you find inspiration in this issue!

As a reminder - this is a newsletter created by Alex Garcia about SQLite - new tools, guides, best practices, and other stuff. There is at most 1 email per week, with many gaps in between.

This week: sqlite-html, an extension for querying, parsing, and generating HTML, all in SQLite!

It's written in Go, made possible with Riyaz Ali's SQLite Go library. The code required to write such extension is very short and easily compiles to a shared library with go build -buildmode=c-shared. Definitely recommend!

Hello! Welcome to the first post in my new SQLite blog.

As a reminder - this is a newsletter created by Alex Garcia about SQLite - new tools, guides, best practices, and other stuff. There is at most 1 email per week, with many gaps in between.

This week: a new tool for SQLite! sqlite-lines is a SQLite extension for reading lines from a file. While a simple feature on it's surface, reading data line-by-line is not possible using built-in SQLite functions, and unlocks the ability to import several new datasets into SQLite databases.

.load ./lines0

select line
from lines_read('./logs.txt');