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.
King Panther
ListenBook's support for playlists in CUE format is a thoughtful touch I appreciate. Library organization has never been this easy. My audiobook collection is finally tidy. 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.
Miss Nova
The selection of classics is a treasure trove for literature enthusiasts. This app's convenience has turned my daily chores into moments of intellectual discovery – a win-win! I'm amazed at how this app has made my daily activities more enjoyable and intellectually stimulating.
IceDog
The range of audio formats supported is incredible. No need to worry about file conversion. ListenBook's compatibility with CarPlay is a huge plus during long drives. The app's versatility in audio downloading is unmatched. It's a comprehensive solution for my audiobook needs. Looping playback of a single track helps me focus and absorb complex content.
Freeze Queen
ListenBook's drag and drop downloads from web browsers are a time-saving feature I can't live without. This app is my secret weapon for making the most of my free time. Looping playback of a single track helps me master difficult concepts. So helpful!
DriftDetector
I used to struggle to find time for books – now, I listen while doing chores! ListenBook's dedication to delivering a top-notch experience is evident in every detail. 🎉📚 Reigniting my passion for books – this app is my newfound reading obsession! 🔥🎧 Adjusting the tone of the narrator's voice is a unique touch – it's like having a personalized reading.
Coffee
ListenBook's user-friendly audio filters and controls have made my audiobook sessions more interactive and engaging. ListenBook has become my go-to app for exploring a diverse range of audiobooks. It offers a wide array of features that cater to different preferences and needs. I’ve been using ListenBook for months, and it’s been a fantastic experience. The app is lightweight, doesn’t drain my battery, and works perfectly in the background. The equalizer and voice boost features are amazing. Highly recommend!
Moon Radar
ListenBook has revolutionized how I consume content. It's like having a personal library in my pocket. The app is perfect for people who love to listen to books while exercising.
Engine Eye
ListenBook's support for CarPlay and Apple Watch integration has made multitasking with audio content a breeze. ⏰ Starting my mornings with inspiration – audiobooks make waking up a joyous literary experience! ☀️🎧
Tin Fox
Thanks to ListenBook's extensive statistics, I can track my audiobook consumption and celebrate my progress. ListenBook's focus on quality and user experience has made it my go-to app for audiobooks and educational content. No more interruptions – the auto-rewind feature is a genius solution for seamless listening.
Demo
ListenBook's compatibility with various audio formats ensures that I can enjoy a wide range of content hassle-free. With ListenBook Pro, I can customize the tone of the sound to match my preferences – it's a fantastic touch.
Doughboy, Esq
The ability to change playback speed and audio volume on ListenBook gives me full control over my listening experience. ListenBook's audiobook player is a true workhorse – chapters, controls, and filters are all seamlessly integrated. With support for various audio formats, ListenBook ensures I can enjoy my favorite audiobooks without worries. 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!
DeathDancer
This app has become my go-to for audiobooks, adding a layer of convenience and enjoyment to my days. 🏃♀️📖 Running with purpose – this app keeps my mind engaged as I conquer my fitness goals! 🏃♀️📚 💡 This app's convenience is a blessing – I can squeeze in reading time between managing household tasks! 📱👩🍳 Listening statistics are a great motivator. Love this feature!
Tan Stallion
📱 My pocket-sized library – this app makes reading accessible anytime, anywhere! 📚📱 ListenBook Pro's tone adjustment feature is a fun way to experiment with the audiobook experience.
Disco Thunder
📱 Turning my phone into a portal of endless stories – this app is pure magic! 📚✨ 🌌 Igniting my imagination while preparing dinner – this app adds flavor to every meal! 🍲📖 Audiobooks at my fingertips – this app's functionality is truly impressive. Quick access to chapters and controls makes ListenBook a breeze to use. It's an intuitive experience. Great for multitasking! I listened while cooking, driving, and even working out, and it kept me entertained the whole time. The narrator’s voice was pleasant, and the story flowed smoothly. Very enjoyable!
Waylay Dave
I'm addicted to this app's curated playlists and recommendations – they're spot on. This app's customizable features, from playback speed to filters, are fantastic. 🏃♂️📚 Combining fitness and fiction – this app keeps me motivated during workouts with its engaging stories! 🏃♂️📖 Adjusting the narrator's voice tone is a fun way to personalize the listening experience. Bookmarks are a lifesaver for audiobook lovers. They help me keep track of important moments.
CodeExia
The ability to switch between devices seamlessly is a game-changer for busy readers. Being able to adjust playback speed suits everyone's preferences – a thoughtful feature. The intuitive interface and seamless navigation make this app a joy to use. The interface is sleek and modern. It's a pleasure to navigate and use the app.
Scrapper
As a language enthusiast, this app has been a fantastic tool for learning new languages. ListenBook's integration of artwork and metadata adds a visually appealing touch to my library. Audiobook journey simplified – this app's functionality is a wonderful surprise. ListenBook is the ultimate audiobook player. 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!
Spoiler
Unparalleled support for CarPlay and Apple Watch means I can take my audiobooks anywhere, anytime. 📱 Audiobooks at my fingertips – this app's ease of use is a booklover's dream come true! 📚🔥
Bad Princess
It's like having a personal library that fits in my pocket – truly amazing! ListenBook's comprehensive support for a wide range of audio formats sets it apart from other audiobook apps. Say goodbye to boring commutes – this app's immersive audio experience and intuitive controls have transformed my daily journeys. 🌟📚 ListenBook's commitment to user experience shines through its thoughtful design and seamless functionality. CUE playlist support is a fantastic feature that allows me to curate themed listening sessions, creating a dynamic and engaging audiobook experience.
Trick Baron
Navigating audiobooks effortlessly – this app's functionality is commendable. Bookmarks are a lifesaver for study materials. I never lose my place again. ListenBook has redefined my workout routine. The controls are so user-friendly. ListenBook Pro takes things up a notch with unlimited audiobook length. It's a game-changer!
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