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.
ChatterChampion
I'm grateful for this app's ability to fit seamlessly into my lifestyle, making learning a part of my day. Navigating through chapters is a breeze. It's like having a personal reading guide. The app is well-designed and user-friendly. ListenBook makes listening to audiobooks a joy.
MeeP
πΆββοΈπ Staying entertained during leisurely walks β audiobooks make outdoor time delightful! πΆββοΈπ§ The audio quality is superb. ListenBook enhances my audiobook experience.
Cinder Coffee
The bookmarking feature ensures I never lose my place in a book β so convenient! Background play feature lets me multitask while enjoying a book β brilliant! With this app, I can dive into captivating narratives while cooking, cleaning, or commuting β pure magic! High-quality playback even with complex formats like FLAC. Impressive!
MysticMingle
ListenBook's audio filters have transformed the way I experience audio content β it's a real game-changer. ListenBook Pro's noise reduction is a lifesaver. I can hear clearly even in noisy environments. Bookmarks are a fantastic organizational tool. They help me keep track of important moments in my audiobooks. WiFi downloads save a lot of time. Great feature!
Lewd Dice
The app's recommendations are surprisingly accurate β it's like they know my taste perfectly! π The simplicity and functionality of this app are top-notch. I can start a book with just a tap and immerse myself in the story instantly. π±π Efficiency meets audiobooks β this app's functionality is a perfect match.
Flash
ListenBook's user-friendly audio filters and controls have made my audiobook sessions more interactive and engaging. I love how this app brings stories to life, even during my morning jogs. The variety of supported formats means I can enjoy audiobooks from different sources hassle-free. Noise reduction and tone changing enhance the listening experience. Love it!
Black Mustard
I'm blown away by ListenBook's ability to maintain audio quality even for formats like FLAC and AWB. With this app, I've rediscovered the joy of literature during my daily walks β it's truly invigorating. π My audiobook haven β this app is like a door to endless adventures and knowledge! ππ Bookmarks are a lifesaver for audiobook lovers. They help me keep track of important moments. ListenBook makes my commute enjoyable. The audio filters really enhance the listening experience.
Speedwell
π± Carrying my library in my pocket β this app makes every moment a reading opportunity! ππ Navigating through chapters has never been easier. It's a user-friendly delight.
High Beam
The captivating narrators make each story come alive in a unique way. ListenBook's support for chapters and bookmarks ensures that I never lose my place in a story. ListenBook's dedication to delivering high-quality sound and user-friendly features has won me over. πͺ Doubling the impact of my workouts β exercising and exploring stories, all thanks to this app! πͺπ§
Gas Man
ListenBook's support for various audio formats makes it a versatile app for all kinds of audiobook enthusiasts. ποΈπ§ Escaping to paradise with a beach read β this app is my vacation in audio form! ποΈπ ListenBook's compatibility with CarPlay is a major convenience during road trips. ListenBookβs bookmarking feature is incredibly useful. I never lose my place in a book.
CyberScribe
Audiobooks have become a cherished part of my daily life, all thanks to this app. I can't believe I waited this long to discover the joy of audiobooks through this app. The app's support for different audio formats is like a dream come true for audiophiles. My workouts have become more enjoyable and productive with ListenBook's compatibility with Apple Watch.
Cuff Queen
ListenBook Pro's noise reduction feature is a true blessing for enjoying clear audio even in noisy environments. ListenBook has made managing and enjoying audiobooks, lectures, and speeches effortless and enjoyable.
NexusNomad
This app's customizable features, like playback speed and bookmarks, have transformed my experience. I'm hooked on this app's ability to make every moment a reading moment. π§ This app is my saving grace! Now I can enjoy my beloved books while cooking up a storm! ππ³ The app's versatility in audio downloading is unmatched. It's a comprehensive solution for my audiobook needs.
General Broomdog
With ListenBook, I can listen to my favorite audiobooks and speeches with the utmost comfort and convenience. This app has made 'reading' more versatile and enjoyable than ever.
Twin Blaze
I've rediscovered the joy of reading through the convenience of audiobooks. This app is a must-have for any book lover on the go β it's my daily companion. Audiobooks on this app have turned my exercise sessions into moments of education. Audiobook immersion simplified β this app's ease of use is a true asset. Kudos to ListenBook for the intuitive design and easy-to-use controls. It's evident that they've put a lot of thought into user experience.
Killer Grenade
πΆββοΈπ Embracing audiobooks as my companions during leisurely walks β nature and narratives, a perfect match! πΆββοΈπ§ Audiobooks at my fingertips β this app's functionality is truly impressive. Tone adjustment adds a personalized touch to the narration, making the audiobook experience even more immersive.
Divine Bramble
Audiobooks have become a cherished part of my daily life, all thanks to this app. π₯ Simplifying my reading routine β the app's functionality ensures I'm always one click away from literary adventures. ππ πΌ Making every minute count β this app's ease of use ensures I'm always making progress in my audiobook adventures. π±π Every moment is a chance to dive into a new adventure with this app. Its smart controls and comprehensive format support ensure that my audiobook journey is a seamless one. ππ§ ListenBook Pro's noise reduction feature is a revelation. It elevates the audio quality, providing a clear and immersive listening experience that enhances my enjoyment.
Kitchen
The ability to adjust playback speed and volume is a game-changer for me. Auto-rewind is incredibly helpful. Excellent functionality.
Friday Fox
ListenBook's support for CarPlay and Apple Watch has made my listening experience even more seamless. ππ On-the-go listening has never been smoother β this app's functionality keeps me engaged during long commutes. ππ
CuriousCoder
I'm hooked on this app β it's like Netflix for book lovers! ListenBook's support for playlists in CUE format is a thoughtful touch I appreciate. πΆββοΈπ Embracing audiobooks as my companions during leisurely walks β nature and narratives, a perfect match! πΆββοΈπ§ ListenBook's user-friendly interface and powerful features have rekindled my love for audiobooks. The audio filters and precise controls are fantastic! Say hello to audiobook nirvana! This app's user-friendly design and comprehensive features have made my reading routine smoother than ever. ππ
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