We performed a comparison between MariaDB and SQLite based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases."It is a stable solution."
"The most valuable features of the solution stem from the fact that it is a cloud-based tool, so it is pretty fast."
"From the user's perspective, the performance of the columnar queries is very good in terms of the database when comparing it to the Oracle, and MySQL."
"MariaDB can solve things better than MySQL. Maria DB has better performance than MySQL."
"There is the need for a robust IDE for MongoDB. The existing PHP admin console doesn't meet the client's requirements effectively."
"The documentation is quite straightforward."
"From a customer perspective, MariaDB is a good choice for cluster configuration. It's also easy to operate and cheap."
"The most valuable feature of the solution is a relational database, which is fairly reliable...It is a stable solution."
"The product is lightweight and highly scalable."
"I use Flutter Technology with the JSF plugin."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"The performance could be a bit better."
"It doesn't have the same level of maturity metrics as Postgres."
"It would be good if they can maybe improve the mass import in the database. Currently, for importing a large number of data, we create a CSV file and upload all the things in the system. The system does not activate them by default. We have to do this manually. This may be due to the version we are using, but this is something we would like to see improved."
"The maintenance and performance could be a bit better."
"The GUI could be improved a bit. The user interface needs to be improved."
"Replication could be better, and it's not so simple. It would be better if they had a replication server. It would make things a lot easier. You need to have that replication server, but not in the same server farm. Then there will be a bit of latency between both because you should have one in one city and another one in a different city. That kind of solution should be more baked into every single database today. Mirroring the database in a live environment where any record written on the production server replicates instantly across the fiber on the other server wasn't easy. Many people don't even bother with that, and they just run one server."
"I am editing."
"Document caching is an area of concern in the product, where improvements are required to help MariaDB improve on the previous queries as they are retained, and you can roll back to them."
"I primarily use SQLite for small-scale applications due to its limitations in storing large amounts of data. For larger-scale projects, I typically opt for MySQL or other alternatives. Storing a large number of dates in SQLite can significantly impact its performance."
"It could have a user-friendly GUI and better intelligence features."
"The performance could be better."
MariaDB is ranked 3rd in Open Source Databases with 30 reviews while SQLite is ranked 9th in Open Source Databases with 2 reviews. MariaDB is rated 8.0, while SQLite is rated 7.6. The top reviewer of MariaDB writes "Allows for fetching data from multiple correlated or related databases in a single query, user-friendly and easy to handle". On the other hand, the top reviewer of SQLite writes "Helps to access data directly from my local storage or databases". MariaDB is most compared with SQL Server, PostgreSQL, Oracle Database, MySQL and IBM Db2 Database, whereas SQLite is most compared with Firebird SQL, PostgreSQL, MySQL and Oracle Berkeley DB.
See our list of best Open Source Databases vendors.
We monitor all Open Source Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.