Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pc7ne-0005Ns-Jb for pgsql-admin@arkaria.postgresql.org; Tue, 14 Mar 2023 16:46:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pc7nd-0000w5-1P for pgsql-admin@arkaria.postgresql.org; Tue, 14 Mar 2023 16:46:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pc7nc-0000vu-KU for pgsql-admin@lists.postgresql.org; Tue, 14 Mar 2023 16:46:56 +0000 Received: from mail-pj1-x1030.google.com ([2607:f8b0:4864:20::1030]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pc7na-0006S0-1t for pgsql-admin@lists.postgresql.org; Tue, 14 Mar 2023 16:46:56 +0000 Received: by mail-pj1-x1030.google.com with SMTP id y15-20020a17090aa40f00b00237ad8ee3a0so15779567pjp.2 for ; Tue, 14 Mar 2023 09:46:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1678812411; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=SNqFt4i+8UV16lfg+xE/O5BPD5ZciWHdZ81+USvIXc8=; b=Rpwrn/63Sq7xfTnQ4nTxxOYV7UvlFUIrv5UfGn5Z24nIpE6ksBTixljpJfNQl54gLX mB+wVYsCzPNyzpOB+b9M7YTnELw+Z1/+WVrydcMenkaWOJCauQUmxVtqEdqHNs1lsgx2 VvT3aA/HxsWe7ioLdXIMiwn9ZuAtCE3gXcJJpxsTXO0QdJhGD/2cvvifixglljQtRI4N SYXKK7HW0anCHCwJS8LOC7BP+geOEWN0knmVhwHViQou3LVE+MtkxuurYRdtN60M398Y 5+Xg8aaLwfLHHBG8yDoDNNV6X1twzdB94U/u5MpALTYoqcgCuhtcGEUCMbrWiEW0/vPg z0cw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678812411; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=SNqFt4i+8UV16lfg+xE/O5BPD5ZciWHdZ81+USvIXc8=; b=IxY09NRaNqeZSAd/DvC3vuEXYKolZhOBvktWUwbVInlveyBKVc1oUy/m2Jt3M3DNWn bNYcZTHdaigSpXrXOwFXHr6BMFpMxprmjWwUHfQE5Cyk/S9/tMuzjIrr46AjwAkku8je 3Vl4pVb0/j0sKZF8HxSLJV7AktUVTNzEPcDIOBd3T9zCH3DWjFr9VX6p4uFjvTjQRbXo /UZElz21Hyh5rD1sP5WpOe8l/H1H3nR8sZ6p87IywxBIWPShj1hNW+XiiOB/Fp8eJd0x 3P5FhO6u+X0XzF17IYHOVqMCsNDTtDbrQrpbptykdBscTJsT3ud/Jo4slss/6xuq1WlE 2JgA== X-Gm-Message-State: AO0yUKVe2nY4pvMAy8ok7DjS3JLBjdUcpkeMdUS/+lBIcgdBvge7PtlB TNCyIkU/bv8HFGjS4Pa6gwhL6SIl4mJv2jSs4qONoPqo X-Google-Smtp-Source: AK7set8uX0wrvYz1XaAccOZ8jk6qGfhT9Xn05f/4dv1F6U9TrICgE4Zut+k+eif5TDse1qbxbnhnG/f58HHUc8432xw= X-Received: by 2002:a17:90a:9109:b0:234:a03b:b84d with SMTP id k9-20020a17090a910900b00234a03bb84dmr14023397pjo.6.1678812411013; Tue, 14 Mar 2023 09:46:51 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Tim Date: Tue, 14 Mar 2023 12:46:39 -0400 Message-ID: Subject: Re: CRUD tool? To: Rich Pixley Cc: "pgsql-admin@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000672eb305f6def99f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000672eb305f6def99f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=E2=80=AFPM Rich Pixley 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? > > > > --000000000000672eb305f6def99f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
You're confusing common and basic with something = thats highly specific and customized to what you need. pgAdmin is a very co= mmon and basic way to interface with the database. All DB GUI tools are goi= ng to have the same functionality, because that is what the functionality o= f a database is.=C2=A0

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 re= ally describing what you need, you need a CRUD tool that works on ONE table= ?!)=C2=A0

Either you have to learn how a DB GUI to= ol works and educate your users accordingly, or you have to build a small s= imple application that can do exactly what you need.=C2=A0

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


On Tue, Mar 14, 2023 at 12:01=E2= =80=AFPM Rich Pixley <rich.pixl= ey@hayden.ai> wrote:
I'm looking for a tool that can provide simple, add/query/c= hange/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?=C2=A0 I haven't been ab= le to
find any and I'm thinking this should be a common, basic sort of
functionality.=C2=A0 Or am I missing something obvious?



--000000000000672eb305f6def99f--