Your email was sent successfully. Check your inbox.

An error occurred while sending the email. Please try again.

Proceed reservation?

Export
  • 1
    ISBN: 9781788470537 , 1788470532
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: PostgreSQL ; SQL (Computer program language) ; Database management ; Databases ; Design ; Electronic books ; Electronic books ; local
    Abstract: Master the capabilities of PostgreSQL 10 to efficiently manage and maintain your database About This Book 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 Who This Book Is For If you are a PostgreSQL data architect or an administrator and want to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL 10, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL are required to make the best use of this book. 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 In Detail 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. Style and approach This mastering-level guide delves into the advanced functionalities of PostgreSQL 10
    Note: Description based on online resource; title from title page (Safari, viewed February 27, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 2
    Online Resource
    Online Resource
    Indianapolis, Ind. : Sams | Boston, MA :Safari,
    Language: English
    Pages: xv, 772 p. , ill. ; , 24 cm
    DDC: 005.2/762
    Keywords: PostgreSQL ; Internet programming ; PHP (Computer program language) ; Electronic books ; local
    Abstract: Sams¿ PHP and MySQL Web Development , by Luke Welling and Laura Thomson, showed that 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 and 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.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 3
    Online Resource
    Online Resource
    Indianapolis, IN : Sams | Boston, MA :Safari,
    Language: English
    Pages: xi, 753 p. , ill. ; , 23 cm
    Keywords: PostgreSQL ; Database management ; Electronic books ; local
    Abstract: 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.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 4
    Online Resource
    Online Resource
    Indianapolis, Ind. : Sams | Boston, MA :Safari,
    Language: English
    Pages: x, 303 p. , ill. ; , 24 cm
    DDC: 005.13/3
    Keywords: C# (Computer program language) ; Compilers (Computer programs) ; Microsoft .NET Framework ; Open source software ; Electronic books ; local
    Abstract: 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.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 5
    ISBN: 9781789539172 , 178953917X
    Language: English
    Pages: 1 online resource (1 volume)
    Edition: Second edition.
    Keywords: PostgreSQL ; SQL (Computer program language) ; Database management ; Databases ; Design ; Electronic books ; Electronic books ; local
    Abstract: Master the capabilities of PostgreSQL 11 to efficiently manage and maintain your database 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 Who this book is for This book is for data and database professionals wanting to implement advanced functionalities and master complex administrative tasks with PostgreSQL 11. Prior experience of database administration with PostgreSQL database will aid in understanding the concepts covered in this book.
    Note: Description based on online resource; title from title page (viewed January 7, 2019)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 6
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (142 pages)
    Edition: 1st edition
    Keywords: Electronic books ; local
    Abstract: Discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases In Detail 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. What You Will Learn Perform routine backups and restore your databases safely Set up replication quickly and easily Handle logfiles and extract information from PostgreSQL Monitor PostgreSQL and integrate it into the existing infrastructure Build desktop applications using C# Optimize PostgreSQL for high speed and tune your database parameters Adjust your user permissions and lock out intruders Detect bottlenecks and find missing indexes with ease
    Note: Online resource; Title from title page (viewed October 15, 2014)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 7
    ISBN: 9781783555369 , 178355536X
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: PostgreSQL ; SQL (Computer program language) ; Database management ; Databases ; Design ; Electronic books ; Electronic books ; local
    Abstract: Master the capabilities of PostgreSQL 9.6 to efficiently manage and maintain your database About This Book 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 Who This Book Is For If you are a PostgreSQL data architect or an administrator who wants to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL is required to make the best use of this book. 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 In Detail 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. Style and Approach This book is a comprehensive guide covering all the concepts you need to master PostgreSQL. Packed with hands-on examples, tips and tricks, even the most advanced concepts are explained in a very easy-to-follow manner. E...
    Note: Description based on online resource; title from title page (Safari, viewed June 21, 2017)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 8
    ISBN: 9781803248349
    Language: English
    Pages: 1 online resource (522 pages) , illustrations
    Edition: 5th edition.
    DDC: 005.74
    Keywords: PostgreSQL ; SQL (Computer program language)
    Abstract: Starting with an introduction to the newly released features of PostgreSQL 15, this updated fifth edition will help you get to grips with PostgreSQL administration and how to build dynamic database solutions for enterprise apps, including designing both physical and technical aspects of the system. You'll explore advanced PostgreSQL features, such as logical replication, database clusters, advanced indexing, 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. Among the other skills that the book will help you build, you'll cover transactions, handling recursions, working with JSON and JSONB data, and setting up a Patroni cluster. It will show you how to improve performance with query optimization. You'll also focus on managing 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 use your database to its utmost capacity by implementing advanced administrative tasks with ease.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 9
    ISBN: 9781783988549 , 1783988541
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Edition: Second edition.
    Series Statement: Community experience distilled
    Keywords: PostgreSQL ; Database management ; SQL (Computer program language) ; Electronic books ; Electronic books ; local
    Abstract: Leverage the power of PostgreSQL replication to make your databases more robust, secure, scalable, and fast In Detail PostgreSQL offers a comprehensive set of replication - related features. Unleashing the power of PostgreSQL provides you with countless opportunities and a competitive advantage over other database systems. This book will guide you through the most important concepts of PostgreSQL replication. It contains all the information you need to design and operate replicated setups. Beginning by giving you an understanding of replication concepts, the PostgreSQL transaction log, and Point-in-time Recovery, we gradually move on to setting up asynchronous and synchronous replication. Next up, you will learn to monitor a PostgreSQL cluster setup, deal with monitoring tools, and then move on to understanding Linux High Availability. Further, we explore widely-used tools such as Slony, SkyTools, Postgres-XC, and walbouncer, and set up PL/Proxy. Finally, you'll get acquainted with the new technology of BDR, which allows bidirectional replication in PostgreSQL. What You Will Learn Use Point-in-time Recovery to perform data recovery as well as replication Set up synchronous as well as asynchronous streaming replication Get familiarized with the transaction log, the core component of most replication setups and its purpose Improve speed and reliability with an understanding of pgpool and PgBouncer Increase your data security and geographically distribute data Make your systems more available and secure with Linux High Availability Scale out with PL/Proxy and Postgres-XC Detect, investigate, and solve replication-related problems
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed August 13, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...