search

ODNZSL / nzsl-dictionary-scripts

Scripts needed to support the NZSL mobile applications
MIT License
3 stars 2 forks source link

Persist the current YYYYMMDD in the user_version PRAGMA metadata store of the output SQLite database #22

Closed joshmcarthur closed 9 months ago

joshmcarthur commented 9 months ago

This pull request stores the release date of the database in YYYYMMDD format using the user_version PRAGMA setting. This is a space allocated by SQLite specifically for an integral version number.

The intent is for consumers of the database to be able to use this version to display the release date to end users, so it is understood which release version is being used at that time to fetch and display results.

After export:

sqlite3 nzsl.db
SQLite version 3.39.5 2022-10-14 20:58:05
Enter ".help" for usage hints.
sqlite> PRAGMA user_version;
20231211