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

SQL - any and all

305 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 1 year ago* (last edited 1 year 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 1 year ago (1 children)

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

[–] requiem 1 points 1 year ago* (last edited 1 year 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 1 year 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.