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.
Curio
I've fallen in love with literature all over again, thanks to this incredible app. Bookmarking on ListenBook makes it easy to pick up where I left off β no more searching for my spot! I'm so grateful for this app β it's like having a personal storyteller wherever I go. With this app, I've discovered a new way to make my daily routines more enriching and rewarding. Effortless and enriching β that's how I'd describe my experience with this app. Its smooth interface and thoughtful features redefine audiobook joy. π±π
Energy
I'm thrilled to finally have a way to enjoy books while keeping up with my busy schedule. This app has become my loyal companion during travels and relaxation times.
Dr. Cocktail
The app's design is sleek and modern β it's a pleasure to navigate. The ability to highlight passages and take notes while listening is a fantastic feature. ListenBook's variety of ways to download audio makes it incredibly convenient. Every moment is a chance to dive into a new adventure with this app. Its smart controls and comprehensive format support ensure that my audiobook journey is a seamless one. ππ§ Effortless and enriching β that's how I'd describe my experience with this app. Its smooth interface and thoughtful features have set the bar high for audiobook enjoyment. π±π
Snout Pixie
ππ On-the-go listening has never been smoother β this app's functionality keeps me engaged during long commutes. ππ ListenBook Pro's noise reduction feature elevates my listening experience, allowing me to focus on the content. Looping playback helps me focus on challenging content and grasp complex concepts. A study must-have! 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.
Icy Avenger
ListenBook's compatibility with multiple downloading methods ensures there's always a way to get my content. I'm blown away by the quality of narration on this app β it's like being in the story. Book groups help me keep series together and navigate my collection more efficiently. A great feature!
McDreamy
I can't believe how quickly I finish books now, all thanks to this app. Absolutely in love with this audiobook app! The seamless functionality and easy navigation make my reading time pure bliss. ππ§
Terror Master
I'm exploring new genres and authors I wouldn't have considered otherwise. π± Accessing my favorite stories has never been this straightforward β this app's functionality is a bookworm's dream come true. ππ« Excellent support for various audio formats. Very satisfied. The app is perfect for bedtime listening. The sleep timer is a must-have.
Mad Jack
βοΈ Loving the fact that I can learn and listen at the same time β multitasking made easy! π§ π§ π₯ Streamlined functionality that's music to my ears β audiobook enjoyment has reached a new level of convenience. π΅π Downloading over WiFi is super efficient. Saves a lot of time. I love the auto-rewind feature. ListenBook always picks up right where I left off.
RiddleRover
ListenBook's dedication to excellence shines through in its performance and features. Revolutionizing the way I enjoy stories β this app's seamless playback and intuitive controls make it a must-have for every book enthusiast. π±π§
CuriousCraft
I'm constantly amazed by the vast selection β there's always something new to discover. The app's interface is sleek and modern, making it a joy to use. I'm addicted to this app's seamless performance and impressive library. This app's seamless integration with my devices has made audiobook listening a hassle-free experience. The speed adjustment feature is my secret weapon for studying complex materials.
Wonder Lady
I love that I can switch between fiction and non-fiction effortlessly. I love the bookmarking feature. ListenBook makes it easy to pick up where I left off.
Whistler
ListenBook is like a personal audiobook curator, allowing me to enjoy my favorite speeches and lectures with unmatched comfort and convenience. No more limits on the genres I can explore! This app's versatility in downloading and organizing audiobooks ensures I always have a captivating tale at my fingertips. ππ± Tone adjustment is such an innovative feature. It adds a personal touch to narration. With features like auto-rewind, I never lose my place when I pause listening.
Sherm
With ListenBook, I can immerse myself in captivating stories and enriching knowledge, all in one convenient app. Finally, an app that lets me enjoy my personal audiobooks, lectures, and speeches effortlessly. ListenBook has elevated my learning experience. I'm retaining more information than ever. AirDrop sharing is a very convenient feature. Thanks, ListenBook! ListenBookβs interface is clean and intuitive. Itβs a joy to use.
High Beam
I've started a book club with my friends, and this app has been our go-to source for titles. This app has turned my daily routine into a source of excitement and joy. ListenBook's support for various audio formats makes it a versatile app for all kinds of audiobook enthusiasts.
Tall Sally
I'm amazed at how this app's features cater to audiobook enthusiasts' every need. I'm amazed at how this app has made reading such a natural part of my day. ListenBook is a must-have for audiobook lovers. The auto-rewind feature ensures I never miss a word. I'm amazed by the app's versatility in downloading audio. It accommodates various sources seamlessly. Organizing my audiobook library has never been easier. The app keeps everything tidy.
Amphibi-Dangerous
I can't get enough of this app β it's a true game-changer for book lovers. The intuitive chapter navigation and quick access to controls make my audiobook experience seamless. The appβs design is sleek and modern. ListenBook is my favorite audiobook player.
Backstreet
This app has rekindled my passion for storytelling in the most convenient way. I love how this app seamlessly integrates into my busy schedule, making multitasking a breeze. I'm blown away by how this app has made my workouts more enjoyable and my mind more active. π Long road trips? No problem β this app keeps me entertained mile after mile! ππ
Pitfall Whiskers
Listening to audiobooks while cooking has made meal prep much more enjoyable. Revolutionizing the way I enjoy stories β this app's seamless playback and intuitive controls make it a must-have for every book enthusiast. π±π§
Soiled Dove
I appreciate how ListenBook offers various methods for downloading audio β it caters to different preferences. With this app, reading is no longer a luxury β it's a convenient habit. πΆββοΈπ§ Walking has never been this productive β exploring new worlds while I exercise! ποΈπ« Tone adjustment is such a unique feature. It's like customizing the narrator's voice.
Demo Zero
With ListenBook, I can enjoy my own audio content with unparalleled ease and comfort. Looping playback has revolutionized my language learning journey. I'm making rapid progress.
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