ZXDB version number

[SkoolKid]

Is there a way to get the ZXDB version number from an instance of the database? I don't see a version table anywhere, but perhaps the version number is located somewhere else?

[Einar Saukas]

Is there a way to get the ZXDB version number from an instance of the database? I don't see a version table anywhere, but perhaps the version number is located somewhere else?

The version number is visible in the ZXDB homepage (current version is 1.0.174) but it's not stored within the files you download.

However there's an easy way to find out the version you have. Compare the date of your file "ZXDB_mysql.sql" with the release dates listed here:

https://github.com/zxdb/ZXDB/commits/master

[SkoolKid]

The version number is visible in the ZXDB homepage (current version is 1.0.174) but it's not stored within the files you download.

OK. It would just be nice to be able to do "SELECT version FROM version" (say) in a script that connects to an instance of the database, and therefore be certain what version it's using.

Could you add a single-row version table, or would that be too much of a pain to maintain?