proxysql

Commit Graph

Author	SHA1	Message	Date
Rene Cannao	fbd0d9732b	Add sqlite-vec static extension for vector search in ProxySQL This commit integrates sqlite-vec (https://github.com/asg017/sqlite-vec) as a statically linked extension, enabling vector search capabilities in all ProxySQL SQLite databases (admin, stats, config, monitor). Changes: 1. Added sqlite-vec source files to deps/sqlite3/sqlite-vec-source/ - sqlite-vec.c: main extension source - sqlite-vec.h: header for static linking - sqlite-vec.h.tmpl: template header 2. Modified deps/Makefile: - Added target sqlite3/sqlite3/vec.o that copies sources and compiles with flags -DSQLITE_CORE -DSQLITE_VEC_STATIC - Made sqlite3 target depend on vec.o 3. Modified lib/Makefile: - Added $(SQLITE3_LDIR)/vec.o to libproxysql.a prerequisites - Included vec.o in the static library archive 4. Modified lib/Admin_Bootstrap.cpp: - Added extern "C" declaration for sqlite3_vec_init - Enabled load extension support for all databases: - admindb, statsdb, configdb, monitordb, statsdb_disk - Registered sqlite3_vec_init as auto-extension at database open (replacing commented sqlite3_json_init) 5. Updated top-level Makefile: - Made GIT_VERSION fallback to git describe --always when tags missing Result: - Vector search functions (vec0 virtual tables, vector operations) are available in all ProxySQL SQLite databases without runtime dependencies - No separate shared library required; fully embedded in proxysql binary - Extension automatically loaded at database initialization	6 months ago

Author

SHA1

Message

Date

Rene Cannao

fbd0d9732b

Add sqlite-vec static extension for vector search in ProxySQL

This commit integrates sqlite-vec (https://github.com/asg017/sqlite-vec)
as a statically linked extension, enabling vector search capabilities
in all ProxySQL SQLite databases (admin, stats, config, monitor).

Changes:
1. Added sqlite-vec source files to deps/sqlite3/sqlite-vec-source/
   - sqlite-vec.c: main extension source
   - sqlite-vec.h: header for static linking
   - sqlite-vec.h.tmpl: template header

2. Modified deps/Makefile:
   - Added target sqlite3/sqlite3/vec.o that copies sources and compiles
     with flags -DSQLITE_CORE -DSQLITE_VEC_STATIC
   - Made sqlite3 target depend on vec.o

3. Modified lib/Makefile:
   - Added $(SQLITE3_LDIR)/vec.o to libproxysql.a prerequisites
   - Included vec.o in the static library archive

4. Modified lib/Admin_Bootstrap.cpp:
   - Added extern "C" declaration for sqlite3_vec_init
   - Enabled load extension support for all databases:
     - admindb, statsdb, configdb, monitordb, statsdb_disk
   - Registered sqlite3_vec_init as auto-extension at database open
     (replacing commented sqlite3_json_init)

5. Updated top-level Makefile:
   - Made GIT_VERSION fallback to git describe --always when tags missing

Result:
- Vector search functions (vec0 virtual tables, vector operations) are
  available in all ProxySQL SQLite databases without runtime dependencies
- No separate shared library required; fully embedded in proxysql binary
- Extension automatically loaded at database initialization

1 Commits (feature/pgsql-native-backend-protocol)