Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
SQLite Extension for Efficient Vector Search (github.com/asg017)
7 points by cube2222 on April 13, 2023 | hide | past | favorite | 1 comment


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




Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: