SQLite Tooling and Guides from Alex Garcia

Archive

sqlite-http: A SQLite Extension for making HTTP Requests

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.

#3
August 23, 2022
Read more

sqlite-html: A SQLite Extension for Parsing HTML Documents

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!

#2
August 5, 2022
Read more

sqlite-lines - A SQLite extension for reading files line-by-line

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');
#1
June 22, 2022
Read more
Brought to you by Buttondown, the easiest way to start and grow your newsletter.