dimanche 28 décembre 2014

Check two sqlite db equality

i'm writing a simple PHP script who get data from various sources and compile an sqlite database. Now, sometimes the data will change, and i want to update the database only when the data changes, so i have two databases: one is the temporary one, who i compile each time the scripts run, the second is the database that my application download and use.


What i want to do is check if there are differences in the two databases, and if so, replace the second one with the first one... My answer is: there are a simple way to do this with php or i have to check the db record by record and table by table?


Aucun commentaire:

Enregistrer un commentaire