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

IBM Informix vs SQLite comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 4, 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

IBM Informix
Ranking in Embedded Database
9th
Average Rating
8.2
Reviews Sentiment
7.5
Number of Reviews
17
Ranking in other categories
Relational Databases Tools (28th)
SQLite
Ranking in Embedded Database
4th
Average Rating
7.2
Reviews Sentiment
5.5
Number of Reviews
8
Ranking in other categories
Open Source Databases (17th)
 

Mindshare comparison

As of November 2026, in the Embedded Database category, the mindshare of IBM Informix is 4.1%, up from 2.0% compared to the previous year. The mindshare of SQLite is 13.0%, down from 25.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Embedded Database Mindshare Distribution
ProductMindshare (%)
SQLite13.0%
IBM Informix4.1%
Other82.9%
Embedded Database
 

Featured Reviews

Nasir Niamat - PeerSpot reviewer
DB Consultant at i2c
Has offered a cost-effective option despite frequent technical issues and limited market demand
We find some bugs in IBM Informix. Maybe we are using it more aggressively than others. Every month or every second month, we find some bugs in it, which is not ideal. It should be rare, not this frequent. The good thing is they cover those bugs in the next release within weeks or days on demand. IBM Informix should become hybrid and should include AI features similar to other DBMS systems such as Snowflake, Redshift, and DataBricks. This would help its value rise with the market.
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 don't have any problems with the Informix Database."
"Replication is a valuable feature and easy to use."
"IBM Informix benefits users with high availability and good integration capabilities."
"The most valuable feature is concurrency and locking because my customers usually use databases in OLTP mode. So, for a large number of competitive users. Other features that are well valued are quick large-scale data types. It is better than Oracle."
"Not looking at Informix would really mean a shot in your own leg before walking a long distance."
"This solution has made financial reporting possible by allowing financial people the opportunity to set Informix to "Auto Pilot" so that they can attend other duties."
"My advice is to take it; you will never regret it."
"The initial setup is pretty easy."
"I use Flutter Technology with the JSF plugin."
"The product is lightweight and highly scalable."
"I haven't encountered any problems in my use cases. So, it has been a stable product for me."
"For me it was a really fast setup, I only needed to include a library into my application."
"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."
"Whenever I need a single file database that works server-less, cross-platform and has acid properties, I use SQLite."
"It was a bit easy to use compared to other tools. It's simple. I found it pretty easy to execute my SQL queries."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
 

Cons

"The solution doesn't include functionality like data anonymization."
"The solution lacks some functionality."
"The solution should offer replication. It would be helpful if the solution would allow us to access third-party tools."
"I would like to see backups from secondary servers."
"This solution is in need of more current tools."
"For me, it's always too expensive. The problem is that Informix sometimes competes with free products, so yes, it's very expensive, but when we're talking about licensed products like SQL Server or anything, the midsize pricing could be significantly improved."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"In my opinion, the packages could be improved. The version I use doesn't allow for packages. I can do some general procedures, but no packages like in Oracle. So, develop separate modules in SQL language. This would be most beneficial for me."
"I used both SQLite and MySQL and I observed that SQLite’s capabilities are inferior to MySQL."
"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."
"A potential drawback is that the database file stored within the application's local storage could be accessible to users."
"It could have a user-friendly GUI and better intelligence features."
"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."
"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."
"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."
 

Pricing and Cost Advice

"The free edition can be enough to handle moderate-size implementations, but you may want a pay for edition to benefit from more functionality, such as replication."
"I am not aware of the licensing costs or terms."
"For me, it's always too expensive."
"The product has reasonable pricing. We purchase its yearly license."
"It's a good value."
"It's not expensive."
"The tool is open-source."
"I rate the product’s pricing a six out of ten."
report
Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.
922,349 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business9
Midsize Enterprise2
Large Enterprise8
By reviewers
Company SizeCount
Small Business5
Midsize Enterprise1
Large Enterprise3
 

Questions from the Community

What is your experience regarding pricing and costs for IBM Informix?
There is a cost reason to move from IBM Informix. It is relatively cheaper than Oracle. The second reason is that moving the whole application to a new database would require significant cost. The ...
What needs improvement with IBM Informix?
We find some bugs in IBM Informix. Maybe we are using it more aggressively than others. Every month or every second month, we find some bugs in it, which is not ideal. It should be rare, not this f...
What is your primary use case for IBM Informix?
We are using IBM Informix for OLTP systems. We are using IBM Informix although it is a technology that is not very popular compared to others. We are using it because our application was initially ...
Ask a question
Earn 20 points
 

Comparisons

 

Also Known As

Informix
No data available
 

Overview

 

Sample Customers

Shaspa, Hildebrand, Kaifa, Ranhill Powertron, Federaci‹ Farmacutica (FedeFarma), Camden Council, The German Aerospace Center (DLR), Myers, Votorantim Group, Doosan Infracore, GreenIvory
Oracle, Bloomberg, Bentley, Mozilla
Find out what your peers are saying about IBM Informix vs. SQLite and other solutions. Updated: November 2026.
922,349 professionals have used our research since 2012.