SQLITE OR POSTGRESQL? IT'S COMPLICATED!

Summary from the TLDR Web Dev newsletter

Both SQLite and PostgreSQL were used - to test performance - when building a blogging dashboard at Twilio. PostgreSQL outperformed SQLite for shorter queries but struggled with longer ones. SQLite handled concurrency better for all query sizes. SQLite also seemed to provide more simplicity for the application, especially since it was a smaller one.