7 entries
About a year and a half ago I wrote about using sqlite-vss to store and query embedding vectors in a SQLite database. Much has changed since then and I'm working on a project that motivated another pass at querying embeddings on a local system for smallish datasets. The sqlite-vector project seemed...
Experimenting with the useful sqlite-vector library for managing vector embeddings in SQLite. Also wrote up a Datasette plugin to query the embeddings in the Datasette tool.
I spent yesterday and today working through the excellent guide by Alex on using sqlite-vss to do vector similarity search in a SQLite database. I'm particularly interested in the benefits one can get from having these tools available locally for getting better insights into non-big datasets with a...
The standard SQLite shell on macOS doesn't support arrow key navigation like many standard CLI programs do. Pressing up, down, right, and left in that order outputs the following escape codes in the shell
I tried setting up sqlite-vss with Deno following these instructions but got stuck on this error
I had a bunch of fun following along with this post with my own Hugo blog to construct a sqlite database of metadata. Building the database indices, I found a mistake I had made years ago in defining a post's alias, which was a duplicate, so I fixed that. I've read a lot of praise of sqlite lately...
I was interested to learn more about the developer experience of Cloudflare's D1 serverless SQL database offering. I started with this tutorial. Using wrangler you can scaffold a Worker and create a D1 database. The docs were straightforward up until the Write queries within your Worker...