Founded in 2008 in the Silicon Valley of USA, Pervasync specializes in database synchronization for Oracle, MySQL, PostgreSQL, Microsoft SQL Server, SQLite and React Native Realm databases. The name “Pervasync” was derived from the words “Pervasive” and “Synchronization” indicating that our products enable you to run smaller databases on pervasively available devices while keeping them in sync with a bigger central database. Based on years of research and development, we created the innovative sync solution that has brought pleasant surprises to enterprise database users who had been treading water with their previous third party or homemade sync solutions.
One current trend in computing is the proliferation of mobile devices. As the devices become more and more capable and pervasive, it is getting both feasible and necessary to run a database system on the devices for the management of the large amount of data that could be stored locally on devices. The device databases would need to exchange data with a central database for data backup, data collection and data distribution purposes. The exchange of data between the local and central databases is called database synchronization. Another trend in computing is the globalization of economy in which an enterprise’s geographically distributed employees, partners and customers access central servers via the Internet. All is good until there is a poor Internet connection or a network outage. More and more enterprises are considering adding local servers to resolve this issue. Here again, the databases of the local servers and those of the central servers need to be synchronized in order to have the best of both worlds: fast, reliable access to the information and consolidation of the information.
Pervasync software provides a data synchronization infrastructure for synchronizing distributed local databases with a central database. It supports SQLite, MySQL, PostgreSQL, Microsoft SQL Server and Oracle databases (including Express, Standard and Enterprise editions). Typically you would run MySQL, PostgreSQL, Microsoft SQL Server or Oracle Enterprise Edition on the server side (in your data center or in the Cloud), while on the client side (Linux or Windows desktops, laptops, tablets, and smartphones), you may choose SQLite, MySQL, PostgreSQL, Microsoft SQL Server, Oracle Express Edition or Oracle Standard Edition.
The Pervasync data synchronization server and client for SQLite, MySQL, PostgreSQL, Microsoft SQL Server and Oracle are written in pure Java. They can run on any platforms that support Java SE. This includes Windows, Linux and Mac OS X. The sync clients for Android and Blackberry devices are written in OS native Java. Sync clients could run in standalone mode or be embedded into your applications on devices.
Pervasync server comes with a web based admin console for administrators and developers to create publications and subscriptions of the sync objects. On the device side there is a sync client GUI application for end users to start or schedule synchronization sessions. The sync system can be set up quickly and you can get your central DB synchronized with your local databases without writing a single line of code. Nevertheless, we also provide client and server Java API that can perform the same tasks in case you need to embed the sync functionality seamlessly in your applications.
From ground up, the system is designed to support data subsetting, so that each client can synchronize its private data as well as shared data with a central server. We introduced the concept of logical transaction for synchronization of the data subsets. Server side logical transactions are computed using the state comparisons of the data subsets. They are used to refresh client side data. Client side logical transactions are tentative and local until they are checked-in on server. The logical transaction based synchronization scheme contrasts with traditional physical transaction based replication schemes, which do not apply to subsets of data and cannot scale due to divergences.
Last but not least, the biggest differentiators of Pervasync compared with other sync solutions are performance and scalability. The number of sync clients and amount of data in your organization tend to grow rapidly over time. So it is important to test the scalability of the sync solutions before you commit to one of them. You will find out that Pervasync stands out in your performance and scalability tests.