Starting from v4, the Pagico is utilizing a dramatically improved data engine, SQLite3, compared to its predecessors. As Pagico evolves over time and comes with better features, the internal database component pretty much remained the same (it lived this long partly because it was a custom-built database that was exactly designed for Pagico). However, as time goes by we clearly felt that the data engine, being the most important component, needs to be improved in many ways. It has to be faster in performance, more stable, easier to move and backup.
But replacing such an important module is not an easy job. Fortunately, with the totally rewritten libraries in Pagico v4, this task becomes much easier and manageable.
Benefits
To sum up, the benefits of the new SQLite3 data engine include:
- Much more reliable (industry-proven database compared to custom-built database)
- 2x faster (not in all aspects, but averagely twice as fast as before)
- Much easier when duplicating and backing up (a regular db contains 50 files, compared to tens of thousands of files before)
- Many more possible features for Pagico based on the better API and functionalities
- And many more.
Server-side Technologies
Server-side technologies are also employed in Pagico to ensure data integrity to the maximum level. For example, Pagico writes changes to the database in just a splash of time just when needed, instead of opening long term database connections which is commonly found in other desktop database programs and is vulnerable to system crashes.
Backup Is Still Important
Although Pagico has multiple measures built in to increase data reliability, we still recommend you to backup your databases regularly. Because we all know that the peace of mind about your data is more valuable than anything else in your computer experience.
Related posts:
