Drop #160 (2022-12-19): Twelve Days of [Quick] Drops • Day 08

sqlite-loadable-rs; sqlite-go; sqlite extension library; sqlite all the things

On The Eighth Day Of Quick Drops 🎅🏽hrbrmstr🎅🏽 Gave To Me…

🎶 SQLite Extend[er|ion]s! 🎶

(If this is your first Xmas Quick Drop, head back to Day 01 to find out what’s going on.)


Well, I correctly predicted that these would be quick drops as soon as .1 entered the mix.

SQLite is everywhere and with the advent of WASM’d SQLite, there’s no better time to revisit the most ubiquitous database on the 🌎 and see how we might be able to bend it even further to our wills.

Chag Sameach! to all readers who celebrate!

sqlite-loadable-rs

This is a very cool, and nascent project that lets you build SQLite extensions in Rust.

https://github.com/asg017/sqlite-loadable-rs

sqlite-go

closeup photo of baubles on christmas tree

This is a very cool, and slightly less-recent project that lets you build SQLite extensions in Golang.

https://github.com/riyaz-ali/sqlite

sqlite extension library

shallow focus photo of four red lighted candles

And, this is a nicely curated list of SQLite extensions. I make use of ipaddr quite a bit in smaller projects.

https://github.com/nalgeon/sqlean

FIN

Try your hand at building a virtual table with either the Rust or Golang libraries. ☮

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.