this post was submitted on 27 Jul 2023
1 points (100.0% liked)

SQL - any and all

302 readers
1 users here now

For discussion about SQL and databases. All versions welcome.

founded 1 year ago
MODERATORS
shertson
1
Graphical SQL Editor with auto-complete for Relational Tables? (self.sql)
submitted 11 months ago* (last edited 11 months ago) by requiem to c/sql
3 comments fedilink hide all child comments
 

Hi!

I'm looking at manually entering quite a bit of relational data and I am wondering whether anyone knows of a nice GUI tool to do it?

What I'm looking at doing is something like matching up names with addresses. I have a table with a list of people, and I have a list of properties. I want to create a table where I could pair up people with properties. I would like the ID's to be entered into the Database, but I would like to see names and addresses on the front-end. Preferably when I click into the new relational table's columns it would give me an auto-complete list of possible values as I type. (So offer suggestions for names / addresses).

I'm looking for something web-based or MacOS / Linux compatible.

Does anyone know of such a tool?

top 3 comments
sorted by: hot top controversial new old
[–] shertson 2 points 11 months ago (1 children)

I've had luck with dBeaver. I've used it with both MSSQL, postgresql, and Apache Hive.

[–] requiem 1 points 11 months ago* (last edited 11 months ago) (1 children)

That’s great. Thank you so much! Does it have features like this out of the box? Did you use one of the paid versions?

[–] shertson 1 points 11 months ago

I generally don't do a whole lot of customizing or tweaking to my computers. So, no, I didn't add anything to make it work.