I’m testing manticoresearch if it fits our needs but already stumbling on the “easy” parts. The SQL (mysql) part is not very intuitive:
GUI tool (datagrip)
can connect but not run any commands, always some error
low-code tools / pipelining
it really seems the cli tool is the only thing that actually works an one can use the SQL interface. But that isn’t a very useful tool in context of actual usage in a real application or for testing and then especially bulk insertion of data in way not needing extensive coding.
it seems in the end one is forced to use the official manticoresearch client anyway making the whole sql interface a bit pointless?
The error is to me meaningless: "Found input string: “”
When I create the table with mysql cli client and then “Show Tables;” works in data grip.
low-code tool I mean KNIME which has a mysql connector but here I suspect they are also doing “clever” things in the background which really only works with mysql. the idea is to have an easy way to populate a db with test data.