{"repo":"boringcollege/postgres-by-example","free":true,"listed":false,"github":"https://github.com/boringcollege/postgres-by-example","clone":"git clone https://github.com/boringcollege/postgres-by-example.git","description":"Yet another postgresql book!","language":"PLpgSQL","stars":289,"topics":["book","postgis","postgres","postgres-book","postgresql","postgresql-database"],"license":null,"category":"databases-storage","readme_excerpt":"Postgres by Example PostgreSQL is a free, open-source, ACID-compliant relational database. It is the database of choice for a large share of new applications because it is reliable, deeply featureful, standards-compliant, and friendly to extension. The official documentation is excellent — keep it open as you work through these lessons. Postgres by Example is a hands-on introduction to PostgreSQL using annotated SQL examples. Each lesson is short enough to read in a few minutes and is paired with a runnable .sql file in source/ . The lessons build on one another: by the end you will know how to model data, query it, index it, run transactions, write stored functions, and operate the database day-to-day. Start with the first example or browse the full list below. Prerequisites. A working PostgreSQL installation (version 14 or newer is recommended; the lessons target current stable PostgreSQL, which at the time of writing is PostgreSQL 17). You should be able to connect with the psql command-line client. The examples assume a database called postgres unless noted; create a scratch database if you prefer ( createdb pbe && psql pbe ). Start the server with your system's service manager ( brew services start postgresql , systemctl start postgresql , etc.) or with pg ctl start for an isolated cluster. How to use this book. Each lesson includes a short explanation, a SQL example you can run, and a sample of the output. Run the file with psql -f source/ .sql postgres and compare what","default_branch":null,"files":null,"tree":[],"storefront":"/r/boringcollege","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/boringcollege/postgres-by-example/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}