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.