Need advice about which tool to choose?Ask the StackShare community!
MariaDB vs Amazon QLDB: What are the differences?
MariaDB: An enhanced, drop-in replacement for MySQL. 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 is designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance; Amazon QLDB: A fully managed ledger database. It is a fully managed ledger database that provides a transparent, immutable, and cryptographically verifiable transaction log owned by a central trusted authority. It can be used to track each and every application data change and maintains a complete and verifiable history of changes over time.
MariaDB and Amazon QLDB can be primarily classified as "Databases" tools.
Some of the features offered by MariaDB are:
- Replication
- Insert Delayed
- Events
On the other hand, Amazon QLDB provides the following key features:
- Immutable and Transparent
- Cryptographically Verifiable
- Serverless
MariaDB is an open source tool with 3.44K GitHub stars and 1.03K GitHub forks. Here's a link to MariaDB's open source repository on GitHub.
We actually use both Mongo and SQL databases in production. Mongo excels in both speed and developer friendliness when it comes to geospatial data and queries on the geospatial data, but we also like ACID compliance hence most of our other data (except on-site logs) are stored in a SQL Database (MariaDB for now)
Pros of Amazon QLDB
Pros of MariaDB
- Drop-in mysql replacement149
- Great performance100
- Open source74
- Free55
- Easy setup44
- Easy and fast15
- Lead developer is "monty" widenius the founder of mysql14
- Also an aws rds service6
- Consistent and robust4
- Learning curve easy4
- Native JSON Support / Dynamic Columns2
- Real Multi Threaded queries on a table/db1