Database

Database

You have the option of using SQLite or Microsoft Compact CE as the main Tabular DB – both are ‘serverless’ databases, which means it is just a file that sits within the file system. No need to set up a server to host the database.

More about SQLite

We are using SQLite to capture Excel Save Points. We use the System.Data.SQLite C# library which is supported by the SQLite Development Team. No need to install any extra software to your client machine to use it.
A database in SQLite is a single disk file. Furthermore, the file format is cross-platform. A database that is created on one machine can be copied and used on a different machine with a different architecture. SQLite databases are portable across 32-bit and 64-bit machines and between big-endian and little-endian architectures.
Max DB size: 140 terabytes
Max row size: 1 gigabyte
All changes within a single transaction in SQLite either occur completely or not at all, even if the act of writing the change out to the disk is interrupted by

• a program crash,
• an operating system crash, or
• a power failure.
  

SQLite is likely used more than all other database engine combined. SQLite is found in:

• Every Android device
• Every iPhone and iOS device
• Every Mac
• Every Windows10 machine
• Every Firefox, Chrome, and Safari web browser
• Every instance of Skype
• Every instance of iTunes
• Every Dropbox client
• Every TurboTax and QuickBooks
• PHP and Python
• Most television sets and set-top cable boxes
• Most automotive multimedia systems
• Countless millions of other applications
  

Detailed info on the application you can find here.