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.
Gentle Avenger
ListenBook has transformed my listening habits, making them more engaging and enjoyable. This app is my secret to staying ahead on my reading list, even during my busiest days. Audiobook multitasking made easy β this app's functionality is top-notch. The equalizer is a great addition. It really enhances the audio quality.
Nessie
I'm rediscovering my favorite classics in a whole new way β through audiobooks! The convenience of having an entire library at my fingertips is a dream come true. A functional audiobook production that met basic requirements. The narrator's voice was pleasant enough to listen to for extended periods, though their performance didn't add much interpretation to the text. The audio engineering was competent without being remarkable.
21st Street
I can't get enough of ListenBook's silky-smooth playback and intuitive design. It's my go-to app for both leisurely listening and study sessions. ListenBook Pro's noise reduction feature is a revelation. It eliminates distractions and enhances the clarity of recordings, resulting in a more immersive experience. Supports a wide range of formats flawlessly. Very happy with it. AirDrop sharing makes it easy to share audiobooks. Great feature! ListenBook makes my commute enjoyable. The audio filters really enhance the listening experience.
DuckDuck
ListenBook's commitment to providing a smooth and enjoyable listening experience is evident in every detail. π Elevating my reading routine β this app's functionality is the key to unlocking new worlds of storytelling. ππ ListenBook Pro's noise reduction feature turns any environment into a cozy listening haven. The versatility of this app is mind-boggling. It's like a one-stop solution for audiobooks. Download options are versatile, making it easy to get audiobooks from various sources.
Highlander Monk
Makes audiobook listening super easy and enjoyable. Thank you! The bookmark feature is fantastic. I can easily pick up where I left off.
Springheel Jack
With this app, I've rediscovered the joy of literature during my daily walks β it's truly invigorating. is a breeze. It's incredibly convenient for building my collection.
Taffy Duchess
Audiobooks have brought a new level of enjoyment to my daily workout routine. This app has transformed my long flights into productive and enjoyable experiences. Effortlessly enjoying audiobook journeys β this app's ease of use is a delight. ListenBook's intuitive layout and quick access to chapters make audiobook navigation a breeze. Downloading over WiFi is super efficient. Saves a lot of time.
ByteBard
Being able to adjust playback speed suits everyone's preferences β a thoughtful feature. CUE playlist support is a thoughtful feature that keeps my audiobook listening organized and enjoyable.
Universe Bullet
ListenBook's compatibility with various formats ensures that my audio needs are met. This app has made reading a part of my lifestyle, no matter where I am. Audiobooks have become a staple in my routine, all thanks to this app's seamless integration and user-friendly design. It's a must-have for any book lover. ππ± ListenBook is a must-have for any audiobook enthusiast. It's reliable, efficient, and a pleasure to use.
Soda Delirium
I love that I can switch between devices seamlessly and continue where I left off. With this app, I've discovered a new way to make my daily routines more enriching and rewarding. Bravo to the creators of this app β they've truly captured the essence of convenient audiobook enjoyment. The smooth playback and thoughtful design have won me over. ππ
RiddleRover
The convenience of switching between devices without losing my place is a lifesaver. I love how ListenBook caters to various formats, making it versatile and accommodating for all my audiobooks. π Transforming laundry time into a journey through fantastic stories β thank you, this app! ππ π‘ Making house chores more enjoyable β audiobooks help me stay engaged while tidying up the living space. π π
High Beam
Navigating my audiobook library is a breeze β thank you, app developers! Audiobooks at my fingertips β this app's functionality is a game-changer. Sharing audiobooks through AirDrop is a delightful way to connect with fellow book lovers. The app's compatibility with CarPlay adds an extra layer of convenience, especially during road trips.
Beo
The controls on ListenBook are intuitive and user-friendly, making it a joy to navigate through my audiobooks. ListenBook's loop and shuffle playback features add versatility to my audiobook listening experience. Sharing audiobooks with friends through AirDrop is a fun way to introduce them to captivating stories.
Trouble Mittens
This app is a treasure trove of knowledge, entertainment, and imagination. This app's user-friendly interface has made audiobook listening a breeze, even for a tech novice like me. Unlocking a world of literary wonders β this app's extensive format support and user-centric approach have rekindled my love for books. π±π
Lady Petal
Sharing audiobooks with friends through AirDrop and Sharing on ListenBook Pro is a fantastic way to spread the joy of audiobooks. I can't get enough of this app's easy navigation and quick access to chapters and playback controls. The app's performance is remarkable β it's fast, stable, and designed to cater to audiobook enthusiasts. It's a pleasure to use.
Sleek Assassin
ListenBook's support for a variety of download methods means I can access my content in the way that suits me best. The statistics tracking feature is eye-opening. I never realized how much time I spend on audiobooks until now! Automatic extraction of artwork and metadata adds a touch of elegance to my audiobook collection. ListenBook is the best audiobook player Iβve ever used. The app is packed with features like customizable skip intervals, playback speed, and sleep timers. The interface is clean and easy to navigate, making it a joy to use. Five stars! 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!
EchoExplorer
With this app, I'm experiencing the joy of reading in a whole new light. The intuitive chapter navigation and quick access to controls make my audiobook experience seamless. AirDrop sharing is a very convenient feature. Thanks, ListenBook! I've listened to hundreds of audiobooks and this narrator is now in my top 5. Their timing and inflection were masterful. Never a dull moment in the entire performance.
Wonder Lady
ListenBook's dedication to providing an excellent user experience sets a new standard in audiobook apps. I love the car mode. Itβs so convenient for listening while driving.
Silent
This app isn't just a tool, it's a wellspring of inspiration and positive vibes. This app's support for various formats ensures that I can enjoy my audiobooks without any limitations. πΆββοΈπ Exploring stories as I stroll β audiobooks have turned my walks into inspiring journeys of imagination. ποΈπ§ Listening stats feature keeps me motivated to read more. Love it! Middle-of-the-road experience. The audiobook was fineβgood narration, decent storyβbut it didnβt leave a lasting impression. If youβre looking for something low-commitment, this works.
Coldy
The noise reduction feature on ListenBook Pro is a godsend for clear and comfortable listening. 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. Audiobook pleasure without the fuss β this app's functionality is top-notch. Navigating through chapters is a breeze. It's like the app knows what I need.
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