Formally give up on trying to provide PostgreSQL DB support?
Hi all, Should we formally give up on trying to provide PostgreSQL support? I find it highly unlikely that we will ever provide it. We may as well close issues like the following: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7365 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7802 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11422 Over the last year or so, the Keycloak community has undergone a lot of conversations on database support. Historically, it's provided support for MariaDB, MSSQL, MySQL, Oracle, PostgreSQL, and more. However, going forward, Keycloak plans to only provide first class support for PostgreSQL and CockroachDB databases. CockroachDB uses the same wire protocol as PostgreSQL, so really they're supporting 1 database type. You can read more about it all at the following links: https://www.keycloak.org/2022/02/dbs.html https://www.keycloak.org/2022/07/storage-map.html Personally, I really like PostgreSQL. I use it for a number of other projects. But I think we're pretty wedded to MySQL/MariaDB with Koha, and maybe we just need to own that? David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595
+1 for giving up. We can focus on other cool features ;) Le 05/12/2022 à 15:49, David Cook a écrit :
Hi all,
Should we formally give up on trying to provide PostgreSQL support?
I find it highly unlikely that we will ever provide it.
We may as well close issues like the following:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7365 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7365>
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7802 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7802>
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11422 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11422>
Over the last year or so, the Keycloak community has undergone a lot of conversations on database support.
Historically, it’s provided support for MariaDB, MSSQL, MySQL, Oracle, PostgreSQL, and more.
However, going forward, Keycloak plans to only provide first class support for PostgreSQL and CockroachDB databases. CockroachDB uses the same wire protocol as PostgreSQL, so really they’re supporting 1 database type. You can read more about it all at the following links:
https://www.keycloak.org/2022/02/dbs.html <https://www.keycloak.org/2022/02/dbs.html>
https://www.keycloak.org/2022/07/storage-map.html <https://www.keycloak.org/2022/07/storage-map.html>
Personally, I really like PostgreSQL. I use it for a number of other projects. But I think we’re pretty wedded to MySQL/MariaDB with Koha, and maybe we just need to own that?
David Cook
Senior Software Engineer
Prosentient Systems
Suite 7.03
6a Glen St
Milsons Point NSW 2061
Australia
Office: 02 9212 0899
Online: 02 8005 0595
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/
-- Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system maintainer 🦄 BibLibre, France
Yes, we already gave up years ago. But we never said so 🙂 ________________________________ Van: Koha-devel <koha-devel-bounces@lists.koha-community.org> namens Fridolin SOMERS <fridolin.somers@biblibre.com> Verzonden: dinsdag 6 december 2022 22:37 Aan: koha-devel@lists.koha-community.org <koha-devel@lists.koha-community.org> Onderwerp: Re: [Koha-devel] Formally give up on trying to provide PostgreSQL DB support? +1 for giving up. We can focus on other cool features ;) Le 05/12/2022 à 15:49, David Cook a écrit :
Hi all,
Should we formally give up on trying to provide PostgreSQL support?
I find it highly unlikely that we will ever provide it.
We may as well close issues like the following:
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D7365&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833271295%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=LYnWdxJxT9NzlyTYxL7YGRfAyUqn5XDSQoUzm0rK91c%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D7365&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833271295%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=LYnWdxJxT9NzlyTYxL7YGRfAyUqn5XDSQoUzm0rK91c%3D&reserved=0> <https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D7365&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833271295%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=LYnWdxJxT9NzlyTYxL7YGRfAyUqn5XDSQoUzm0rK91c%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D7365&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833271295%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=LYnWdxJxT9NzlyTYxL7YGRfAyUqn5XDSQoUzm0rK91c%3D&reserved=0>>
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D7802&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=HTW18FpqsJA4wuqlef63rFnAMKqEkZ38LG15e3QE8Rc%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D7802&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=HTW18FpqsJA4wuqlef63rFnAMKqEkZ38LG15e3QE8Rc%3D&reserved=0> <https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D7802&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=HTW18FpqsJA4wuqlef63rFnAMKqEkZ38LG15e3QE8Rc%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D7802&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=HTW18FpqsJA4wuqlef63rFnAMKqEkZ38LG15e3QE8Rc%3D&reserved=0>>
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D11422&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2F5lNH3THCpISrrptFEKwWVl8RFQ1T9m%2BPkUihQE%2B9tk%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D11422&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2F5lNH3THCpISrrptFEKwWVl8RFQ1T9m%2BPkUihQE%2B9tk%3D&reserved=0> <https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D11422&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2F5lNH3THCpISrrptFEKwWVl8RFQ1T9m%2BPkUihQE%2B9tk%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D11422&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2F5lNH3THCpISrrptFEKwWVl8RFQ1T9m%2BPkUihQE%2B9tk%3D&reserved=0>>
Over the last year or so, the Keycloak community has undergone a lot of conversations on database support.
Historically, it’s provided support for MariaDB, MSSQL, MySQL, Oracle, PostgreSQL, and more.
However, going forward, Keycloak plans to only provide first class support for PostgreSQL and CockroachDB databases. CockroachDB uses the same wire protocol as PostgreSQL, so really they’re supporting 1 database type. You can read more about it all at the following links:
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.keycloak.org%2F2022%2F02%2Fdbs.html&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=yTqxQLhGj4yCTQ%2Fnl6ridH7pB9%2F8wc2d%2BTA8cCu0w7U%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.keycloak.org%2F2022%2F02%2Fdbs.html&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=yTqxQLhGj4yCTQ%2Fnl6ridH7pB9%2F8wc2d%2BTA8cCu0w7U%3D&reserved=0> <https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.keycloak.org%2F2022%2F02%2Fdbs.html&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=yTqxQLhGj4yCTQ%2Fnl6ridH7pB9%2F8wc2d%2BTA8cCu0w7U%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.keycloak.org%2F2022%2F02%2Fdbs.html&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=yTqxQLhGj4yCTQ%2Fnl6ridH7pB9%2F8wc2d%2BTA8cCu0w7U%3D&reserved=0>>
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.keycloak.org%2F2022%2F07%2Fstorage-map.html&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=q1%2BMldQLmrWd38KXiLlxviiIMaOsDiXXcDGslbY55io%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.keycloak.org%2F2022%2F07%2Fstorage-map.html&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=q1%2BMldQLmrWd38KXiLlxviiIMaOsDiXXcDGslbY55io%3D&reserved=0> <https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.keycloak.org%2F2022%2F07%2Fstorage-map.html&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=q1%2BMldQLmrWd38KXiLlxviiIMaOsDiXXcDGslbY55io%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.keycloak.org%2F2022%2F07%2Fstorage-map.html&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=q1%2BMldQLmrWd38KXiLlxviiIMaOsDiXXcDGslbY55io%3D&reserved=0>>
Personally, I really like PostgreSQL. I use it for a number of other projects. But I think we’re pretty wedded to MySQL/MariaDB with Koha, and maybe we just need to own that?
David Cook
Senior Software Engineer
Prosentient Systems
Suite 7.03
6a Glen St
Milsons Point NSW 2061
Australia
Office: 02 9212 0899
Online: 02 8005 0595
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.koha-community.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fkoha-devel&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3h6jayfnHhuYlU2XHaIgQuj5PvC4fR11SI58xe4Z2Ag%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.koha-community.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fkoha-devel&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3h6jayfnHhuYlU2XHaIgQuj5PvC4fR11SI58xe4Z2Ag%3D&reserved=0> website : https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.koha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=7oxWxYoeWacmmMf15vANzMVtLuevbWBkgmReOtKhY%2FA%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.koha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=7oxWxYoeWacmmMf15vANzMVtLuevbWBkgmReOtKhY%2FA%3D&reserved=0> git : https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgit.koha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=XHqzAuAVzGWJ8rD0bYqPp5eqTMvCuJcuN1P1f%2FrgrPI%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgit.koha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=XHqzAuAVzGWJ8rD0bYqPp5eqTMvCuJcuN1P1f%2FrgrPI%3D&reserved=0> bugs : https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=FhKRY4cBmXAbpMK9ZfTvmWKePfIOEEHeetknV8YwGJY%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=FhKRY4cBmXAbpMK9ZfTvmWKePfIOEEHeetknV8YwGJY%3D&reserved=0>
-- Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system maintainer 🦄 BibLibre, France _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.koha-community.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fkoha-devel&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3h6jayfnHhuYlU2XHaIgQuj5PvC4fR11SI58xe4Z2Ag%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.koha-community.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fkoha-devel&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3h6jayfnHhuYlU2XHaIgQuj5PvC4fR11SI58xe4Z2Ag%3D&reserved=0> website : https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.koha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=7oxWxYoeWacmmMf15vANzMVtLuevbWBkgmReOtKhY%2FA%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.koha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=7oxWxYoeWacmmMf15vANzMVtLuevbWBkgmReOtKhY%2FA%3D&reserved=0> git : https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgit.koha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=XHqzAuAVzGWJ8rD0bYqPp5eqTMvCuJcuN1P1f%2FrgrPI%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgit.koha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=XHqzAuAVzGWJ8rD0bYqPp5eqTMvCuJcuN1P1f%2FrgrPI%3D&reserved=0> bugs : https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=FhKRY4cBmXAbpMK9ZfTvmWKePfIOEEHeetknV8YwGJY%3D&reserved=0<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C0def9e5a25da444295ba08dad7d3135c%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638059598833427540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=FhKRY4cBmXAbpMK9ZfTvmWKePfIOEEHeetknV8YwGJY%3D&reserved=0>
We are not giving up, we never really tried. It could stay a long term goal, waiting for someone to work on it. I don't think we should start again adding MySQLisms. Le mar. 6 déc. 2022 à 02:49, David Cook <dcook@prosentient.com.au> a écrit :
Hi all,
Should we formally give up on trying to provide PostgreSQL support?
I find it highly unlikely that we will ever provide it.
We may as well close issues like the following:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7365
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7802
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11422
Over the last year or so, the Keycloak community has undergone a lot of conversations on database support.
Historically, it’s provided support for MariaDB, MSSQL, MySQL, Oracle, PostgreSQL, and more.
However, going forward, Keycloak plans to only provide first class support for PostgreSQL and CockroachDB databases. CockroachDB uses the same wire protocol as PostgreSQL, so really they’re supporting 1 database type. You can read more about it all at the following links:
https://www.keycloak.org/2022/02/dbs.html
https://www.keycloak.org/2022/07/storage-map.html
Personally, I really like PostgreSQL. I use it for a number of other projects. But I think we’re pretty wedded to MySQL/MariaDB with Koha, and maybe we just need to own that?
David Cook
Senior Software Engineer
Prosentient Systems
Suite 7.03
6a Glen St
Milsons Point NSW 2061
Australia
Office: 02 9212 0899
Online: 02 8005 0595
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/
On 07.12.22 21:59, Jonathan Druart wrote:
We are not giving up, we never really tried. It could stay a long term goal, waiting for someone to work on it. I don't think we should start again adding MySQLisms.
+1 My question would also be how this decision would impact our coding guidelines.
Le mar. 6 déc. 2022 à 02:49, David Cook <dcook@prosentient.com.au> a écrit :
Hi all,
Should we formally give up on trying to provide PostgreSQL support?
I find it highly unlikely that we will ever provide it.
We may as well close issues like the following:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7365
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7802
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11422
Over the last year or so, the Keycloak community has undergone a lot of conversations on database support.
Historically, it’s provided support for MariaDB, MSSQL, MySQL, Oracle, PostgreSQL, and more.
However, going forward, Keycloak plans to only provide first class support for PostgreSQL and CockroachDB databases. CockroachDB uses the same wire protocol as PostgreSQL, so really they’re supporting 1 database type. You can read more about it all at the following links:
https://www.keycloak.org/2022/02/dbs.html
https://www.keycloak.org/2022/07/storage-map.html
Personally, I really like PostgreSQL. I use it for a number of other projects. But I think we’re pretty wedded to MySQL/MariaDB with Koha, and maybe we just need to own that?
David Cook
Senior Software Engineer
Prosentient Systems
Suite 7.03
6a Glen St
Milsons Point NSW 2061
Australia
Office: 02 9212 0899
Online: 02 8005 0595
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website :https://www.koha-community.org/ git :https://git.koha-community.org/ bugs :https://bugs.koha-community.org/
participants (5)
-
David Cook -
Fridolin SOMERS -
Jonathan Druart -
Katrin Fischer -
Marcel de Rooy