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.