180 lines
9.3 KiB
HTML
180 lines
9.3 KiB
HTML
<h1 id="awesome-mariadb">awesome-mariadb</h1>
|
||
<p>A curated list of awesome MariaDB resources, maintained by <a
|
||
href="https://vettabase.com">Vettabase</a> and sponsored by the <a
|
||
href="https://mariadb.org/">MariaDB Foundation</a>.</p>
|
||
<p><a href="https://github.com/sindresorhus/awesome"><img
|
||
src="https://cdn.rawgit.com/sindresorhus/awesome/d7305f38d29fed78fa85652e3a63e154dd8e8829/media/badge.svg"
|
||
alt="Awesome" /></a> Inspired by the <code>awesome-*</code> trend on
|
||
GitHub.</p>
|
||
<p>Topics are organised by audience, to save people from navigating
|
||
through the noise.</p>
|
||
<p><strong>Awesome MariaDB sublists</strong></p>
|
||
<p>Lists for a specific audience:</p>
|
||
<ul>
|
||
<li><strong><a href="list-dba.md">Awesome MariaDB for Database
|
||
Administrators</a></strong></li>
|
||
<li><strong><a href="list-dev.md">Awesome MariaDB for
|
||
Developers</a></strong></li>
|
||
<li><strong><a href="list-den.md">Awesome MariaDB for Data
|
||
Engineers</a></strong></li>
|
||
</ul>
|
||
<p>Specific topics:</p>
|
||
<ul>
|
||
<li><a href="humour.md">Hilarious 🤣 MariaDB List</a></li>
|
||
<li><a href="list-int.md">Awesome MariaDB Internals and Plugins
|
||
Development</a></li>
|
||
</ul>
|
||
<h2 id="the-problem-we-try-to-solve">The Problem we Try to Solve</h2>
|
||
<p>Why are we maintaining a list that is specifically for MariaDB, and
|
||
not for MySQL and its forks?</p>
|
||
<p>It’s easy to find software, cloud services or educative resources for
|
||
MySQL. Finding MariaDB related resources is a bit more difficult. The
|
||
reason is simple: many authors of MySQL resources assume that, if
|
||
something works with MySQL, it will work with MariaDB as well. And it is
|
||
certainly true that MariaDB and MySQL are very similar. MariaDB was
|
||
initially created by forking MySQL 5.1, and some effort to guarantee
|
||
compatibility was made over the years.</p>
|
||
<p>However, MariaDB and MySQL are diverging more and more over time. So,
|
||
before saying that a MySQL resource works well with MariaDB, you should
|
||
ask yourself some questions:</p>
|
||
<p><strong>Does the Resource Use Some MySQL Unique
|
||
Features?</strong></p>
|
||
<p>In the worst case, a tool won’t work at all, but this is not common.
|
||
It is more common that some features of a tool can’t be used with
|
||
MariaDB. For example, using certain features of the community.mysql
|
||
Ansible module will generate queries that fail with MariaDB.</p>
|
||
<p><strong>Does the Resource take Advantage of MariaDB Unique
|
||
Features?</strong></p>
|
||
<p>Sometimes a resource works on MySQL, but it does things that could be
|
||
done better by taking advantage of MariaDB features. For example, a GUI
|
||
might not allow you to create a <code>UUID</code> or <code>INET6</code>
|
||
columns because these types are not supported by MySQL. An ORM for MySQL
|
||
might not allow you to produce a <code>DELETE ... RETURNING</code> for
|
||
the same reason. A monitoring system for MySQL normally won’t show
|
||
MariaDB-specific metrics.</p>
|
||
<p><strong>Is the Resource Adequately Tested with MariaDB?</strong></p>
|
||
<p>This might not matter much for a blog post. But software projects
|
||
should be well tested with MariaDB. It’s easy to overlook this
|
||
necessity, because one might think that if the code doesn’t return
|
||
strange errors it works. But when a query fails, the application might
|
||
not expose errors. After some time you might find out that some data are
|
||
missing or inconsistent.</p>
|
||
<p><strong>Is the Resource Really “for MySQL and MariaDB”?</strong></p>
|
||
<p>As you can guess, sometimes resources “for MySQL and MariaDB” are
|
||
mostly for MySQL, meaning that they are not thoroughly tested and
|
||
optimised for MariaDB. Any of the problems listed above might apply in
|
||
such cases.</p>
|
||
<p>If you spot these problems in an open source application that
|
||
officially supports MariaDB, please report a bug or contribute a
|
||
bugfix.</p>
|
||
<h2 id="our-solution-awesome-mariadb">Our Solution: Awesome MariaDB</h2>
|
||
<p>When the MariaDB Foundation reached us proposing to sponsor the
|
||
Awesome MariaDB list, we saw it as an opportunity to help tackle the
|
||
above problem. But how exactly?</p>
|
||
<p><strong>Provide a List of Real MariaDB Resources</strong></p>
|
||
<p>In this list, whenever possible, you will only find resources that
|
||
properly support MariaDB. It doesn’t matter to us if it also supports
|
||
MySQL or not, and whether the project’s priority is MariaDB or not. We
|
||
simply want to list “stuff that works well”.</p>
|
||
<p>Ideally, we aim to test all the listed resources with MariaDB. We
|
||
temporarily list resources that we didn’t test yet, but in that case we
|
||
at least checked the documentation and the website for MariaDB support.
|
||
When unsure, we also take a look at the source code.</p>
|
||
<p>Whenever relevant, we indicate if a project is FLOSS software
|
||
(Free/Libre Open Source Software), proprietary downloadable software, or
|
||
a cloud service. When appropriate, we also indicate the supported
|
||
platforms or programming language. These aspects are often very
|
||
important when you’re looking for software that solves a problem.</p>
|
||
<p><strong>Provide a List of Open Source Resources That Have Problems
|
||
with MariaDB</strong></p>
|
||
<p>If a listed resource has problems with MariaDB, we aim to indicate
|
||
this. We try to list such resources only if they are open source or free
|
||
software. In this case, if you decide to use the resource, we warmly
|
||
encourage you to contribute to the project, with the aim of improving
|
||
MariaDB support by applications.</p>
|
||
<p>There are various ways you can contribute improving MariaDB
|
||
support:</p>
|
||
<ul>
|
||
<li>Report bugs describing them clearly, to help software maintainers to
|
||
reproduce them.</li>
|
||
<li>Contribute bugfixes.</li>
|
||
<li>Report mistakes in documentation, technical articles, and even
|
||
printed books.</li>
|
||
<li>Write a guide on how to make an application work smoothly with
|
||
MariaDB, for example in the form of a blog post.</li>
|
||
</ul>
|
||
<p><strong>Knowledge Sharing</strong></p>
|
||
<p>Suppose you consult Awesome MariaDB, and you learn that a certain
|
||
software doesn’t work well with MariaDB because it doesn’t use a certain
|
||
SQL syntax. If you’re a developer, you’ll find out that this syntax
|
||
exists, and what it is for. Hopefully, you will later use this
|
||
information in your daily job to produce better code.</p>
|
||
<p><strong>Grow a Sense of Community</strong></p>
|
||
<p>All the activity listed in the previous point are normal and
|
||
spontaneously happen in a community.</p>
|
||
<p>Let’s grow the MariaDB community to see an increase in these kinds of
|
||
activities, and let’s show support towards resources that aim to work
|
||
well with MariaDB.</p>
|
||
<p><a href="https://memory-alpha.fandom.com/wiki/Make_It_So">Make it
|
||
so!</a></p>
|
||
<p>(yes, adding a nerd Star Trek link was one of our primary goals as
|
||
well)</p>
|
||
<h2 id="contributing">Contributing</h2>
|
||
<p>Contributions welcome!</p>
|
||
<p>If you want to suggest a new resource, remember that this is
|
||
<strong>Awesome MariaDB</strong>, and ask yourself two simple
|
||
questions:</p>
|
||
<ul>
|
||
<li>Does it work well with MariaDB?</li>
|
||
<li>Is it actually awesome?</li>
|
||
</ul>
|
||
<p>If both the answers are yes, you can add links through <a
|
||
href="https://github.com/Vettabase/awesome-mariadb/pulls">pull
|
||
requests</a>. Once a PR is approved, we would appreciate if you take the
|
||
time to notify the maintainer of the resource.</p>
|
||
<p>If you find inaccurate information, obsolete information, or
|
||
resources that are not maintained anymore, please report the problem by
|
||
creating an <a
|
||
href="https://github.com/Vettabase/awesome-mariadb/issues">issue</a>, or
|
||
fix it by yourself by opening a <a
|
||
href="https://github.com/Vettabase/awesome-mariadb/pulls">pull
|
||
request</a>.</p>
|
||
<p>If you contribute to Awesome MariaDB, we encourage you to add your
|
||
name to the <code>CONTRIBUTORS.md</code> file.</p>
|
||
<h2 id="how-to-thank-us">How to Thank Us</h2>
|
||
<p>If you’re the maintainer of a resource we linked, we encourage you to
|
||
show in your resource an <a
|
||
href="https://github.com/sindresorhus/awesome/blob/main/awesome.md#awesome-mentioned-badge">Awesome
|
||
mentioned badge</a>.</p>
|
||
<p>Simply paste this code in your <code>README.md</code> file:</p>
|
||
<pre><code>[](https://github.com/Vettabase/awesome-mariadb)</code></pre>
|
||
<p>The result will look like the following:</p>
|
||
<p><a href="https://github.com/Vettabase/awesome-mariadb"><img
|
||
src="https://awesome.re/mentioned-badge.svg"
|
||
alt="Mentioned in Awesome MariaDB" /></a></p>
|
||
<h2 id="related-awesome-lists">Related Awesome Lists</h2>
|
||
<ul>
|
||
<li><a href="https://github.com/shlomi-noach/awesome-mysql">Awesome
|
||
MySQL</a> - Resources for MySQL and its variants. Only includes
|
||
resources that are open source and available without registration. Their
|
||
quality requirements are stricter than ours.</li>
|
||
<li><a
|
||
href="https://github.com/Releem/awesome-mysql-performance">Awesome MySQL
|
||
Performance</a> - A curated list of awesome links related to MySQL /
|
||
MariaDB / Percona Server configuration tuning for improved
|
||
performance.</li>
|
||
<li><a href="https://github.com/agarcialeon/awesome-database">Awesome
|
||
Database</a> - A categorized community-driven collection of amazingly
|
||
awesome database resources.</li>
|
||
</ul>
|
||
<p>See also <a
|
||
href="https://mariadb.com/docs/server/clients-and-utilities/server-client-software/applications-supporting-mariadb">Applications
|
||
Supporting MariaDB</a>, in the MariaDB Documentation.</p>
|
||
<hr />
|
||
<p>Copyright 2024 2025 Vettabase Ltd and contributors.</p>
|
||
<p>Awesome MariaDB list is licensed under <a
|
||
href="https://creativecommons.org/licenses/by-sa/4.0/">CC BY-SA 4.0
|
||
license</a>.</p>
|
||
<p><a href="https://github.com/Vettabase/awesome-mariadb">mariadb.md
|
||
Github</a></p>
|