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.
Mother Hen
ListenBook has reignited my love for storytelling and learning, one audio file at a time. 🌟 Embracing reading in the busiest of times – this app is my everyday escape! 📚🏃♀️ Playback speed and volume controls are top-notch. Highly recommend. ListenBook is the best audiobook player I’ve ever used. 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!
King Panther
🧘♂️ Finding zen through storytelling – this app makes meditation even more calming. 🧘♂️🎧 Sharing audiobooks with friends through AirDrop is a fantastic way to introduce them to captivating stories.
Tweety
ListenBook's configurable auto-rewind after interruptions is a smart addition that keeps me on track. ListenBook's versatile features have made my audiobook experience more enjoyable than ever. Automated artwork and metadata retrieval add a professional touch to my carefully curated audiobook collection. The statistics tracking is a nice touch. ListenBook helps me keep track of my audiobook habits.
Marine Dre
This app's simplicity has made me fall in love with books all over again. Looping playback has revolutionized my language learning journey. I'm making rapid progress.
Mr. Lucky
ListenBook has taken my listening pleasure to new heights – it's a true audio marvel. With this app, I can devour books like never before – it's incredibly efficient. The app is perfect for people who love to listen to books at night.
General Finish
The minimalist interface and intuitive settings make for an amazing user experience. I can't imagine my life without this app – it's my daily dose of literary magic. Who knew that commuting could become such an enjoyable reading session? ListenBook's commitment to user experience shines through its thoughtful design and seamless functionality. Downloading books over WiFi is quick and hassle-free. Very convenient.
Sapiens
I'm addicted to this app's seamless performance and impressive library. I'm hooked on this app's curated content – it's like having a personal librarian. This app has turned even the most ordinary moments into reading sessions. The auto-rewind feature after interruptions is a small thing that makes a big difference.
9Lives
I'm constantly amazed by the variety of genres – there's something for everyone. ListenBook's support for various formats means I can explore a wide range of content without limitations. ListenBook's dedication to excellence shines through in its performance and features. Streamlined audiobook integration – this app's usability is impressive. Say goodbye to boring commutes – this app's immersive audio experience and intuitive controls have transformed my daily journeys. 🌟📚
Gro
I'm able to enjoy books in a whole new way – while cooking, working out, or even gardening. Audiobooks made delightful – this app's usability is a breath of fresh air. I love the auto-rewind feature after interruptions. No more searching for where I left off! With its powerful audio downloading features, I can have my favorite audiobooks ready to go, anytime and anywhere. The app is perfect for people who love to listen to books while commuting.
Dr. Cocktail
My kids are hooked on the children's audiobook collection – it's a parenting win! ListenBook's dedication to excellence is evident in its well-designed interface, smooth playback, and powerful features. With this app, I've found a way to turn every moment into an opportunity for learning and enrichment. AirDrop sharing is a very convenient feature. Thanks, ListenBook!
Fresh Peper
ListenBook Pro's noise reduction feature is a blessing for enjoying clear audio in any environment. I can't get enough of this app's easy navigation and quick access to chapters and playback controls. This app has made my daily walks a time for both exercise and learning. The book groups feature is a thoughtful addition. It helps me keep my series and related titles together.
Toolmaker
Say goodbye to monotony – this app's diverse format support and intuitive controls have turned my daily activities into thrilling audiobook adventures. 📱🔊 ListenBook's integration with CarPlay and Apple Watch adds a new level of convenience to my audiobook journey. I’m so impressed with ListenBook. The app is reliable, fast, and packed with features like customizable themes and playback speed. The sleep timer is a lifesaver for bedtime listening. Highly recommend this app!
Divine Quasar
With this app, I can devour books like never before – it's incredibly efficient. 🧘♀️☕ Sipping tea and getting lost in stories – the ultimate way to unwind! 🍵📖 Sharing audiobooks through AirDrop is a fun and convenient way to share the magic of storytelling with friends and family, sparking meaningful discussions. Automated artwork and metadata extraction add a professional touch to my audiobook collection.
Tweety Bun Bun
ListenBook's user-friendly interface and precise controls make it a joy to use every day. The intuitive interface and seamless navigation make this app a joy to use. Audiobooks on this app have made my workouts more enjoyable and productive. Finally, an app that lets me organize my audiobooks effortlessly. The library organization and book groups feature make navigation a breeze.
Rook
The ability to download audiobooks directly is fantastic. ListenBook is very convenient. The app is perfect for people who love to listen to books while commuting.
Tse Tse Guy
I can't get enough of this app – it's like having a personal storyteller in my pocket. Flawless support for various audio formats. Highly satisfied. The app is perfect for people who love to listen to books while commuting.
Father Abbot
This app's convenience has turned my exercise sessions into enlightening moments. Tone adjustment is such an innovative feature. It adds a personal touch to narration. Looping playback is an invaluable study tool. It helps me absorb complex information effortlessly. I'm blown away by the app's performance. It's fast, reliable, and tailored for audiobook lovers. Sharing audiobooks through AirDrop is a wonderful way to share the joy of storytelling with friends, sparking engaging conversations and connections that transcend boundaries.
Rink Ruler
This app's features, from bookmarking to customizable playback speed, are fantastic. This app has brought the magic of books back into my life.
Twinkle
ListenBook's drag-and-drop download feature simplifies the process of adding new audiobooks to my collection. ListenBook Pro's noise reduction feature enhances my immersion in every audiobook, regardless of surroundings. Noise reduction and tone changing enhance the listening experience. Love it!
Bad Princess
The quality of the audio is top-notch, making the experience truly immersive. ListenBook's support for a wide range of formats means I can listen to all my favorite content without worries. 📱 It's like having a personal audiobook library at my fingertips! This app's functionality is a dream come true for book lovers. 📚🔥 From novels to speeches, this app's versatility in playing various audio formats has turned my daily activities into enriching listening sessions. What a game-changer! 🌟📚 ListenBook is the best audiobook player I’ve ever used. The app is reliable, fast, and packed with features like customizable themes and playback speed. The sleep timer is a lifesaver for bedtime listening. Great job, developers!
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