Universal editor for relational databases?

Question

Database

Can anyone recommend a good universal database editor that works with any structure, i.e. similar to PhpMyAdmin, but user-friendly (and not dangerous)? It is desirable to support filters, search, navigation through links, master-detail display, it is desirable to work with several DBMS, but at least MySQL. Already googled, Habr read, I know some options, but so far I didn’t like anything. More interesting with the web interface.

Answer 1

Look towards SQL Manager for MySql (Firevird, MSSql, etc.). There are free versions for almost all databases. A very handy product. Website.

Answer 2

Perhaps they will throw a slipper at me - I use MS Access.
Why:
1. Most of the source data for new projects starts in Excel (well, or very easily gets there)
2. Access has the ability to very easily bind display keys (in the Table Designer, any field has a Lookup -> DisplayControl: Combobox -> RowSource : Table with key names -> Column Count:2 (if the name of the key is in the second field of the key table) -> Column Width:0 (to hide the key index) - after this magic, the value of the key is displayed in the table content editor, not its index. This allows you to transfer data from Excel to the database with a simple mass copy-paste (First the keys, then the data) and do not have to worry about a bunch of indexes.
3. In Access, you can set relationships even if they are not set in the database itself (for example, they are implemented through ORM).
How:
1. I download the ODBC client - it is available for almost any relational database engine.
2. In Access - External Data/More/ODBC database. I select/create an ODBC connection to the database. It is important to choose Link and not datacopy, select tables from the database that we link
3. Profit!!!
PS - just yesterday from Excel to MySQL - I imported 1100 records with 4 keys - I spent most of the time combing the data itself - and the clean transfer work took 20 minutes.

Answer 3

Navicat is very good.

Answer 4

I'll throw it up as a variant of HeidiSQL

Answer 5

Maybe SQLyog?

Answer 6

Another option is Database Browser
www.dbsoftlab.com/database-editors/database-browser/overview.html

Answer 7

Well, these are all not web interfaces, this is a locally installed software for Windows. It is all good, but full of service functions, all the specifics of the DBMS and far from the user. I'm looking for exactly "convenient (and not dangerous) for the user" so that an unprepared person for the initial data entry can work in it. And it is desirable that all this is via the web, so that many people can work.