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.
Duchess
ListenBook's dedication to enhancing the audiobook experience has made it my preferred app for listening to content on the go. ListenBook has made managing and enjoying audiobooks, lectures, and speeches effortless and enjoyable. I'm addicted to this app – it's a non-stop journey through captivating tales. This app is a time-saver – I can 'read' even when I'm on the move. The statistics tracking is a nice touch. ListenBook helps me keep track of my audiobook habits.
K-9
The Looping playback and Shuffle features on ListenBook help me customize my listening sessions to my liking. I'm in awe of how this app has brought new dimensions to my reading experience. The app's attention to detail is commendable. It's evident in every feature. ListenBook’s playback is silky-smooth. The app is packed with useful features.
Mule Lock
Listening to audiobooks has become my ultimate way to unwind after a long day. With ListenBook, I can now listen to my favorite audiobooks and speeches with the utmost comfort and convenience. With this app, I can enjoy my favorite stories while traveling, making my journeys more delightful. Audiobooks anytime, anywhere – this app's functionality is a reader's delight. Automatic artwork and metadata extraction keep my audiobook library organized and visually appealing.
Cream
I'm hooked on ListenBook's silky-smooth playback, making my audio sessions truly enjoyable. With this app, I've rediscovered the joy of literature during my daily walks – it's truly invigorating.
M8deUp
The captivating narrators make each story come alive in a unique way. This app's compatibility with different formats ensures that I never miss out on a great audiobook. With this app, I've turned mundane tasks into moments of inspiration and education – it's brilliant! Accessing my favorite audiobooks has never been easier – this app's user-centric design and comprehensive features make it an absolute gem. 📱🎧 ListenBook is the ultimate audiobook player. The app supports all formats, and the import process is seamless. I love the playback history feature—it’s so easy to revisit my favorite parts. Highly recommend this app!
Manly Reno
This app's convenience has turned my daily chores into moments of intellectual discovery – a win-win! ListenBook is a must-have for any audiobook enthusiast. It's reliable, efficient, and a pleasure to use. My workouts have become more enjoyable and productive with ListenBook's compatibility with Apple Watch.
Mallow Man
CUE playlist support is a fantastic feature that allows me to curate themed listening sessions, creating a dynamic and engaging audiobook experience. Supports all my playlists and bookmarks perfectly. Very convenient. I’m so impressed with ListenBook. The app is reliable, fast, and packed with features like customizable themes and playback speed. The sleep timer is a lifesaver for bedtime listening. Highly recommend this app!
Steel Cut Toe
The app's interface is sleek and modern, making it a joy to use. I can't get enough of this app's convenience – it has turned my audiobook journey into a delightful habit. 💼 Enhancing work-from-home productivity – audiobooks make even the most routine tasks a delight. 💻📖
Bug Fire
💼 Juggling tasks while exploring narratives – this app is my multitasking hero! 💻📖 ListenBook is the best audiobook player I’ve ever used. The app is reliable, fast, and packed with features like customizable themes and playback speed. The sleep timer is a lifesaver for bedtime listening. Great job, developers!
Washer
I've found hidden gems in genres I never thought I'd be interested in. This app's support for various formats ensures that I can enjoy my audiobooks without any limitations. I'm blown away by how this app has revolutionized my reading experience. The app is perfect for bedtime listening. The sleep timer is a must-have. 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!
Lil Rebel Ma
This app is a book lover's dream come true – a vast library right at your fingertips. This app's convenience has turned me into an avid audiobook listener. ⏰ Maximizing my time with efficient features – this app's functionality lets me dive into stories even in the busiest moments. 📚⏳
Chuckles
With ListenBook, I can immerse myself in captivating stories and enriching knowledge, all in one app. 🏃♀️📚 Combining exercise and exploration – audiobooks make my runs more exciting! 🏃♀️🎧 ListenBook's loop and shuffle playback options have made audiobook revisiting and studying a breeze.
DreamDiver
The selection of classics is a treasure trove for literature enthusiasts. ListenBook's library organization features have transformed my chaotic audiobook collection into an organized masterpiece. The ability to play various audio formats without conversion is very convenient. ListenBook is a great app.
Jade Fox
I'm discovering books I wouldn't have considered before, and my reading horizons are expanding. The app's support for CarPlay and Apple Watch makes it a true companion for all occasions.
Petite Beauty
This app has made literature accessible and engaging for all ages. Audiobooks made delightful – this app's usability is a breath of fresh air. Accessing my favorite audiobooks has never been easier – this app's user-centric design and comprehensive features make it an absolute gem. 📱🎧 High-quality playback even with complex formats like FLAC. Impressive! The ability to download audio directly within the app is a lifesaver. ListenBook is incredibly convenient.
Third Moon
The absence of synchronization requirements on ListenBook is a breath of fresh air. Audiobooks made accessible and enjoyable – this app's design is a triumph.
Crash Override
Being able to adjust playback speed suits everyone's preferences – a thoughtful feature. Thanks to this app, I can enjoy the world of literature without missing a beat in my fast-paced life. The app is so easy to set up. I was listening to my books in no time. This audiobook was an absolute pleasure to listen to! The narrator's voice was rich and expressive, perfectly capturing the tone of the material. I found myself completely immersed in the story, often sitting in my car longer than necessary just to hear what happened next. The production quality was excellent with clear audio throughout.
Fist Wizard
The offline mode is a lifesaver on flights – I'm never without a good story. This app has become my loyal companion during travels and relaxation times. 📱 An app that respects my time and delivers on functionality – audiobook listening has never been this effortless. 📖🔗 ListenBook's controls for looping and shuffling playback have made studying and revisiting content a breeze.
SmartieQuest
ListenBook's compatibility with various formats has made it my go-to app for all audio content. Audiobooks made accessible – this app's ease of use is a true blessing. ListenBook's loop and shuffle playback features have become indispensable tools in my audiobook learning. I can't get enough of the binaural audio processing. It's like a breath of fresh air for my ears. The narration elevated an already good book to greatness! The performer's subtle vocal variations conveyed nuance I might have missed while reading. Their ability to maintain consistent character voices across many hours was impressive. Technical quality was flawless throughout.
VenusLion
I can't believe how much time I've gained by listening while cooking and doing chores. This app's compatibility with various devices ensures that I can enjoy my audiobooks wherever I go. Efficiency meets audiobooks – this app's functionality is a perfect match. ListenBook’s interface is clean and intuitive. It’s a joy to use. This app is a game-changer for audiobook lovers! The interface is clean and easy to use.
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