Database storage
This dialog is opened by pressing shortcut key CTRL+C or via menu Options->Configuration and selecting the SQLite Database tab
Here you can enable database storage and set a path to where database archives will be stored.
SQLite database storage options
Store data to daily database - If enabled Data Server will save each captured strike event to daily SQLite database archives. A new daily database archive will be created after midnight each day.
Database folder - Lets you select a folder where all Data Server database archives are stored.
Data Server database file naming follows the convention NGXDS_YYYYMMDD.db3 where...
- YYYY is the year (4 digits)
- MM is month (2 digits, 01-12)
- DD is day (2 digits, 01-31).
The SQLite database engine allows concurrent reads which means that the contents of the current days' database can be viewed and extracted even while in use by Data Server.
For viewing contents of NGX Data Server databases or exploring the structure we recommend DB Browser for SQLite which is a free database browser for SQLite compatible databases.
Database fields
| Field name | Description | Value type | Example |
|---|---|---|---|
| ID | Unique sequential identifier number | INTEGER | 1 |
| EPOCH_MS | Time of event, Epoch time milliseconds | INT(8) | 1431686391000 |
| DATETIME_UTC | Time of event UTC, human readable form | TEXT | 2015-05-15 10:39:47.000 |
| LATITUDE | Latitude of event, Degrees Decimal format | REAL | 36.2352717492458 |
| LONGITUDE | Longitude of event, Degrees Decimal format | REAL | -3.14798434599177 |
| TYPE | Strike type* | INT | 1 |
* Strike types are defined as:
0 - Positive cloud to ground
1 - Negative cloud to ground
2 - Cloud flash
3 - Uncategorized/undefined
99 - Uncategorized/undefined
👉 NOTE! In custom database applications or with any type of database browser software, make sure that you do not lock the active daily database for reading or writing. Doing so may produce unpredictable results and will likely cause Data Server database storage feature to fail.
🔥 TIP! With the Strike rate limiter, if NexStorm strike rate per minute exceeds the pre-defined limit a reduced amount of lightning data will be stored in the database. If your primary use of Data Server is for database storage you can increase Strike rate limiter to maximum permitted value in order to ensure that all data received from NexStorm is stored in the database.