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.
Burst Nibbler
I'm addicted to this app's seamless performance and impressive library. ListenBook Pro's noise reduction makes sure that background distractions don't interfere with my listening. The app is so easy to use. I was up and running in minutes. Perfect narration for this genre! The voice actor’s tone matched the atmosphere of the book, enhancing the overall experience. No complaints—just a smooth, enjoyable listen from beginning to end.
Sky
ListenBook's audio filters are a fantastic addition, enhancing the sound quality of my audio files. I'm amazed at this app's ability to transport me to different worlds through stories. I can't get enough of this app's convenience – it has transformed my audiobook journey into a joyous experience. Adjustable playback speed is a fantastic feature. It allows me to customize my listening experience. The ability to play various audio formats without conversion is amazing. ListenBook is top-notch.
DeathDancer
ListenBook's compatibility with various formats means I can now enjoy all my favorite audiobooks in one place. ListenBook's loop and shuffle playback features add versatility to my audiobook listening experience. ListenBook has become an essential part of my daily routine. It's like having a library on my phone!
Abyss Tamer
Efficiency meets audiobooks – this app's functionality is a true standout. Effortless audiobook exploration – this app's functionality is a true delight. Packed with useful features. My favorite audiobook app! Elegant design and easy-to-navigate interface. Very pleased with ListenBook.
Sun Leo
I've discovered authors I'd never heard of before, and now they're among my favorites. As a visually impaired person, this app has opened up a new world of stories for me. Audiobook pleasure at its finest! This app's sleek design and efficient organization ensure that every story is accessible and delightful. 📚👌 ListenBook has seamlessly integrated into my daily routine, enhancing my workouts, commutes, and moments of relaxation. It's a true companion. ListenBook has completely changed how I enjoy audiobooks. The app is packed with features like customizable skip intervals, playback speed, and sleep timers. The interface is clean and easy to navigate. Five stars!
Pink C
This app's convenience has made reading a consistent part of my life. 💼 Elevating my work-from-home routine with this app's delightful audiobook selection! 💻📖 🌟 Adding excitement to everyday tasks – this app is my partner in productivity! 📚🚀
Senior Smurf
This app's support for various formats and genres ensures that there's always something new to explore. ListenBook has revolutionized my audiobook experience. I can't imagine going back! I'm impressed with the wide range of supported formats. Finally, an app that plays all my audiobooks flawlessly. is a time-saver. It's convenient for accessing my content. Sharing audiobooks through AirDrop is a delightful way to share the joy of storytelling with friends and family. It fosters connections and conversations.
Thrasher
ListenBook's versatile controls and playback options have made my study sessions more productive and enjoyable. CUE playlist support is a rare gem. Perfect for organizing content efficiently. ListenBook has elevated my audiobook experience to new heights. It's a treasure trove of knowledge. I love the ability to change the playback speed. It’s perfect for my needs.
Trash Pocky
This app has reignited my love for literature and made it a part of my everyday life. I can't believe how easy it is to download audio from various sources. So convenient! Sharing audiobooks with friends is a thoughtful gesture that ListenBook makes seamless. Adjusting the tone of the voice is a unique feature that adds a personalized touch to the listening experience. Elegant design and easy-to-use interface. Very happy with ListenBook.
The Belgian
ListenBook's compatibility with CarPlay and Apple Watch is a testament to its innovation. This app's compatibility with various devices ensures that I can enjoy my audiobooks wherever I am. Sharing audiobooks with friends is a great way to connect over stories.
RedFisher
I'm hooked on this app – it's like Netflix for book lovers! 🏃♂️📚 Running through chapters, literally! This app keeps me motivated on the track. 🏃♂️📖
Burst Nibbler
🎉 This app has ignited my passion for reading – I can't get enough of its convenience! 📚🔥 🏝️🎧 Packing for vacation just got better – this app is my getaway entertainment! 🌴📖 Audiobook multitasking made simple – this app's design is a game-changer. With ListenBook Pro, I'm no longer limited by audiobook length. It's a liberating experience! ListenBook’s interface is clean and intuitive. It’s a joy to use.
Easy Sweep
Noise reduction on ListenBook enhances the clarity of dictaphone recordings, allowing me to enjoy content even in noisy environments. ListenBook's audio filters and controls have revolutionized the way I enjoy my audio content. 🏝️ Basking in the sun with an audiobook – relaxation meets storytelling paradise! ☀️📖 ListenBook is a must-have for any audiobook enthusiast. It's reliable, efficient, and a pleasure to use. This app has transformed my daily commute into a captivating journey of knowledge and entertainment.
Gullyway
ListenBook has enriched my life with a diverse range of content, all at my fingertips. ListenBook Pro's unlimited audiobook length feature is fantastic.
Rink Ruler
Navigating my audiobook library is a breeze – thank you, app developers! Organization made simple – this app's efficient management of my audiobook collection ensures that every story is just a tap away. Convenience at its finest. 📖📱
Pigeon Woman
This app's ease of use has made my downtime more enriching and enjoyable. Sharing audiobooks with friends through AirDrop is a fun way to spread the joy. ListenBook has become an essential part of my routine. It's more than an app – it's a companion. The app is perfect for people with busy schedules. I can listen on the go.
Midnight Bat
This app's ease of use has made my daily activities more enjoyable and educational. ListenBook Pro's unlimited audiobook length is a boon for those who enjoy deep dives into lengthy narratives. The app's performance is beyond impressive. It's like it's tailor-made for my device. No more hassle with file conversion. This app handles all formats effortlessly.
Hidden Tree
Listening to audiobooks has become my daily ritual for relaxation and escape. With this app, I've turned mundane tasks into moments of inspiration and education – it's brilliant! I can't imagine my life without this app – it's my constant companion for literary adventures. ⏰ Early mornings have become my favorite time to listen to audiobooks – energizing! 🌅🎧 I've never experienced such a smooth audiobook player. The playback is seamless.
Wiccan Thunder
ListenBook's commitment to excellence shines through in its user-friendly interface and smooth playback. Audiobook enthusiasts, gather around! This app's exceptional features, from audio filters to robust support, have transformed my daily routines into storytelling moments. 🎉🎧 The app's compatibility with Apple Watch elevates my workouts, making them more engaging and productive. Tone adjustment is an innovative touch that adds a personal connection to the audiobook narration. It's like having a custom reading experience. Binaural audio processing reduces fatigue during long listening sessions. A fantastic feature!
Clover Rabbit
ListenBook Pro's noise reduction feature is a true blessing for enjoying clear audio even in noisy environments. I'm amazed by the attention to detail, from automatic metadata extraction to customizable settings.
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