proxysql

Commit Graph

Author	SHA1	Message	Date
Rene Cannao	9f30d85e10	Add tar.gz packaging for sqlite-rembed dependency - Download official sqlite-rembed-0.0.1-alpha.9.tar.gz from GitHub - Update deps/Makefile to extract from tar.gz instead of using local source - Add tar.gz to git repository, remove sqlite-rembed-source from git cache - Update documentation to remove ClickHouse troubleshooting reference - Clean targets now remove sqlite-rembed-*/ and sqlite-rembed-source/ Following the pattern of other ProxySQL dependencies, the Rust extension is now packaged as a compressed tarball that gets extracted during build.	2 months ago
Rene Cannao	01d654692d	Integrate sqlite-rembed for text embedding generation Add support for sqlite-rembed Rust SQLite extension to enable text embedding generation from remote AI APIs (OpenAI, Nomic, Ollama, Cohere, etc.) within ProxySQL's SQLite3 Server. Changes: 1. Build system integration for Rust static library compilation - Rust toolchain detection in deps/Makefile - Static library target: sqlite3/libsqlite_rembed.a - Linking integration in lib/Makefile and src/Makefile 2. Extension auto-registration in Admin_Bootstrap.cpp - Declare sqlite3_rembed_init() extern C function - Register via sqlite3_auto_extension() after sqlite-vec 3. Documentation updates - doc/sqlite-rembed-integration.md: comprehensive integration guide - doc/SQLite3-Server.md: usage examples and provider list 4. Source code inclusion - deps/sqlite3/sqlite-rembed-source/: upstream sqlite-rembed v0.0.1-alpha.9 The integration follows the same pattern as sqlite-vec (static linking with auto-registration). Provides rembed() function and temp.rembed_clients virtual table for embedding generation. Build requires Rust toolchain (cargo, rustc) and clang/libclang-dev.	2 months ago
Rene Cannao	d55947b49f	Add comprehensive documentation for sqlite-vec integration This commit adds extensive documentation for the sqlite-vec vector search extension integration in ProxySQL, including: ## README Documentation ### deps/sqlite3/README.md - Overview of sqlite-vec and its vector search capabilities - Integration method using static linking - Directory structure explanation - Compilation flags and build process details - Usage examples for all ProxySQL databases - Benefits and verification instructions ### deps/sqlite3/sqlite-vec-source/README.md - Complete sqlite-vec documentation - Source files explanation - Integration specifics for ProxySQL - Licensing information - Standalone building instructions - Performance considerations ## Doxygen Code Documentation ### lib/Admin_Bootstrap.cpp - Added comprehensive doxygen comments for sqlite-vec integration - Documented sqlite3_vec_init function declaration - Added section documentation for SQLite database initialization - Detailed documentation for each database instance: * Admin: Configuration analytics and vector operations * Stats: Performance metrics and similarity analysis * Config: Configuration optimization with vectors * Monitor: Anomaly detection and pattern recognition * Stats Disk: Historical trend analysis - Included usage examples and cross-references - Explained auto-extension mechanism and integration benefits The documentation provides developers with a complete reference for understanding, using, and maintaining the sqlite-vec integration in ProxySQL's SQLite databases. Technical Details: - Static linking implementation - Virtual table mechanism - JSON vector format support - Auto-extension registration - Multi-database integration - Performance optimizations	2 months ago
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	2 months ago
Miro Stauder	6f29a4d3c7	upgrade sqlite3 to v3.50.4	5 months ago
Miro Stauder	5e8b518f4d	fix sqlite3 throw	2 years ago
Javier Jaramago Fernández	04866fd06d	Fix 'sqlite3_pass_exts' patch compilation on Centos 7	2 years ago
Javier Jaramago Fernández	6c5bd0971c	Add new SQLite3 functions for password generation Added new functions 'MYSQL_NATIVE_PASSWORD' and 'CACHING_SHA2_PASSWORD' for generating MySQL compatible hashed passwords.	2 years ago
Miro Stauder	8dd5cf1bd3	update to sqlite3 v 3.43.2	2 years ago
Miro Stauder	fa6fe55ad0	update SQLite3 to v3.42.0	3 years ago
Miro Stauder	e6150364e1	fixes for issues detected by CodeQL	3 years ago
Miro Stauder	25f75197a7	update sqlite3 from 3.19.2 to 3.40.1	3 years ago
Miro Stauder	c52a2c7841	patch deps CodeQL alerts	4 years ago
René Cannaò	312a04c73d	Upgraded SQLite3 to 3.19.2	9 years ago
René Cannaò	b49966a850	Adding FROM_UNIXTIME() to SQLite3 #758	9 years ago
René Cannaò	451a3dee31	Upgrade SQLite3 from 3.9.2 to 3.15.0	9 years ago
René Cannaò	303d005ca9	SQLite3 is no skipped as source files	10 years ago
René Cannaò	6b057435ae	Upgrade to Sqlite 3.9.2 - upgrade from 3.8.4 to 3.9.2 - moved back into deps directory	10 years ago
René Cannaò	68d6786320	first commit	11 years ago

19 Commits (v3.0-pgsql_monitor_repl_lag)