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.
Pitfall Whiskers
I can't believe how easy it is to download audio from various sources. So convenient! ListenBook is fantastic! Supports every audiobook format I have. Super convenient!
Yellow Menace
The narrators have a way of bringing characters to life β it's a unique experience. Sharing audiobooks with friends through AirDrop and Sharing on ListenBook is a fantastic way to spread the joy of listening. ListenBook's dedication to providing a smooth and enjoyable listening experience is evident in every aspect of the app. ππ Embarking on literary journeys even with my eyes closed β bedtime stories have taken a new form with this app! π΄π§ No need for file conversion is a game-changer. Love using ListenBook on my iPhone.
Manly
I can't get enough of this app's intuitive design β it's like a personal library right at my fingertips. π₯ Simplifying my reading routine β the app's functionality ensures I'm always one click away from literary adventures. ππ Audiobook multitasking made easy β this app's functionality is top-notch.
Virgo Moon
With ListenBook, my audio content is organized, accessible, and ready to inspire me. ListenBook's drag-and-drop download feature from web browsers is incredibly convenient. Downloading audiobooks has never been this easy. The range of supported formats is impressive. No more converting files! The app's compatibility with CarPlay is a fantastic bonus. It keeps me entertained during long drives.
Swing Setter
I've become the go-to storyteller at bedtime with the help of this magical app. With this app, reading is no longer a luxury β it's an essential part of my day. πΆββοΈπ Walking my way through exciting narratives β this app makes exercise more fun! ποΈπ§ Bookmarking my favorite parts of audiobooks is now a breeze. Love this feature! Sharing audiobooks with friends is a thoughtful gesture that ListenBook makes seamless.
Glyph
I can't get enough of this app's user-friendly interface β it's a true delight. Sharing audiobooks with friends is a blast. AirDrop makes it seamless. The app's performance is exceptional, ensuring a smooth and uninterrupted audiobook experience. It's clear that it's designed with audiobook enthusiasts in mind. No more hassle with file conversion. This app handles all formats effortlessly.
Twine X
π‘ Making house chores more enjoyable β audiobooks help me stay engaged while tidying up the living space. π π Audiobooks at my fingertips β this app's functionality is truly impressive.
Wanted Candy
The offline mode is a lifesaver on flights β I'm never without a good story. This app is a must-have for any book lover on the go β it's my daily companion. I'm hooked on this app's effortless downloading process β I can have my favorite audiobooks in seconds. ππ This app has rekindled my love for books β I can't stop listening! ππ§ Automatic metadata retrieval adds a professional touch to my audiobook collection.
Wild Kitten
This app has rekindled my passion for literature in a whole new way. Audiobooks have become my companions during long hours of household chores. ListenBook has transformed my listening habits, making them more engaging and enjoyable. I can't imagine a day without this app β it has made my audiobook journey seamless and fulfilling.
Prometheus
ListenBook has become my workout buddy. It keeps me entertained and motivated during exercise. The playback speed control is a game-changer. ListenBook lets me listen at my own pace.
Sky Trinity
I'm finally making progress on my reading goals, thanks to this app's convenience. ListenBook's library organization and book groups have made managing my audiobooks a breeze. With this app, my daily routines have become moments of intellectual growth and personal enjoyment. Audiobooks at my fingertips β this app's functionality is a game-changer. ListenBook Pro's noise reduction feature is a revelation. It eliminates distractions and enhances the clarity of recordings, resulting in a more immersive experience.
Evil Smith
With this app, I can switch seamlessly between my iPhone and iPad, making my reading experience continuous. π§ββοΈβ Sipping tea and getting lost in stories β the ultimate way to unwind! π΅π πͺ Doubling the impact of my workouts β exercising and exploring stories, all thanks to this app! πͺπ§ Makes listening to audiobooks so easy and enjoyable. Thank you, ListenBook!
MuseMaster
Audiobook enthusiasts, gather round! This app's remarkable features, including audio filters and compatibility, have transformed my commutes into captivating journeys. ππ§ Apple Watch compatibility enhances my audiobook experience. It's a convenient way to control playback.
The Flying Mouse
This app has brought the magic of books back into my life. With this app, I can devour books like never before β it's incredibly efficient. Audiobook multitasking made simple β this app's functionality is a true delight. I can't get enough of the binaural audio processing. It's like a breath of fresh air for my ears.
Duchess
ListenBook's compatibility with CarPlay and Apple Watch integration ensures that I can enjoy my audiobooks wherever I am. With ListenBook, I can explore new genres, learn new topics, and enjoy classic literature with ease. I'm impressed by ListenBook's ability to extract artwork and metadata automatically. π§ββοΈ Finding zen through storytelling β this app makes meditation even more calming. π§ββοΈπ§
Sokol
User-centric audiobook joy β this app's ease of use is impressive. ListenBook's commitment to a seamless user experience is evident in its sleek design and intuitive controls.
Toy Dogwatch
Audiobooks have brought a new level of enjoyment to my daily workout routine. This app's compatibility with various formats ensures that I can enjoy my audiobooks hassle-free. ListenBook's compatibility with CarPlay and Apple Watch enhances my audiobook experience during daily activities. ListenBook's loop and shuffle playback features add versatility to my audiobook listening experience. ListenBook has changed the way I listen to audiobooks. The app is so easy to use.
MrOnsTr
π This app is a game-changer β its intuitive design and seamless functionality make listening to audiobooks a joy. ππ§ Audiobook pleasure simplified β this app's functionality is a reader's delight. ListenBook is a must-have for audiobook enthusiasts. It's reliable, versatile, and a pleasure to use. Quick access to chapters and controls ensures a seamless listening experience with ListenBook. It's effortless to use. Adjustable playback speed is my secret weapon for covering more material in less time. A productivity boost!
Lady Killer
I'm amazed at how this app has seamlessly integrated reading into my daily rhythm. Looping playback has revolutionized my study sessions. I'm learning faster than ever.
ByteBard
It's like having a personal library that fits in my pocket β truly amazing! Thanks to ListenBook's binaural audio processing, my extended listening sessions are fatigue-free. I'm in awe of this app's ability to make reading so accessible and convenient. I'm amazed by the extensive statistics tracking. It's fascinating to see my listening habits.
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