Client working with two model: Firebird (Server) and SQLite (mobile p)

afercon · 2014-12-21 23:38:45

Hello,

Congratulations to everyone for making this great software.
I would ask if I can use a model on the client side. To access a sqlite database, stored in a mobile phone, through its corresponding model.
The architecture is as follows:
Server: Windows Server PC with Firebird RDBMS.
Clients: Mobile Phones (these in turn store a small SQLite database, and would like to use a data model to interact with the database. Clients work with two models, one server model (Firebird on server) and another its own model (SQLite on mobile phones).

Best regards, Antonio Angel.

ab · 2014-12-22 05:46:24

Not yet.

See http://synopse.info/forum/viewtopic.php?id=2237

danielkuettner · 2014-12-22 07:44:57

On client-side he could use a normal sqlite-db-connection, and Firebird with Model.

ab · 2014-12-22 22:02:54

@daniel Indeed. But the issue is how to synchronize the local and remote data, in both offline and online modes.
This is why this feature request should be IMHO better be linked to the "data synchronization" feature request.

danielkuettner · 2014-12-23 09:35:36

@AB

Ok, I've though the sqlite db on client is only for saving connecting settings of the FirebirdDB and no synchronization is necessary.
At client you have to save server, db, username etc. and for that sqlite is a solution.

ab · 2014-12-23 09:42:28

IMHO the client is not to be connected directly to the firebird db, but only via a mORMot server.

And sqlite was on client side for offline mode.

BTW I think firebird is not the best choice for a new mORMot project, only to be used with a legacy existing firebird db.

afercon · 2014-12-23 13:13:58

Thank you very much, wait then...
When you think "Local storage units SynCrossPlatform" it will be implemented ??

Best regards, Antonio Angel.

mORMot Open Source

#1 2014-12-21 23:38:45

Client working with two model: Firebird (Server) and SQLite (mobile p)

#2 2014-12-22 05:46:24

Re: Client working with two model: Firebird (Server) and SQLite (mobile p)

#3 2014-12-22 07:44:57

Re: Client working with two model: Firebird (Server) and SQLite (mobile p)

#4 2014-12-22 22:02:54

Re: Client working with two model: Firebird (Server) and SQLite (mobile p)

#5 2014-12-23 09:35:36

Re: Client working with two model: Firebird (Server) and SQLite (mobile p)

#6 2014-12-23 09:42:28

Re: Client working with two model: Firebird (Server) and SQLite (mobile p)

#7 2014-12-23 13:13:58

Re: Client working with two model: Firebird (Server) and SQLite (mobile p)

Board footer