We can use LiteSync with the QSQLITE driver


First follow the instructions to compile and install LiteSync from the source code or use the pre-compiled binaries for your platform. You can start with the free version.


Modify the driver to use the LiteSync library:

sudo apt install patchelf

cd /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers

sudo patchelf --replace-needed libsqlite3.so.0 liblitesync.so libqsqlite.so

Instead of x86_64-linux-gnu it can be i386-linux-gnu or arm-linux-gnueabihf, it depends on the architecture

To check if it was successful:

ldd libqsqlite.so

It should appear liblitesync.so on the list.


Generally the QSQLITE driver on Windows already includes the SQLite engine embedded. This means that we need to recompile it to use an external SQLite, on this case the one containing LiteSync.

Here are the steps:

1  Install the Qt sources using the Qt Maintainance Tool

2  Download the LiteSync binaries to a folder like C:\litesync

3  Create a "include" folder and copy the 2 .h files there

4  Create a "lib" folder and copy the LIB and DLL there

5  Enter the lib folder and rename litesync-0.1.lib to sqlite3.lib (only this file)

6  Click on the Windows Start button > Qt > Qt Terminal

7  Run:

cd %QTDIR%\qtbase\src\plugins\sqldrivers qmake -- -system-sqlite SQLITE_PREFIX=C:/LITESYNC

When this step finishes, it will show 2 more commands to run to build and install the libraries

It is also necessary to copy the litesync-0.1.dll to the Windows\System folder OR to the same folder that the qsqlite.dll is installed

Example code
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
if (!db.open()) {
  qDebug() << "Can't Connect to DB!";

QSqlQuery query;
QString result;
while (true){
  query.exec("PRAGMA sync_status");
  result = query.value(0).toString();
  if (result.contains("\"db_is_ready\": true")) break;

A complete working example is available here