proxysql

Commit Graph

Author	SHA1	Message	Date
Rene Cannao	62cbd6c71e	Fix issues identified in AI code review - Fix combined_search: Build SQL query dynamically based on search_term - Only include MATCH relevance when search_term is provided - Fix parameter binding (fulltext_params vs params) - Fix search_term/query parameter mismatch in run_demo - combined_search mode now correctly receives query from kwargs - Add environment variable support for database credentials - nlp_search_demo.py: DB_HOST, DB_PORT, DB_USER, DB_PASSWORD, DB_NAME - stackexchange_posts.py: SOURCE_DB_* and TARGET_DB_* variables - Fix README CreationDate SQL example to use JSON_EXTRACT - Add zero division checks in get_table_stats and similarity_search_preparation	2 months ago
Rene Cannao	ecfff09633	Add NLP search demo script with comprehensive search capabilities - Create nlp_search_demo.py with full-text, boolean, tag-based, and combined search - Include statistics and similarity search preparation modes - Add proper error handling with MySQL fallback mechanisms - Fix syntax errors and indentation issues - Update README.md with correct command usage examples - Support --mode parameter with appropriate sub-parameters - Demonstrate various search techniques on processed StackExchange posts	2 months ago
Rene Cannao	d37d291488	Implement comprehensive StackExchange posts processing with search capabilities - Unified script that creates target table with search-optimized schema - Adds full-text search indexes and text processing for better search results - Implements duplicate detection and prevention - Fixed MySQL functional index compatibility issue (removed problematic Tags index) - Added support for --limit 0 to process all posts - Added --warning-large-batches flag for batch size > 1000 - Improved text cleaning and normalization for search optimization - Enhanced progress tracking and batch processing efficiency Removes separate scripts (populate_search_columns.py, nlp_search_demo.py) and consolidates all functionality into unified solution.	2 months ago
Javier Jaramago Fernández	a443e3ded0	Improve RESTAPI example scripts 'kill_idle_backend_conns.py' and doc	4 years ago
Javier Jaramago Fernández	691c19a0b1	Fix 'change_host_status' README example for RESTAPI example scripts	4 years ago
Javier Jaramago Fernández	d6a753d0f6	Update 'scripts' folder with several RESTAPI example scripts	4 years ago

6 Commits (v3.0-MCP_multi)