>
could [Persona] take the place of 3rd party social sign in providers like Gigya & Janrain?Ideally, yes. One button, any user. No mandatory centralized / trusted third parties.
> if Google, Facebook, etc provided Persona endpoints could I use them to login people to $work's website?
You can actually do that right now. Persona includes a temporary centralized fallback that lets it work for any user, at any domain, right now. The only constraint is that the domain either needs to support Persona (as per the article), or the user needs to be able to receive email at that domain.
> All we really need is a way to authenticate a user and associate them with a user ID in our local database.
Persona is a Very Good Fit for this use case. If you're already storing email addresses for your users, you can implement Persona without making a single schema change. It should take you about an hour to get a proof of concept working.
I gave a 30 minute talk (+15 minutes Q&A) about Persona at PyCon last month: http://pyvideo.org/video/1764/. You might find it helpful in understanding the what, why, and how. I'm also more than happy to help you out personally -- contact info is in my HN profile. Please reach out to me if you have any questions.