WHAT YOU NEED TO KNOW ABOUT SQLITE

Summary from the TLDR Web Dev newsletter

SQLite has become a viable option as the main database for Ruby on Rails apps, especially for smaller apps. SQLite does have limitations like single-writer concurrency and reliance on a single host, but its strengths are its simplicity, ease of setup, and surprisingly good performance on modern hardware.