- Single File or Database
- Storage Modes in Detail
Storage Modes: Which to use?
InnoList stores the data (including configuration) according to the storage mode set.
The storage modes differ in handling and performance.
Single File or Database
Single Files: Easy to save in file systems and do not have further dependencies, the file alone contains the complete application. There might be disadvantages when used for big amount of data, the performance can be low(er).
Database Connection: Especially suitable for large amounts of data and/or many users. The installation of a separate database management system (MySQL, MariaDB, PostgreSQL, Microsoft SQL Server) is required. The data is accessible by other SQL Clients available.
Storage Modes in Detail
The storage modes in detail:
Saves data and configuration in a single XML file. This format is good for small and medium size applications.
If needed you can read the data with other software/scripts, this could be helpful if you want to use the data in another process step. Also searching using a file content search is possible.
The data is stored unencrypted and readable. Do not use this storage mode for confidential information in an environment where unauthorised users could access the file.
Own File Format
Saves data and configuration in a single file, using a proprietary binary format.
Good for small and medium applications.
The data is store unencrypted, but the reading and manipulation is hindered by the format.
SQLite: Database in File System
SQLite is a compact database that stores data in a separate file.
InnoList is configured to create a SQLite file data.db in the same directory as the configuration file. All further data is stored in this file.
SQLite is a mature database solution that is easy to use but can have significant advantages in performance, compared to the storage modes mentioned above.
The data is stored unencrypted, using Command Line Shell For SQLite the data can be read in a convenient way.
Database Connection With JDBC
Creates a connection to an installed database. For this the server/hostname, database name and (if applicable) username/password are needed.
This storage mode can have significant advantages regarding performance, compared to the other storage modes.
Please install your own database management system to connect to it.
These database management systems are supported:
(With the variety of versions available it cannot be guaranteed that any version is usable)
- Microsoft SQL Server
Also a new database needs to be created inside the database management system.