> browser based
For whatever reason, this is the main limiting factor, local software can already be really good, for example:
• DBeaver - pretty nice and lightweight local tool for a plethora of databases https://dbeaver.io/
• DataGrip - commercial product, but you'll feel right at home if you use other JetBrains products https://www.jetbrains.com/datagrip/
• HeidiSQL - haven't really used this myself but the version graph on the page is cool https://www.heidisql.com/
• DbVisualizer - really cool tool that helps you explore messy schemas https://www.dbvis.com/
• Jailer - something for exploring datasets, a bit niche, but can be useful https://wisser.github.io/Jailer/
There's also some solutions that are specific to certain databases, like:
• pgAdmin - for PostgreSQL https://www.pgadmin.org/
• MySQL Workbench - for MySQL/MariaDB, sometimes a bit buggy but I really like the reverse engineering and forward engineering functionality https://www.mysql.com/products/workbench/
• Adminer - one of the somewhat rare web based solutions for the likes of MySQL/MariaDB, actually pleasant to use as long as you use it securely, this I think is a good example of web based DB tools https://www.adminer.org/
(out of respect for my own sanity, not mentioning SQL Developer, even though it sort of works)
For whatever reason, this is the main limiting factor, local software can already be really good, for example:
• DBeaver - pretty nice and lightweight local tool for a plethora of databases https://dbeaver.io/
• DataGrip - commercial product, but you'll feel right at home if you use other JetBrains products https://www.jetbrains.com/datagrip/
• HeidiSQL - haven't really used this myself but the version graph on the page is cool https://www.heidisql.com/
• DbVisualizer - really cool tool that helps you explore messy schemas https://www.dbvis.com/
• Jailer - something for exploring datasets, a bit niche, but can be useful https://wisser.github.io/Jailer/
There's also some solutions that are specific to certain databases, like:
• pgAdmin - for PostgreSQL https://www.pgadmin.org/
• MySQL Workbench - for MySQL/MariaDB, sometimes a bit buggy but I really like the reverse engineering and forward engineering functionality https://www.mysql.com/products/workbench/
• Adminer - one of the somewhat rare web based solutions for the likes of MySQL/MariaDB, actually pleasant to use as long as you use it securely, this I think is a good example of web based DB tools https://www.adminer.org/
(out of respect for my own sanity, not mentioning SQL Developer, even though it sort of works)