On 11/05/2023 15:54, Julia Kreger wrote:
Awesome! Thanks for the prompt reply and action on a patch for Neutron. The test patch proposed against Ironic passed, which is definitely a good sign!
While it's really cool to see how quickly this PostgreSQL issue was fixed for Ironic, I believe there is no widespread testing and validation of PostgreSQL for other projects (anymore). There even was an official communication from the TC in 2017 about not "supporting" anything but MySQL / MariaDB: https://governance.openstack.org/tc/resolutions/20170613-postgresql-status.h... I myself ran into multiple issues, some during schema upgrades and some only at runtime because certain side-effect such as improper booleans or "free solo SQL" where used within the code, rendering the ORM abstraction of the actually used DBMS useless. This is also making it very hard to fully validate the DBMS is interchangeable without particularly testing for those kind of cases in all sorts of database fields or by doing code reviews. What I am saying is, that as a an operator I appreciate clear communication and clear deprecation processes over "best-effort" commitments. It does not help if there is a minefield of issues and raised bugs about incompatibilities are not considered really important since the user-base for PostgreSQL installs has diminished. If I use a set of services just fine, but as soon as I add another OS project to my cloud I could run into all sorts of problems, just because I chose the "wrong" DBMS. Regards Christian