Notes and Restrictions

Notes and restrictions that must be considered when using SQLite®.

Important: The SQLite® database is an alternative to the existing RAIMA database and they cannot be used simultaneously within a project.
  • SQLite® can only be used in combination with NextGen Archiver (NGA).
  • NGA can be used in a RAIMA or SQLite® project. However, SQLite® can only be used with NGA and not with HDB / RDB Archiving.
  • You can switch from RAIMA to SQLite® but not back.
  • The managers that require configurations (e.g. drivers) are not shut down when they attempt to connect to a data manager that is in mirroring mode. The managers wait until the mirroring mode has ended.
Note: Queries with SELECT ALL are now correctly returning an error as they are not supported in SQLite-NGA projects.

Using network mounted drive CIFS (Samba share) with SQLite

According to the official documentation, using SQLite over a network mounted file system is neither recommended nor tested. In particular, the synchronization and locking reliability of network file systems is questionable. The CIFS file system is not fully compatible with the SQLite locking mechanism. In WAL mode, most operations should work, but some operations on the DB require an exclusive lock, which is a problem in this case.

Workaround: When mounting a CIFS (Samba) network drive to access an SQLite database, it is necessary to connect the disk with the nobrl (No Byte-Range Locking) option. This can be done using the following command:

sudo mount -t cifs -o nobrl,username=z004cknf,password=***** //host.docker.internal/SharedF /home/winccoa/winccoaproj
Important: The nobrl option only hides the problem. The main issue is that SQLite officially doesn't support network file systems. In the worst case, the database can get corrupted.

Sources: