summersale2015 Hier klicken Jetzt Mitglied werden studentsignup Cloud Drive Photos WHDsFly Learn More UrlaubundReise Fire HD 6 Shop Kindle Sparpaket SummerSale
  • Alle Preisangaben inkl. MwSt.
Nur noch 1 auf Lager (mehr ist unterwegs).
Verkauf und Versand durch Amazon.
Geschenkverpackung verfügbar.
PostgreSQL: Up and Runnin... ist in Ihrem Einkaufwagen hinzugefügt worden
Gebraucht: Sehr gut | Details
Verkauft von gerhoff
Zustand: Gebraucht: Sehr gut
Kommentar: unbenutzt, wegen leichter Lager-/Transportspuren als Mängelexemplar gekennzeichnet - Rechnung mit ausgew. MwSt. - kostenloser Versand durch
Ihren Artikel jetzt
eintauschen und
EUR 3,25 Gutschein erhalten.
Möchten Sie verkaufen?
Zur Rückseite klappen Zur Vorderseite klappen
Anhören Wird wiedergegeben... Angehalten   Sie hören eine Probe der Audible-Audioausgabe.
Weitere Informationen
Alle 2 Bilder anzeigen

PostgreSQL: Up and Running (Englisch) Taschenbuch – 31. Juli 2012

1 Kundenrezension

Alle Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Amazon-Preis Neu ab Gebraucht ab
"Bitte wiederholen"
EUR 19,57
EUR 19,57 EUR 9,00
4 neu ab EUR 19,57 5 gebraucht ab EUR 9,00

Dieses Buch gibt es in einer neuen Auflage:

PostgreSQL: Up and Running
EUR 21,95
Auf Lager.

Hinweise und Aktionen

  • Buch Sommerangebote: Entdecken Sie unsere bunte Auswahl an reduzierten Hörbüchern und englischen Büchern für den Sommer. Hier klicken.

Wird oft zusammen gekauft

PostgreSQL: Up and Running + PostGIS Cookbook
Preis für beide: EUR 59,14

Die ausgewählten Artikel zusammen kaufen
Jeder kann Kindle Bücher lesen — selbst ohne ein Kindle-Gerät — mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.


  • Taschenbuch: 164 Seiten
  • Verlag: O'Reilly & Associates; Auflage: 1 (31. Juli 2012)
  • Sprache: Englisch
  • ISBN-10: 1449326331
  • ISBN-13: 978-1449326333
  • Größe und/oder Gewicht: 17,8 x 0,9 x 23,3 cm
  • Durchschnittliche Kundenbewertung: 5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
  • Amazon Bestseller-Rang: Nr. 122.281 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)

Mehr über die Autoren

Entdecken Sie Bücher, lesen Sie über Autoren und mehr


Über den Autor und weitere Mitwirkende

Regina Obe holds a BS degree in mechanical engineering from the Massachusetts Institute of Technology with a concentration in Bioelectronics and control theory. She has over 15 years professional experience in various programming languages and database systems. Regina focuses on sales, project cost estimation, high-level programming and troubleshooting, providing technical guidance to programming staff, and one-on-one mentoring to clients in various programming and database disciplines. She is also the resident expert on PostGIS spatial database engine and other Open Geospatial technologies. She is a member of the PostGIS project steering committee and the PostGIS core development team. She is a co-author of the book PostGIS in Action. Leo Hsu holds an MS degree in engineering of economic systems from Stanford University. He also holds dual BS degrees in mechanical engineering and economics from the Massachusetts Institute of Technology with a minor in Finance. He has over 15 years professional experience working for and with Federal, State, non-profits and Dot coms developing automated pricing and process applications and devising workflow strategies. His education and experience runs the gamut from programming, economics, statistics, operations research, database systems and application architecture, mechanical engineering, control theory and game theory. Leo focuses on advanced database design, application architecture, and overall project management. He is the resident SQL expert. He is a co-author of the book PostGIS in Action.

Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?


5.0 von 5 Sternen
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Sterne
Siehe die Kundenrezension
Sagen Sie Ihre Meinung zu diesem Artikel

Die hilfreichsten Kundenrezensionen

0 von 1 Kunden fanden die folgende Rezension hilfreich Von Egbert König am 5. Februar 2013
Format: Kindle Edition Verifizierter Kauf
Dieses Buch ist ein typisches O'Reilly Buch, genau richtig geschrieben. Der Text ist kurz und prägnant, die Anleitungen im Buch haben mir sehr weitergeholfen.
Kommentar War diese Rezension für Sie hilfreich? Ja Nein Feedback senden...
Vielen Dank für Ihr Feedback. Wenn diese Rezension unangemessen ist, informieren Sie uns bitte darüber.
Wir konnten Ihre Stimmabgabe leider nicht speichern. Bitte erneut versuchen

Die hilfreichsten Kundenrezensionen auf (beta) 14 Rezensionen
36 von 37 Kunden fanden die folgende Rezension hilfreich
Misleading title, misleading reviews 22. April 2013
Von Theodore D. Sternberg - Veröffentlicht auf
Format: Taschenbuch Verifizierter Kauf
This is not an introduction to PostgreSQL. It's certainly not a "tutorial", as another reviewer claims. A better title would be "PostgreSQL Tips and Tricks". This book won't make much sense until you've already familiarized yourself with PostgreSQL's online documentation. As for how useful those tips and tricks are, I can't say. I came to this book with a solid academic understanding of databases (at the level of Ullman's Principles of Database & Knowledge-Base Systems, Vol. 1: Classical Database Systems) and some light experience with Oracle and PostgreSQL itself. With that as my background, this book didn't offer me much. However, I do intend to learn a lot about PostgreSQL (at this, point, I guess, from its own online documentation), at which point I will return to this book and have more to say. But for now, my warning stands: if you're looking for an introduction or a tutorial, look somewhere else.

As a secondary point, the English in this book is bad enough to be annoying. O'Reilly should be concerned enough about its reputation to hire an editor who understands noun-verb agreement (e.g. "the dog bites the man", not 'the dog bite the man").
7 von 7 Kunden fanden die folgende Rezension hilfreich
Useful books with serious problems 23. Februar 2014
Von Ulas Tuerkmen - Veröffentlicht auf
Format: Taschenbuch
The idea for this book is in fact rather good: A quick reminder of
features that set PostgreSQL apart and how one can start using them
quickly. This is also achieved to a decent extent. PostgreSQL is an
extremely versatile and complete database, with lots of features the
average programmer does not know about. This causes many developers to
resort to hacky alternative methods (such as writing slow code to
achieve what PostgreSQL does natively and faster), or to other
persistent stores that tout their horn louder (*cough*, nosql,
*cough*). A quick skim of this book would help them achieve the same
functionality without committing to maintenance work or less
feature-rich platforms.

In the first few chapters of the book, the authors explain the base
cases and useful deviations of simple functionality such as getting
PostgreSQL to run with different settings, making backups and
restoring from them, monitoring and terminating database activity,
etc. An important feature of the book is that the authors, due to
their experiences with managing bigger clusters, always mention
options and alternatives that might be useful when one is working with
a large database that is live. The feature-rich commandline client
psql, a major feature of PostgreSQL, and its visual companion
pgAdmin, both of these get their own chapters with decent treatments.

The rest of the book deals with useful extensions of PostgreSQL to the
SQL standard, such as different kinds of indices, constraints, views,
window functions, and common table expressions. It is really
astonishing how many powerful features are packed into PostgreSQL,
such as functional indices, which allow the user to define an index on
a function of a column, or recursive CTEs through which the user can
traverse trees through simple relations. Recursive CTEs are not
available in any other DBMSs, by the way. The authors do a good job of
giving a foretaste of what these features can accomplish, and how they
set PostgreSQL apart from other DBMSs, including proprietary ones. The
last two chapters deal with topics very important for people who want
to use PostgreSQL in challenging live setups: Optimization and
replication. Instead of detailed guidelines, the reader is presented
with initial solutions and ways to gather more information on which
directions can be taken.

Despite doing a good job of whetting apetite for PostgreSQL, and
giving important pointers, the book has serious flaws, and leaves a
lot to be desired. First of all, there are big gaps of information in
the text on certain definitely interesting topics, and the reader is
simply pointed to either PostgreSQL documentation, or a blog post
written by the authors somewhere else. An example is the treatment of
custom types, where the creation of operators on these types is simply
omitted, although it would be just another page or so
(p.72). Providing at least the gist of the referred posts and
documentation pages would have been rather beneficial. The authors
sometimes use incredibly weird and maybe even nonexistent
words. Effectuate, turducken? Why do I have to look up a word that
essentially means the same thing with a widely known word with just
four extra letters? In one instance, the authors refer to someone as a
"data entry dude", which might be OK in a blog, but not in an O'Reilly
book. The most annoying shortcoming for me though was the fact that
half of the book used the US census data in database form for sample
queries, but this database is not provided by the authors for trying
things out. If you Google for it, there are some howtos on how to dump
the census data into a database, but none of these are as simple as
restoring a dump or running a sql file. I expect from the authors of a
technical book to provide the sample data they use so that the users
can do some experimentation and try other things than what the authors
have written.
8 von 9 Kunden fanden die folgende Rezension hilfreich
Great Overview of Using PostgreSQL 20. August 2012
Von Trevis Rothwell - Veröffentlicht auf
Format: Taschenbuch
Numerous books will teach you SQL either in the abstract or attached to some particular RDBMS. There aren't a lot of PostgreSQL books out there, and the official documentation, while excellent, is too long to practically sit down and read.

This book assumes you already understand the essence of SQL and focuses on using PostgreSQL in particular, with frequent references to relevant sections of the official documentation and to other related online articles. The writing flows well, and you could easily read the book cover to cover in a few evenings, gaining a good overall understanding of how to use PostgreSQL for your relational database projects.
10 von 12 Kunden fanden die folgende Rezension hilfreich
Short Friendly Introduction to PosgreSQL 14. August 2012
Von G. van Staden - Veröffentlicht auf
Format: Kindle Edition
PostgreSQL is something I always wondered about having seen its use in Google Earth Enterprise and a few other products. This book helps those with some experience in databases understand this interesting application platform. The run-of-the mill relational database features (datatypes, database objects and such) are covered briefly but the focus of the book is on what makes PostgreSQL unique. Good points of consideration concerning the applicability of PostgreSQL are provided making this a good book for professionals thinking about using PostgreSQL in their projects.

The book does a good job of distilling the vast on-line content surrounding PostgreSQL and explains the tools surrounding it a bit better than the documentation provided for them (in particular pgAdmin). Installation, configuration, security, database object management, functions (in SQL and Python) as well as performance tuning are covered. Don't expect elaborate coverage of the topics. I enjoyed this conciseness but there were times I had to used the provided references (links) to on-line material to get a better understanding.

Any reader must be aware that the book focuses on PostgreSQL 9.1. It does mention where there are differences with older versions but you might be left wanting if you are stuck with an older version.

It's short and powerful introduction to PostgreSQL's core features and approach. Many useful links to PostgreSQL resources are included. This book was enjoyable to read and perfect for getting me up-to-speed with PostgreSQL.
7 von 8 Kunden fanden die folgende Rezension hilfreich
Delivers what the title promises! 7. November 2012
Von Peter Clark - Veröffentlicht auf
Format: Taschenbuch
Quick summary: PostgreSQL Up and Running, by Regina Obe and Len Hsu, tells you everything you need to know if you want to start playing with the database engine that all the cool kids are using. It assumes that you already know something about SQL, but as the title promises, it walks you through how to get a PostgreSQL server installed, set it up, get a login role configured, and start playing. After reading it, you'll know about the cool features that PostgreSQL brings to the party (such as table inheritance, custom types, and extensions), the basics of running a postgres instance, some of the key configuration parameters, areas (like permissions) that have unavoidable complexity, and where to go to learn more.

More details:

The PostgreSQL 9.1 reference manual, available for free from [...], is extensive, highly detailed, and large - it's nearly 2700 pages. This can be quite intimidating for a new user, as it offers only a 5-page "getting started" section that doesn't provide much handholding if things go wrong.

"PostgreSQL Up and Running" fills that gap. It's more than a tutorial, but isn't weighted down with the esoterica in the reference manual. The authors have been active in the PostgreSQL community for some time, and have also written a book, PostGIS in Action, on the PostGIS spatial database environment built on top of PostgreSQL. They've got the experience needed to explain the postgres environment with a focus on the useful rather than on the comprehensive.

The book has 10 chapters, in two broad groups. The first group covers basics, database admin, the psql command-line tool, and the pgAdmin GUI. These chapters cover downloading a postgres distribution, getting it installed and running, the basics of configuring and administering it (including extensions, backup and restore), and a couple different ways of talking to it once it's up. This group of chapters offers many sample queries and command invocations, heavily annotated to explain what each part of the query or invocation is doing.

The second group covers what you need to know to write programs against the database engine - data types; table, constraints, and indices; appropriate SQL style for PostgreSQL; writing custom functions; performance tuning; and replication and external data. You may not care about all of those topics, but it's useful to know what your options are. In particular, Postgres offers a variety of data types that may be new, such as arrays and rows; some with more options than you might expect, such as date time; and some where the intuition about tradeoffs may be different than you're used to, such as varchar vs text. The book covers thee common use cases and offers some guidance about common areas where you might get tripped up.

The authors clearly like using PostgreSQL; there are a number of sections in the book that start with a sentence like "PostgreSQL support for is the best of any database we've come across." While this is hard to deny (I don't know what databases they've come across), it's a little distracting. Nevertheless, they usually follow this sort of comment with a clear explanation of how that feature works.

I got my start with PostgreSQL using the combination of the PostgreSQL reference manual and the authors' PostGIS book. I wish that PostgreSQL: Up and Running" had been available then; it would have saved me some time and confusion. If you're curious about postgresql, this book will give you a guided tour by the experts. Recommended, and I'll be buying a couple copies to give to new people on my development team.

Full disclosure: O'Reilly offered me a free copy of the ebook in exchange for a review. Turns out, I'd have bought it anyway.
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.