Re: Choosing the right embedded database.

Hi Chris,

Chris Swinney wrote:
One facility that would be nice is for users to be able to update their local data store via an internet link. As users "could" also add further dance information to their local store, it maybe nice if this was a two way procedure. However, this could lead to repetition of information if everything was stored in the same table so maybe added data form the users could be stored in a separate table and then uploaded to a different temporary store to the downloaded updates. This uploaded information would then be checked through and added to the download store ready for the next updates. Would this be done with some kind of replication, but what are the data repetition issues if any?
>
Is any of this actually possible with an embedded system?

I would recommend you have a look at FireBird. There is an embedded version, and a client/server version. So depending on whether you need it for one machine or for several, you could install either one or the other. Furthermore, it's very simple to install, and rather light.

As for replication, I have written a database replication component suite for Interbase / FireBird, which I am in the process of releasing. Obviously, I would recommend it. ;) It includes advanced primary key synchronisation and conflict managment techniques, which ought to solve any potential issues you are anticipating concerning data repetition.

I'll post on this newsgroup as soon as I've got the beta release ready, probably some time this afternoon.

Regards,
Jonathan Neve.
.

Relevant Pages

  • Re: Choosing the right embedded database.
    ... >> different temporary store to the downloaded updates. ... > As for replication, I have written a database replication component suite ... > any potential issues you are anticipating concerning data repetition. ...
    (borland.public.delphi.thirdpartytools.general)
  • More replication woes
    ... My mailbox is on the Ex2003 server and I have a test mailbox on the Ex2000 ... then "SMTP Store Driver: ... the Public Folder Store "First Storage Group\Public Folder Store " ... Which I understand to be a sign that replication is working (as per KB ...
    (microsoft.public.exchange2000.information.store)
  • Re: Public Folder Replication - Size and Items
    ... I cannot go threw the 2 PF on each store using OWA ... So forcing replication does not sync those items which are different but any ... All these show the same items except for 23 folders, ... Public Folder Store --> Replication Status ...
    (microsoft.public.exchange.admin)
  • Re: Public Folder Replication - Size and Items
    ... Just looking on Newsgroups so many problems with replication etc, ... which PF store I create it on it replcates to the other .. ... All these show the same items except for 23 folders, ... the Public Folder store on Exch2 is now some items greater in those ...
    (microsoft.public.exchange.admin)
  • Re: OAB replication issue
    ... The 9175 event usually indicates that the store is not running and or we ... Possible ad replication problems? ... settings, pf settings, smtp settings, etc. ... replications are being sent and recieved by both servers. ...
    (microsoft.public.exchange.admin)