Meie tegevjuht Hans-Jürgen Schönig annab regulaarselt välja PostgreSQL-i raamatuid ja tutvustab neis iga PostgreSQL-i versiooni olulisi funktsioone. Tutvuge lähemalt:

Mastering PostgreSQL 13

Mastering PostgreSQL 13

Order on Amazon
Kindle Ebook Edition

Key Features

  • Master advanced PostgreSQL 13 concepts with the help of real-world datasets and examples
  • Leverage PostgreSQL’s indexing features to fine-tune the performance of your queries
  • Extend PostgreSQL’s functionalities to suit your organization’s needs with minimal effort

Book Description

Thanks to its reliability, robustness, and high performance, PostgreSQL has become one of the most advanced open source databases on the market. This updated fourth edition will help you understand PostgreSQL administration and how to build dynamic database solutions for enterprise apps with the latest release of PostgreSQL, including designing both physical and technical aspects of the system architecture with ease.

Starting with an introduction to the new features in PostgreSQL 13, this book will guide you in building efficient and fault-tolerant PostgreSQL apps. You’ll explore advanced PostgreSQL features, such as logical replication, database clusters, performance tuning, advanced indexing, monitoring, and user management, to manage and maintain your database. You’ll then work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and move from Oracle to PostgreSQL. The book also covers transactions, locking, and indexes, and shows you how to improve performance with query optimization. You’ll also focus on how to manage network security and work with backups and replication while exploring useful PostgreSQL extensions that optimize the performance of large databases.

By the end of this PostgreSQL book, you’ll be able to get the most out of your database by executing advanced administrative tasks.

What you will learn

  • Get well versed with advanced SQL functions in PostgreSQL 13
  • Get to grips with administrative tasks such as log file management and monitoring
  • Work with stored procedures and manage backup and recovery
  • Employ replication and failover techniques to reduce data loss
  • Perform database migration from Oracle to PostgreSQL with ease
  • Replicate PostgreSQL database systems to create backups and scale your database
  • Manage and improve server security to protect your data
  • Troubleshoot your PostgreSQL instance to find solutions to common and not-so-common problems

Who this book is for

This database administration book is for PostgreSQL developers and database administrators and professionals who want to implement advanced functionalities and master complex administrative tasks with PostgreSQL 13. Prior experience in PostgreSQL and familiarity with the basics of database administration will assist with understanding key concepts covered in the book.

Mastering PostgreSQL 12

mastering postgresql 12 book by hans juergen schoenig

Order on Amazon
Kindle Ebook Edition

Key Features

  • Grasp advanced PostgreSQL 12 concepts with real-world examples and sample datasets
  • Explore query parallelism, data replication, database administration, and more
  • Extend PostgreSQL functionalities to suit your organization’s needs with minimal effort

Book Description

Thanks to its reliability, robustness, and high performance, PostgreSQL has become the most advanced open source database on the market. This third edition of Mastering PostgreSQL helps you build dynamic database solutions for enterprise applications using the latest release of PostgreSQL, which enables database analysts to design both physical and technical aspects of system architecture with ease.

Starting with an introduction to the newly released features in PostgreSQL 12, this book will help you build efficient and fault-tolerant PostgreSQL applications. You’ll thoroughly examine the advanced features of PostgreSQL, including logical replication, database clusters, performance tuning, monitoring, and user management. You’ll also work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and understand how to move from Oracle to PostgreSQL. As you progress through the chapters, you’ll cover transactions, locking, indexes, and how to optimize queries for improved performance. Additionally, you’ll learn how to manage network security and explore backups and replications while understanding useful PostgreSQL extensions to help you in optimizing the performance of large databases.

By the end of this PostgreSQL book, you’ll be able to get the most out of your database by implementing advanced administrative tasks effortlessly.

What you will learn

  • Understand the advanced SQL functions in PostgreSQL 12
  • Use indexing features in PostgreSQL to fine-tune the performance of queries
  • Work with stored procedures and manage backup and recovery
  • Master replication and failover techniques to reduce data loss
  • Replicate PostgreSQL database systems to create backups and to scale your database
  • Manage and improve the security of your server to protect your data
  • Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems

Mastering PostgreSQL 11

Order on Amazon
Kindle Ebook Edition

Key Features

  • Master advanced concepts of PostgreSQL 11 with real-world datasets and examples
  • Explore query parallelism, data replication, and database performance while working with larger datasets
  • Extend the functionalities of your PostgreSQL instance to suit your organization’s needs with minimal effort

Book Description

This second edition of Mastering PostgreSQL 11 helps you build dynamic database solutions for enterprise applications using the latest release of PostgreSQL, which enables database analysts to design both the physical and technical aspects of the system architecture with ease.

This book begins with an introduction to the newly released features in PostgreSQL 11 to help you build efficient and fault-tolerant PostgreSQL applications. You’ll examine all of the advanced aspects of PostgreSQL in detail, including logical replication, database clusters, performance tuning, monitoring, and user management. You will also work with the PostgreSQL optimizer, configuring PostgreSQL for high speed, and see how to move from Oracle to PostgreSQL. As you progress through the chapters, you will cover transactions, locking, indexes, and optimizing queries to improve performance. Additionally, you’ll learn to manage network security and explore backups and replications, while understanding the useful extensions of PostgreSQL so that you can optimize the speed and performance of large databases.

By the end of this book, you will be able to use your database to its utmost capacity by implementing advanced administrative tasks with ease.

What you will learn

  • Get to grips with advanced PostgreSQL 11 features and SQL functions
  • Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries
  • Work with stored procedures and manage backup and recovery
  • Master replication and failover techniques
  • Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems
  • Perform database migration from MySQL and Oracle to PostgreSQL with ease

Mastering PostgreSQL 10

Order on Amazon
Kindle Ebook Edition

Key Features

  • Your one-stop guide to mastering advanced concepts in PostgreSQL 10 with ease
  • Master query optimization, replication, and high availability with PostgreSQL
  • Extend the functionalities of your PostgreSQL instance to suit your organizational needs with minimal effort

Book Description

PostgreSQL is an open source database used for handling large datasets (big data) and as a JSON document database. This book highlights the newly introduced features in PostgreSQL 10, and shows you how you can build better PostgreSQL applications, and administer your PostgreSQL database more efficiently. We begin by explaining advanced database design concepts in PostgreSQL 10, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery, high availability, and much more. You will understand common and not-so-common troubleshooting problems and how you can overcome them. By the end of this book, you will have an expert-level command of advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL 10.

What you will learn

  • Get to grips with the advanced features of PostgreSQL 10 and handle advanced SQL
  • Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries
  • Work with stored procedures and manage backup and recovery
  • Master replication and failover techniques
  • Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems
  • Learn how to migrate your database from MySQL and Oracle to PostgreSQL without any hassle

Mastering PostgreSQL 9.6

Mastering PostgreSQL 9.6

Order on Amazon
Kindle Ebook Edition

Key Features

  • Your one-stop guide to mastering the advanced concepts in PostgreSQL with ease
  • Master query optimization, replication, and high availability with PostgreSQL
  • Extend the functionalities of PostgreSQL to suit your organizational needs with minimum effort

Book Description

PostgreSQL is an open source database used for handling large datasets (Big Data) and as a JSON document database. It also has applications in the software and web domains. This book will enable you to build better PostgreSQL applications and administer databases more efficiently.

We begin by explaining the advanced database design concepts in PostgreSQL 9.6, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery and high availability, and much more. You will understand the common and not-so-common troubleshooting problems and how you can overcome them.

By the end of this book, you will have an expert-level command of the advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL.

What you will learn

  • Get to grips with the advanced features of PostgreSQL 9.6 and handle advanced SQL
  • Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries
  • Work with the stored procedures and manage backup and recovery
  • Master the replication and failover techniques
  • Troubleshoot your PostgreSQL instance for solutions to the common and not-so-common problems
  • Learn how to migrate your database from MySQL and Oracle to PostgreSQL without any hassle

Troubleshooting PostgreSQL

Troubleshooting PostgreSQL

Order on Amazon
Kindle Ebook Edition

If you are a database administrator looking for solutions to common PostgreSQL problems, this is the book for you. The book is suitable for people with intermediate and professional expertise.

PostgreSQL is a powerful, open source, object-relational database system. PostgreSQL offers many advantages for your company or business over other database systems.

This book is your practical guide to understanding the advanced techniques used to handle complex data and methods to solve issues that you might face while working with PostgreSQL. We will start with discussing the issues that arise at the time of setting up PostgreSQL. The next step will be to decide which data types will be most suitable to the task at hand and optimize performance using the right ones.

We will understand how to deal with transaction locks, fuzzy matches, cursors, joins, and so on. Know the warning signs to look for, and how to avoid the most common issues before they even happen. In addition to that, specific high-level topics such as replication and Point-In-Time-Recovery will be discussed. The entire book is based on PostgreSQL 9.4 and contains up-to-date information.

PostgreSQL Administration Essentials

PostgreSQL Administration Essentials

Order on Amazon
Kindle Ebook Edition
Order at Packt Publishing

With more than a quarter of a century of development and innovation, PostgreSQL has gained a reputation for stability, robustness, and ease of use. The variety of features available within PostgreSQL makes it a powerful tool for your professional relational database infrastructure.

With the database administrator in mind, this compact, easy-to-read, and practically oriented book will make your daily handling of PostgreSQL more efficient and rewarding. You will learn about optimization, bottleneck detection, backup and recovery, replication, logfile management, indexing, and much more in a systematic and carefully structured manner. This invaluable guide will enable you to develop the fundamental skills required to deploy PostgreSQL in order to efficiently manage your databases.

Discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases.

PostgreSQL Replication

PostgreSQL Replication


Order on Amazon
Kindle Edition

“PostgreSQL Replication” – a new book is out:

We are proud to announce our latest book called “PostgreSQL Replication”.
It deals with all replication related concepts such as streaming replication,
synchronous replication, as well as with a variety of other topics.

Table of contents:

Preface
Chapter 1: Understanding Replication Concepts
Chapter 2: Understanding the PostgreSQL Transaction Log
Chapter 3: Understanding Point-In-Time-Recovery
Chapter 4: Setting up Asynchronous Replication
Chapter 5: Setting up Synchronous Replication
Chapter 6: Monitoring Your Setup
Chapter 7: Understanding Linux High Availability
Chapter 8: Working with pgbouncer
Chapter 9: Working with pgpool
Chapter 10: Configuring Slony
Chapter 11: Using Skytools
Chapter 12: Working with Postgres-XC
Chapter 13: Scaling with PL/Proxy

We hope that our work is beneficial to many people using PostgreSQL out there.
More information can be found here: http://amzn.to/14dAze7
Hans-Jürgen Schönig & Zoltan Böszörmenyi

PostgreSQL Developer’s Handbook (Developer’s Library)

PostgreSQL Developers Handbook

Order on Amazon

PostgreSQL is an object-relational database server that is widely considered to be the world’s most advanced open-source database system. It is ANSI SQL-compatible, and it offers powerful features to enable more complex software design than would be possible with relational databases that are not object-oriented. PostgreSQL is extremely modular, it supports a large number of datatypes, and programming interfaces for PostgreSQL are available for all important programming languages, including C, Perl, Python, Tcl, Java, and PHP. PostgreSQL Developer’s Handbook provides a complete overview of the PostgreSQL database server and extensive coverage of its core features, including object orientation, PL/pgSQL, and the most important programming interfaces. The book introduces the reader to the language and syntax of PostgreSQL and then moves quickly into advanced programming topics.

PHP and PostgreSQL Advanced Web Programming

PHP and PostgreSQL Advanced Web Programming

Order on Amazon

There is a strong demand for books that describe how to use PHP together with a specific open-source database to develop Web applications. While MySQL is very popular, PostgreSQL is widely considered to be the more powerful of the two open-source databases. And PostgreSQL is rapidly gaining market share-large organizations are beginning to use PostgreSQL instead of Oracle; the demand for PostgreSQL training and support has increased by some accounts 50% in the last six months; and Web hosting services increasingly offer PostgreSQL along with MySQL. PHP & PostgreSQL Advanced Web Programming focuses on the specific needs of a PostgreSQL developer and will detail how to make use of PostgreSQL’s unique, advanced features to develop high-availability, fail-safe Web applications with PHP and PostgreSQL.

Mono .NET-kompatible Anwendungen mit dem Open Source-Framework

Mono .NET-kompatible Anwendungen mit dem Open Source-Framework

Order on Amazon

Mono ist das Open Source-Framework für Programmierung und Einsatz .NET-kompatibler Anwendungen unter Unix, Linux und Windows. Mono vereint die Vorteile der großen Frameworks .NET und J2EE – Sprach- und Plattformunabhängigkeit – mit den Vorzügen freier Software. Dieses Buch bietet Ihnen als Profi-Programmiererin oder -Programmierer eine praxisorientierte und uebersichtliche Einführung in Mono und die NET-Kernsprache C#. Es beschreibt umfassend und übersichtlich alle relevanten Aspekte der Anwendungsentwicklung – von Datentypen und Klassen bis hin zu Thread-, Netzwerk- und GUI-Programmierung (mit gtk# und Qt#). Das Vorwort schrieb Mono-Gründer Miguel de Icaza.

Datenbank-Anwendungen mit PostgreSQL. Einführung in die Programmierung mit SQL, Java, C/C++, Perl, PHP u.a.

Datenbank-Anwendungen mit PostgreSQL . Einführung in die Programmierung mit SQL, Java, C/C++, Perl, PHP

Order on Amazon

Dies ist ein Buch für Datenbankprofis, die nach PostgreSQL migrieren und einen Einstieg in Administration und Programmierung der Open Source-Datenbank auf hohem Niveau suchen. Aufbauend auf einer Einführung in PostgreSQL, seine Installation, Administration, Optimierung und einem Tutorial zur Arbeit mit SQL, führen die Autoren praxis- und lösungsorientiert in die Arbeit mit den wichtigsten Programmierschnittstellen von PostgreSQL ein: Java, C/C++, Perl, PHP, Tcl, PL/pgSQL, ECPG, EFEU und Delphi. Jede von ihnen wird ausführlich vorgestellt und ihr Einsatz an einem praxisnahen Beispiel gezeigt. Das Buch schließt mit einer Übersicht über PostgreSQL-Interna. Die beiliegende CD enthält einen Teilabzug von ftp.postgresql.org mit PostgreSQL und Tools für alle großen Plattformen sowie alle Beispiele aus dem Buch.

Mono Kick Start

Mono Kick Start

Order on Amazon

Mono is an open-source implementation of the infrastructure upon which Microsoft’s .NET Framework is built. Providing a compatible option with all of the technical features of .NET without the restrictive licensing and prohibitive costs that Microsoft imposes, the Mono project was initiated and co-financed by Ximian Corporation for the development of an open source version of .NET Framework for Linux/Unix and Windows platforms (Mac OS X support will be added).. Mono will allow cross-platform programming and operating of .NET compatible applications. Experts see the presence of a Unix-compatible version as decisive for the success of .NET. Mono Kick Start is a practical introduction to Mono and .NET compatible application programming with Mono. After a classically structured crash-course on the C# language and Mono’s own compiler, the authors reach down deeper to subjects like threads, network programming, security, database interaction, XML, and more. A comprehensive practical section shows you how to set up Web applications with Mono, how GUIs can be programmed using GTK, and how applications written with .NET can be operated in the Mono framework.

Professionaalne abi

Võtke meiega juba täna ühendust, et saada CYBERTECilt just Teile sobiv pakkumine. Oma 20-aastase PostgreSQL-i kogemusega saame Teile pakkuda kiiret ja professionaalsel tasemel teenindust.

Võta meiega ühendust