MySQL has a few 'quirks' to how it manages things like multiple databases, which may lead you to making less good decisions if you tried to take your experience over to different DBMS, especially in bigger enterprise roles. SQLite's simplicity actually avoids most of these experiences, which is not helpful to you if that is what you hope to learn. If your aim is actually to have a bit of 'operational' experience, in terms of things like what command line tools might be available as standard for the DBMS, understanding how the DBMS handles multiple databases, when to use multiple schemas vs multiple databases, some basic privilege management etc. As others have said, SQLite would offer you the ability to very easily get started, and would give you a reasonably standard (if a little basic) SQL dialect to work with. If your aim is to have experience with SQL and any related libraries and frameworks for your language of choice (python, I think?), then it kind of doesn't matter too much which you pick so much. Here's a link to MariaDB's open source repository on GitHub.Īccording to the StackShare community, MariaDB has a broader approval, being mentioned in 496 company stacks & 461 developers stacks compared to SQLite, which is listed in 314 company stacks and 477 developer stacks.Ī question you might want to think about is 'What kind of experience do I want to gain, by using a DBMS?'. MariaDB is an open source tool with 2.82K GitHub stars and 864 GitHub forks. 'Drop-in mysql replacement', 'Great performance' and 'Open source' are the key factors why developers consider MariaDB whereas 'Lightweight', 'Portable' and 'Simple' are the primary reasons why SQLite is favored. MariaDB and SQLite belong to 'Databases' category of the tech stack. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. SQLite reads and writes directly to ordinary disk files. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite is an embedded SQL database engine. On the other hand, SQLite is detailed as ' A software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine'. MariaDB is designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance. Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry. MariaDB vs SQLite: What are the differences?ĭevelopers describe MariaDB as ' An enhanced, drop-in replacement for MySQL'.

Postgres vs mysql vs mariadb