OpenCAD-php
OpenCAD-php copied to clipboard
opencad-community
Proposal to drop support for old versions of SQL.
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).
Agreed, this needs to be done. No sense in supporting unsupported versions.
That might work, in fact. Follow the mainstreamers LOL.
From: Michael Spears @.> Sent: Tuesday, April 6, 2021 1:45 PM To: opencad-app/OpenCAD-php @.> Cc: Katherine Moss @.>; Comment @.> Subject: Re: [opencad-app/OpenCAD-php] Proposal to drop support for old versions of SQL. (#384)
Agreed, this needs to be done. No sense in supporting unsupported versions. If we wanted to, might not be a bad idea to base our supported enviroments off of WordPress' requirements (https://wordpress.org/about/requirements/https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwordpress.org%2Fabout%2Frequirements%2F&data=04%7C01%7C%7C89d148f0974e43ef102708d8f923af47%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637533278941539889%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=sUPo7R70zVEkyCti4RXsF3dMXzP93W3gWnztjPD%2Bi%2FI%3D&reserved=0)
You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fopencad-app%2FOpenCAD-php%2Fissues%2F384%23issuecomment-814309473&data=04%7C01%7C%7C89d148f0974e43ef102708d8f923af47%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637533278941549884%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=LNwzzUjeOLIcPdGrKmK%2Bqp%2Bl7x%2FMyZJfKGxDiMfBk18%3D&reserved=0, or unsubscribehttps://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FADS4MABZXVCBFA3CDTFUJOLTHNCBJANCNFSM42NZWSUA&data=04%7C01%7C%7C89d148f0974e43ef102708d8f923af47%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637533278941549884%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=nRViOkT1SlpZEgqNAruBpnKvbnZgehU79uraoj01Wj0%3D&reserved=0.
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.
