In weniger als einer Minute können Sie mit dem Lesen von PostgreSQL: Up and Running auf Ihrem Kindle beginnen. Sie haben noch keinen Kindle? Hier kaufen Oder fangen Sie mit einer unserer gratis Kindle Lese-Apps sofort an zu lesen.

An Ihren Kindle oder ein anderes Gerät senden

 
 
 

Kostenlos testen

Jetzt kostenlos reinlesen

An Ihren Kindle oder ein anderes Gerät senden

Jeder kann Kindle Bücher lesen  selbst ohne ein Kindle-Gerät  mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.
PostgreSQL: Up and Running
 
 

PostgreSQL: Up and Running [Kindle Edition]

Regina O. Obe , Leo S. Hsu
5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)

Kindle-Preis: EUR 8,64 Inkl. MwSt. und kostenloser drahtloser Lieferung über Amazon Whispernet

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 8,64  
Taschenbuch EUR 14,95  

Kunden, die diesen Artikel gekauft haben, kauften auch


Produktbeschreibungen

Kurzbeschreibung

Thinking of migrating to PostgreSQL? This updated guide helps you quickly understand and use the 9.3 release of this open source database system. You’ll not only learn about its unique enterprise-class features, but also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform.

Using numerous examples, this book shows you how to achieve tasks that are difficult or impossible in other databases. The second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. If you’re an existing PostgreSQL user, you’ll pick up gems you may have missed along the way.

  • 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 to replicate data, using built-in replication features

Ü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.

Produktinformation

  • Format: Kindle Edition
  • Dateigröße: 1129 KB
  • Seitenzahl der Print-Ausgabe: 168 Seiten
  • Gleichzeitige Verwendung von Geräten: Keine Einschränkung
  • Verlag: O'Reilly Media; Auflage: 1 (6. Juli 2012)
  • Verkauf durch: Amazon Media EU S.à r.l.
  • Sprache: Englisch
  • ASIN: B008IGIKY6
  • Text-to-Speech (Vorlesemodus): Aktiviert
  • X-Ray:
  • Durchschnittliche Kundenbewertung: 5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
  • Amazon Bestseller-Rang: #86.405 Bezahlt in Kindle-Shop (Siehe Top 100 Bezahlt in Kindle-Shop)

  •  Ist der Verkauf dieses Produkts für Sie nicht akzeptabel?

Mehr über die Autoren

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

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


Kundenrezensionen

4 Sterne
0
3 Sterne
0
2 Sterne
0
1 Sterne
0
5.0 von 5 Sternen
5.0 von 5 Sternen
Die hilfreichsten Kundenrezensionen
0 von 1 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Sehr hilfreich 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.
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com: 3.8 von 5 Sternen  10 Rezensionen
27 von 28 Kunden fanden die folgende Rezension hilfreich
2.0 von 5 Sternen Misleading title, misleading reviews 22. April 2013
Von Theodore D. Sternberg - Veröffentlicht auf Amazon.com
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").
10 von 11 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Short Friendly Introduction to PosgreSQL 14. August 2012
Von G. van Staden - Veröffentlicht auf Amazon.com
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.
8 von 9 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Great Overview of Using PostgreSQL 20. August 2012
Von Trevis Rothwell - Veröffentlicht auf Amazon.com
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.
7 von 8 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Delivers what the title promises! 7. November 2012
Von Peter Clark - Veröffentlicht auf Amazon.com
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.
3 von 3 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen Useful books with serious problems 23. Februar 2014
Von Ulas Tuerkmen - Veröffentlicht auf Amazon.com
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.
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.
Kundenrezensionen suchen
Nur in den Rezensionen zu diesem Produkt suchen

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Thema:
Erster Beitrag:
Eingabe des Log-ins
 

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen
   


Ähnliche Artikel finden