[wink]

Just installed it for the first time in a few years.

- Again I wonder why it doesn't show the tables first, I have to go through Schemas -> Public.

- 480 MB of RES RAM, I'm connected to one smallish Postgres DB.

- I can't even find "just show me the contents of the table, like 'SELECT * FROM'.

I know, maybe it's tailored for Enterprise Database Architects, but this is my smoke test for a DB GUIs:

"How long and how many clicks does it take so that it provides more value than: 'psql; \dt+; SELECT * FROM X;'"

[spricket]

Maybe I've been jaded by SSMS and Mysql Management Studio heh. DBeaver actually has a better UI than most DB tools I've used, even though that's still not saying a lot.

Mouse over the buttons for an excessive amount of time and the tooltips will tell ya what they do.

Double click a table and go to "data" tab to see contents.

Schemas ->public is just a side effect of supporting a lot of different databases. Many support schemas

Ram is because default java heap size, you could probably change launch params to get it much lower though.

On all counts other DB tools I've used are just as obtuse and burn tons of resources. Most are written in Java or another high-level language because it's nigh impossible to get DB drivers for a ton of different databases working together in C. DBeaver is basically leveraging JDBC for what it was designed for

[wink]

I don't know those 2, but I like Sequel Pro and pgadmin.

And yeah, I found "data" and maybe reading the manual would even let me somehow get there quicker. Still, I don't remember ever working with Postgres (or Oracle) in whatever role or project and not needing the "data" view 10 times as often as the schemas or other stuff :)

[spricket]

I agree completely. The UI is kinda hokey but I still love it because I've seen so much worse. Try giving it a few weeks, as you need the more advanced stuff you'll learn where the bodies are buried and it becomes semi pleasant to use

[h1d]

My workflow is just too used to the easiness of using SequelPro, I can't live using any of "heavy" clients, not even DataGrip which is unfortunate as I cannot leave using MySQL.

Closest thing that works for me is TablePlus but the UI smoothness is still rough around the edges.

[mritchie712]

I have this same smoke test and it's one of the reasons we built "slash commands" into SeekWell (https://seekwell.io/). If you type "/show" (or even just "/s") you get a list of tables that will be filtered down as you type. Once you select a table it will autocomplete a SELECT statement and return the results. It also works for things like adding a WHERE condition. The goal is to make it so you never have to leave your keyboard, but also never need to type out menial SQL. Here's a 30 seconds video showing how it works.

https://www.useloom.com/share/0e0b79b0b8304035af4bb15552abc3...

[spricket]

DBeaver has some basic autocomplete that's frequently useful. Nothing super powerful but hitting shift enter(shortcut may be different off Mac) when on text pane at top of data tab will help you select cold easier