Relevant info: Using Python3, mysql database and mysql connector package for connecting to the database. I have a program that uses database to get info that it needs and to write to it. On my machine it works well because I'm connected to the local host but on another machine it won't work. Because program will use real server someday, I want to, if program doesn't have access to the server to use copy of a database that will be stored in his files. I'm new to databases and I can't seem to find any remotely relevant info on this. Help on how can I do this or point me in the right direction where to look, thanks.

CodePudding user response：

What you want to do is called database caching. Look it up and you should find tips and strategies.

Here is an SO question asking about doing it in python

Hope this helps!