sqlite-ecosystem VS beepy

I definitely plan to! I have a much larger list of SQLite extensions I've built here: https://github.com/asg017/sqlite-ecosystem

Here's a few other references you may enjoy if you wanna learn more about SQLite extensions:

- The single source file for sqlite-vec: https://github.com/asg017/sqlite-vec/blob/main/sqlite-vec.c

- sqlean, a project from Anton Zhiyanov which is good base of great SQLite extensions: https://github.com/nalgeon/sqlean

- The official SQLite docs: https://www.sqlite.org/loadext.html

- The "hello world" SQLite extension example: https://www.sqlite.org/src/file/ext/misc/rot13.c

Author here, happy to answer any questions! My "Introducing sqlite-vss: A SQLite Extension for Vector Search" [0] blog post has more details about the motivations behind this extensions, along with a demo. Includes a semantic search engine hosted on Datasette, build with sqlite-vss and sentence-transformers, on fly.io. Simple and cheap!

Though my favorite part about this extension (and all my other SQLite extensions[1]): you can `pip install sqlite-vss` for Python, `npm install sqlite-vss` for Node.js, or use https://deno.land/x/sqlite_vss for Deno! The underlying SQLite extension has been compiled on different platforms and uploaded to pip/npm/deno.land/x to make distribution easier. There's also pre-compiled extensions on each Github release if you just want to use it with the sqlite3 CLI.

Currently working on getting Mac M1 arm builds, hopefully by end of this week [2]

[0] https://observablehq.com/@asg017/introducing-sqlite-vss

[1] https://github.com/asg017/sqlite-ecosystem

[2] https://github.com/asg017/sqlite-vss/issues/13

Author here — happy to answer any questions! This is more of a "I'm working on a new project" rather than an official release, the extension itself is still a work-in-progress. A link to the project: https://github.com/asg017/sqlite-vec

I have a pretty specific vision of what v0.1.0 of this extension will look like, but it'll take a few more weeks to get there. This blog post was more for letting users of sqlite-vss (a previous vector search SQLite extension I wrote) know what will be coming next. There will be a much bigger release when that is ready.

But in general, I'm super excited to have an easy embeddable vector search alternative! Especially one that runs on all operating system, in WASM, mobile devices, Raspberry Pis, etc. I personally I'm trying to run a lil' semantic search app on my Beepy[0], which is a ton of fun to play with.

[0] https://beepy.sqfmi.com/

This is the hardware that I wish Beepy had: https://beepy.sqfmi.com

By the way, does anyone know why all of these devices use the Arabic BlackBerry keyboard? Was there a particular surplus of this layout?

This is quite small, but you get Linux running on a hard to find Raspberry Pi Zero 2 W. https://beepy.sqfmi.com/

Hey there, just saw this kit, that makes a Zero board the brains of a handheld console. The thing is that the kit was just about 50 units made.

Beepberry by SQFMI looks like a nice cyber deck, but can't find any good videos on YouTube for this. just this YouTube short by JeffGeerling

The Beepberry isn't far off: https://beepberry.sqfmi.com/ looks like it's got a Blackberry keyboard. Missing LTE, but since it's just a raspberry pi zero, you could probably hack one in directly to a serial port on the GPIO. Needs a case though, but 3D printing one shouldn't be hard.

But I think the general market for this kind of device is really tiny; phones and tablets can do this pretty well, and appeal to general consumers

I am not sure but from Beepberry repository, the 3rd step about the setup script installs a kernel module to drive the LCD screen. The device tree file lists compatible chip including Broadcom SoC bcm2835, bcm2708 and bcm2709.