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

afercon
Member
Registered: 2014-12-21
Posts: 2

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

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.

Offline

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

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,659
Website

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

Offline

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

danielkuettner
Member
From: Germany
Registered: 2014-08-06
Posts: 357

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

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

Offline

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

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,659
Website

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

@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.

Offline

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

danielkuettner
Member
From: Germany
Registered: 2014-08-06
Posts: 357

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

@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.

Offline

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

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,659
Website

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

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.

Offline

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

afercon
Member
Registered: 2014-12-21
Posts: 2

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

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

Best regards, Antonio Angel.

Offline

Board footer

Powered by FluxBB