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.
Natural Gold
With ListenBook, I can enjoy my audiobooks with enhanced sound quality and personalized settings. Thanks to ListenBook, I'm now exploring different genres and formats I never thought I would. ListenBook Pro's noise reduction feature is a fantastic addition that enhances my audio experience. ListenBook's loop and shuffle playback features have become indispensable tools in my audiobook learning.
Ice
ListenBook has elevated my audiobook enjoyment to a whole new level β it's a must-have for any audio enthusiast. π‘ Seamlessly weaving audiobooks into my daily routine β this app's functionality has redefined how I enjoy books. π±π Adjusting the narrator's voice tone is a fantastic feature. It adds a personal touch. This audiobook was a fantastic listen! The narrator's voice was clear and engaging, making it easy to follow along. The pacing was just rightβnot too fast, not too slow. Perfect for long commutes or relaxing at home. Highly recommend!
CommandX
I'm no longer missing out on great stories β this app fits perfectly into my lifestyle. ListenBook has rekindled my love for learning, one audio experience at a time. ποΈπ§ Soaking up the sun while indulging in beach reads β this app is my ultimate relaxation companion. ποΈπ With ListenBook, I can finally enjoy my audiobooks without worrying about format compatibility. It handles everything! The app is so well-designed. Itβs clear the developers put a lot of thought into it.
Sun Runner
I'm impressed by how much more I'm learning through audiobooks compared to traditional reading. ListenBook's support for chapters and bookmarks ensures that I never lose my place in a story. I can't imagine my daily activities without this app β it's the perfect way to stay engaged and informed. Adjusting the tone of the narrator's voice is a unique feature that adds a personal touch.
Zod
ListenBook's user-friendly design and compatibility with different formats have made it my go-to app. Downloading audio from network devices is a brilliant feature. It's incredibly convenient. 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! This was a competent audiobook production with no major flaws. The narrator's voice was pleasant enough and the audio quality was acceptable, though not exceptional. While the performance didn't particularly stand out, it served its purpose adequately for my daily commute.
Gumby Train
π§ Fueling my audiobook addiction with this fantastic app β pure listening pleasure! ππ₯ ListenBook Pro's noise reduction feature has significantly improved the audio quality of my recordings.
Omega Sub
ListenBook's support for CarPlay and Apple Watch is a game-changer for my on-the-go listening. πββοΈπ Running with purpose β this app keeps my mind engaged as I conquer my fitness goals! πββοΈπ πΆ Forget background music, I've got enchanting stories to accompany my chores! π΅π Playback speed and volume controls are top-notch. Highly recommend. 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.
Crumb Cake
Seamless integration with all my devices and flawless synchronization β top-notch. ListenBook's library organization and book groups have made managing my audiobooks a breeze.
Sloth
πΆββοΈπ Strolling through captivating narratives has never been easier β this app's intuitive controls make audiobook listening a delight. π§ποΈ Sharing audiobooks with friends through AirDrop is a fun and interactive way to bond over stories.
Uncle Psycho
I'm hooked on this app's sleek design and seamless performance β it's a must-have for any reader. ListenBook Pro's unlimited audiobook length is a boon for those who enjoy deep dives into lengthy narratives. The app is very user-friendly. ListenBook makes listening to audiobooks a breeze. I love the ability to share my progress with friends. Itβs a fun feature.
Ozzie Treat
ListenBook Pro is worth every penny. Unlimited audiobook length? Count me in! The interface is beautiful and functional. ListenBook is my go-to app for audiobooks.
Dorothy Solitaire
I can't thank this app enough for making my audiobook experience exceptional. Its intuitive interface and diverse compatibility are a true game-changer. π±π§ The interface is sleek and intuitive, making my audiobook experience a joy. Adjustable playback speed and volume controls are excellent.
Breezy Mustang
The ListenBook app is a must-have for anyone who loves to learn and be entertained through audiobooks. ListenBook has given me the gift of time β turning daily tasks into moments of inspiration. The statistics feature in ListenBook adds an element of self-awareness to my audiobook consumption. ListenBook Pro has taken my audiobook experience to the next level. No regrets! The bookmark feature is fantastic. I can easily pick up where I left off.
Street Jolly
I can't stop raving about this app β it's like having a personal library in my pocket. Seamless audiobook integration β this app's functionality is a technological marvel. Quick access to chapters is a blessing. No more scrolling through endless content. 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!
The Shield Toronto
I've been able to explore different cultures and perspectives through a diverse range of books. Listening to audiobooks with my kids has become a cherished bonding activity.
RealmRanger
Audiobooks on this app have become my go-to entertainment for winding down. The app is so easy to set up. I was listening to my books in no time.
Judge
πΆπ Enriching my environment with the power of storytelling β audiobooks infuse my home with literary magic. π§π Book groups are a thoughtful addition. I can group related titles for easy access. Adjusting the tone of the voice is an innovative feature that allows for a personalized listening experience. The app is very easy to use. ListenBook makes managing my audiobook library simple.
Crossing Guard
ListenBook's customizable audio filters allow me to personalize my listening experience β a fantastic feature. ListenBook's support for CarPlay and Apple Watch is a game-changer for my on-the-go listening. This was a competent audiobook production with no major flaws. The narrator's voice was pleasant enough and the audio quality was acceptable, though not exceptional. While the performance didn't particularly stand out, it served its purpose adequately for my daily commute.
Cujo
The sleek design and easy navigation are visually pleasing and user-friendly. β° Early mornings have become my favorite time to listen to audiobooks β energizing! π π§ I've never experienced such a smooth audiobook player. The playback is seamless. I'm impressed with the wide range of supported formats. Finally, an app that plays all my audiobooks flawlessly.
RedFeet
I've never been so entertained while doing household chores β this app is a lifesaver! Audiobooks on this app have made me look forward to my long commutes. Finally, an app that understands the power of CUE playlists. Perfect for organizing.
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