Sync offline db with online
lazarus / 16-Databases

----------------------------------------------------------------------
christensen · 2020-12-07 06:47

Hi,

What is the simplest and easyest way to sincronize an offline database
containt with an online.

The online database will run from a server and have 4 client tabletes
attached, but when those tablets are not in wifi range than should
store the details offline local, when it's reach online connection to
upload the containt.

At this stage i haven't choosen database provider (mainly i had work
on firebird), but i consider to move to other if that make possible
this request.

Any help would be apreciated!

----------------------------------------------------------------------
mangakissa · 2020-12-07 08:49

I don't have this situation on me, but in this case I shall save the
record by XML/json.
Create a thread that pings the connection. If up, sent the the
XML/json to the server to process.

----------------------------------------------------------------------
Thaddy · 2020-12-07 11:26

use Tbufdataset on the clent side. There are many examples