Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.2, 9.3, and 9.4, you’ll also discover that PostgeSQL is more than a database system—it’s also an impressive application platform.
With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. If you’re a current PostgreSQL user, you’ll pick up gems you may have missed before.
Learn basic administration tasks such as role management, database creation, backup, and restore
Apply the psql command-line utility and the pgAdmin graphical administration tool
Explore PostgreSQL tables, constraints, and indexes
Learn powerful SQL constructs not generally found in other databases
Use several different languages to write database functions
Tune your queries to run as fast as your hardware will allow
Query external and variegated data sources with foreign data wrappers
Learn how use built-in replication filters to replicate data
Chapter 1The Basics
Where to Get PostgreSQL
PostgreSQL Database Objects
What’s New in Latest Versions of PostgreSQL?
Where to Get Help
Notable PostgreSQL Forks
Chapter 2Database Administration
Backup and Restore
Managing Disk Storage with Tablespaces
Interactive versus Noninteractive psql
Importing and Exporting Data
Chapter 4Using pgAdmin
Job Scheduling with pgAgent
Chapter 5Data Types
Characters and Strings
Custom and Composite Data Types
Chapter 6Tables, Constraints, and Indexes
Chapter 7SQL: The PostgreSQL Way
FILTER Clause for Aggregates
Common Table Expressions
Chapter 8Writing Functions
Anatomy of PostgreSQL Functions
Writing Functions with SQL
Writing PL/pgSQL Functions
Writing PL/Python Functions
Writing PL/V8, PL/CoffeeScript, and PL/LiveScript Functions
Regina Obe is a co-principal of Paragon Corporation, a database consulting company based in Boston. She has over 15 years of professional experience in various programming languages and database systems, with special focus on spatial databases. She is a member of the PostGIS steering committee and the PostGIS core development team. Regina holds a BS degree in mechanical engineering from the Massachusetts Institute of Technology. She co-authored PostGIS in Action.
Leo Hsu is a co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 15 years of professional experience developing and thinking about databases for organizations large and small. Leo holds an MS degree in engineering of economic systems from Stanford University and BS degrees in mechanical engineering and economics from the Massachusetts Institute of Technology. He co-authored PostGIS in Action.
The animal on the cover of PostgreSQL: Up andRunning is an elephant shrew (Macroscelidesproboscideus), an insectivorous mammal native to Africa named forits lengthy trunk, which resembles that of an elephant. They are distributedacross southern Africa in many types of habitat, from the Namib Desert toboulder-covered terrain in South Africa and thick forests.The elephant shrew is small and quadrupedal; they resemble rodents andopossums with their scaly tails. Their legs are long for their size,allowing them to move around in a hopping fashion similar to a rabbit. Thetrunk varies in size depending on species, but are all able to twist aroundin search of food. They are diurnal and active, though they are hardly seen due to beingwary animals, which makes them difficult to trap. They are well camouflagedand quick at dashing away from threats. Though elephant shrews are not very social, many of them live inmonogamous pairs, sharing and defending their home territory. Femaleelephant shrews experience a menstrual cycle similar to that of humanfemales; their mating period lasts for several days. Gestation lasts from 45to 60 days, and the female gives birth to litters of one to three young,which are born fairly developed and remain in the nest for several daysbefore venturing out. This can happen several times a year. Five days after birth, young elephant shrews add mashed insects—whichtheir mother collects and transports in her cheeks—to their milk diet. Theyoung begin their migratory phase after about 15 days, lessening theirdependency on the mother. They subsequently establish their own home rangeand become sexually active within 41 to 46 days.Adult elephant shrews feed on invertebrates, such as insects, spiders,centipedes, millipedes, and earthworms. Eating larger prey can be somewhatmessy. The elephant shrew must pin down the prey using its feet, then chewspieces with its cheek teeth, which can result in many dropped bits. Theelephant shrew then uses its tongue to flick small food into its mouth,similar to an anteater. When available, some also eat small amounts of plantmatter, such as new leaves, seeds, and small fruits.Many of the animals on O’Reilly covers are endangered; all of them areimportant to the world. To learn more about how you can help, go to animals.oreilly.com.The cover image is from Meyers Kleines Lexicon.The cover fonts are URW Typewriter and Guardian Sans. The text font is AdobeMinion Pro; the heading font is Adobe Myriad Condensed; and the code font isDalton Maag’s Ubuntu Mono.
Comments about oreilly PostgreSQL: Up and Running, 2nd Edition:
The preface hints that if databases aren't your thing, at least the cover has a cute picture of an elephant shrew. I'll give points for that.
Unfortunately, this book has too much and too little. It starts with setup instructions, yet the pace at which it covers PostgreSQL seems to assume a reader who really doesn't need a book on PostgreSQL. As another reviewer noted, there's not much in the way of how-to. However, there's not as much as there could be on what you need to be thinking about when you decide which features to use and how.
The authors are obviously enthusiastic about PostgreSQL, but if you want to share their enthusiasm, you'll be better served by first trying out the recipes in the PostgreSQL Cookbook.
If you're already an expert, this book might show you a few things you've missed.
Bottom Line No, I would not recommend this to a friend
Comments about oreilly PostgreSQL: Up and Running, 2nd Edition:
As a general primer on installing and getting PosgreSQL running, this book does a good job. It presents the necessary steps in a clear and logical fashion. It also presents a reasonable amount of explanation as to why some of the components work the way they do. If you are looking for a good overall reference guide, this isn't it. While the information is laid out well for a beginner, theinformation as presented does not lend itself well to answering specific "how do I..." type questions.
Bottom Line Yes, I would recommend this to a friend