POSTGRES: The First Experience (POSTGRES: First acquaintance)

This book is great for beginners to get acquainted with the popular Postgres database. The authors of the book are Pavel Luzanov, Egor Rogov, Igor Levshin, and Egor Rogov is also the author of the book PostgreSQL. 15 From the inside out, I am talking about this book. He told me. And although the book about Postgres inside is good, but it is a bit difficult to start, and today's book is perfect for this. It consists of everything. 175 pages that are divided into 12 The chapters presented below. The book can be downloaded here: Russian version, English

1. PostgreSQL — what is it all about? A story about the emergence and development of the postgres project
2. What’s new in PostgreSQL 15 Changelog changes to version 15 compared 14 version
3. Installation on Linux and Windows Simple instructions about installing postgres so you can play with it
4. Connecting to a server, writing SQL queries, and using transactions An example of working with postgres via the command line with DDL execution (Data Definition Language), DML (Data Manipulation Language), DCL (Data Control Language), TCL (Transaction Control Language) Create table, alter table, drop table, select, insert, delete, update, grant, revoke, start/commit, rollback
5. Learning the SQL language on a demo database - Demo on the example of booking hotels, buying tickets, airports and so on. This demo database can be downloaded and played with more complex queries, including aggregation functions, window functions, work with arrays, recursive queries, and work with extensions.
6. Using PostgreSQL with your application - a chapter with a story about how to get users for individual applications. Remote connections from the program code (php, perl, python, java). Then comes the story of how to make backups.
7. Minimal server setup A chapter on postgres settings and how they affect the system. Here on the stage there are settings: buffers (shared_buffers)cache size (effective_cache_size)working memory (work_mem), autovacuum settings, bone settings for request scheduler (random\ page\ cost and seq\ page\ cost). It is interesting that the book gives the setting 1C.
8. About a useful pgAdmin application A chapter on using UI to configure postgres
9. Advanced features: full-text search, JSON format, foreign data wrappers - a story about additional features available in postgres, among which there is a full-text search, which is not comparable to the conditional elastic, sphinx, but for some things suitable. Another cool feature jsonb, which allows you to use postgres as a document-oriented database (Climbing into MongoDB territory)We can index the fields within jsonb. And the final feature is external integration through foreign-data wrapper.
10. Education and certification opportunities This is about the training and certification that Postgres Professionals has and what areas they cover.
11. Keeping up with all updates - description of sources for additional information: mailing list, conferences
12. About the Postgres Professional company - description of the company Postgres Pro, vendor Postgres from Russia, which employs the authors of this book

#Databases #DistributedSystems #Architecture #SoftwareArchitecture #Software