SQLite Viewer with sqlite-vec support

[mi-iro]

Hi, and thank you for creating sqlite-vec. It's a fantastic and lightweight tool for vector search.

The Problem While integrating sqlite-vec into our workflow, we've run into a challenge: we are unable to inspect or browse the contents of vec0 virtual tables using standard database GUI tools. This makes debugging and data verification difficult.

Notably, many visualizers address cypher and FTS5 grammar but not support vec0 extension till now. For example, the DB Browser for SQLite (DB4S) and DBeaver. Thus, the support should be of importance.

Finally, Is there a recommended GUI tool or configuration that is known to work for browsing vec0 virtual tables?

Thank you again for your excellent work on this project. We look forward to your guidance.

Best Wishes.

[artiommocrenco]

@mi-iro I use sqlitebrowser.org. In Tools->Load Extension you can load vec0.so (this extension). I got it from the python package files but one can get it from the Releases of this repo, for example there is one in sqlite-vec-0.1.6-loadable-linux-aarch64.tar.gz

They you are able to "browse" the table by selecting from it

select * from your_vec0_table

[mi-iro]

@mi-iro I use sqlitebrowser.org. In Tools->Load Extension you can load vec0.so (this extension). I got it from the python package files but one can get it from the Releases of this repo, for example there is one in sqlite-vec-0.1.6-loadable-linux-aarch64.tar.gz

They you are able to "browse" the table by selecting from it

select * from your_vec0_table

Thanks for your reply! This operation should be helpful for Windows/Linux systems. But for MacOS, I met the signature issue. For user, it can be hard to solve. Maybe the author @asg017 can solve the signature issue. :)

Error loading extension: dlopen(/Users/mi-iro/Downloads/vec0.dylib.dylib, 0x000A): tried: '/Users/mi-iro/Downloads/vec0.dylib.dylib' (code signature in <0DDDCDA7-3E0C-304B-A80F-EC8656A687AB> '/Users/mi-iro/Downloads/vec0.dylib.dylib' not valid for use in process: mapping process and mapped file (non-platform) have different Team IDs), '/System/Volumes/Pre

[artiommocrenco]

@mi-iro I use sqlitebrowser.org. In Tools->Load Extension you can load vec0.so (this extension). I got it from the python package files but one can get it from the Releases of this repo, for example there is one in sqlite-vec-0.1.6-loadable-linux-aarch64.tar.gz

They you are able to "browse" the table by selecting from it

select * from your_vec0_table

Thanks for your reply! This operation should be helpful for Windows/Linux systems. But for MacOS, I met the signature issue. For user, it can be hard to solve. Maybe the author @asg017 can solve the signature issue. :)

Error loading extension: dlopen(/Users/mi-iro/Downloads/vec0.dylib.dylib, 0x000A): tried: '/Users/mi-iro/Downloads/vec0.dylib.dylib' (code signature in <0DDDCDA7-3E0C-304B-A80F-EC8656A687AB> '/Users/mi-iro/Downloads/vec0.dylib.dylib' not valid for use in process: mapping process and mapped file (non-platform) have different Team IDs), '/System/Volumes/Pre

It works for me on Linux, but I'm aware of problems with this on MacOS. I can recommend trying to follow this guide https://til.simonwillison.net/sqlite/trying-macos-extensions