Hello everyone!
A new update of LiteSync was released. Here is what has changed:
- Added the
PRAGMA log_sql_commands command to enable or disable logging SQL commands to the -log file
- The
VACUUM command is now blocked as it is not compatible with replicated databases
- Renamed the generated Windows DLL from
litesync-0.1.dll to litesync.dll
- The single argument to the
on_sync notification now contains the list of tables that were updated
The way to setup the notification is different for each programming language.
The changes parameter is a JSON string with this format:
{
"users": {
"inserted": ["17179869188","17179869189"],
"updated": ["17179869185"],
"deleted": ["17179869186","17179869189"]
}, "msgs": {
"inserted": ["17179869186"]
}}
Currently it only tracks insertions, updates and deletions of rows on tables.
Each operation contains a list with the row id of the affected rows.
If there are more than 32 items on a list, then the JSON string will contain just the ... string instead of the list of affected rows.
Here is an example for more than 32 insertions on the "users" table:
{"users": {
"inserted": "..."
}}
How to Update
You can either download the updated binaries or pull the latest version from the repository and compile it.
If you have not updated to the version 2.1 before, we recommend to follow the related instructions
Make sure to update the wrapper as well (if your app uses one)
If you have any questions or issues, please let us know.