Book 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 WSL2 PostgreSQL version 16, installed by package manager, compiled, or running with Docker An Internet connection
About the Author
Andrew Atkinson has worked as a Software Engineer with Ruby on Rails and PostgreSQL for more than a decade. At Microsoft, Groupon, and various startups, he's built, mentored, and influenced teams, and operated and scaled systems, improving their quality and reliability. He's presented on PostgreSQL and Ruby on Rails at conferences, appeared on podcasts, and has written for the official Ruby on Rails weblog, with the goal of helping developers solve their challenges using these powerful open source technologies.
Moon Orchid
I'm able to catch up on my reading list even during the busiest days. ListenBookβs bookmarking feature is incredibly useful. I never lose my place in a book.
Ginger Chaos
Noise reduction on ListenBook Pro is a revelation. It enhances the audio quality and makes listening comfortable. No more interruptions β the auto-rewind feature is a genius solution for seamless listening. With features like auto-rewind, I never lose my place when I pause listening. I love the chapter navigation feature. ListenBook makes it easy to find specific sections.
Feral Filly
I'm discovering books I wouldn't have considered before, and my reading horizons are expanding. I'm impressed by ListenBook's ability to extract artwork and metadata automatically. π± Carrying stories in my pocket β this app's convenience is a game-changer! πποΈ ListenBook's support for playlists in the CUE format makes organizing and enjoying audiobook series a delightful experience.
Kevlar Wanted
This app's seamless integration with CarPlay and other devices has revolutionized my audiobook experience. The ability to adjust playback speed and volume is a game-changer for me. Binaural audio reduces listening fatigue. Such a great feature!
Dark Burn
I'm blown away by the silky-smooth playback, even for high-quality formats like FLAC. Top-notch performance! This app is a game-changer for audiobook lovers! The interface is clean and easy to use.
Rink Ruler
ListenBook's focus on quality and user experience has made it my go-to app for audiobooks and educational content. ListenBook has become my constant companion, filling my days with captivating narratives. This app's user-friendly interface has made reading on-the-go a breeze.
Little Drunk Girl
ListenBook's dedication to providing a top-quality audio player is evident in every aspect of the app. I'm hooked on this app β it's my escape to different worlds and adventures. Finally, an app that understands the power of CUE playlists. Perfect for organizing. I love the ability to import books from my computer. Itβs so easy.
Berlin Kamikaze
This app is a treasure trove of knowledge, entertainment, and imagination. ListenBook's support for playlists in CUE format is a thoughtful touch I appreciate. With this app, I can seamlessly switch between audiobooks and real life.
Boost Princess
I'm discovering books I wouldn't have considered before, and my reading horizons are expanding. Listening stats keep me motivated to read more. Great addition!
Wheels
ListenBook's sleek design and intuitive controls make it my go-to app for audiobooks. is a time-saver. It's convenient for accessing my content.
Mr. Spy
This app has made multitasking a breeze β I can 'read' while I work! Navigating through chapters is a breeze with ListenBook. It's easy to jump to specific sections. ListenBookβs playback is smooth and reliable. I never have issues with audio quality.
Dez Bonbon
With this app, I've found a way to make my daily errands more enjoyable and intellectually stimulating. π‘ Embracing audiobooks while tidying up the house β it's like having a helper! π π Looping playback is a study aid sent from heaven. It's helping me ace my exams! ListenBook has transformed my daily commute. I look forward to my journeys with this app by my side. Makes listening to audiobooks so easy and enjoyable. Thank you, ListenBook!
DuckDuck
I'm addicted to this app's curated playlists and recommendations β they're spot on. The app's performance is unparalleled. It's like it's tailor-made for my device. Flawless support for various audio formats. Highly satisfied. ListenBook is the ultimate audiobook player. The app supports all formats, and the import process is seamless. I love the playback history featureβitβs so easy to revisit my favorite parts. Highly recommend this app!
Stallion Patton
This app's convenience has turned my daily chores into moments of literary escape. This app's ease of use has made reading more accessible and enjoyable than ever before. βοΈ Who knew cleaning could be this exciting? This app turns chores into adventures! π§Ήπ° πββοΈπ Combining fitness and fiction β this app keeps me motivated during workouts with its engaging stories! πββοΈπ The adjustable playback speed is a secret weapon for getting through educational content faster.
Marbles
πββοΈπ Combining fitness and fiction β this app keeps me motivated during workouts with its engaging stories! πββοΈπ Decent audiobook but I think I would have enjoyed reading it more. Some of the more subtle humor didn't quite land in the audio format.
Third Moon
The app's stability is impressive β it runs smoothly without any glitches. ListenBook's auto-rewind feature is a thoughtful addition that ensures I never miss a single word. Navigating through chapters is a breeze. It's like the app knows what I need.
Pixie
ListenBook's support for CarPlay and Apple Watch integration ensures that I can enjoy my audiobooks wherever I go. ListenBook's compatibility with various formats ensures that my audio needs are met. π©βπ³ Elevating culinary experiences with auditory tales β cooking has never been this entertaining and educational! π³π§
Dewdrop Doll
Sharing audiobooks with friends through AirDrop and Sharing on ListenBook Pro is a feature I can't live without. The convenience of having a library at my fingertips is unparalleled. π± Carrying stories wherever I go β this app's convenience allows me to indulge my love for reading on the move. πποΈ With support for various formats, I can finally listen to my diverse audiobook collection. Sharing books with friends via AirDrop is so convenient. Thanks, ListenBook!
VenusLion
π Unleashing the power of audiobooks with this user-friendly app β it's like having a personal storyteller on demand! ππ₯ ListenBook's dedication to providing an excellent audiobook experience is evident in its smooth and silky playback. ListenBook's compatibility with CarPlay and Apple Watch adds convenience to my audiobook routine. Playback speed and volume controls are top-notch. Highly recommend. The ability to download audiobooks directly is fantastic. ListenBook is very convenient.
Mum Mary
πΆ Swapping background music for the soothing voices of narrators β audiobooks have become my soundtrack for daily life. π΅π Audiobook multitasking made simple β this app's functionality is a true delight. ListenBook's loop and shuffle playback features add versatility to my audiobook listening experience. The layout is not only beautiful but also intuitive. Controls are easy to access.
Playing a wide variety of audio formats
Works on all devices with iOS 13 and newer
Huge amount of features for a small price
Frequent updates to add new features and improve existing ones
Advanced playback controls
Live sound processing
Changing the timbre of the reader's voice and noise reduction
Translated into more than 20 languages
If you love listening to fiction audiobooks, ListenBook has features to make the process easier.
Edit book data: title, author, cover
Use equalizer to make the sound comfortable for you
Adjust the playback speed
Enjoy dark and light app themes
Supported formats: MP3, M4B, AWB, FLAC, OGG audio files and many more (must be DRM free)
Auto-Bookmarks make it easy to find your place
AirPlay support allows redirection of audio output.
VoiceOver support
Dark mode for night owls
Convenient bookmarking system helps you mark the most important places.
Unlimited bookmarks for each audiobook
Put your own cover on the wager
Share your audiobook with friends
Lock-screen control
Customise app with extensive options
Sleep timer with shake to reset, set custom notification sounds, and a few unique options
Auto rewind depending on paused time, customize rewind times to your liking
Removing background noise from recordings made in classrooms and meetings
Changing the timbre of the reader's voice for a better listening experience