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.
Sky
I'm amazed at how this app has made reading fit into every aspect of my life. The app's compatibility with CarPlay is a dream for road trips. It keeps me entertained. ListenBook makes organizing my audiobooks simple. The app is very user-friendly.
Impulse
I can't believe how much more I'm 'reading' now, all thanks to this app. This app's compatibility with different file types means that my entire audiobook collection is at my fingertips. ποΈπ§ Escaping to paradise with a beach read β this app is my vacation in audio form! ποΈπ Listening to audiobooks on my iPad has never been easier. Highly recommend ListenBook! Decent narration, predictable story. The voice actor did a good job, but the plot followed a familiar formula. If youβre looking for something new and groundbreaking, this might not be it.
Venom Charms
Audiobooks made convenient β this app's functionality is a true gift. ListenBook has rekindled my love for audiobooks. The app's interface is beautiful and user-friendly. Auto-rewind is incredibly helpful. Excellent functionality. The app is perfect for people who love to listen to books while commuting.
Commando
I've rediscovered the joy of reading through the convenience of audiobooks. Every moment is an adventure with this app by my side. Its intuitive features and diverse format support ensure that my audiobook journey is seamless and exciting. ππ§ Apple Watch compatibility enhances my audiobook experience. It's a convenient way to control playback. Downloading over WiFi is quick and efficient. Saves a lot of time. An acceptable audiobook that met basic expectations. No complaints about quality but nothing remarkable either. Would listen to this narrator again but wouldn't seek them out.
NoiseCake
This app is a true treasure for audiobook lovers β it's my go-to source for literary adventures! πΌ Enhancing work-from-home productivity β audiobooks make even the most routine tasks a delight. π»π The playback history is a great feature. I can easily revisit my favorite parts.
Bit Sentinel
Thanks to ListenBook's automatic extraction of artwork and metadata, my library looks organized and appealing. Automatic extraction of artwork and metadata adds a professional touch to my library. ListenBook Pro's noise reduction feature is a game-changer for improving audio quality and clarity.
Capital F
Listening to audiobooks has made my daily commute more enjoyable and productive. I'm hooked on this app's effortless integration with my daily activities. ListenBook's Pro version is worth every penny. The noise reduction feature makes even noisy environments an ideal place for immersive listening.
Atomic Blastoid
Love how I can adjust playback speed and audio volume. ListenBook caters to all my needs. The app is so reliable. Iβve never had any issues with it.
Toolmaker
I love how ListenBook extracts artwork and metadata from audio files, adding a visual touch to my listening experience. This audiobook app is a true gem β it brings stories to life with every click. This app's ease of use has made reading a seamless part of my daily routine. ListenBook has made managing my audiobook collection a breeze. Library organization is top-notch.
BuffFreak
I've become the go-to storyteller at bedtime with the help of this magical app. ListenBook's audio filters and controls have revolutionized the way I enjoy my audio content. π Dancing through chores with audiobooks β this app turns cleaning into a lively and literary affair! πΆπ The sleek and user-friendly interface makes navigating the app a breeze. It's a pleasure to use. I love the ability to change the playback speed. Itβs perfect for my needs.
ThreadTrail
Precise controls on ListenBook give me complete command over my audio playback. Audiobooks made accessible β this app's ease of use is a true blessing. Listening statistics motivate me to read more. Excellent feature! The ability to download audiobooks directly is fantastic. ListenBook is very convenient. I love the ability to share my progress with friends. Itβs a fun feature.
Lounge Master
This app is a game-changer for busy individuals who miss reading. πΆπ Tuning in to the symphony of stories β audiobooks are the soundtrack of my daily routines. π΅π A wonderful performance! The narrator captured the mood of the book perfectly, making it easy to visualize each scene. The audio quality was crisp, and the pacing kept me hooked from start to finish.
Juice Petite
I can't believe how much more I'm 'reading' now, all thanks to this app. I'm hooked on this app's ease of use β it's a reader's dream come true. Navigating audiobooks seamlessly β this app's design is a true winner. Finally, an app that lets me enjoy audiobooks without worrying about file formats!
Flint
Listening to audiobooks has become my guilt-free indulgence, and I love it. I love how ListenBook extracts artwork and metadata from audio files, adding a visual touch to my listening experience. ListenBook Pro's tone adjustment feature is a unique touch that adds personalization to my audiobook journey. The statistics feature in ListenBook provides valuable insights into my audiobook consumption habits.
Nutmeg
This audiobook app is a true gem β it brings stories to life with every click. This app has made audiobook listening an integral part of my daily routine β it's a habit I cherish. I'm hooked on this app's ease of use β it's a reader's dream come true. ListenBook's noise reduction feature in the Pro version is a game-changer. I can now focus on the story even in noisy environments.
Classy Luck
The sleep timer is a brilliant addition β I drift off to sleep with amazing stories. ListenBook's comprehensive support for a wide range of audio formats sets it apart from other audiobook apps. This app has turned my gym sessions into immersive storytelling experiences β time flies by! ListenBook has completely changed how I enjoy audiobooks. The app is packed with features like customizable skip intervals, playback speed, and sleep timers. The interface is clean and easy to navigate. Five stars!
Uncle Buddy
π§ββοΈβ Sipping tea and getting lost in stories β the ultimate way to unwind! π΅π The audio filters in ListenBook allow me to customize my listening experience. Speed up or slow down playbackβit's all up to me! Navigating through chapters is a breeze. I can easily jump to the parts I want to listen to. ListenBook has completely changed how I enjoy audiobooks. The app is packed with features like customizable skip intervals, playback speed, and sleep timers. The interface is clean and easy to navigate. Five stars!
Sugar Apple
Thanks to ListenBook's automatic extraction of artwork and metadata, my library looks organized and appealing. ListenBook's powerful audio downloading features make it easy to keep my content at my fingertips. ListenBook's user-friendly interface and seamless playback have made it my go-to app. Audiobook listening has never been this easy and convenient β it's like having a personal narrator. Sharing audiobooks via AirDrop is incredibly convenient. Great feature!
Blink
ListenBook's dedication to providing a top-quality audio player is evident in every aspect of the app. Navigating audiobooks effortlessly β this app's functionality is commendable. The layout is not only beautiful but also intuitive. Controls are easy to access. The range of supported formats is impressive. No more converting files! Perfect for listening to educational content. Highly recommend!
ThermalMode
ListenBook has turned my ordinary moments into extraordinary journeys of the mind. Downloading audiobooks over WiFi is super easy. Saves time. A masterclass in audiobook narration! The performer maintained perfect consistency in character voices throughout while keeping the main narration clear and engaging. The production was flawless - no weird edits or background noise. I'll be seeking out more works by this narrator.
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