Related question: Is anyone working on porting the Koha database structure (and codebase) to Postgresql? (because of course everyone has unlimited time and energy)
With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 8888 ext.1 | libr...@dml.vic.edu.au | library.dmlibrary.org.au -----Original Message----- From: Koha <koha-boun...@lists.katipo.co.nz> On Behalf Of Coehoorn, Joel Sent: Saturday, 14 December 2019 2:49 PM To: Charles Kelley <cmkelley...@gmail.com> Cc: Discussion Group Koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] Difference Between MariaDB and MySQL There's some fun history here. MariaDB was created when Oracle bought out Sun Microsystems in January 2010. Sun had owned the MySql DB project, but since the project was open source that's not the same as full ownership of the code itself. Oracle doesn't exactly have the best reputation as a good steward for open source projects, so when the acquisition was announced several prominent MySql contributors started their own project based on the then-current MySql code. The express purpose of the project is to ensure a MySql-compatible database remains available should Oracle start to behave poorly. So, then, the whole point of the MariaDB project is that it should be compatible with MySql. Additionally, the licensing used with MariaDB is seen as a little better (more permissive for end users, while also safer for the "pure" open source projects like Debian). As for the Oracle situation, MariaDB has been partially successful. The existence of the project has effectively prevented Oracle from closing off MySql code in favor or their prior Oracle Database (the pricing model for which would shock you -- they have customers who pay over $100,000 for a single instance). However, it has not stopped Oracle from allowing the project to become stagnant. MySql (and MariaDB) have until recently lacked *many* modern database features: CTEs, recursive queries, lateral joins, windowing functions, transaction DDL, correct/ansi NULL handling by default... I could go on and on and on. Sql Server, Postgresql, and Oracle have all had all of those features for over a decade. Really, **no one** should have started new projects with MySql (or MariaDB) from around 2012 -- when it was clear MySql had fallen far behind and wasn't progressing -- through April of 2018, when MySql 8.0 finally went GA. Today, MySql is (thankfully) finally advancing as a project again, but it still has some catch-up to do, and given a choice I'd much prefer to be using Postgresql in Koha. Joel Coehoorn Director of Information Technology 402.363.5603 *jcoeho...@york.edu <jcoeho...@york.edu>* *Please contact helpd...@york.edu <helpd...@york.edu> for technical assistance.* The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society On Thu, Dec 12, 2019 at 12:15 AM Charles Kelley <cmkelley...@gmail.com> wrote: > Hi, all! > > Is there a difference between MariaDB and MySQL in the working > environment of Koha? > > Thanks for your input. > > -- > -- Charles. > > Charles Kelley, MLS > PSC 704 Box 1029 > APO AP 96338 > > Charles Kelley > 1-5-2 Tsukimino #210 > Yamato-shi, Kanagawa-ken, 〒242-0002 > JAPAN > > 1-301-741-7122 [US cell] > 011-81-80-4714-5490 [JPN cell] > > mnogoja...@aol.com [h] > cmkelley...@gmail.com [p] > > linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> > Meeting Your Information Needs. Virtually. > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha -- Click here to report this message as spam: https://console.mailguard.com.au/ras/1X7zZKjNl5/6STDFRfDhGLpkmDiXDV6yr/0.5 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
