We performed a comparison between IBM Informix and SQLite based on real PeerSpot user reviews.
Find out what your peers are saying about SAP, Oracle, Firebird and others in Embedded Database."It supports multiple applications and business intelligence tools."
"For IoT business cases, having Informix Enterprise Edition work on edge computers, like Raspberry Pi and using Informix replication, makes complex situations simple to build and maintain."
"The stability is incredible. I have customers with uptimes of several years."
"So far, we do not have a lot of issues. It's pretty problem-free."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"It supports in-house-built applications in .NET and VB6"
"Every version is faster than the previous."
"The solution's stability, performance, enhanced functionality, and replication are all great features."
"I haven't encountered any problems in my use cases. So, it has been a stable product for me."
"I use Flutter Technology with the JSF plugin."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"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."
"The product is lightweight and highly scalable."
"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."
"The solution really doesn't add new features very often."
"I really would love to have a QT plugin."
"I experienced poor input/output (IO) performance."
"The technical support services need substantial improvement."
"I would like to see backups from secondary servers."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"This product could be made easier to use for beginners."
"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."
"A potential drawback is that the database file stored within the application's local storage could be accessible to users."
"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."
IBM Informix is ranked 6th in Embedded Database with 16 reviews while SQLite is ranked 4th in Embedded Database with 7 reviews. IBM Informix is rated 8.6, while SQLite is rated 7.4. The top reviewer of IBM Informix writes "Quite stable and flexible but not very innovative". On the other hand, the top reviewer of SQLite writes "Good for scenarios where you need offline capabilities within your mobile applications, stable and useful plugin". IBM Informix is most compared with Oracle Database, SQL Server, IBM Db2 Database, MySQL and MariaDB, whereas SQLite is most compared with Firebird SQL, MariaDB, PostgreSQL, MySQL and Oracle Berkeley DB.
See our list of best Embedded Database vendors.
We monitor all Embedded Database 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.