Top all-time · #7648
Alex Garcia
Personal blog · alexgarcia.xyz/blog · on HN as alexgarcia-xyzdataprogramming
Alex Garcia's personal blog at alexgarcia.xyz covers data and programming. Since 2024, 10 different Hacker News readers have linked it 14 times, most often “Hybrid full-text search and vector search with SQLite”. It is still writing: the last post was on 2026-10-07, and you can follow it by feed.
Too few sampled comments (4) to say how often HN recommends it.?
Why HN links it
HN readers link Alex Garcia's pages on sqlite-vec, a vector search SQLite extension: its Wasm builds, installation, and hybrid search for retrieval. Commenters cite them as extra context in project and RAG threads.
Summarised by Claude from a sample of 4 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Most-linked posts?
- Hybrid full-text search and vector search with SQLite4 people · 4 mentions · first linked 2024-10-02
- SQLite-vec v0.1.0: a vector search SQLite extension that runs everywhere2 people · 2 mentions · first linked 2024-08-01
What Hacker News says?
Creator of sqlite-vec here, happy to help debug anything if you do attempt to try out SQLite vector search again. You mentioned "VSS" in another comment, which if that was my sqlite-vss extension, I more-or-less abandoned that extension for sqlite-vec last year. The VSS extension was more unstable and bloated (based on Faiss), but the new VEC extension is much more lightweight and easy to use (custom C vector functi…
Comment linking /sqlite-vec/
on “Show HN: I rewrote my Mac Electron app in Rust”Submitted I’m writing a new vector search SQLite Extension as a story · 526 points
HN discussionIt can be statically compiled into the official SQLite Wasm builds: https://alexgarcia.xyz/sqlite-vec/wasm.html It can also be statically compiled into the Wasm used by my Go bindings.
Comment linking /sqlite-vec/wasm.html
on “Sqlite-vec: Work-in-progress vector search SQLite extension that runs anywhere”Submitted SQLite-vec v0.1.0: a vector search SQLite extension that runs everywhere as a story · 40 points
HN discussionThank you for this, it's really super exciting! The link on See Installing sqlite-vec for more details. https://alexgarcia.xyz/sqlite-vec/installing.html is a a 404 (the correct link is https://alexgarcia.xyz/sqlite-vec/installation.html presumably). The datasette link https://datasette.io/plugins/datasette-sqlite-vec is an error 500. On the releases page https://github.com/asg017/sqlite-vec/releases/tag/v0.1.0 can…
Comment linking /sqlite-vec/installation.html
on “Sqlite-vec: Work-in-progress vector search SQLite extension that runs anywhere”Submitted Hybrid full-text search and vector search with SQLite as a story · 4 points
HN discussionAuthor here, happy to answer any questions! Been working on this for a while, so I'm very happy to get this v0.1.0 "stable" release out. sqlite-vec works on MacOS, Linux, Windows, Raspberry Pis, in the browser with WASM, and (theoretically) on mobile devices. I focused a lot on making it as portable as possible. It's also pretty fast - benchmarks are hard to do accurately, but I'd comfortable saying that it's a very…
Comment linking /blog/2024/sqlite-vec-stable-release/index.html
on “Sqlite-vec: Work-in-progress vector search SQLite extension that runs anywhere”Submitted Libfec: A new FEC file parser and CLI tool written in Rust as a story · 2 points
HN discussionLots more details in Alex's blog post here: https://alexgarcia.xyz/blog/2024/sqlite-vec-stable-release/i...
Comment linking /blog/2024/sqlite-vec-stable-release/index.html
on “Sqlite-vec: Work-in-progress vector search SQLite extension that runs anywhere”Submitted Hybrid full-text search and vector search with SQLite as a story · 2 points
HN discussionThis might provide context: https://alexgarcia.xyz/blog/2024/sqlite-vec-hybrid-search/in...
Comment linking /blog/2024/sqlite-vec-hybrid-search/index.html
on “Retrieval Augmented Generation Based on SQLite”Submitted Hybrid full-text search and vector search with SQLite as a story · 1 points
HN discussionI really dig more content about how vector databases/tools handle problems like this! In sqlite-vec, there's only a flat brute-force index (though DiskANN/IVF will be coming soon). But we do have a concept of partition keys[0], which allows you to "internally shard" the vector index based on a user_id or any other value. create virtual table vec_documents using vec0( document_id integer primary key, user_id integer…
Comment linking /sqlite-vec/features/vec0.html
on “Sharding Pgvector”
