TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Show HN: rqlite and Docker and SQLite-vec – highly-available Vector Search

2 pointsby otoolep9 months ago
Hi -- I&#x27;m the creator of rqlite[1], a lightweight distributed database built on SQLite.<p>Recently I released support for SQL Extensions[2], making it possible to load extensions into rqlite at launch time. This has opened up a bunch of new possibilities for the database. I have now taken it one step further, and baked a bunch of SQLite extensions into the rqlite Docker images[3].<p>All of this means that rqlite can be deployed as highly-available Vector Search database in a matter of seconds, thanks to the convenience of Docker and loading sqlite-vec[4] -- but all in a lightweight, easy-to-use manner:<p>Launch an rqlite node with vector search enabled:<p>docker run -e SQLITE_EXTENSIONS=&#x27;sqlite-vec&#x27; -p4001:4001 rqlite&#x2F;rqlite<p>Set up vector search tables using the rqlite shell:<p>127.0.0.1:4001&gt; CREATE VIRTUAL TABLE vec_examples USING vec0(sample_embedding float[8])<p>This feels like a promising new product area for rqlite -- super easy to use, network accessible Vector Search, all in a highly available package if you want that. I&#x27;m looking for any and all feedback, as this is a very new area for rqlite (SQLite extensions, and new types of search).<p>[1] <a href="https:&#x2F;&#x2F;rqlite.io" rel="nofollow">https:&#x2F;&#x2F;rqlite.io</a><p>[2] <a href="https:&#x2F;&#x2F;www.philipotoole.com&#x2F;rqlite-8-27-loadable-sqlite-extensions-support&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.philipotoole.com&#x2F;rqlite-8-27-loadable-sqlite-ext...</a><p>[3] <a href="https:&#x2F;&#x2F;www.philipotoole.com&#x2F;rqlite-828-enhanced-docker-support-sqlite-extensions&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.philipotoole.com&#x2F;rqlite-828-enhanced-docker-supp...</a><p>[4] <a href="https:&#x2F;&#x2F;github.com&#x2F;asg017&#x2F;sqlite-vec">https:&#x2F;&#x2F;github.com&#x2F;asg017&#x2F;sqlite-vec</a>

no comments

no comments