file synchronization as in Ecco? (M)

Submitted by jimspoon on 2011/05/25 04:02
Does / will IQ have file synchronization?  Ecco's system of file "replicas" and a "master file" that contains all changes and keeps all the replicas synced has worked well for me.  Or does / will IQ have a very different way of working with one's databases from various computers?
 
jim 

Comments

[quote=jimspoon]
Does / will IQ have file synchronization?  Ecco's system of file "replicas" and a "master file" that contains all changes and keeps all the replicas synced has worked well for me.  Or does / will IQ have a very different way of working with one's databases from various computers?
 
jim 
[/quote]
 
I dont know what the plans are. Pierre is on holidays for two weeks, so hopefully someone else can answer your query.
 
See also 7. Synchronization - not the same - but possibly of interest:
> InfoQube can pull data from external data sources, such as SQL Server, mySQL, Oracle, MSAccess, etc. Any ODBC data source can be used.
 

@Jim: As Tom said...
 
But I'm not sure of what you mean exactly by file synchronization and Ecco's system of file "replicas" and a "master file".
For syncing, a lot of people use Dropbox.
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 2
Dell Vostro 1500, Ram:3gb, CPU:Core2Duo T7500 2.2ghz

jimspoon

2011/05/25 16:08

In reply to by Armando

Well, in Ecco, you can make a "replica" of any .eco file, and move that replica to any other computer.  From that point, any changes made to the original file, or to any of the replicas, are recorded in a separate "master file" with an .ecg extension.  The changes are kept in the master file until they have been replicated in the original file and all the replicas.  Synchronization can be done manually from the original file or any replica, by means of export/import files. 
 
Synchronization can also be done "online" - i.e. there is a network connection between the computer with the replica file and the computer with the .ECG master file.  In this case, any changes in the replica file are instantly received in the master file.  If multiple replicas are open at the same time on multiple connected computers, changes made on one replica are instantly replicated on the others.  It works really well.
 
Dropbox is great, but what if you're running IQ on computer 1 and computer 2 at the same time, with the  IQbase file in the Dropbox open at the same time on each computer, and changes are made to the file on both computers?  Not sure if Dropbox can make the appropriate changes on both computers without losing some of the changes, or corrupting the file.  The Ecco system understands the Ecco data structures, and can handle this situation very well.
 
 

Armando

2011/05/25 16:44

In reply to by jimspoon

While not limited to it, IQ's database backend is currently Jet 4 (i.e. : Access), and will probably be for a while as there doesn't seem to be any drawbacks to it at this point. The Jet database engine is by default multi-user, and is fine up to 25 concurrent users and probably much more, depending on the use.
 
On Pierre's todo list there's a "multi-user sync" item (it's not in Mantis though). I don't know when this will be implemented but it's probably not too complicated as other IQ flavours are already used in multi-user environments businesses ( Recyc-Québec and  Eco-Entreprise Québec I believe).
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 2
Dell Vostro 1500, Ram:3gb, CPU:Core2Duo T7500 2.2ghz

MANTIS
 
Update Issue1138 Implement multi-user DB sync  New featurefeaturenew  2011-07-03 12:04Armando
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 2
Dell Vostro 1500, Ram:3gb, CPU:Core2Duo T7500 2.2ghz