Curious what the community is running for authentication/authorization in their apps (e.g. Auth0, Supabase Auth, Clerk, Firebase Auth, Cognito, etc.)

A few things I'd love to hear your take on:

• What provider are you using and what's your primary stack? (e.g. Next.js + Clerk, Go + Auth0, etc.)

• What's the one thing that surprised you , good or bad ?

• Would you make the same call today? Especially curious if you've hit scaling pain.

For context: I'm building a B2C application with my own database layer, and currently in the process of evaluating which authentication provider best fits the architecture. Trying to understand how others are handling the auth <> database relationship and what influenced your final decision.