|
About SQLite
SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
SQLite is the most widely deployed database in the world, it is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
For more information please visit SQLite web site.
SQLite in our program
In our program SQLite is a default database. Software ships the SQLite engine and is ready to use, you do not need to install anything else.
It can be used locally, or SQLite database files may be shared across a network using a network file-system.
This sometimes is not a particularly efficient method and may have problems (depending on the file-system, or may simply not be available, also because of the latency associated with most network file-systems, performance will not be great for large databases.
SQLite database is recommended to be used for all software features besides storing large Wheel Systems or Lottery Numbers, in that case we recommend server-based database systems, you can downland free MySQL, PostgreSQL and Microsoft SQL Express server systems.
If SQLite database file can't be opened when placed in network folder please check if the file has set all necessary security permissions, so the software can access the file to read and write to.
SQLite Configuration
The software is already preconfigured to use SQLite database, you can change the following options:
On Network
You can check here if you want to connect to the database on network.
Data Folder
Here you can set database's local data folder. After you change database folder you must either move your existing database to new folder or create a new database.
Even if you are using the database on the network, this property must be set and database in this local folder must be present too.
This is done for the purpose when you are starting the software and the software is unable to connect to the database on network, then the connection will fall back to the local connection.
Also, in a case when you use other database types on network and connection fails,then software will fall back to SQLite default database.
Network Data Folder
When you use database on network please set here the path to data folder on the network drive:
Universal naming convention (UNC) paths, which are used to access network resources, have the following format:
1.A server or host name, which is prefaced by \\
2.A share name, which is separated from the host name by \ . Usually this is a hard drive on your network computer.
3.A directory name
For example: \\NetworkComputerName\ShareName\NetworkComputerFolderName
Please be aware that for unknown reason, known only to Windows or SQLite developers, sometimes the path to a file starting with \\ do not work, try to use the opposite syntax with //
You can test the connection to see if you are successfully connected to the database.
Backup Location
Here you can set database backup folder. After you change database backup folder it is advisable to move existing backup files to that new folder or create new backup.
Backup location can be a local folder, network folder or ftp server address.
If you want to use ftp server as your backup location then you must configure ftp server in main software main options in FTP section
If you have it already configured enter into Backup Location text box a server address.
Notes:
Do not enter or look for any database names, software manages it, you only must set or select folder names.
After changing any settings here please do not forget to click the Save Settings button to save the changes.
|