Coming October 25: PeerSpot Awards will be announced! Learn more

MySQL vs SQLite comparison

Cancel
You must select at least 2 products to compare!
Oracle Logo
14,445 views|12,196 comparisons
SQLite Logo
968 views|868 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between MySQL and SQLite based on real PeerSpot user reviews.

Find out in this report how the two Open Source Databases solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed MySQL vs. SQLite report (Updated: September 2022).
632,611 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"One of the most valuable features is MySQL's ability to run our email system. We use a system called Colab.""However, it is easy to scale MySQL using the functions provided with the product.""It's a good tool, a good database platform.""A good traditional database that supports JSON.""The solution is easy to use.""The initial setup for the SQL database is not complex and it even integrates into the platform. You set up the recipe and then just follow the runbook, the build book. Then it works as long as you follow the procedures.""MySQL has cross-platform support for multiple operating systems. The backups on a Linux machine can be restored on a Windows machine, and vice versa.""It was easy to install."

More MySQL Pros →

"The product is lightweight and highly scalable."

More SQLite Pros →

Cons
"Its performance should be better. When we use big data, it is slow in performance. We should be able to use mirroring for improved performance.""It should have some code analytical functions. It can also have a monitoring tool.""We want high availability and replication features, which are currently missing in this solution. It would be great if they can provide an in-built replication feature, similar to Oracle RAC, in MySQL.""There are some issues with compatibility with Java environments that need to be improved. When Oracle bought this solution there were some driver changes that caused some issues with operations.""On the database side, it should be really lightweight, and the data structure should be like MongoDB.""I would like to have features that allow us to jump between the cloud and our on-premises system.""MySQL could be improved by adding more automation.""The solution could improve by having better performance and security."

More MySQL Cons →

"The performance could be better."

More SQLite Cons →

Pricing and Cost Advice
  • "This is an open-source product that can be used free of charge."
  • "It's an open-source database management system that can be used free of charge."
  • "Microsoft licensing for SQL Server is probably ten times more expensive. I used to work for the government, and I remember when we were looking into upgrading to the enterprise version of SQL Server 2019, the licensing was going to cost 350,000. To get the equivalent in the cloud, it was going to be about four grand to get the same processing power and everything else. With MySQL, it was going to be about 300 for the same licensing. Cost-wise, for sure, there is a huge difference. Would you prefer to pay 300 a month or 3,000 to have the same amount of data resources? You might lose a few options that you need, but it isn't worth the price difference."
  • "This product has a good price point."
  • "There is a licensing cost because we are going for a proprietary product. There are some other versions for which there is no licensing cost."
  • "It has a community version."
  • "It is open-source."
  • "I am not paying, but I am not sure about the exact licensing requirements."
  • More MySQL Pricing and Cost Advice →

    Information Not Available
    report
    Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
    632,611 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The easy access to the data and the ability to sort the data with multiple methods are very valuable features.
    Top Answer:Sometimes, I get lost in the toggles and buttons, and a better visual design would be nice. The layout is not user-friendly or efficient. I would like to be able to sort the data easily without having… more »
    Top Answer:The product is lightweight and highly scalable.
    Top Answer:The solution is open-source. You do not have to pay for it in order to use it.
    Top Answer:It's not a very fast product. The performance could be better. That said, for what we have to do, it doesn't really affect us much.
    Ranking
    1st
    Views
    14,445
    Comparisons
    12,196
    Reviews
    53
    Average Words per Review
    434
    Rating
    7.9
    5th
    Views
    968
    Comparisons
    868
    Reviews
    1
    Average Words per Review
    537
    Rating
    9.0
    Comparisons
    Firebird SQL logo
    Compared 20% of the time.
    PostgreSQL logo
    Compared 12% of the time.
    MariaDB logo
    Compared 10% of the time.
    Oracle Database logo
    Compared 10% of the time.
    SQL Server logo
    Compared 10% of the time.
    Learn More
    SQLite
    Video Not Available
    Overview

    Until its recent acquisition by Oracle, MySQL was possibly the most renowned open source database enterprise package that could be accessed completely for free. With the merger, the server increased both its features and its price tag, but there is still a free version available to the general community to contribute ideas and suggestions.

    MySQL is a fast and relatively inexpensive database management system. It can easily integrate with a wide variety of programming languages, and it is considered to be a very reliable option. One of the most prominent features that customers seem to enjoy is the easy scalability of this system.

    SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine
    Offer
    Learn more about MySQL
    Learn more about SQLite
    Sample Customers
    Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.
    Oracle, Bloomberg, Bentley, Mozilla
    Top Industries
    REVIEWERS
    Computer Software Company20%
    Financial Services Firm9%
    University9%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Comms Service Provider21%
    Computer Software Company20%
    Financial Services Firm9%
    Government5%
    VISITORS READING REVIEWS
    Comms Service Provider39%
    Computer Software Company14%
    Manufacturing Company8%
    Media Company7%
    Company Size
    REVIEWERS
    Small Business49%
    Midsize Enterprise15%
    Large Enterprise36%
    VISITORS READING REVIEWS
    Small Business21%
    Midsize Enterprise17%
    Large Enterprise62%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise30%
    Large Enterprise54%
    Buyer's Guide
    Open Source Databases
    September 2022
    Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases. Updated: September 2022.
    632,611 professionals have used our research since 2012.

    MySQL is ranked 1st in Open Source Databases with 53 reviews while SQLite is ranked 5th in Open Source Databases with 1 review. MySQL is rated 8.0, while SQLite is rated 9.0. The top reviewer of MySQL writes "Has a simple and user-friendly installation". On the other hand, the top reviewer of SQLite writes "Lightweight, easy to set up, and free to use". MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Oracle Database and SQL Server, whereas SQLite is most compared with Firebird SQL, MariaDB, PostgreSQL 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.