Based on what you've written, for your specific use case I'd probably go with "local SQLite syncing with remote server whenever possible" even if PostgreSQL was

Based on what you've written, for your specific use case I'd probably go with "local SQLite syncing with remote server whenever possible" even if PostgreSQL was 100% perfect. There's just so much that can go wrong with an internet connection, or you end up with "that one entrance where hand-scanners don't quite work because of bad reception in that corner", and stuff like that.