beekeeper-studio VS mathesar

If we access a client like PgAdmin or Beekeeper, or accessing its container via bash and checking via CLI, we can see that the table was created successfully:

This tool doesn't let you run SQL queries or create tables. SchemaSpy describes and visualizes an already-created database.

To work directly with SQL, I recommend https://www.beekeeperstudio.io/ or https://dbgate.org/

I use the free “community” edition daily: https://github.com/beekeeper-studio/beekeeper-studio/release...

postgres has some cool tools these days. postico if you are on macos or my personal fav lately has been https://www.beekeeperstudio.io/

Beekeeper Studio is a modern (aesthetic) and lightweight SQL client that supports MySQL, Postgres, SQLite, SQL Server, etc. It is available on Linux, Mac and Windows.

I'm trying to renew my certificate for Beekeeper Studio, 3 years ago it was a simple download, but now it costs 3x the price and they want to ship me a physical device with the private key on it.

`cask "beekeeper-studio"` [link][oss] for anything database

Congratulations on launching, it's nice to see more open source products in this area (I work on https://mathesar.org/). Feel free to reach out if you'd like to talk and compare notes.

This is what we're trying to do with [Mathesar](https://github.com/centerofci/mathesar). We probably don't meet your needs yet because we don't support real-time concurrent editing, but we're actively working on the project and it is early days.

I'm an engineer on the Mathesar core team and I'd just like to clarify that Mathesar does support grouping to some extent. Here is a screenshot[1] that demonstrates the grouping functionality. Grouping levels are unlimited. You can play with this functionality on our live demo[2]. It's worth mentioning that Mathesar does not yet have the capability to expand and collapse groups, but that feature is planned[3].

Best of luck building Visual DB! Nice to see more innovation in this space!

[1]: https://mathesar.org/assets/crm-table-zoomed.png

[2]: https://demo.mathesar.org/

[3]: https://github.com/centerofci/mathesar/issues/475

I’m not sure if it’s okay to plug my project, but I work on Mathesar (https://github.com/centerofci/mathesar) which can be used as a Postgres GUI. We’re putting a lot of product/design effort into making it nice to use for non technical users.

Otherwise, I just use the command line.

We're trying to do this with Mathesar: https://github.com/centerofci/mathesar. Some feedback would be great!

We're trying to build a community driven project in this space - https://github.com/centerofci/mathesar. We just did our alpha release a couple of months ago.

I'm philosophically opposed to open core (Mathesar is run out of a non-profit), but I can see why other projects do it – finding funding for a big project like this is difficult without VCs (who expect returns).

I'm working on https://mathesar.org/ – it's an open source database solution built on Postgres, you can import data, connect to multiple databases, edit data and build reports. It can't connect to non-Postgres databases, so it may not work for you.

We've just released Mathesar v0.1.2. Major new features are support for multiple databases in the UI and more options for installing Mathesar. We also made a bunch of smaller UX improvements and fixed a few bugs. Our full release notes are here: https://github.com/centerofci/mathesar/releases/tag/0.1.2

We did this for our open source project, Mathesar (https://github.com/centerofci/mathesar), which also uses Django. It's a lot of work. You can take a look at our code if it's helpful.