Guidance need for eol,lts and other date/boolean columns

[adriens]

❔ About

I'm currently working on daily API driven dumps of endoflife.date. I want to create strong typed columns in addition to text based ones.

For some columns :

• eol
• lts
• extendedSupport
• ...

🙏 Help requested

👉 For each of them I would need some guidance/rules on how to compute the DATE and BOOLEAN versions.

🎟️ Related resources

• ❔ boolean columns definition adriens/endoflife-date-snapshots#5
• CSV file #2650
• https://www.kaggle.com/code/adriensales/endoflife-date-database-export/notebook

[marcwrobel]

@adriens, this is more a question than an issue, so converted your original issue.

support, eol, extendedSupport dates fields can either be a date (if it is known) or a boolean (if it's not known).

lts can also be a date or a boolean, but it does not have the same meaning. Usually a boolean is used because the information is known when the first version of a cycle is released. But for some products :

• Whether or not a particular version is an LTS is not known in advance (Jenkins for instance). This means the value will be updated to a boolean, but may be also to a date (I don't have an example to provide for this case).
• A release cycle is considered LTS only at a certain point in time (SonarQube for instance). This means the value will be a date.

Note that field description is available on https://github.com/endoflife-date/endoflife.date/blob/master/CONTRIBUTING.md. Do not hesitate to let us know if something can be improved or provide a PR to improve it.

[adriens]

Thank you @marcwrobel .

So, for example, for eol field

• true ➡️ true
• false ➡️ false
• DATE (NOT NULL) ➡️ ❔ (ideally a formulae, even if it's based on the current date)
• NULL ➡️ ❔ (ideally a formulae, even if it's based on the current date)

[marcwrobel]

I do not have such "formula" : a null value in a field indicates the information is not available.

[adriens]

[adriens]

Ok, so I'll leave data like that 👍

[adriens]

💡 If anyone has some ideas on how to force boolean to be only true/false (and not NULL), just let me know 🙏