2025-10-13
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.
5 entries
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.
Sabrina wrote an interesting write up on solving a math problem with gpt-4o. It turned out the text-only, chain-of-thought approach was the best performing, which is not what I would have guessed.
About a month ago, I had been looking into creating a NL to SQL plugin for datasette. Simon release a version of exactly that the next day and I came across it in his article here. Hopefully I can find time to try this out in the next few days.
I'm taking a break from sketchybar for now.
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...