GUI for manticore

Jan_Gucik · January 25, 2023, 10:04am

What kind of GUI (preferable for Windows) are you using for writing/testing queries for Manticore? For queries to MySQL, I use a tool from Devart (dbForge), but this tool has a problem with the connection to Manticore (The tool sends some SQL commands for detection of the configuration of MySql and the commands are not valid in Manticore MySQL engine and the connection fail). I have the same problem even with the official tool from MySql - MySql Workbench.

Sergey · January 25, 2023, 10:08am

Please create feature requests for supporting these tools on GitHub with detailed explanations of the problems (perhaps attach some screenshots). We are now adding integrations for various things (e.g. mysqldump) and most likely will be able to add the new integrations too.

I personally use command line clients only (standard mysql/mariadb clients).

Jan_Gucik · January 25, 2023, 10:37am

Thanks, Sergey. I sent there a feature request and screenshots.

barryhunter · January 25, 2023, 3:58pm

A long time ago I built this
https://nearby.org.uk/sphinx/phpsphinxadmin.phps
Somewhat modeled after PHPMyAdmin

It’s a minimalist frontend for SphinxSerach, I still use it sometimes with ManticoreSearch. Works well for testing ‘SELECT’ queries.

I still mostly have disk indexes, so support for editing RT indexes in minimal at best, and some not implemented. Doesnt currently have anything for the newer ‘RT’ mode, eg creating tables on on the fly, nor cluster commands.

marclaporte · March 1, 2023, 10:44am

Web admin panel, which can be integrated in different platforms (like Virtualmin)

opened 10:32AM - 01 Mar 23 UTC

marclaporte

Let's add a GUI. Let's just start with the basics, and it will grow over time wi…th features like: - Check status, start / stop - Basic info (Version of Manticore, Columnar library, etc.) - Empty cache - Check permissions - Show slow queries - View stats (uptime, memory usage, disk space, etc.) - View data - View logs - Change configs (ports, etc.) - etc. Related: - Adminer - Database management in a single PHP file: Supports: MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB, SimpleDB (plugin), Firebird (plugin), ClickHouse (plugin) https://github.com/vrana/adminer - A basic interface for running SphinxQL commands in a interface somewhat reminiscent of PHPMyAdmin.: https://forum.manticoresearch.com/t/re-monitoring-tool/462/5 - https://github.com/manticoresoftware/manticoresearch/issues/1019 This would be interesting in the context of: https://manticoresearch.com/blog/manticoresearch-buddy-challenges-and-solutions/ It should be made available via https://packagist.org/packages/manticoresoftware/ Projects like phpBB could embed right in their UI: https://forum.manticoresearch.com/t/phpbb-support-config-for-manticore/337/6 We would like to integrate such a tool in Virtualmin, like we do for: - https://gitlab.com/wikisuite/virtualmin-tikimanager - https://gitlab.com/wikisuite/syncthing-for-virtualmin It will add a GUI on top of what we have here https://wikisuite.org/Manticore-Search Here is another related project: https://github.com/manticoresoftware/manticoresearch/issues/1059 Thoughts? Thanks!