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?
3 Comments
shertson@lemmy.world · 2 pts · 3y
I've had luck with dBeaver. I've used it with both MSSQL, postgresql, and Apache Hive.
requiem@lemmy.world · 1 pts · 3y
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@lemmy.world · 1 pts · 3y
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.