I recently installed MariaDB on my ArchLinux and would like to have some GUI program for me to interact with the databases more easily. I tried MySQL Workbench but it doesn't seem to connect properly to the MariaDB and after research it looks like it has been broken for quite some time.
You can view a Bug Thread here, or a Unix related question here.
Any other suggestions?
I use MariaDB on Arch Linux as well and I can recommend DBeaver.
Free Universal Database Tool https://dbeaver.io/
Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.
Arch Linux - dbeaver 5.2.4-1 (x86_64) https://www.archlinux.org/packages/community/x86_64/dbeaver/
You can install on Arch with:
pacman -S dbeaver
See the DBeaver Wikipedia entry here: https://en.wikipedia.org/wiki/DBeaver
I'm a fan of DataGrip by Jetbrains. It is platform independent and can be used for a multitude of database types by downloading the relevant driver - this is managed via the interface when setting up a connection.
This will allow you to perform the functions you require, but doesn't offer the database design ability which MySQL Workbench had, but will allow you to create, modify, drop tables, as well as perform queries, see the tables easily and perform other functions.
If you choose to migrate away from MariaDB to another database store, or have another project which uses a different database, you can use the same tool.
