There also seem to be database corruption problems with sqlite after an unclean shutdown. This shouldn’t be happening anyway (sqlite should use a journal) but I’d expect postgres to be more resilient to unclean shutdowns as it’s used in production environments with high durability guarantees; sqlite is not.
I’d vote for postgres over sqlite just from a reliability perspective.