March 13, 2019

How do you edit the database data in your project?

Lets say you want your team to edit an user info manually but you dont want them to edit the database directly using a GUI or running commands. What approach/solution people normally use?

Wondering if the "normal" approach is to build a custom solution or try to reuse a CMS that connects with your DB but i think is not 100% valid after all.

#askih #tech-questions

  1. 1

    I typically do it all via scripts directly in the database but only after a code review.

    1. 1

      Thats good too but i would like a GUI for non tech people in order to update, etc.

      Thanks for the help

  2. 1

    It's important to record who/when/where update the user info.

    1. 1

      Yeah, good point and useful if a disaster happens hehe.

      Thanks 😊

  3. 1

    Symfony, Rails, Django all have admin interfaces built-in (or very easy to install). What backend stack do you use?

    1. 1

      Ah okay, so is a common solution to use some frameworks admin panels (like Django) but there are not standard tools. My stack is under Node.js and is true there are some tools but normally focused to Mongodb not Postgresql. I think a workaround could be to use Django admin just for this :)

      Many thanks!! 👏

  4. 1

    This comment was deleted 7 months ago.