REDISQL.COPYthat copy the content from a source database into a destination database.
REDISQL.COPYcommand takes two parameters as input, a
sourcedatabase and a
destinationdatabase and it overwrite the content of the
sourcedatabase into the
REDISQL.COPYcommand takes as input two databases, both of them must be created using the
REDISQL.CREATE_DBcommand. This API allows several use cases that are quite interesting.
DBrunning with some table and some data:
/home/foo/backup.sqlitewill contains all the data that were originally on the
/home/foo/recover.sqlitewe start by loading it, and then move it into an in-memory database, and finally we can also delete the database we used for recovering.
DBthat is an in-memory one and we have used the
TO_RECOVERdatabase to load the recovering file.
DB1that makes quite complex and long queries, if that start to be a problem we could spread the load into two identical databases.