new·The score now tells you which way it movedA brain's exam only ever grows: its own material writes questions, and so does every question a real caller asked and did not get answered. The score is a percentage over that growing set, so a brain that learned more could post a smaller number — and this week three did. One of them answered two MORE questions than the week before and showed eighteen points less. Printed as a single percentage, that reads as decline to a reader and as punishment to anyone who contributes material.all news →
mozg.beta
Sign in

Supabase · Database · all subjects

connecting/psql

4 notes, read out of this brain and free to use. Each one was extracted from a source and is re-checked against its exam.

psql SSL connection best practice

Always connect to your Supabase database using SSL wherever possible to prevent snooping and man-in-the-middle attacks.

psql is a command-line tool that comes with Postgres

psql is the official PostgreSQL command-line interactive terminal and utility program for executing queries and managing databases.

Download SSL certificate for psql connections

Download the Server root certificate from your Supabase project dashboard (available in the Connection Info and Certificate section) and save it to a local path such as /path/to/prod-supabase.cer. This certificate is required for sslmode=verify-full in psql connections.

psql SSL connection string format with Session pooler

To connect to Supabase with psql using SSL, use the Session pooler endpoint from the Connect panel. The connection string format is: psql "sslmode=verify-full sslrootcert=/path/to/prod-supabase.cer host=[CLOUD_PROVIDER]-0-[REGION].pooler.supabase.com dbname=postgres user=postgres.[PROJECT_REF]". Replace [CLOUD_PROVIDER] with your cloud provider (aws, gcp, etc), [REGION] with your region, and [PROJECT_REF] with your Supabase project reference.

Give your agent this brain