SphinxQL support / custom startup commands on connect

kaseriisikas posted 6 years ago in Feature discussion
I've been using HeidiSQL for several months and I really like this tool. Keep up the good work!

I'd like to use HeidiSQL to make fulltext queries on a Sphinx Search Server (http://www.sphinxsearch.com), which has a MySQL-like interface (http://sphinxsearch.com/docs/2.0.2/sphinxql-reference.html).
I can make a connection and run queries, but some errors pop out in the process. Specifically, the SphinxQL does not seem to support the queries

that are being executed after establishing the connection. Sphinx cannot be blamed, since it is not a true MySQL server and probably will never support these.

However, is it possible to define a new session (in the Session manager) in a way that no additional startup commands (even those required to fetch a list of databases) are sent to server? Or perhaps override the default startup commands from a file? I've tried the "Startup script" parameter in the Session manager, but that does not work the way I'd like.
ansgar posted 6 years ago
Well Heidi is a MySQL + MSSQL client, and does not support Sphinx. I wonder you can connect to it at all with Heidi.
jfalch posted 6 years ago
MariaDB has Sphinx access as a "storage engine" plugin (http://kb.askmonty.org/en/about-sphinxse/2941/); this way, you define "sphinx databases" within your mysql server (which do access an external sphinx server). This way, no automatic server startup code should be run for a sphinx database. I do not know wether this plugin will run with your server, but it should be worth a try.

Please login to leave a reply, or register at first.