PostgreSQL

PostgreSQL is a relational database. It can be classified as an OLTP database.

Client libraries

• PostgreSQL JDBC driver available in jdbc.postgres.org.
• psycopg2 is the popular Python library
  • pip install psycopg2-binary for the pre-built binary package

Partitions

PostgreSQL has built-in support for partitioned tables. But it’s not super seamless. pg_partman is a very useful Postgres package for automatically managing table partitions.

Network protocol

• https://www.postgresql.org/docs/current/protocol.html

Leave a Comment