Is there a best practice, tutorials, examples out there that demenstrates the best ways to create an offline mode of a python app that gets and sends its data to a remote database. I have tried creating my own via json API to mysql and using sqlalchemy SQLite and mysql. Everything I seem to come up with is buggy and or extremely ugly