High Performance PostgreSQL for Rails : Reliable, Scalable, Maintainable Database Applications

Saved in:
Bibliographic Details
Title: High Performance PostgreSQL for Rails : Reliable, Scalable, Maintainable Database Applications
Description: Build faster, more reliable Rails apps by taking the best advanced PostgreSQL and Active Record capabilities, and using them to solve your application scale and growth challenges. Gain the skills needed to comfortably work with multi-terabyte databases, and with complex Active Record, SQL, and specialized Indexes. Develop your skills with PostgreSQL on your laptop, then take them into production, while keeping everything in sync. Make slow queries fast, perform any schema or data migration without errors, use scaling techniques like read/write splitting, partitioning, and sharding, to meet demanding workload requirements from Internet scale consumer apps to enterprise SaaS. Deepen your firsthand knowledge of high-scale PostgreSQL databases and Ruby on Rails applications with dozens of practical and hands-on exercises. Unlock the mysteries surrounding complex Active Record. Make any schema or data migration change confidently, without downtime. Grow your experience with modern and exclusive PostgreSQL features like SQL Merge, Returning, and Exclusion constraints. Put advanced capabilities like Full Text Search and Publish Subscribe mechanisms built into PostgreSQL to work in your Rails apps. Improve the quality of the data in your database, using the advanced and extensible system of types and constraints to reduce and eliminate application bugs. Tackle complex topics like how to improve query performance using specialized indexes. Discover how to effectively use built-in database functions and write your own, administer replication, and make the most of partitioning and foreign data wrappers. Use more than 40 well-supported open source tools to extend and enhance PostgreSQL and Ruby on Rails. Gain invaluable insights into database administration by conducting advanced optimizations - including high-impact database maintenance - all while solving real-world operational challenges. Take your new skills into production today and then take your PostgreSQL and Rails applications to a whole new level of reliability and performance. What You Need: A computer running macOS, Linux, or Windows and WSL2PostgreSQL version 16, installed by package manager, compiled, or running with DockerAn Internet connection
Authors: Andrew Atkinson
Resource Type: eBook.
Subjects: Relational databases, Database management, Web applications, Application software--Development
Categories: COMPUTERS / Database Administration & Management, COMPUTERS / Languages / SQL, COMPUTERS / Internet / Web Programming
Database: eBook Collection (EBSCOhost)
FullText Links:
  – Type: ebook-pdf
  – Type: ebook-epub
Text:
  Availability: 0
Header DbId: nlebk
DbLabel: eBook Collection (EBSCOhost)
An: 4021578
RelevancyScore: 1123
AccessLevel: 6
PubType: eBook
PubTypeId: ebook
PreciseRelevancyScore: 1122.83581542969
IllustrationInfo
ImageInfo – Size: thumb
  Target: https://rps2images.ebscohost.com/rpsweb/othumb?id=NL$4021578$PDF&s=r
– Size: medium
  Target: https://rps2images.ebscohost.com/rpsweb/othumb?id=NL$4021578$PDF&s=d
Items – Name: Title
  Label: Title
  Group: Ti
  Data: High Performance PostgreSQL for Rails : Reliable, Scalable, Maintainable Database Applications
– Name: Abstract
  Label: Description
  Group: Ab
  Data: Build faster, more reliable Rails apps by taking the best advanced PostgreSQL and Active Record capabilities, and using them to solve your application scale and growth challenges. Gain the skills needed to comfortably work with multi-terabyte databases, and with complex Active Record, SQL, and specialized Indexes. Develop your skills with PostgreSQL on your laptop, then take them into production, while keeping everything in sync. Make slow queries fast, perform any schema or data migration without errors, use scaling techniques like read/write splitting, partitioning, and sharding, to meet demanding workload requirements from Internet scale consumer apps to enterprise SaaS. Deepen your firsthand knowledge of high-scale PostgreSQL databases and Ruby on Rails applications with dozens of practical and hands-on exercises. Unlock the mysteries surrounding complex Active Record. Make any schema or data migration change confidently, without downtime. Grow your experience with modern and exclusive PostgreSQL features like SQL Merge, Returning, and Exclusion constraints. Put advanced capabilities like Full Text Search and Publish Subscribe mechanisms built into PostgreSQL to work in your Rails apps. Improve the quality of the data in your database, using the advanced and extensible system of types and constraints to reduce and eliminate application bugs. Tackle complex topics like how to improve query performance using specialized indexes. Discover how to effectively use built-in database functions and write your own, administer replication, and make the most of partitioning and foreign data wrappers. Use more than 40 well-supported open source tools to extend and enhance PostgreSQL and Ruby on Rails. Gain invaluable insights into database administration by conducting advanced optimizations - including high-impact database maintenance - all while solving real-world operational challenges. Take your new skills into production today and then take your PostgreSQL and Rails applications to a whole new level of reliability and performance. What You Need: A computer running macOS, Linux, or Windows and WSL2PostgreSQL version 16, installed by package manager, compiled, or running with DockerAn Internet connection
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Andrew+Atkinson%22">Andrew Atkinson</searchLink>
– Name: TypePub
  Label: Resource Type
  Group: TypPub
  Data: eBook.
– Name: Subject
  Label: Subjects
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22Relational+databases%22">Relational databases</searchLink><br /><searchLink fieldCode="DE" term="%22Database+management%22">Database management</searchLink><br /><searchLink fieldCode="DE" term="%22Web+applications%22">Web applications</searchLink><br /><searchLink fieldCode="DE" term="%22Application+software--Development%22">Application software--Development</searchLink>
– Name: SubjectBISAC
  Label: Categories
  Group: Su
  Data: <searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Database+Administration+%26+Management%22">COMPUTERS / Database Administration & Management</searchLink><br /><searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Languages+%2F+SQL%22">COMPUTERS / Languages / SQL</searchLink><br /><searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Internet+%2F+Web+Programming%22">COMPUTERS / Internet / Web Programming</searchLink>
PLink https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=nlebk&AN=4021578
RecordInfo BibRecord:
  BibEntity:
    Classifications:
      – Code: 005.7585
        Scheme: ddc
        Type: prePub
    Languages:
      – Code: eng
        Text: English
    Subjects:
      – SubjectFull: Relational databases
        Type: general
      – SubjectFull: Database management
        Type: general
      – SubjectFull: Web applications
        Type: general
      – SubjectFull: Application software--Development
        Type: general
    Titles:
      – TitleFull: High Performance PostgreSQL for Rails : Reliable, Scalable, Maintainable Database Applications
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Andrew Atkinson
      – PersonEntity:
          Name:
            NameFull: Andrew Atkinson
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 01
              Type: published
              Y: 2024
            – D: 12
              M: 12
              Type: profile
              Y: 2025
          Identifiers:
            – Type: isbn-print
              Value: 9798888650387
            – Type: isbn-electronic
              Value: 9798888651094
            – Type: isbn-electronic
              Value: 9798888651087
          Titles:
            – TitleFull: High Performance PostgreSQL for Rails : Reliable, Scalable, Maintainable Database Applications
              Type: main
ResultId 1