CopyCat Developer 3.9 released!
Changes in this release include:
- Improvements in the RTC inverted connection mechanism.
- Major improvements in the trigger mechanism when in ReplicateOnlyChangedFields mode. The list of fields is now calculated dynamically in the trigger (instead of being hard-coded in the trigger), meaning that you don’t need to recreate the triggers after adding a field. It also means that the triggers create no dependency on your fields, so you can drop fields or even change the primary key definition without having to drop and recreate your triggers.
- Fixed a bug causing replication to abort incorrectly after a timeout when a connection was lost due to a timeout from a very slow connection, when replicating over a transport layer (RTC or XMLRPC), sometimes resulting in a row being wrongly deleted from the destination database.
- Various other minor bug fixes
is available, bringing a number of small bug fixes, as well as a vastly improved trigger mechanism allowing to replicate changes field by field rather than by whole rows. This means that problems that used to occur with replication order (particalarly foreign key violations that were sometimes inevitable), should now never happen at all.
The new trigger mechanism also allows for the primary key fields of the changed row to be found dynamically, meaning that you can now drop or recreate a primary key without having to recreate the triggers, and the change will automatically be detected in the triggers. This makes LiveMirror more seamless than ever.
If you’ve been experiencing any problems with previous vesions of LiveMirror, please give this new release a try! And don’t forget you can contact us through the support forum
if you need any help getting things working.
We’re pleased to announce the release of CopyCat Developer version 3.08.0!
The changes in this release are as follows:
We’re pleased to announce the release of CopyCat Developer version 3.7.1!
The changes in this release are as follows:
– XE7 support
– Major performance and memory management improvements of big logs. Instead of loading the whole list of changes to replicate into memory at once, it is now streamed in row by row.
– The UPDATE OR INSERT statement is now used in FB 2.1+, in order to reduce the number of statements needed and thus optimize performance.
– Internal changes enabling the use of prepared queries during replication, thus again dramatically improving performance.
– Improved performance of TCcConnection.GetFieldType
– Fixed a memory leak that caused problems with long-running replication cycles.
– Fixed a bug in the millisecond handling in Firebird.
A new case study from one of our long-time customers !
Our organization distributes Christian literature through volunteer groups based in two European countries. We needed a central database to keep a record of when, where, and how many pieces of literature were distributed by our multiple groups. This database also had to be accessible by individual members in a manner that was efficient and allowed for various levels of access.
To manage the central database, we used MySQL 5.X, with a PHP interface that was developed by CopyCat ; this interface was essential for facilitating safe and encrypted access to the database. For client access, we used Firebird 2.X. Using this framework, and with the support of CopyCat, we were able to accomplish the following:
- The central database was accessible by each member of each group on their local computer, even when working offline.
- All new data was automatically compiled and updated within the central database.
- Each group’s access to the database was restricted, such that a group could change the administrative options for its own geographical region, but not the options for another group’s region.
- Within a given group, members who were higher in the administration were allowed greater levels of access to their system.
Given CopyCat’s software and developer support, we were able to design an easy to use, and easy to manage, central database with efficient and flexible client access.
I will be speaking at the Firebird conference in Prague
on the 24th and 25th of October 2014, presenting recent changes in CopyCat, offering a hands-on demonstation, answering questions, and so on…
So if you are curious about CopyCat and plan to attend the conference, I hope to meet up with you !
We are pleased to announce a new release of our database replication engine, CopyCat Developer !
This new release includes the following improvements:
* PostgreSQL support
* Oracle support