Muutke küpsiste eelistusi

PostgreSQL: Up and Running [Pehme köide]

3.79/5 (206 hinnangut Goodreads-ist)
,
  • Formaat: Paperback / softback, 166 pages, kõrgus x laius: 233x178 mm, Illustrations
  • Ilmumisaeg: 14-Aug-2012
  • Kirjastus: O'Reilly Media
  • ISBN-10: 1449326331
  • ISBN-13: 9781449326333
Teised raamatud teemal:
  • Pehme köide
  • Hind: 28,23 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
PostgreSQL: Up and RunningSuurem pilt
  • Formaat: Paperback / softback, 166 pages, kõrgus x laius: 233x178 mm, Illustrations
  • Ilmumisaeg: 14-Aug-2012
  • Kirjastus: O'Reilly Media
  • ISBN-10: 1449326331
  • ISBN-13: 9781449326333
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781449326333.html
Märksõnad:

If you’re thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQL’s unique features. Not only will you learn about the enterprise class features in the 9.2 release, you’ll also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform.

With numerous examples throughout this book, you’ll learn how to achieve tasks that are difficult or impossible in other databases. 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
Preface ix
1 The Basics
1(8)
Where to Get PostgreSQL
1(1)
Notable PostgreSQL Forks
1(1)
Administration Tools
2(1)
What's New in Latest Versions of PostgreSQL?
3(2)
Why Upgrade?
4(1)
What to Look for in PostgreSQL 9.2
4(1)
PostgreSQL 9.1 Improvements
5(1)
Database Drivers
5(1)
Server and Database Objects
6(2)
Where to Get Help
8(1)
2 Database Administration
9(22)
Configuration Files
9(5)
The postgresql.conf File
10(2)
The pg_hba.conf File
12(2)
Reload the Configuration Files
14(1)
Setting Up Groups and Login Roles (Users)
14(2)
Creating an Account That Can Log In
15(1)
Creating Group Roles
15(1)
Roles Inheriting Rights
16(1)
Databases and Management
16(2)
Creating and Using a Template Database
16(1)
Organizing Your Database Using Schemas
17(1)
Permissions
17(1)
Extensions and Contribs
18(5)
Installing Extensions
20(1)
Common Extensions
21(2)
Backup
23(2)
Selective Backup Using pg_dump
23(1)
Systemwide Backup Using pg_dumpall
24(1)
Restore
25(3)
Terminating Connections
25(1)
Using psql to Restore Plain Text SQL backups
26(1)
Using pg_restore
26(2)
Managing Disk Space with Tablespaces
28(1)
Creating Tablespaces
28(1)
Moving Objects Between Tablespaces
28(1)
Verboten
28(3)
Delete PostgreSQL Core System Files and Binaries
29(1)
Giving Full Administrative Rights to the Postgres System (Daemon) Account
29(1)
Setting shared_buffers Too High
30(1)
Trying to Start PostgreSQL on a Port Already in Use
30(1)
3 psql
31(12)
Interactive psql
31(1)
Non-Interactive psql
32(1)
Session Configurations
33(4)
Changing Prompts
35(1)
Timing Details
35(1)
Autocommit
35(1)
Shortcuts
36(1)
Retrieving Prior Commands
36(1)
psql Gems
37(1)
Executing Shell Commands
37(1)
Lists and Structures
37(1)
Importing and Exporting Data
38(1)
Basic Reporting
39(4)
4 Using pgAdmin
43(16)
Getting Started
43(2)
Overview of Features
43(1)
Connecting to a PostgreSQL server
44(1)
Navigating pgAdmin
44(1)
pgAdmin Features
45(6)
Accessing psql from pgAdmin
46(1)
Editing postgresql.conf and pg_hba.conf from pgAdmin
47(1)
Creating Databases and Setting Permissions
47(1)
Backup and Restore
48(3)
pgScript
51(3)
Graphical Explain
54(1)
Job Scheduling with pgAgent
55(4)
Installing pgAgent
56(1)
Scheduling Jobs
56(1)
Helpful Queries
57(2)
5 Data Types
59(14)
Numeric Data Types
59(1)
Serial
59(1)
Generate Series Function
60(1)
Arrays
60(2)
Array Constructors
61(1)
Referencing Elements in An Array
61(1)
Array Slicing and Splicing
62(1)
Character Types
62(3)
String Functions
63(1)
Splitting Strings into Arrays, Tables, or Substrings
63(1)
Regular Expressions and Pattern Matching
64(1)
Temporal Data Types
65(5)
Time Zones: What It Is and What It Isn't
66(2)
Operators and Functions for Date and Time Data Types
68(2)
XML
70(1)
Loading XML Data
70(1)
Querying XML Data
71(1)
Custom and Composite Data Types
71(2)
All Tables Are Custom
71(1)
Building Your Own Custom Type
72(1)
6 Of Tables, Constraints, and Indexes
73(12)
Tables
73(4)
Table Creation
73(2)
Multi-Row Insert
75(1)
An Elaborate Insert
75(2)
Constraints
77(2)
Foreign Key Constraints
77(1)
Unique Constraints
78(1)
Check Constraints
78(1)
Exclusion Constraints
79(1)
Indexes
79(6)
PostgreSQL Stock Indexes
79(2)
Operator Class
81(1)
Functional Indexes
82(1)
Partial Indexes
82(1)
Multicolumn Indexes
83(2)
7 SQL: The PostgreSQL Way
85(14)
SQL Views
85(2)
Window Functions
87(3)
Partition By
88(1)
Order By
89(1)
Common Table Expressions
90(3)
Standard CTE
91(1)
Writeable CTEs
92(1)
Recursive CTE
92(1)
Constructions Unique to PostgreSQL
93(6)
Distinct On
93(1)
LIMIT and OFFSET
94(1)
Shorthand Casting
94(1)
ILIKE for Case Insensitive Search
94(1)
Set Returning Functions in SELECT
95(1)
Selective DELETE, UPDATE, and SELECT from Inherited Tables
95(1)
Returning Changed Records
96(1)
Composite Types in Queries
96(3)
8 Writing Functions
99(12)
Anatomy of PostgreSQL Functions
99(2)
Function Basics
99(1)
Trusted and Untrusted Languages
100(1)
Writing Functions with SQL
101(2)
Writing PL/pgSQL Functions
103(1)
Writing PL/Python Functions
103(2)
Basic Python Function
104(1)
Trigger Functions
105(2)
Aggregates
107(4)
9 Query Performance Tuning
111(12)
Explain and Explain Analyze
111(2)
Writing Better Queries
113(5)
Overusing Subqueries in SELECT
114(2)
Avoid SELECT
116(1)
Make Good Use of CASE
116(2)
Guiding the Query Planner
118(3)
Strategy Settings
118(1)
How Useful Is Your Index?
118(2)
Table Stats
120(1)
Random Page Cost and Quality of Drives
120(1)
Caching
121(2)
10 Replication and External Data
123(8)
Replication Overview
123(2)
Replication Lingo
123(1)
PostgreSQL Built-in Replication Advancements
124(1)
Third-Party Replication Options
125(1)
Setting Up Replication
125(3)
Configuring the Master
125(1)
Configuring the Slaves
126(1)
Initiate the Replication Process
127(1)
Foreign Data Wrappers (FDW)
128(3)
Querying Simple Flat File Data Sources
128(1)
Querying More Complex Data Sources
129(2)
Appendix: Install, Hosting, and Command-Line Guides 131
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.