91–100 of 153 posts
Make it as easy to run as something like datasette.
For years I've wondered why a general purpose, high quality, good UX, browser based DB browser has not existed. I've implemented 3 such (not general-purpose) browsers in my career. But I'd be really happy to stop doing that and use this instead. I would love to see a Firestore driver implemented (maybe I'll take a crack at it some day), as I'm stuck in GCP land for the time being.
I think it's because there's no business model in the pure "DB browser" product. People don't seem willing to pay enough for it to build a good business around it. Everyone I've seen either pivots to a Retool competitor or a BI tool. Source: I've tried it twice.
For years I've wondered why a general purpose, high quality, good UX, browser based DB browser has not existed. I've implemented 3 such (not general-purpose) browsers in my career. But I'd be really happy to stop doing that and use this instead. I would love to see a Firestore driver implemented (maybe I'll take a crack at it some day), as I'm stuck in GCP land for the time being.
dbeaver? it has dbeaver community edition, and supports tons of database.
Earlier quoted context omitted.
Still a valid counterargument. A good browser based DB GUI might just not exist because the existing desktop ones are so good already. I personally also vouch for DataGrip, a fantastic tool. No browser based tool is going to come close to the experience of an actual desktop app imo
> No browser based tool is going to come close to the experience of an actual desktop app imo Why?
The main benefit is that you can organize your SQLs in files or even better in markdown files.
God knows how many times I had to retype the same or a very similar SQL in the past.
For years I've wondered why a general purpose, high quality, good UX, browser based DB browser has not existed. I've implemented 3 such (not general-purpose) browsers in my career. But I'd be really happy to stop doing that and use this instead. I would love to see a Firestore driver implemented (maybe I'll take a crack at it some day), as I'm stuck in GCP land for the time being.
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)