mORMot Open Source

general-e

Member

From: Germany

Registered: 2013-04-11

Posts: 7

Local DB in Mobile Apps

Hi guys,

is there a way to use the SynCrossPlatform units to access a local SQlite DB on Android or IOS.
My app should sync data with a Mormot-Server. But it should work offline. So I need to store the data localy.

Any suggestions?

Marco

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 15,069

Website

Re: Local DB in Mobile Apps

Currently, there is no local storage for SynCrossPlatform units.

I've added a feature request.
See http://synopse.info/fossil/tktview/292d00675ec

What kind of storage do you need?
How much data do you expect to be stored locally?
I suppose a simple TObjectList + JSON local storage may be easy to implement.

Note that this feature request is tied to http://synopse.info/fossil/tktview?name=3453f314d9
which is the automatic data synchronization feature, among servers, but also between clients and servers.

general-e

Member

From: Germany

Registered: 2013-04-11

Posts: 7

Re: Local DB in Mobile Apps

I thought about a Sqlite DB, but JSON storage would be fine.
At the moment I need to store some customer-information, tasks, dates.
A few tables and not so much data.
At the beginning my App would only read data. So I wouldn't need a real synchronization.
To add/modify data the app must be linked to server (at the beginning).

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 555

Re: Local DB in Mobile Apps

also interested in local storage

---

Rad Studio 12.3 Athens / 13.0 Ganymede

AOG

Member

Registered: 2014-02-24

Posts: 490

Re: Local DB in Mobile Apps

Hello Ab,

Is (simple) local storage still on your (current) roadmap ?
And if so, could you give an indication about its implementation ?
(when, how)

At this moment, I am fetching mORMot data the cross-platform way.
And use build-in Delphi functions for local data storage with sqlite.

But 100% mORMot would be much better !

Thanks in advance.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 15,069

Website

Re: Local DB in Mobile Apps

There is no time estimation yet.
I would probably implement it as part of the "Auto-Synch between mORMot servers (as cache or for branch office cache), and potentially mORMot clients (offline mode)" feature request.
See http://synopse.info/fossil/info/3453f314d9
It fits with the offline mode.