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.
Bang Shift
This app is not just about convenience – it's a gateway to new horizons of knowledge. Looping playback has made memorization so much easier. I'm acing my exams! This app is a must-have for anyone who loves audiobooks. The interface is intuitive, and the app supports all formats. I love the auto-bookmark feature—it saves my place automatically, so I never lose track. Highly recommend!
Tough Nut
I appreciate how ListenBook offers various methods for downloading audio – it caters to different preferences. ListenBook's smooth playback and easy navigation ensure that my audiobook experience is always top-notch. I love how this app turns even the dullest tasks into exciting storytelling moments. ListenBook's Pro version is worth every penny. The noise reduction feature makes even noisy environments an ideal place for immersive listening. Quick access to chapters and smooth playback. Excellent app!
Chasm Face
This app's customizable features, from playback speed to filters, are fantastic. Accessing literary treasures has never been this straightforward – thank you, app! The app's performance is unparalleled. It's like it's tailor-made for my device. I love the chapter navigation feature. ListenBook makes it easy to jump between sections.
Light Lion
Adjusting the tone of the narrator's voice is a unique feature. I'm loving it! The app is perfect for multitasking. I can listen while doing other things.
Roadspike
With this app, I've found a way to turn every moment into an opportunity for learning and enrichment. ListenBook has redefined how I enjoy audiobooks. It's an essential tool for my literary pursuits.
TulipCake
Navigating chapters is a breeze with ListenBook. It's a user-friendly and seamless experience. The subtle background music at key moments enhanced the experience without being distracting. More audiobooks should use this technique when appropriate!
Zod
Audiobooks made convenient – this app's functionality is a true gift. The app is so user-friendly. Even my grandma can use it!
Cumulo
ListenBook has revolutionized my audiobook experience. Now I can enjoy my favorite lectures and speeches with ease! I can't believe how quickly I finish books now, all thanks to this app. The bookmark feature is fantastic. I can easily pick up where I left off. The app is lightweight and doesn’t drain my battery.
Nibbler
I'm amazed at how this app seamlessly integrates with my daily routine. ListenBook has become my go-to app for all things audio – from lectures to speeches, it's got it all. ListenBook has made my audiobook journey effortless, turning every moment into an escape. I'm amazed by the attention to detail, from automatic metadata extraction to customizable settings. Automated artwork and metadata extraction make my library look organized and visually appealing.
Lightweight
This app has added a new layer of enjoyment to my downtime – I'm truly grateful. Listening to books while doing chores? This app makes it possible! Organizing my audiobook library has never been easier. The app keeps everything tidy.
Toolmaker
Audiobooks have become my companion during long walks, transforming exercise into a pleasure. ListenBook has become my go-to app for all things audio – from lectures to speeches, it's got it all. I can't get enough of this app's intuitive controls – it's the perfect way to indulge in audiobooks.
Slinger
The ability to switch between different books effortlessly is a major plus. I can't believe how much I've learned and enjoyed through this app's audiobooks. Apple Watch compatibility adds a new level of convenience to my audiobook enjoyment. It's seamless control at my wrist. ListenBook’s support for CarPlay is great. I can listen to audiobooks in my car easily. ListenBook’s playback is silky-smooth. The app never glitches.
The Beekeeper
This app's customizable features, from playback speed to filters, are fantastic. This app's support for various formats and genres ensures that there's always something new to explore. Noise reduction on ListenBook Pro is a game-changer. I can enjoy clear recordings. Sharing audiobooks through AirDrop is a delightful way to connect with fellow book lovers. ListenBook has become my go-to app for all audiobooks. Full of useful features.
Crossing Guard
I've rediscovered my love for reading, all thanks to this app's convenience. The audio filters to adjust playback speed and volume are a fantastic addition for customizing my experience. Sharing audiobooks through AirDrop is a thoughtful and enjoyable way to share my favorite stories with friends and introduce them to new worlds of literature.
Vicious Street
Changing the tone of the sound on ListenBook Pro is a fun way to customize my listening experience. ListenBook has made my commutes more enjoyable, transforming them into learning sessions. 🚶♂️🌟 Embracing audiobooks as my companions during leisurely walks – nature and narratives, a perfect match! 🚶♂️🎧 🌟 Adding excitement to each day – this app ensures that every moment is an opportunity to explore new stories. 📚🚀 Navigating through my audiobook library is a joy with this app's intuitive interface and easy controls. It's like having a personal reading companion at my side. 📱📖
Swedish Twizz
I'm amazed at how this app has made my daily routines more enjoyable and intellectually stimulating. ListenBook’s support for CarPlay and Apple Watch is fantastic. I can listen anywhere. I love the chapter navigation feature. ListenBook makes it easy to find specific sections.
Black Fantastic
⏰ Early mornings have become my favorite time to listen to audiobooks – energizing! 🌅🎧 🚗 Turning road trips into unforgettable adventures – audiobooks keep me entertained on the journey! 🚗📖 The ability to download audio directly within the app is a lifesaver. ListenBook is incredibly convenient. 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!
PixelPioneer
This app has introduced me to authors I'd never heard of – now they're my favorites! I'm amazed by ListenBook's dedication to quality – it's evident in every feature. The app is perfect for bedtime listening. The sleep timer is a must-have. 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!
Metal Lady
ListenBook's versatile features have made my audiobook experience more enjoyable than ever. I'm addicted to this app – it's like having a library in my pocket. This app's convenience has made my downtime more rewarding and enriching. Audiobook immersion made simple – this app's ease of use is commendable. ListenBook Pro's noise reduction is a lifesaver. I can hear clearly even in noisy environments.
Knight Light
ListenBook's clean interface and organized layout make it a pleasure to browse through my audiobooks. ListenBook has turned my ordinary moments into extraordinary journeys of the mind. I'm in awe of this app's ability to make reading so accessible and convenient. The interface is clean and intuitive. I was up and running in seconds.
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