Google signin

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: PostgreSQL WWW <pgsql-www(at)postgresql(dot)org>
Subject: Google signin
Date: 2017-07-12 12:23:26
Message-ID: CABUevEwOLc_MvtQ-kVdY-PGaEA7ZNbMnCQHmvHe5uOhG_zDURQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www

I'm working on Cleaning Up Some Old Branches (TM) in the pgweb repository,
and found one I did during some airport hacking that I forgot to post to
people about.

It's been discussed a couple of times that we should perhaps support Google
signin for community auth.

Basically, the idea behind it would be that on the login page you would
both have the regular userid/password box, and also a button for "sign in
with google". If somebody signs in with Google, it would automatically
match it to their community account based on email address (since Google
doesn't have the concept of a separate userid, and even if they did that
would open up all sorts of hijacking vulnerabilities). If they didn't
already have a community account, we'd offer to create one automatically
and copy the main information over from the Google profile.

My implementation so far, which does the login but not the provisioning of
new accounts yet, is about 50 lines of python/django and 25 lines of
javascript. So it's not very difficult to do.

The bigger question is - do we *want* to do this?

I've attached a screenshot of what the implementation looks like at this
point. Obviously, CSSing and things can always be improved.

Thoughts?

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Attachment Content-Type Size
image/png 16.8 KB

Responses

Browse pgsql-www by date

  From Date Subject
Next Message Dave Page 2017-07-12 12:30:20 Re: Google signin
Previous Message Huy Pham 2017-07-12 08:52:29 Wiki editor request