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.
Marshmallow Treat
ListenBook has revolutionized my audio experience, making it both personalized and engaging. ListenBook's compatibility with a wide array of audio formats makes it my ultimate audiobook companion. CUE playlist support helps me organize my audiobooks efficiently. It's a great organizational tool. What a fantastic listening experience! The narrator brought the characters to life with distinct voices and emotional depth. The pacing was perfect - not too fast to lose details, not too slow to become boring. I particularly appreciated how well the narrator conveyed the atmosphere of key scenes.
Devil Chick
ListenBook's support for various audio formats means I never have to worry about compatibility issues. ListenBook's compatibility with CarPlay and Apple Watch integration is a brilliant touch. Kudos to the developers for creating an app that caters to audiobook lovers like me. From sleek design to functional features, it's a true gem. ππ Audiobooks on demand? Yes, please! With this app's diverse format support and easy downloads, my reading routine has reached new heights. ππ ListenBook has made managing my audiobook collection a breeze. Library organization is top-notch.
New Magoo
The ListenBook app has transformed my device into a treasure trove of knowledge and entertainment. ListenBook's configurable auto-rewind after interruptions is a smart addition that keeps me on track. AirDrop and sharing make it easy to spread the audiobook love with friends. The app is so reliable. Iβve never had any issues with it.
Stud muffin
πΌ Making work hours enjoyable β audiobooks turn my tasks into learning opportunities and moments of joy. π»π Quick access to chapters and controls makes ListenBook a breeze to use. It's an intuitive experience. ListenBook has become my gateway to new worlds, allowing me to explore stories, ideas, and knowledge. 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!
Chew Chew
ListenBook's commitment to providing top-notch audio quality has taken my audiobook experience to a new level. ListenBook has made my audiobook journey effortless, turning every moment into an escape.
Mr. Thanksgiving
This app has made my workouts and chores so much more enjoyable. Listening statistics are a great motivator. Love this feature! I love the ability to import books from my computer. Itβs so easy.
Spooky Yellowjacket
I've started a book club with my friends, and this app has been our go-to source for titles. Seamless audiobook integration β this app's functionality is truly remarkable. The layout is not only beautiful but also intuitive. Controls are easy to access.
Fire Sass
I'm rediscovering my favorite classics in a whole new way β through audiobooks! The narrators' voices on this app are so soothing β it's my relaxation therapy. I'm hooked on this app's ability to turn any moment into a reading opportunity. Adjusting the narrator's voice tone is a fun way to personalize the listening experience. Supports all my playlists and bookmarks perfectly.
21st Street
Audiobook excellence made simple β this app's functionality is a true asset. The playback speed control is a game-changer. ListenBook lets me listen at my own pace.
Treasure Devil
ListenBook's sleek design and easy chapter access make navigation a breeze. Discovering new literary worlds has never been this easy. This app's compatibility with various formats ensures that my audiobook library is at my fingertips. ππ
Texas Butterfly
The bookmark feature is a lifesaver β no more losing my place in the story! Kudos for the thoughtfully curated collections β I'm discovering hidden gems! Frequent updates ensure there's always something new and exciting to listen to. I'm amazed at how this app has made reading a seamless part of my life. Perfect for repeat listening! The narrator's performance was so rich with detail that I'm sure I'll discover new layers on a second listen. Their interpretation felt authentic to the material while bringing fresh insights. The audio production was pristine from start to finish.
Moxie
π± Carrying stories wherever I go β this app's convenience allows me to indulge my love for reading on the move. πποΈ Automated metadata extraction is a time-saver. My library is so organized now.
Toe
User-friendly brilliance! This app's functionality enhances my audiobook experience. ListenBook's statistics feature is eye-opening. I had no idea how much time I spent immersed in audiobooks until I started using it.
Lady Fantastic
The narrators on this app are truly talented β they bring characters to life. ListenBook has made managing and enjoying audiobooks a seamless and delightful experience. As someone who struggles to focus on audiobooks, this kept my attention the whole way through. The narrator's clear diction and expressive delivery were perfect.
Greek Rifle
ListenBook has given me a renewed appreciation for audio content β it's my new favorite app. ListenBook has made my daily activities more interesting and meaningful β I'm hooked! Finally, an app that values usability β navigating and listening is a breeze! I love the chapter navigation feature. ListenBook makes it easy to find specific sections. The interface is sleek and modern. Itβs a joy to use.
Steel
I've become the go-to storyteller at bedtime with the help of this magical app. This app has turned my screen time into valuable learning opportunities. πΆββοΈπ§ Walking and listening has never been this smooth β this app's user-friendly interface makes it a breeze to enjoy my favorite stories. ποΈπ
Predator
Listening to audiobooks has turned mundane tasks into enjoyable experiences. Thanks to ListenBook's extensive statistics, I can track my audiobook consumption and celebrate my progress. ListenBook Pro's noise reduction feature is a blessing for clear listening in noisy environments. Adjusting the tone of the narrator's voice is a unique feature. I'm loving it! The auto-rewind feature is a thoughtful addition that enhances my listening journey. I appreciate it!
JesterZilla
ListenBook's integration with CarPlay and Apple Watch is a seamless addition to my daily routine. Listening statistics motivate me to read more. Excellent feature!
Murmur
Thanks to ListenBook, I can enjoy my audiobooks without the need for constant synchronization. The attention to detail is commendable. Artwork and metadata are sorted automatically. Supports all my playlists and bookmarks seamlessly. Very convenient.
M8deUp
I'd love to see more classic titles, but the current selection is already fantastic. ListenBook's dedication to delivering a high-quality playback experience sets it apart from other apps. I'm amazed by the variety of genres available β there's something for everyone. I can't thank this app enough for making my audiobook experience exceptional. Its intuitive interface and diverse compatibility are a true game-changer. π±π§ Adjusting the tone of the narrator's voice is a unique feature that adds a personal touch.
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