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@lemmy.worldM
    link
    fedilink
    arrow-up
    2
    ·
    11 months ago

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

    • requiem@lemmy.worldOP
      link
      fedilink
      English
      arrow-up
      1
      ·
      edit-2
      11 months 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?

      • Shertson@lemmy.worldM
        link
        fedilink
        arrow-up
        1
        ·
        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.