The new nav data format (.s3db) is all well and may well be an efficient database, but it has one big problem, unlike txt files of the old format there is no ubiquitous means of editing missing data into the new format, and as someone who fly’s lots in Africa etc, I run into missing airports all the time, some of which were at one time in your nav database but are now not.
now with the old format, I could keep a txt file and update each new nav data cycle used, but with the new .s3db this is not posable easily (txt file and notepad etc).
so could I ask that with the new nav data format that you include a structured txt based file that gets parsed alongside the .s3db and contains user data for things missing from the currant nav data, which would make things more fit for purpose while leaving the .s3db intact?
I am an end user, I am NOT making an app, I am seeking a simple way to augment what is held within the .s3db via an external text file, so missing or erroneous etc data can be added into the external structured txt based file (much like the old nav data format was), so end users can add things.
so I can add missing airports or seasonal airports etc, or ones that are correctly in the MSFS (2020 and 2024 Microsoft data) but are absent from your data, meaning I don’t have to edit .s3db but instead add them to a txt file that sits alongside that gets parsed alongside the .s3db and contains user data for things missing from the currant nav data.
one of the advantages of the old nav data was it was txt based in a structured format, thus could be edited\added to
Hi,
Understood, thank you - two comments on this:
I don´t know any third-party add-on that supports the SQLite database and text files in parallel. The add-ons that I know can read either the SQLite database or the text files, but not both in sync. In other words, when your add-on supports only the SQLite database, it won´t read text files (and vice versa, of course).
Second comment - a SQLite database is also a structured format …
You can export all tables in a CSV file, for example, and add your records. The question for me is, for what? What do you do with the added records?
So, in summary, no, we don´t offer any text-based format at the moment because no add-on developer has requested it, but as you see on our development portal webpage, we can offer all this data in text format, too.
