Обсуждение: CRUD tool?

Поиск
Список
Период
Сортировка

CRUD tool?

От
Rich Pixley
Дата:
I'm looking for a tool that can provide simple, add/query/change/delete 
kinds of operations on a table (or view) and I'm not finding much.

pgAdmin can do this but it also exposes a LOT of power and complexity 
that I don't need to expose to the set of users I have in mind.

Are there any other appropriate tools for this?  I haven't been able to 
find any and I'm thinking this should be a common, basic sort of 
functionality.  Or am I missing something obvious?




Re: CRUD tool?

От
Tim
Дата:
You're confusing common and basic with something thats highly specific and customized to what you need. pgAdmin is a very common and basic way to interface with the database. All DB GUI tools are going to have the same functionality, because that is what the functionality of a database is. 

What you want is something extremely specific to your scenario, which doesnt exist already because you're the only one with your particular scenario. (You're not even really describing what you need, you need a CRUD tool that works on ONE table?!) 

Either you have to learn how a DB GUI tool works and educate your users accordingly, or you have to build a small simple application that can do exactly what you need. 

Its like saying I need a vehicle for my grandmother that only drives to the grocery store and church on Sundays, regular cars expose too much functionality. 


On Tue, Mar 14, 2023 at 12:01 PM Rich Pixley <rich.pixley@hayden.ai> wrote:
I'm looking for a tool that can provide simple, add/query/change/delete
kinds of operations on a table (or view) and I'm not finding much.

pgAdmin can do this but it also exposes a LOT of power and complexity
that I don't need to expose to the set of users I have in mind.

Are there any other appropriate tools for this?  I haven't been able to
find any and I'm thinking this should be a common, basic sort of
functionality.  Or am I missing something obvious?



Re: CRUD tool?

От
Mónica Gamarra
Дата:
If you create limited user accounts to the table they have to manage, the use of pgAdmin is suitable for you.
If possible isolate the table in a separate db/schema to simplify user account definition.



On Tue, Mar 14, 2023 at 5:01 PM Rich Pixley <rich.pixley@hayden.ai> wrote:
I'm looking for a tool that can provide simple, add/query/change/delete
kinds of operations on a table (or view) and I'm not finding much.

pgAdmin can do this but it also exposes a LOT of power and complexity
that I don't need to expose to the set of users I have in mind.

Are there any other appropriate tools for this?  I haven't been able to
find any and I'm thinking this should be a common, basic sort of
functionality.  Or am I missing something obvious?





--
............................................
Mónica Gamarra Barrios
monica.gamarra@gmail.com

Re: CRUD tool?

От
Thomas Kellerer
Дата:
Rich Pixley schrieb am 14.03.2023 um 17:01:
> I'm looking for a tool that can provide simple,
> add/query/change/delete kinds of operations on a table (or view) and
> I'm not finding much.
>
> pgAdmin can do this but it also exposes a LOT of power and complexity
> that I don't need to expose to the set of users I have in mind.
>
> Are there any other appropriate tools for this?  I haven't been able
> to find any and I'm thinking this should be a common, basic sort of
> functionality.  Or am I missing something obvious?

I haven't used them, but NocoDB or Baserow might be what you are looking for.


Thomas