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.
Heartbreaker
Thanks to ListenBook's binaural audio processing, my extended listening sessions are fatigue-free. πΆββοΈπ Strolling through stories on a lazy afternoon β this app is my relaxation buddy! ποΈπ§ Binaural audio processing reduces fatigue during long listening sessions. A fantastic feature!
Oblivion
ListenBook's compatibility with CarPlay and Apple Watch integration ensures that I can enjoy my audiobooks wherever I am. This app is my audiobook haven. With a user-friendly interface and features like audio filters, I'm engrossed in stories like never before. ππ The versatility of this app is mind-boggling. It's like a one-stop solution for audiobooks. Binaural audio processing really helps reduce listening fatigue. Great feature! ListenBookβs interface is clean and intuitive. Itβs a joy to use.
Deano
The ListenBook app has transformed my device into a treasure trove of knowledge and entertainment. With this app, audiobook listening has become an integral part of my daily routines β it's a game-changer. ListenBook has made my daily commutes enjoyable. No more boredom! Automated metadata extraction is a time-saver. My library is so organized now. I love the bookmarking feature. ListenBook makes it easy to pick up where I left off.
Trash Pocky
I've been recommending this app to all my friends β it's a true game-changer. Efficient audiobook enjoyment β this app's functionality is a revelation.
Swedish Pixie
Book Groups on ListenBook make it easy to categorize and access my audiobooks. Drag and drop downloads are so convenient. No more messing around with complicated steps. Binaural audio processing reduces listening fatigue. Fantastic feature! I love the ability to import books from my computer. Itβs so easy.
RealmRanger
ListenBook's audio filters are a fantastic addition, enhancing the sound quality of my audio files. ListenBook's library organization and book groups have made managing my audiobooks a breeze. With this app, I've discovered a new way to make my workouts and downtime more engaging and insightful. 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 has become my workout companion. It keeps me engaged and entertained during exercise.
PixelPathfinder
ListenBook Pro offers an unbeatable deal β unlimited audiobook length and noise reduction. π Adding a touch of magic to mundane tasks β this app turns errands into epic quests! ππ Seamless integration of audiobooks β this app's ease of use is impressive. The app is so user-friendly. Even my grandma can use it!
Martini Flower
The diverse range of narrators adds a new layer of depth to each story. ListenBook has given me a renewed appreciation for audio content β it's my new favorite app. This app's customizable features, like playback speed and bookmarks, have transformed my experience. The auto-rewind feature after interruptions is a small thing that makes a big difference. ListenBookβs interface is clean and intuitive. Itβs a joy to use.
Queen Ginger
Sharing audiobooks with friends is a great way to connect over stories. The audio quality is superb. ListenBook enhances my audiobook experience.
Carrot Joker
ListenBook Pro's tone adjustment feature is an innovative touch that adds a layer of personalization. CUE playlist support is a fantastic addition. It helps me organize my audiobooks effortlessly.
ShadowDancer
The fact that ListenBook supports a wide range of formats without DRM protection is a huge win. Navigating audiobooks with ease β this app's design is user-centric. Talk about convenience! This app's ease of use and support for multiple audio formats ensure that I can enjoy my favorite stories without any hassle. π±π The book groups feature is a thoughtful addition. It helps me keep my series and related titles together.
Biscuit Meg
ListenBook Pro takes my experience to the next level. Unlimited audiobook length, noise reduction, and voice tone adjustment? Count me in! The appβs design is sleek and modern. ListenBook is my favorite audiobook player.
Chlorine
This app has turned even my mundane tasks into exciting learning opportunities. This app's ease of use has made my daily tasks so much more enjoyable. Audiobooks at my fingertips β this app's ease of use is a game-changer. Audiobook immersion simplified β this app's ease of use is a true asset. No need for file conversion is a game-changer. Love using ListenBook on my iPhone.
Tin Mutt
With ListenBook, I can now enjoy my favorite audiobooks and speeches with the utmost comfort and convenience. ListenBook's customizable audio filters are a game-changer for tailoring my audiobook playback. is a breeze. It's incredibly convenient for building my collection. Adjusting the tone of the voice is an innovative feature that allows for a personalized listening experience. Makes listening to audiobooks easy and enjoyable. Thank you, ListenBook!
Bad Bond
I can't imagine a day without this app β it has made my audiobook journey seamless and fulfilling. ListenBook Pro's tone adjustment feature is an innovative touch that adds a layer of personalization. I don't have strong feelings about this one either way. The narration was competent but forgettable. The story itself was more engaging than the performance.
Lime
The narrator's voice in some audiobooks is so soothing, it's like a spa for the ears. This audiobook was neither good nor bad - simply average. The narrator's delivery was professional but uninspired, and the recording quality was clean though not exceptional. It provided satisfactory entertainment without standing out from similar titles.
Hyper Kong
With ListenBook, I've found a versatile and enjoyable way to listen to audiobooks and expand my knowledge. ListenBook's support for playlists in CUE format is a thoughtful touch I appreciate. The app's performance is beyond impressive. It's like it's tailor-made for my device.
Santa's Little Helper
ListenBook has changed my audiobook game forever. No more format woes! Download options are abundant, from WiFi to iTunes. It's all about convenience with this app. The app is perfect for bedtime listening. The sleep timer is a must-have.
Energy
Audiobook excellence β this app's design enhances my reading experience. ListenBook's user-friendly interface and powerful features have rekindled my love for audiobooks. The audio filters and precise controls are fantastic! The user-friendly interface and precise controls make listening to audiobooks an absolute delight. The app is so easy to use. I was up and running in minutes.
Stone Boomstick
ListenBook's versatile player features are like having a personal audio assistant β it's that good! ListenBook Pro's sharing features allow me to spread the joy of audiobooks with my friends and family. Enhancing my daily routines β this app's design makes listening a joy. The range of audio formats supported is incredible. No need to worry about file conversion. CarPlay compatibility takes my driving experience to a whole new level. Audiobooks on the road have never been better.
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