• 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)
I'm bad at marketing and poor at product decisions. For 10 years it only worked with one database. It took 30 lines of code to work on many more databases but I waited 10 years to do it. Don't make my mistake! I am trying to get better.
A nerd’s nerd. I am exactly the same, I think it’s because folks like a lot of the people that hang out around these comments are easily excited and self-motivated for the creative, engineering challenges involved, but struggle to produce the same kind of get up and go when it comes to the basic, fundamental packaging and presentation involved with marketing and/or sales.
As a graphic artist, I even get enthusiastic for a lot of the marketing, but as a freelance IT consultant, I tend to lose all motivation for selling my services the nanosecond I achieve sufficient income to get by, and revert to spending my time exploring and tinkering. We all have our own blind/weak spots.
I have often thought that some kind of service to pair creatives/engineers with professional development/managers would be really useful. I think that’s just called “LinkedIn”, but something more explicitly about entrepreneurial endeavors would be nice.
Jailer is awesome and really not “niche”. Also, it's not something for exploring "datasets", but for tables and relational databases in an innovative way. I think it would be fantastic if more people knew about it.
(https://wisser.github.io/Jailer/)
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)