Skip to content
This repository has been archived by the owner on Mar 10, 2024. It is now read-only.

Proposal to drop support for old versions of SQL. #384

Open
ItsAGeekThing opened this issue Apr 6, 2021 · 4 comments · Fixed by #376
Open

Proposal to drop support for old versions of SQL. #384

ItsAGeekThing opened this issue Apr 6, 2021 · 4 comments · Fixed by #376
Assignees
@ItsAGeekThing
Labels
high priority Security
Milestone
1.0.0

Comments

@ItsAGeekThing
Copy link
Member

Synopsis
OpenCAD's officially supports MySQL >=5.5 (no recommended version) and MariaDB >=10.0 (with 10.3 being recommended) per our current documentation.
Running older versions of MySQL/MariaDB may expose servers to security vulnerabilities and children eating bugs that would have otherwise already been fixed on current releases.

MySQL 5.5 (OpenCAD's minimum supported version) has reached end of life (support ended on Dec. 2015).
MySQL 5.6's support ended in Feb. 2018 and MySQL 5.7's in Oct. 2020.

The latest version of MySQL that currently has support is 8.0 (which ends in April 2023).

MariaDB 10.0 (OpenCAD's minimum supported version) has reached end of life (support ended on Mar. 2019).
MariaDB 10.1's support ended in Oct. 2020.

The latest version of MariaDB that currently has support is 10.2 (which ends in May 2022)

Where do we begin?
We should set our minimal (and supported) version of MySQL as 8.0 (support end in April 2023).
We should set our minimal version of MariaDB as 10.2 (support end in May 2022) and the recommended version as 10.5 (support ends in June 2025).

What do we do after?
Once we shift OpenCAD's officially supported version of MySQL and MariaDB to maintained versions we should begin to follow Oracle's Oracle Lifetime Support Policy and MariaDB's Maintenance policy, respectively.

What other considerations must we discuss before making any changes?
While this is a minor change in principle, the fact is that there are so many different environments being utilized by our community.

* We base MySQL's EOL date off of its support end date and not the extended support date (Oracle charges a support fee for extended support which is intended for their enterprise customers).
@ItsAGeekThing ItsAGeekThing added this to the 1.0.0 milestone Apr 6, 2021
@ItsAGeekThing ItsAGeekThing linked a pull request Apr 6, 2021 that will close this issue
OpenCAD 1.0.0 Extravaganza #376
Merged
@ItsAGeekThing ItsAGeekThing pinned this issue Apr 6, 2021
@Cambridgeport90
Copy link
Contributor

Cambridgeport90 commented Apr 6, 2021 via email •
edited by ItsAGeekThing
Loading

ItsAGeekThing added a commit to ItsAGeekThing/OpenCAD-php that referenced this issue Apr 6, 2021
@ItsAGeekThing
Drop support for end-of-life PHP and MySQL/MariaDB versions.
a69124f 
Raise minimum MySQL version from 5.5 to 8.0 (8.0 recommended), MariaDB from 10.0 to 10.2 (10.5 recommended). Closes opencad-community#384

Raise minimum PHP version from 7.2 to 7.3 (8.0 recommend). Closes opencad-community#374

Minor cosmetic changes to README.md.
@ItsAGeekThing ItsAGeekThing mentioned this issue Apr 6, 2021
Merged
@mikespears
Copy link
Contributor

mikespears commented Apr 6, 2021 •
edited
Loading

Agreed, this needs to be done. No sense in supporting unsupported versions.

@Cambridgeport90
Copy link
Contributor

Cambridgeport90 commented Apr 6, 2021 via email

@phillf
Copy link
Contributor

phillf commented Apr 6, 2021

One the topic of SQL we need to check for both MySQL (proper) and MariaDB versions as the version strings are a unique format for each.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees

@ItsAGeekThing ItsAGeekThing

Labels
high priority Security
Projects
None yet
Milestone
1.0.0
Development

Successfully merging a pull request may close this issue.

OpenCAD 1.0.0 Extravaganza ItsAGeekThing/OpenCAD-php
4 participants
@phillf @ItsAGeekThing @Cambridgeport90 @mikespears