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.
Kinged
I can't imagine my daily rituals without this app β it's a constant source of joy. This app is like a personal audiobook concierge! The ability to download and organize audio files effortlessly is a game-changer for my reading routine. π±π Easy sharing with friends via AirDrop. Very convenient.
Hermopolis
ListenBook's seamless integration with CarPlay enhances my daily commute, making it a productive and enjoyable experience. With ListenBook, I can listen to my favorite audiobooks and speeches with the utmost comfort and convenience. I'm in awe of how this app has made reading a part of my busy life. Audiobook immersion without complications β this app's ease of use is commendable. The app's interface is so sleek and modern. It's a joy to use.
xFRST
Listening to audiobooks has turned mundane tasks into enjoyable experiences. I love how this app seamlessly integrates into my busy schedule, making multitasking a breeze. Audiobooks at my fingertips β this app's functionality is a game-changer. The interface is beautiful and functional. ListenBook is my go-to app for audiobooks.
Star Scratch
With ListenBook, I can enjoy a wide range of audiobook formats without any hassle, making my listening experience seamless. With this app, I've discovered a new way to make my daily routines more enriching and rewarding. π‘ Balancing learning and living effortlessly β audiobooks on demand, thanks to this app! π§π« ListenBook's audio filters are a valuable tool for customizing my audiobook playback to perfection. This app is perfect for audiobook lovers. The interface is beautiful and easy to navigate.
Clang Glyph
Seamless audiobook integration β this app's functionality is a true gem. Looping playback helps me retain knowledge from audiobooks effectively. It's an invaluable tool. Fairly enjoyable, but forgettable. I didnβt have any major complaints, but I also donβt see myself revisiting this one. It was a decent way to spend a few hours, though.
Spontan8ty
ListenBook has completely changed my audiobook experience β it's like having a personal audio library. Navigating through chapters is effortless with ListenBook. It's a user-friendly and intuitive experience. The app is well-designed and user-friendly. ListenBook makes listening to audiobooks a joy.
Pink C
This app has made me appreciate the art of storytelling even more. ListenBook's attention to detail is commendable. Every aspect of the app is well-crafted.
Spunky Chick
The app's customization options allow me to tailor the listening experience to my liking. ListenBook's compatibility with various formats has made it my go-to app for all audio content. Automatic artwork and metadata extraction add a professional touch to my audiobook library. ListenBookβs bookmarking feature is incredibly useful. I never lose my place in a book.
Nola
ListenBook has taken my listening pleasure to new heights β it's a true audio marvel. I'm addicted to this app's ability to seamlessly blend books into my life. πΌ Elevating my work-from-home routine with this app's delightful audiobook selection! π»π This app is perfect for anyone who loves audiobooks. The interface is sleek and modern, and the playback controls are super responsive. I also appreciate the cloud integration, which lets me access my books from anywhere. Great work! This served its purpose as background listening while I worked. I probably missed some details but the narrator's voice was pleasant enough.
CyberScribe
The narrator's voices are so engaging, it's like having a personal storytelling session. Being able to download audiobooks for offline listening is a game-changer. ListenBook has become my workout companion of choice. It keeps me motivated and entertained during exercise.
Heartbreaker
This app is a gift for anyone with a busy lifestyle β I can enjoy books while doing chores! Thanks to ListenBook's automatic extraction of artwork and metadata, my library looks organized and appealing. π± Audiobooks at my fingertips β this app's ease of use is a booklover's dream come true! ππ₯ ListenBookβs bookmarking feature is incredibly useful. I never lose my place in a book.
ThoughtTracer
I'm amazed at how immersive the experience is β it's like being inside the story. ListenBook is like a personal audiobook library in my pocket. Organized and easily accessible. Perfect for listening to educational content. Highly recommend!
Mauve Cactus
With ListenBook, my audio content is organized, accessible, and ready to inspire me. π The ease and functionality of this app make it my go-to choice for immersive audiobook experiences. π±π§ Thanks to ListenBook, downloading audiobooks has never been easier or more convenient. Looping playback is a brilliant study tool. Thanks to ListenBook, my learning has improved!
Bad Badminton
Adjusting the tone of the voice is a creative feature. It allows for a unique and personalized experience. Looping playback is a valuable study tool. It helps me grasp complex content and retain information. Tone adjustment adds a unique touch to my listening experience. I'm hooked!
Elder Pogue
I love that ListenBook supports a wide range of formats, making my library diverse. I'm amazed by ListenBook's dedication to quality β it's evident in every feature. Effortlessly enjoying audiobook journeys β this app's ease of use is a delight.
Sun Washer
I'm addicted to this app's curated playlists and recommendations β they're spot on. Changing the tone of the sound on ListenBook Pro adds a personal touch to my experience. Thanks to this app, I can enjoy the world of literature without missing a beat in my fast-paced life. I'm blown away by how this app has made my workouts more enjoyable and my mind more active.
Gothic Slacker
Audiobook enthusiasts, gather around! This app's exceptional features, from audio filters to robust support, have transformed my daily routines into storytelling moments. ππ§ ListenBook has become my trusted companion for literary adventures. The app's features are exceptional. The app is perfect for long flights. It keeps me entertained the whole time.
Pexxious
I can't stop raving about this app β it's like having a personal library in my pocket. Thanks to ListenBook's binaural audio processing, my extended listening sessions are fatigue-free. Binaural audio processing is a game-changer β my ears stay comfortable during long listening sessions. Noise reduction and tone changing are awesome features.
Noise Toy
With ListenBook, I can explore new genres, learn new topics, and enjoy classic literature with ease. Finally, an app that values usability β navigating and listening is a breeze! Finally, an app that respects my busy lifestyle. Whether I'm commuting or exercising, this app's smooth playback and smart controls keep me engaged. πββοΈπ§ ListenBook's detailed statistics feature helps me keep track of my listening habits. It's amazing to see how much I've learned from all those audiobooks! Adjusting the tone of the voice is genius. It's like having a customizable audiobook narrator.
xSTORMx
ListenBook's support for various formats ensures that no audiobook is out of reach. I love how ListenBook makes it easy to organize my audiobook library. The app supports all formats, and the import process is a breeze. The playback controls are responsive, and the sound quality is excellent. Highly recommend!
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