SQLITE OR POSTGRESQL? IT'S COMPLICATED!
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.