PostgreSQL: Up and Running. A Practical Guide to the Advanced Open Source Database. 3rd Edition
- Autorzy:
- Regina O. Obe, Leo S. Hsu
- Ocena:
- Bądź pierwszym, który oceni tę książkę
- Stron:
- 314
- Dostępne formaty:
-
ePubMobi
Opis ebooka: PostgreSQL: Up and Running. A Practical Guide to the Advanced Open Source Database. 3rd Edition
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.5 to 10, you’ll also discover that PostgeSQL is more than a database system—it’s an impressive application platform as well.
With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper (FDW) enhancements; new full text functions and operator syntax introduced in version 9.6; XML constructs new in version 10; query parallelization features introduced in 9.6 and enhanced in 10; built-in logical replication introduced in Version 10.e.
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 to use built-in replication to replicate data
Wybrane bestsellery
-
For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those comman...(211.65 zł najniższa cena z 30 dni)
220.15 zł
259.00 zł(-15%) -
Język SQL w świecie IT jest niczym tabliczka mnożenia dla ucznia. Stanowi absolutną podstawę w pracy zarówno analityków, jak i programistów, a jego opanowanie jest konieczne do efektywnej pracy z danymi. By w pełni skorzystać z możliwości tego języka zapytań, należy jeszcze wybrać odpowiedni syst...
Analiza danych w PostgreSQL. Kurs video. Relacyjne bazy danych w pigułce Analiza danych w PostgreSQL. Kurs video. Relacyjne bazy danych w pigułce
(39.90 zł najniższa cena z 30 dni)76.05 zł
169.00 zł(-55%) -
PostgreSQL is a powerful open-source database management system, now recognized as the expert choice for a wide range of applications. This book contains useful administration recipes for improving the performance, security, and stability of your PostgreSQL 14 solution.
PostgreSQL 14 Administration Cookbook. Over 175 proven recipes for database administrators to manage enterprise databases effectively PostgreSQL 14 Administration Cookbook. Over 175 proven recipes for database administrators to manage enterprise databases effectively
-
Jeśli planujesz karierę administratora systemów IT, temat zarządzania bazami danych powinien - a nawet więcej: musi - być Ci bliski. Bazami danych można zarządzać na rozmaite sposoby, jednym z nich jest model relacyjny. Jeśli masz lub będziesz mieć do czynienia z tego typu bazą danych, prędzej cz...
PostgreSQL. Kurs video. Zostań administratorem systemów IT PostgreSQL. Kurs video. Zostań administratorem systemów IT
(39.60 zł najniższa cena z 30 dni)54.45 zł
99.00 zł(-45%) -
This book is divided into two parts with the first helping you to build advanced and scalable PostgreSQL apps. The second part enables you to administer them using DevOps. All the projects in this book will be demonstrated via the use of a small banking application for managing ATM machine locati...
Developing Modern Database Applications with PostgreSQL. Use the highly available and object-relational PostgreSQL to build scalable and reliable apps Developing Modern Database Applications with PostgreSQL. Use the highly available and object-relational PostgreSQL to build scalable and reliable apps
-
PostgreSQL has become the most advanced open source database on the market. This book adopts a step-by-step approach to meet almost every requirement you can think of while deploying PostgreSQL in production environments. You will not only learn how to design and manage your database but also dis...
PostgreSQL 13 Cookbook. Over 120 recipes to build high-performance and fault-tolerant PostgreSQL database solutions PostgreSQL 13 Cookbook. Over 120 recipes to build high-performance and fault-tolerant PostgreSQL database solutions
-
Updated to include the new features introduced in PostgreSQL 13, this book shows you how to build better PostgreSQL applications and administer your PostgreSQL database efficiently. You’ll master the advanced features of PostgreSQL and develop the skills you need to build secure and highly...
Mastering PostgreSQL 13. Build, administer, and maintain database applications efficiently with PostgreSQL 13 - Fourth Edition Mastering PostgreSQL 13. Build, administer, and maintain database applications efficiently with PostgreSQL 13 - Fourth Edition
-
This book will get you up and running with the working of relational databases, data modeling, data manipulation, and more. You will learn to build efficient relational database solutions from scratch using the latest features of PostgreSQL 12 and 13. You’ll also be able to identify bottle...
Learn PostgreSQL. Build and manage high-performance database solutions using PostgreSQL 12 and 13 Learn PostgreSQL. Build and manage high-performance database solutions using PostgreSQL 12 and 13
-
Oto przystępny przewodnik, dzięki któremu nauczysz się krok po kroku pisać zapytania SQL. Poznasz też narzędzia, które umożliwiają zrozumienie, edytowanie i tworzenie zapytań SQL. Nową wiedzę utrwalisz poprzez analizę setek szczegółowo wyjaśnionych przykładów. Niepostrzeżenie zaczniesz rozwiązywa...(39.90 zł najniższa cena z 30 dni)
70.95 zł
129.00 zł(-45%) -
Database outages are costly and largely avoidable. That's why it's important to apply time-tested high availability techniques. This book will help you design and build an indestructible PostgreSQL 12 cluster that can remain online even in the direst circumstances. You will learn to monitor and a...
PostgreSQL 12 High Availability Cookbook. Over 100 recipes to design a highly available server with the advanced features of PostgreSQL 12 - Third Edition PostgreSQL 12 High Availability Cookbook. Over 100 recipes to design a highly available server with the advanced features of PostgreSQL 12 - Third Edition
Ebooka "PostgreSQL: Up and Running. A Practical Guide to the Advanced Open Source Database. 3rd Edition" przeczytasz na:
-
czytnikach Inkbook, Kindle, Pocketbook, Onyx Boox i innych
-
systemach Windows, MacOS i innych
-
systemach Windows, Android, iOS, HarmonyOS
-
na dowolnych urządzeniach i aplikacjach obsługujących formaty: PDF, EPub, Mobi
Masz pytania? Zajrzyj do zakładki Pomoc »
Audiobooka "PostgreSQL: Up and Running. A Practical Guide to the Advanced Open Source Database. 3rd Edition" posłuchasz:
-
w aplikacji Ebookpoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych
-
na dowolnych urządzeniach i aplikacjach obsługujących format MP3 (pliki spakowane w ZIP)
Masz pytania? Zajrzyj do zakładki Pomoc »
Kurs Video "PostgreSQL: Up and Running. A Practical Guide to the Advanced Open Source Database. 3rd Edition" zobaczysz:
-
w aplikacjach Ebookpoint i Videopoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych z dostępem do najnowszej wersji Twojej przeglądarki internetowej
Szczegóły ebooka
- ISBN Ebooka:
- 978-14-919-6336-4, 9781491963364
- Data wydania ebooka:
- 2017-10-10 Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie. Jeśli masz wątpliwości skontaktuj się z nami sklep@ebookpoint.pl.
- Język publikacji:
- angielski
- Rozmiar pliku ePub:
- 3.5MB
- Rozmiar pliku Mobi:
- 8.0MB
Spis treści ebooka
- Preface
- Audience
- For More Information on PostgreSQL
- Code and Output Formatting
- Conventions Used in This Book
- Using Code Examples
- OReilly Safari
- How to Contact Us
- 1. The Basics
- Why PostgreSQL?
- Why Not PostgreSQL?
- Where to Get PostgreSQL
- Administration Tools
- psql
- pgAdmin
- phpPgAdmin
- Adminer
- PostgreSQL Database Objects
- Whats New in Latest Versions of PostgreSQL?
- Why Upgrade?
- Features Introduced in PostgreSQL 10
- Features Introduced in PostgreSQL 9.6
- Features Introduced in PostgreSQL 9.5
- Features Introduced in PostgreSQL 9.4
- Database Drivers
- Where to Get Help
- Notable PostgreSQL Forks
- 2. Database Administration
- Configuration Files
- Making Configurations Take Effect
- Reloading
- Restarting
- Making Configurations Take Effect
- The postgresql.conf File
- Checking postgresql.conf settings
- Changing the postgresql.conf settings
- I edited my postgresql.conf and now my server wont start.
- The pg_hba.conf File
- I edited my pg_hba.conf and now my server is broken.
- Authentication methods
- Configuration Files
- Managing Connections
- Check for Queries Being Blocked
- Roles
- Creating Login Roles
- Creating Group Roles
- Database Creation
- Template Databases
- Using Schemas
- Privileges
- Types of Privileges
- Getting Started
- GRANT
- Default Privileges
- Privilege Idiosyncrasies
- Extensions
- Installing Extensions
- Step 1: Installing on the server
- Step 2: Installing into a database
- Upgrading to the new extension model
- Installing Extensions
- Common Extensions
- Popular extensions
- Classic extensions
- Backup and Restore
- Selective Backup Using pg_dump
- Systemwide Backup Using pg_dumpall
- Restoring Data
- Using psql to restore plain-text SQL backups
- Using pg_restore
- Managing Disk Storage with Tablespaces
- Creating Tablespaces
- Moving Objects Among Tablespaces
- Verboten Practices
- Dont Delete PostgreSQL Core System Files and Binaries
- Dont Grant Full OS Administrative Privileges to the Postgres System Account (postgres)
- Dont Set shared_buffers Too High
- Dont Try to Start PostgreSQL on a Port Already in Use
- 3. psql
- Environment Variables
- Interactive versus Noninteractive psql
- psql Customizations
- Custom Prompts
- Timing Executions
- Autocommit Commands
- Shortcuts
- Retrieving Prior Commands
- psql Gems
- Executing Shell Commands
- Watching Statements
- Retrieving Details of Database Objects
- Crosstabs
- Dynamic SQL Execution
- Importing and Exporting Data
- psql Import
- psql Export
- Copying from or to Program
- Basic Reporting
- 4. Using pgAdmin
- Getting Started
- Overview of Features
- Connecting to a PostgreSQL Server
- Navigating pgAdmin
- Getting Started
- pgAdmin Features
- Autogenerating Queries from Table Definitions
- Accessing psql from pgAdmin3
- Editing postgresql.conf and pg_hba.conf from pgAdmin3
- Creating Database Assets and Setting Privileges
- Creating databases and other database assets
- Privilege management
- Import and Export
- Importing files
- Exporting queries as a structured file or report in pgAdmin
- Backup and Restore
- Backing up an entire database
- Backing up systemwide objects
- Selective backup of database assets
- pgScript
- Graphical Explain
- Job Scheduling with pgAgent
- Installing pgAgent
- Scheduling Jobs
- Helpful pgAgent Queries
- 5. Data Types
- Numerics
- Serials
- Generate Series Function
- Numerics
- Textuals
- String Functions
- Splitting Strings into Arrays, Tables, or Substrings
- Regular Expressions and Pattern Matching
- Temporals
- Time Zones: What They Are and Are Not
- Datetime Operators and Functions
- Arrays
- Array Constructors
- Unnesting Arrays to Rows
- Array Slicing and Splicing
- Referencing Elements in an Array
- Array Containment Checks
- Range Types
- Discrete Versus Continuous Ranges
- Built-in Range Types
- Defining Ranges
- Defining Tables with Ranges
- Range Operators
- Overlap operator
- Contains and contained in operators
- JSON
- Inserting JSON Data
- Querying JSON
- Outputting JSON
- Binary JSON: jsonb
- Editing JSONB data
- XML
- Inserting XML Data
- Querying XML Data
- Full Text Search
- FTS Configurations
- TSVectors
- TSQueries
- Using Full Text Search
- Ranking Results
- Full Text Stripping
- Full Text Support for JSON and JSONB
- Custom and Composite Data Types
- All Tables Are Custom Data Types
- Building Custom Data Types
- Composites and NULLs
- Building Operators and Functions for Custom Types
- 6. Tables, Constraints, and Indexes
- Tables
- Basic Table Creation
- Inherited Tables
- Partitioned Tables
- Unlogged Tables
- TYPE OF
- Tables
- Constraints
- Foreign Key Constraints
- Unique Constraints
- Check Constraints
- Exclusion Constraints
- Indexes
- PostgreSQL Stock Indexes
- Operator Classes
- Functional Indexes
- Partial Indexes
- Multicolumn Indexes
- 7. SQL: The PostgreSQL Way
- Views
- Single Table Views
- Using Triggers to Update Views
- Materialized Views
- Views
- Handy Constructions
- DISTINCT ON
- LIMIT and OFFSET
- Shorthand Casting
- Multirow Insert
- ILIKE for Case-Insensitive Search
- ANY Array Search
- Set-Returning Functions in SELECT
- Restricting DELETE, UPDATE, and SELECT from Inherited Tables
- DELETE USING
- Returning Affected Records to the User
- UPSERTs: INSERT ON CONFLICT UPDATE
- Composite Types in Queries
- Dollar Quoting
- DO
- FILTER Clause for Aggregates
- Percentiles and Mode
- Window Functions
- PARTITION BY
- ORDER BY
- Common Table Expressions
- Basic CTEs
- Writable CTEs
- Recursive CTE
- Lateral Joins
- WITH ORDINALITY
- GROUPING SETS, CUBE, ROLLUP
- 8. Writing Functions
- Anatomy of PostgreSQL Functions
- Function Basics
- Triggers and Trigger Functions
- Aggregates
- Trusted and Untrusted Languages
- Anatomy of PostgreSQL Functions
- Writing Functions with SQL
- Basic SQL Function
- Writing SQL Aggregate Functions
- Writing PL/pgSQL Functions
- Basic PL/pgSQL Function
- Writing Trigger Functions in PL/pgSQL
- Writing PL/Python Functions
- Basic Python Function
- Writing PL/V8, PL/CoffeeScript, and PL/LiveScript Functions
- Basic Functions
- Writing Aggregate Functions with PL/V8
- Writing Window Functions in PL/V8
- 9. Query Performance Tuning
- EXPLAIN
- EXPLAIN Options
- Sample Runs and Output
- Graphical Outputs
- EXPLAIN
- Gathering Statistics on Statements
- Writing Better Queries
- Overusing Subqueries in SELECT
- Avoid SELECT *
- Make Good Use of CASE
- Using FILTER Instead of CASE
- Parallelized Queries
- What Does a Parallel Query Plan Look Like?
- Parallel Scans
- Parallel Joins
- Guiding the Query Planner
- Strategy Settings
- How Useful Is Your Index?
- Table Statistics
- Random Page Cost and Quality of Drives
- Caching
- 10. Replication and External Data
- Replication Overview
- Replication Jargon
- Evolution of PostgreSQL Replication
- Third-Party Replication Options
- Replication Overview
- Setting Up Full Server Replication
- Configuring the Master
- Configuring the Slaves for Full Server Cluster Replication
- Initiating the Streaming Replication Process
- Replicating Only Some Tables or Databases with Logical Replication
- Foreign Data Wrappers
- Querying Flat Files
- Querying Flat Files as Jagged Arrays
- Querying Other PostgreSQL Servers
- Querying Other Tabular Formats with ogr_fdw
- Querying Nonconventional Data Sources
- A. Installing PostgreSQL
- Windows and Desktop Linux
- CentOS, Fedora, Red Hat, Scientific Linux
- Debian, Ubuntu
- FreeBSD
- macOS
- B. PostgreSQL Packaged Command-Line Tools
- Database Backup Using pg_dump
- Server Backup: pg_dumpall
- Database Restore: pg_restore
- psql Interactive Commands
- psql Noninteractive Commands
- Index
O'Reilly Media - inne książki
-
JavaScript gives web developers great power to create rich interactive browser experiences, and much of that power is provided by the browser itself. Modern web APIs enable web-based applications to come to life like never before, supporting actions that once required browser plug-ins. Some are s...(177.65 zł najniższa cena z 30 dni)
186.15 zł
219.00 zł(-15%) -
How will software development and operations have to change to meet the sustainability and green needs of the planet? And what does that imply for development organizations? In this eye-opening book, sustainable software advocates Anne Currie, Sarah Hsu, and Sara Bergman provide a unique overview...(160.65 zł najniższa cena z 30 dni)
177.65 zł
209.00 zł(-15%) -
OpenTelemetry is a revolution in observability data. Instead of running multiple uncoordinated pipelines, OpenTelemetry provides users with a single integrated stream of data, providing multiple sources of high-quality telemetry data: tracing, metrics, logs, RUM, eBPF, and more. This practical gu...(143.65 zł najniższa cena z 30 dni)
152.15 zł
179.00 zł(-15%) -
Interested in developing embedded systems? Since they don't tolerate inefficiency, these systems require a disciplined approach to programming. This easy-to-read guide helps you cultivate good development practices based on classic software design patterns and new patterns unique to embedded prog...(152.15 zł najniższa cena z 30 dni)
160.65 zł
189.00 zł(-15%) -
If you use Linux in your day-to-day work, then Linux Pocket Guide is the perfect on-the-job reference. This thoroughly updated 20th anniversary edition explains more than 200 Linux commands, including new commands for file handling, package management, version control, file format conversions, an...(92.65 zł najniższa cena z 30 dni)
101.15 zł
119.00 zł(-15%) -
Gain the valuable skills and techniques you need to accelerate the delivery of machine learning solutions. With this practical guide, data scientists, ML engineers, and their leaders will learn how to bridge the gap between data science and Lean product delivery in a practical and simple way. Dav...(245.65 zł najniższa cena z 30 dni)
254.15 zł
299.00 zł(-15%) -
This practical book provides a detailed explanation of the zero trust security model. Zero trust is a security paradigm shift that eliminates the concept of traditional perimeter-based security and requires you to "always assume breach" and "never trust but always verify." The updated edition off...(203.15 zł najniższa cena z 30 dni)
211.65 zł
249.00 zł(-15%) -
Decentralized finance (DeFi) is a rapidly growing field in fintech, having grown from $700 million to $100 billion over the past three years alone. But the lack of reliable information makes this area both risky and murky. In this practical book, experienced securities attorney Alexandra Damsker ...(203.15 zł najniższa cena z 30 dni)
211.65 zł
249.00 zł(-15%) -
Whether you're a startup founder trying to disrupt an industry or an entrepreneur trying to provoke change from within, your biggest challenge is creating a product people actually want. Lean Analytics steers you in the right direction.This book shows you how to validate your initial idea, find t...(126.65 zł najniższa cena z 30 dni)
126.65 zł
149.00 zł(-15%) -
When it comes to building user interfaces on the web, React enables web developers to unlock a new world of possibilities. This practical book helps you take a deep dive into fundamental concepts of this JavaScript library, including JSX syntax and advanced patterns, the virtual DOM, React reconc...(194.65 zł najniższa cena z 30 dni)
211.65 zł
249.00 zł(-15%)
Dzieki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka, którą chcesz zamówić pochodzi z końcówki nakładu. Oznacza to, że mogą się pojawić drobne defekty (otarcia, rysy, zagięcia).
Co powinieneś wiedzieć o usłudze "Końcówka nakładu":
- usługa obejmuje tylko książki oznaczone tagiem "Końcówka nakładu";
- wady o których mowa powyżej nie podlegają reklamacji;
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka drukowana
Oceny i opinie klientów: PostgreSQL: Up and Running. A Practical Guide to the Advanced Open Source Database. 3rd Edition Regina O. Obe, Leo S. Hsu (0) Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.