No more typing reviews! Try our Samantha, our new voice AI agent.

Percona Server vs SQLite comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 23, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Percona Server
Ranking in Open Source Databases
8th
Average Rating
8.2
Reviews Sentiment
6.2
Number of Reviews
12
Ranking in other categories
No ranking in other categories
SQLite
Ranking in Open Source Databases
17th
Average Rating
7.2
Reviews Sentiment
5.5
Number of Reviews
8
Ranking in other categories
Embedded Database (4th)
 

Mindshare comparison

As of November 2026, in the Open Source Databases category, the mindshare of Percona Server is 2.6%, up from 2.0% compared to the previous year. The mindshare of SQLite is 4.6%, down from 5.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Open Source Databases Mindshare Distribution
ProductMindshare (%)
Percona Server2.6%
SQLite4.6%
Other92.8%
Open Source Databases
 

Featured Reviews

Pieter Geelen - PeerSpot reviewer
Freelancer at geelen.io
Reliable open-source database has supported our migration and improved e-commerce performance
Percona Server seems great to me overall. If I had to think of any small area for improvement for Percona Server, it would be around the proxy story. When adding a proxy to manage traffic better, we first tried SQL Proxy, but it never really worked for us, which was unfortunate because SQL Proxy offers better optimizations for read performance. We did have success with HAProxy, but it works on a network level, while SQL Proxy was designed to be SQL-aware and distribute parts of the query across the database cluster. The performance gain we were hoping for with SQL Proxy did not materialize, so we remained on the network level with HAProxy. Databases can be finicky regarding the performance they need. We had some disk I/O latency issues, which led us to use different types of nodes in our Kubernetes cluster where we provisioned Percona Server explicitly. There is a lot of IOPS happening under the hood, and while I suspect the application was not very efficient, it was also challenging to identify that we were experiencing performance issues due to disk performance. It would be helpful to clarify the metrics related to disk I/O latency so we could understand where our bottlenecks are.
Neeraj Tiwari - PeerSpot reviewer
Student at Queens University Belfast
Pretty easy to execute my SQL queries but issues while uploading and importing my dataset
It was a bit easy to use compared to other tools. It's simple. I found it pretty easy to execute my SQL queries. Since I was a beginner, it was comfortable for me to learn SQL using SQLite. However, when I used it for my professional work and for my assignments, I found some complications. Maybe I'm not proficient with it, that's why. The main benefit for me was learning. Since I was new to SQL, SQLite helped me understand how to work with structured data.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"We find the product mostly stable."
"I consider Percona Server to be MySQL Enterprise on steroids without licensing fees or restrictions, and it performs exceptionally well."
"Percona Server's scalability is very strong, as it features thread pooling for over 10,000 connections, scales out horizontally, and comes with XtraDB Cluster and ProxySQL, making it very effective."
"Percona Server has positively impacted my organization because it is open source, and if the official MongoDB goes in different directions or makes its product expensive, we can still use Percona Server, which serves as a sort of safety net."
"Percona Server has positively impacted my organization by reducing downtime for applications and improving backup capabilities."
"After switching to Percona Server, we were able to resolve those issues quickly."
"The best feature that Percona Server offers is that it was free."
"In my use of Percona Server, I've found that the replication and High Availability features are the most valuable."
"It was a bit easy to use compared to other tools. It's simple. I found it pretty easy to execute my SQL queries."
"The product is lightweight and highly scalable."
"It is like a baseline; it is one of the things any big organization can start with, and as you mature as a company, you can migrate to more robust options like Pentaho and other databases that are available."
"For me it was a really fast setup, I only needed to include a library into my application."
"Sometimes, you want data to persist within the app even when there's no internet connectivity. To avoid showing blank screens, we can use SQLite to store data locally and then sync it with the cloud database when connectivity is restored."
"I haven't encountered any problems in my use cases. So, it has been a stable product for me."
"Whenever I need a single file database that works server-less, cross-platform and has acid properties, I use SQLite."
"I use Flutter Technology with the JSF plugin."
 

Cons

"Percona Server can be improved by addressing the lag between releasing new versions of MySQL and its Percona support, and also by enhancing the configuration of performance variables to provide more user-friendly and easier to configure options."
"Percona Server can be improved because administration can still be complex, requiring database expertise, and broader built-in visualization would be beneficial along with more beginner-friendly management."
"I would like to add that the user interface is very crowded, which makes it challenging for new engineers to know where to turn, so I had to sit down and understand the documentation before I was able to manage the application myself."
"It doesn't reclaim disk space when rows are deleted."
"I have limited experience to provide detailed insights about needed improvements."
"Percona Server could be improved by adding more advanced query fields, which would be very helpful."
"If I had to think of any small area for improvement for Percona Server, it would be around the proxy story."
"I also think there should be more use cases and documentation on deploying in Kubernetes with real-life examples, as currently, the documentation is minimal, making it difficult in a production situation."
"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."
"A potential drawback is that the database file stored within the application's local storage could be accessible to users."
"SQLite does not have user defined functions like other database management systems do, and you have to write C code, which is a complication that you may not get into for a user defined function."
"Compared to other tools, the performance was less effective than that of Microsoft Access."
"It's not a very fast product. The performance could be better."
"It could have a user-friendly GUI and better intelligence features."
"There are some difficulties on the server side. When syncing data with databases like SQL Server or Oracle, SQLite requires a kind of double effort."
"I used both SQLite and MySQL and I observed that SQLite’s capabilities are inferior to MySQL."
 

Pricing and Cost Advice

Information not available
"The tool is open-source."
"It's not expensive."
"I rate the product’s pricing a six out of ten."
"It's a good value."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
921,774 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Comms Service Provider
23%
Outsourcing Company
11%
Financial Services Firm
10%
Manufacturing Company
8%
Comms Service Provider
17%
Outsourcing Company
12%
Financial Services Firm
9%
University
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business4
Midsize Enterprise4
Large Enterprise3
By reviewers
Company SizeCount
Small Business5
Midsize Enterprise1
Large Enterprise3
 

Questions from the Community

What is your experience regarding pricing and costs for Percona Server?
Since I used the free tier, my experience with pricing, setup cost, and licensing was that it was the best model available at the time.
What needs improvement with Percona Server?
I have limited experience to provide detailed insights about needed improvements. Visibility and advertisement are the improvements I think Percona Server needs.
What is your primary use case for Percona Server?
I was using Percona Server as a MySQL database replacement for an application that needed a database in the background to manage tasks.
Ask a question
Earn 20 points
 

Comparisons

 

Overview

 

Sample Customers

Pricefalls Marketplace, Micpoint, Rent the Runway, Transmart, Wattpad, Singular Group, Invoca, 3E
Oracle, Bloomberg, Bentley, Mozilla
Find out what your peers are saying about Percona Server vs. SQLite and other solutions. Updated: November 2026.
921,774 professionals have used our research since 2012.