News for hackers. Stuff that matters.
Re:Show HN: Outerbase Studio – Open-Source Database GUI by KronisLV on Thursday December 05, 2024 @02:44AM (#42325924)
> 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)

Re:Show HN: Outerbase Studio – Open-Source Database GUI by RyanHamilton on Thursday December 05, 2024 @03:08AM (#42326040)
QStudio. Editor and notebook in one, works on all os with 30+ databases and is Free: https://www.timestored.com/qstudio/ disclaimer: I'm the author
Re:Show HN: Outerbase Studio – Open-Source Database GUI by wazoox on Thursday December 05, 2024 @05:02AM (#42326632)
Looks great, how come I didn't know it? :)
Re:Show HN: Outerbase Studio – Open-Source Database GUI by RyanHamilton on Thursday December 05, 2024 @05:13AM (#42326698)
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.
Re:Show HN: Outerbase Studio – Open-Source Database GUI by earthnail on Thursday December 05, 2024 @08:46AM (#42328182)
The chart feature looks amazing. I’d try making a landing page just around charts and see if it sticks.
Re:Show HN: Outerbase Studio – Open-Source Database GUI by nativeit on Thursday December 05, 2024 @12:28PM (#42330327)
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.

Re:Show HN: Outerbase Studio – Open-Source Database GUI by anbotero on Thursday December 05, 2024 @09:42AM (#42328659)
Looks interesting. Have you thought about providing it as a Homebrew Cask? Anyways, looking into it.
Re:Show HN: Outerbase Studio – Open-Source Database GUI by kennethh on Thursday December 05, 2024 @04:59AM (#42326618)
Great list.

Azure Data Studio is pretty good and free to use. https://learn.microsoft.com/en-us/azure-data-studio

Supports of course most MS products but also: PostgreSQL MySQL MongoDB Apache Spark Apache Cassandra

Re:Show HN: Outerbase Studio – Open-Source Database GUI by bbkane on Thursday December 05, 2024 @08:32AM (#42328063)
Two more tools I really enjoy:

- https://www.beekeeperstudio.io/ - electron based and I find it really simple to use.

- 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 for example)

Re:Show HN: Outerbase Studio – Open-Source Database GUI by asmith11 on Thursday December 05, 2024 @08:45AM (#42328173)
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/)
Re:Show HN: Outerbase Studio – Open-Source Database GUI by gondo on Thursday December 05, 2024 @11:00AM (#42329386)
There is also an old school browser based phpMyAdmin
Re:Show HN: Outerbase Studio – Open-Source Database GUI by tianzhou on Wednesday December 11, 2024 @05:38AM (#42386563)
https://www.bytebase.com/sql-editor/ with data access control, dynamic data masking.