Web users as database users?

[David Gallagher]

Hi - I’m working on a database that will be accessed via a web app. I’m
used to a setup where there is one account/role that the app would use to
access the database, but in my current scenario I’m interested in row level
security and auditing enforced by the database. In this scenario, would it
make sense to have a user account on the database to mirror the user
account from the web app? Is that an unusual practice?

Re: "Go" (lang) standard driver

[David Gallagher]

I can recommend sqlx:
https://github.com/jmoiron/sqlx


On Tue, Aug 18, 2020 at 4:56 PM Scottix  wrote:

> I have been using pgx and seems to be working well.
>
> I recommend if your just starting to use the v4 version.
>
> On Tue, Aug 18, 2020 at 5:53 AM Stephen Frost  wrote:
>
>> Greetings,
>>
>>
>>
>>
>>
>> * Olivier Gautherot (ogauthe...@gautherot.net) wrote:
>>
>>
>> > Le mar. 18 août 2020 à 09:36, Tony Shelver  a
>> écrit :
>>
>>
>> > > -- Forwarded message -
>>
>>
>> > > From: Tony Shelver 
>>
>>
>> > > Date: Tue, 18 Aug 2020 at 09:33
>>
>>
>> > > Subject: Re: "Go" (lang) standard driver
>>
>>
>> > > To: Edson Richter 
>>
>>
>> > >
>>
>>
>> > >
>>
>>
>> > > A quick Google search found https://github.com/lib/pq.   Has 6.1K
>> stars
>>
>>
>> > > so I would guess fairly well used.
>>
>>
>> >
>>
>>
>> > I have used it successfully and it performed perfectly. Go for it.
>>
>>
>>
>>
>>
>> It also says that it's not actively developed and recommends pgx
>>
>>
>> instead...
>>
>>
>>
>>
>>
>> Thanks,
>>
>>
>>
>>
>>
>> Stephen
>>
>>
>>
>
> --
> T: @Thaumion
> IG: Thaumion
> scot...@gmail.com
>
>
>