I am curious about your script.
How did you make the insertions? Have you used the proper URI when opening the database?
You did not run this script while the local db was open by another app, right? Notice that we can have just a single connection to each db.
Can you share more info?
Can you check the status on the secondary node using
pragma sync_status? Does it appears as connected to the primary node?
Regarding C, you can use any example code for using SQLite in C and make these 3 changes:
- Convert the database name string into an URI
- Check if the database is ready to be accessed.
Check the example code in the details page on the Basic App Example section and select the C language.
- Link your code to the LiteSync library instead of plain SQLite:
gcc test.c -o test -llitesync