Re: javascript app running in crhome with connection to postgreSQL

Hi Stan. I have been dealing with this lately. I have a Chrome Extension
that does work gathering the info to save in the postgresql, such as screen
scraping a specific tab. I am using AWS RDS hosted Postgresql, btw. I am
not sure however, due to security reasons, that you can open a connection
*directly* from the Chrome extension to the database. If you find it is
possible, please let me know. The security rules on Extension are very
strict. The Extension is written in javascript,. The extension can
communicate to my web app that is running in a tab (via the Chrome API). It
is this web app that will maintain an open connection to the postgres
server (which is remote). My webapp is written in php and from my
understanding each copy (it is multiuser) maintains its own connection to
postgres. I will implement RLS (row level security) just to be sure! Will
this all work? I am not totally done yet and am stuck right now on getting
the php App (running on Docker) to open a connection with the RDS
Postgresql.

Nice BF quote. If you haven't read it, read BF's autobiography. It reads
like it was written just recently.

On Wed, Jun 10, 2020 at 9:23 AM stan <stanb(at)panix(dot)com> wrote:

>
> OK, I have to admit this is a case of my being influenced by things going
> on
> in the news, which I am not normally influenced by.
>
> All the news about the touch screens on the crew dragon capsule using a
> JavaScript app running in Chrome, have me thinking about doing some
> testing for a project I am working on that I am not happy with the
> direction we are currently going in for the fronted.
>
> Can anyone point me to some documentation as to how to start building a
> test application for this?
>
> My first question is whether this would have a persistent connection to the
> backend database, or would it work like a CGI script, and have to make a
> connection to the backend every time the user takes an action?
>
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
> -- Benjamin Franklin
>
>
>
>