postgresql-101

postgresql-101 for who want to learning and using PostgreSQL from scratch.

to-do-list

• Setup postgresql-18 lab at Debain host
• learning with docs
  • I. Tutorial
  • II. The SQL Language
  • III. Server Administration
  • IV. Client Interfaces
  • V. Server Programming
  • VI. Reference
  • VII. Internals

Docs/Tips/Guides/Tutorials...etc

• Linux downloads (Debian)
• wiki
  • wiki.postgresql.org/wiki/Apt
• PostgreSQL 18
  • www.postgresql.org/docs/18/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
  • www.postgresql.org/docs/18/sql-keywords-appendix.html
• PostgreSQL 17
  • source code
    • www.postgresql.org/ftp/source/v17.5/
  • www.postgresql.org/docs/17/tutorial.html
  • www.postgresql.org/docs/17/admin.html
  • www.postgresql.org/docs/17/client-interfaces.html
    • wiki.postgresql.org/wiki/List_of_drivers
      • www.postgresql.org/docs/current/libpq.html
      • www.psycopg.org/psycopg3/docs/
      • github.com/sfackler/rust-postgres
      • jdbc.postgresql.org/
  • www.postgresql.org/docs/17/database-roles.html
    • www.postgresql.org/docs/17/app-createuser.html
  • www.postgresql.org/docs/17/tutorial-sql-intro.html
• cloudnative-pg/cloudnative-pg/blob/main/docs/src/quickstart
  • This section guides you through testing a PostgreSQL cluster on your local machine by deploying CloudNativePG on a local Kubernetes cluster using either Kind or Minikube.
• 正規化探討