x-yuri

Overview of Cloud SQL (PostgreSQL) authentication

There are 2 ways to connect to a Cloud SQL database: directly, or via a connector. [2 types of connectors][n] are supported: standalone ([Cloud SQL Auth Proxy][b]), and in-process ([Cloud SQL Language Connector][a], available for [Java, Python, Go, and Node.js][c]).

There are also [2 ways to authenticate][d] to a database:

• The PostgreSQL's built-in authentication (password).
• IAM database authentication. In this case you need an IAM service account and a [matching PostgreSQL user][e].

But before you can do that, you need to give yourself access to the database ([authorize the connection][f]):

cpursley

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

gboudreau

Generating Authy passwords on other authenticators

---

*update: TBC, but this new might affect how easy it is to use this technique past August 2024: Authy is shutting down its desktop app | The 2FA app Authy will only be available on Android and iOS starting in August

---

This gist, based in part on a gist by Brian Hartvigsen, allows you to export from Authy your TOTP tokens you have stored there.
Those can be "standard" 6-digits / 30 secs tokens, or Authy's own version, the 7-digits / 10 secs tokens.