pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
CRUD tool?
4+ messages / 4 participants
[nested] [flat]

* CRUD tool?
@ 2023-03-14 16:01  Rich Pixley <rich.pixley@hayden.ai>
  0 siblings, 3 replies; 4+ messages in thread

From: Rich Pixley @ 2023-03-14 16:01 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>

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?






^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: CRUD tool?
@ 2023-03-14 16:46  Tim <timfosho@gmail.com>
  parent: Rich Pixley <rich.pixley@hayden.ai>
  2 siblings, 0 replies; 4+ messages in thread

From: Tim @ 2023-03-14 16:46 UTC (permalink / raw)
  To: Rich Pixley <rich.pixley@hayden.ai>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>

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?
>
>
>
>

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: CRUD tool?
@ 2023-03-14 17:19  Mónica Gamarra <monica.gamarra@gmail.com>
  parent: Rich Pixley <rich.pixley@hayden.ai>
  2 siblings, 0 replies; 4+ messages in thread

From: Mónica Gamarra @ 2023-03-14 17:19 UTC (permalink / raw)
  To: Rich Pixley <rich.pixley@hayden.ai>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>

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
Barriosmonica.gamarra@gmail.com <monica.gamarra@gmail.com>*

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: CRUD tool?
@ 2023-03-14 17:28  Thomas Kellerer <shammat@gmx.net>
  parent: Rich Pixley <rich.pixley@hayden.ai>
  2 siblings, 0 replies; 4+ messages in thread

From: Thomas Kellerer @ 2023-03-14 17:28 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

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





^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2023-03-14 17:28 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-03-14 16:01 CRUD tool? Rich Pixley <rich.pixley@hayden.ai>
2023-03-14 16:46 ` Tim <timfosho@gmail.com>
2023-03-14 17:19 ` Mónica Gamarra <monica.gamarra@gmail.com>
2023-03-14 17:28 ` Thomas Kellerer <shammat@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox