3 ms·

> browser based For whatever reason, this is the main limiting factor, local software can already be really good, for example: • DBeaver - pretty nice and lig

> 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/ https://dbeaver.io/ • DataGrip - commercial product, but you'll feel right at home if you use other JetBrains products https://www.jetbrains.com/datagrip/ 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/ https://www.heidisql.com/ • DbVisualizer - really cool tool that helps you explore messy schemas https://www.dbvis.com/ https://www.dbvis.com/ • Jailer - something for exploring datasets, a bit niche, but can be useful https://wisser.github.io/Jailer/ https://wisser.github.io/Jailer/ There's also some solutions that are specific to certain databases, like: • pgAdmin - for PostgreSQL https://www.pgadmin.org/ 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/ 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/ https://www.adminer.org/ (out of respect for my own sanity, not mentioning SQL Developer, even though it sort of works)

RyanHamilton 2y ago
QStudio. Editor and notebook in one, works on all os with 30+ databases and is Free: https://www.timestored.com/qstudio/ https://www.timestored.com/qstudio/ disclaimer: I'm the author
- wazoox 2y ago
  Looks great, how come I didn't know it? :)
  - RyanHamilton 2y ago
    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.
    - earthnail 2y ago
      The chart feature looks amazing. I’d try making a landing page just around charts and see if it sticks.
    - nativeit 2y ago
      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.
- anbotero 2y ago
  Looks interesting. Have you thought about providing it as a Homebrew Cask? Anyways, looking into it.
kennethh 2y ago
Great list. Azure Data Studio is pretty good and free to use. https://learn.microsoft.com/en-us/azure-data-studio https://learn.microsoft.com/en-us/azure-data-studio Supports of course most MS products but also: PostgreSQL MySQL MongoDB Apache Spark Apache Cassandra
tianzhou 2y ago
https://www.bytebase.com/sql-editor/ https://www.bytebase.com/sql-editor/ with data access control, dynamic data masking.
bbkane 2y ago
Two more tools I really enjoy: - https://www.beekeeperstudio.io/ https://www.beekeeperstudio.io/ - electron based and I find it really simple to use. - https://github.com/k1LoW/tbls https://github.com/k1LoW/tbls - generate markdown docs from databases (similar to DbVisualizer, but it's a static binary and you can just push the md files - see https://github.com/bbkane/envelope/tree/master/dbdoc https://github.com/bbkane/envelope/tree/master/dbdoc for example)
deleted 2y ago
[deleted]
asmith11 2y ago
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/ https://wisser.github.io/Jailer/)
gondo 2y ago
There is also an old school browser based phpMyAdmin

RyanHamilton 2y ago

QStudio. Editor and notebook in one, works on all os with 30+ databases and is Free: https://www.timestored.com/qstudio/ https://www.timestored.com/qstudio/ disclaimer: I'm the author

wazoox 2y ago
Looks great, how come I didn't know it? :)
- RyanHamilton 2y ago
  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.
  - earthnail 2y ago
    The chart feature looks amazing. I’d try making a landing page just around charts and see if it sticks.
  - nativeit 2y ago
    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.
anbotero 2y ago
Looks interesting. Have you thought about providing it as a Homebrew Cask? Anyways, looking into it.

kennethh 2y ago

Great list. Azure Data Studio is pretty good and free to use. https://learn.microsoft.com/en-us/azure-data-studio https://learn.microsoft.com/en-us/azure-data-studio Supports of course most MS products but also: PostgreSQL MySQL MongoDB Apache Spark Apache Cassandra

tianzhou 2y ago

https://www.bytebase.com/sql-editor/ https://www.bytebase.com/sql-editor/ with data access control, dynamic data masking.

bbkane 2y ago

Two more tools I really enjoy: - https://www.beekeeperstudio.io/ https://www.beekeeperstudio.io/ - electron based and I find it really simple to use. - https://github.com/k1LoW/tbls https://github.com/k1LoW/tbls - generate markdown docs from databases (similar to DbVisualizer, but it's a static binary and you can just push the md files - see https://github.com/bbkane/envelope/tree/master/dbdoc https://github.com/bbkane/envelope/tree/master/dbdoc for example)

deleted 2y ago

[deleted]

asmith11 2y ago

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/ https://wisser.github.io/Jailer/)

gondo 2y ago

There is also an old school browser based phpMyAdmin