1 Meeting Postgres

 

This chapter covers

  • Understanding what “Just Use Postgres” means
  • Starting Postgres and connecting from a command-line tool.
  • Generating mock data using built-in database capabilities and running a few basic queries

PostgreSQL (or simply Postgres, as most call it), is one of the fastest-growing relational and general-purpose databases.

As a relational database, it natively supports SQL (structured query language) and is a popular choice for OLTP (online transaction processing) workloads that process user requests with low latency while guaranteeing data consistency and integrity even if a database server crashes in the middle of an operation execution. You encounter OLTP systems daily while booking a flight to your next vacation destination, paying for groceries at a local supermarket, or sharing a new post on social media.

1.1 Why is Postgres so popular?

1.2 “Just Use Postgres” explained

1.3 Starting Postgres in Docker

1.4 Connecting with psql

1.5 Generating mock data

1.6 Running basic queries

1.7 Summary