PostgreSQL

Cannot install psycopg2 with pip3 on M1 Mac

export LDFLAGS="-L/opt/homebrew/opt/openssl@1.1/lib -L/opt/homebrew/opt/libpq/lib"
export CPPFLAGS="-I/opt/homebrew/opt/openssl@1.1/include -I/opt/homebrew/opt/libpq/include"

Links

• Five Tips For a Healthier Postgres Database in the New Year (2021)
• PostgreSQL collation
• Postgres Tips & Tricks
• Analysis and optimization SQL queries. Some PL/pgSQL scripts
• Learn Postgres at the Playground
• PGLoader - Migrate to PostgreSQL in a single command!
• Understanding the Postgres EXPLAIN cost
• Scaling PostgresML to 1 Million Requests per Second
• Individual PostgreSQL instances to everyone - Why we moved from AWS RDS to Postgres in Kubernetes
• Топ полезных SQL-запросов для PostgreSQL (2022)
• Django PostgreSQL Database Connection Pooling with PgBouncer (2023)
• Some useful, non-obvious Postgres patterns
• Enhance your Postgres skills - crunchydata