Leebra sql
login register

Graphical SQL Editor with auto-complete for Relational Tables?

3 years ago by requiem to c/sql

save

share

report

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?

shertson 2 points 3 years ago

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

save

path: 0 1996287, hotness: undefined, score: 2, children: 2
requiem 1 point 3 years ago

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?

save

path: 0 1996287 2001780, hotness: undefined, score: 1, children: 1
shertson 1 point 3 years 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.

save

path: 0 1996287 2001780 2062091, hotness: undefined, score: 1, children: 0
sql
sql

@lemmy.world

login for more options
329
14
7

For discussion about SQL and databases. All versions welcome.

  • MSSQL
  • PostgreSQL
  • MariaDB
  • SQLite
  • etc...

go to feed...