# IBM Informix vs SingleStore Comparison | | IBM Informix | SingleStore | |---|---|---| | **Star Rating** | 4.5 out of 5 | 4.5 out of 5 | | **Total Reviews** | 111 | 118 | | **Largest Market Segment** | Enterprise (43.5% of reviews) | Small-Business (37.7% of reviews) | | **Entry Level Price** | See IBM website or contact IBM PVU, VPC,User licensing | No pricing available | --- ## Ratings Comparison | Rating | IBM Informix | SingleStore | |---|---|---| | **Meets Requirements** | 9.2 (79 reviews) | 8.9 (99 reviews) | | **Ease of Use** | 9.1 (79 reviews) | 8.7 (98 reviews) | | **Ease of Setup** | 8.9 (57 reviews) | 8.4 (59 reviews) | | **Ease of Admin** | 9.3 (56 reviews) | 8.1 (58 reviews) | | **Quality of Support** | 8.5 (76 reviews) | 8.7 (90 reviews) | | **Has the product been a good partner in doing business?** | 7.8 (56 reviews) | 8.8 (52 reviews) | | **Product Direction (% positive)** | 6.0 (78 reviews) | 8.6 (89 reviews) | --- ## Pricing ### IBM Informix #### Entry-Level Pricing Plan: Informix Enterprise Edition / Informix Advanced Enterprise Edition Price: See IBM website or contact IBM PVU, VPC,User licensing Description: Various flexible licensing options available, including user, processor/virtual core. Try Informix for free: https://ibm.biz/Bdzp7v [Browse all 5 editions](https://www.g2.com/products/ibm-informix/pricing) #### Free Trial Yes ### SingleStore #### Entry-Level Pricing No pricing available #### Free Trial Yes --- ## Features Comparison By Category ### Data Replication | Product | Score | Reviews | |---|---|---| | **IBM Informix** | 8.5/10 | 7 | | **SingleStore** | N/A | N/A | #### Management | Feature | IBM Informix | SingleStore | |---|---|---| | **Real-Time Analytics** | 8.6 (7 reviews) | Not enough data | | **Solution Integration** | 8.1 (6 reviews) | Not enough data | | **Infrastructure Compatibility** | 8.1 (6 reviews) | Not enough data | | **Monitoring** | 8.6 (6 reviews) | Not enough data | #### Solution Provision | Feature | IBM Informix | SingleStore | |---|---|---| | **System Failover** | 8.9 (6 reviews) | Not enough data | | **Pay by Usage** | 8.3 (5 reviews) | Not enough data | | **Service Provision** | 9.0 (5 reviews) | Not enough data | ### Relational Databases | Product | Score | Reviews | |---|---|---| | **IBM Informix** | 8.8/10 | 81 | | **SingleStore** | 8.9/10 | 81 | #### Management | Feature | IBM Informix | SingleStore | |---|---|---| | **Data Schema** | 8.9 (11 reviews) | 9.3 (28 reviews) | | **Query Language** | 9.1 (11 reviews) | 9.4 (29 reviews) | | **ACID - Complaint** | 8.5 (10 reviews) | 9.0 (23 reviews) | | **Data Replication** | 9.2 (11 reviews) | 8.8 (23 reviews) | #### Support | Feature | IBM Informix | SingleStore | |---|---|---| | **Text Search** | 7.8 (10 reviews) | 8.6 (23 reviews) | | **Data Types** | 8.5 (11 reviews) | 9.3 (25 reviews) | | **Languages** | 8.8 (11 reviews) | 8.7 (22 reviews) | | **Operating Systems** | 8.8 (11 reviews) | 8.8 (18 reviews) | #### Security | Feature | IBM Informix | SingleStore | |---|---|---| | **Database Locking** | 8.6 (11 reviews) | 8.5 (19 reviews) | | **Access Control** | 9.1 (11 reviews) | 8.9 (19 reviews) | | **Encryption** | 8.2 (11 reviews) | 8.6 (19 reviews) | | **Authentication** | 8.8 (11 reviews) | 8.9 (20 reviews) | #### Performance | Feature | IBM Informix | SingleStore | |---|---|---| | **Disaster Recovery** | 8.5 (10 reviews) | 8.8 (20 reviews) | | **Data Concurrency** | 8.7 (10 reviews) | 9.0 (22 reviews) | | **Workload Management** | 8.3 (11 reviews) | 8.8 (23 reviews) | | **Advanced Indexing** | 8.7 (10 reviews) | 9.0 (23 reviews) | | **Query Optimizer** | 9.0 (10 reviews) | 9.1 (24 reviews) | #### Database Features | Feature | IBM Informix | SingleStore | |---|---|---| | **Storage** | 9.1 (66 reviews) | 9.0 (70 reviews) | | **Availability** | 9.5 (67 reviews) | 9.2 (69 reviews) | | **Stability** | 9.3 (66 reviews) | 8.9 (69 reviews) | | **Scalability** | 9.2 (65 reviews) | 9.1 (68 reviews) | | **Security** | 8.8 (62 reviews) | 8.9 (61 reviews) | | **Data Manipulation** | 9.1 (65 reviews) | 8.8 (66 reviews) | | **Query Language** | 9.0 (66 reviews) | 9.1 (70 reviews) | ### Vector Database | Product | Score | Reviews | |---|---|---| | **IBM Informix** | N/A | N/A | | **SingleStore** | N/A | N/A | #### Data Indexing | Feature | IBM Informix | SingleStore | |---|---|---| | **Semantic Search** | Not enough data | Not enough data | | **Indexing Data** | Not enough data | Not enough data | #### Filters | Feature | IBM Informix | SingleStore | |---|---|---| | **Accurate Search** | Not enough data | Not enough data | | **Single Stage Filtering - Vector Database** | Not enough data | Not enough data | ### Real-time Analytic Database | Product | Score | Reviews | |---|---|---| | **IBM Informix** | N/A | N/A | | **SingleStore** | N/A | N/A | #### Query latency | Feature | IBM Informix | SingleStore | |---|---|---| | **Lower query latency** | Not enough data | Not enough data | | **Continuous queries** | Not enough data | Not enough data | #### Data latency | Feature | IBM Informix | SingleStore | |---|---|---| | **Lower data latency** | Not enough data | Not enough data | | **Data pipeline performance** | Not enough data | Not enough data | #### Connectors | Feature | IBM Informix | SingleStore | |---|---|---| | **Faster ingestion** | Not enough data | Not enough data | | **Built-in connectors** | Not enough data | Not enough data | #### Scale | Feature | IBM Informix | SingleStore | |---|---|---| | **Linearly scalable database** | Not enough data | Not enough data | | **Storage management** | Not enough data | Not enough data | #### Architecture | Feature | IBM Informix | SingleStore | |---|---|---| | **Data security** | Not enough data | Not enough data | | **Lockless architecture** | Not enough data | Not enough data | ### Backup | Product | Score | Reviews | |---|---|---| | **IBM Informix** | N/A | N/A | | **SingleStore** | N/A | N/A | #### Management | Feature | IBM Informix | SingleStore | |---|---|---| | **Disaster Recovery** | Not enough data | Not enough data | | **Remote Backup** | Not enough data | Not enough data | | **Storage Formats** | Not enough data | Not enough data | | **Scheduled Backups** | Not enough data | Not enough data | | **On-Demand Restoration** | Not enough data | Not enough data | #### Reporting | Feature | IBM Informix | SingleStore | |---|---|---| | **Activity Monitoring** | Not enough data | Not enough data | | **Documentation** | Not enough data | Not enough data | | **Alerts/Notifications** | Not enough data | Not enough data | #### Security | Feature | IBM Informix | SingleStore | |---|---|---| | **Data Encryption** | Not enough data | Not enough data | | **Security and Compliance** | Not enough data | Not enough data | | **Deduplication ** | Not enough data | Not enough data | --- ## Categories **Shared Categories (1):** [Relational Databases](https://www.g2.com/categories/relational-databases) **Unique to IBM Informix (1):** [Data Replication Software](https://www.g2.com/categories/data-replication) **Unique to SingleStore (2):** [Real-time Analytic Database Software](https://www.g2.com/categories/real-time-analytic-database), [Vector Database Software](https://www.g2.com/categories/vector-database) --- ## Reviewer Demographics ### By Company Size | Segment | IBM Informix | SingleStore | |---|---|---| | **Small-Business** | 23.9% | 37.7% | | **Mid-Market** | 32.6% | 24.6% | | **Enterprise** | 43.5% | 37.7% | ### By Industry #### IBM Informix - **Information Technology and Services:** 16.3% - **Computer Software:** 13.0% - **Government Administration:** 9.8% - **Retail:** 5.4% - **Insurance:** 5.4% - **Financial Services:** 4.3% - **Telecommunications:** 4.3% - **Education Management:** 3.3% - **Logistics and Supply Chain:** 3.3% - **Business Supplies and Equipment:** 2.2% - **Other:** 32.6% #### SingleStore - **Information Technology and Services:** 21.9% - **Computer Software:** 18.4% - **Financial Services:** 12.3% - **Internet:** 7.0% - **Banking:** 6.1% - **Telecommunications:** 2.6% - **Consumer Services:** 2.6% - **Computer & Network Security:** 2.6% - **Hospital & Health Care:** 2.6% - **Retail:** 1.8% - **Other:** 21.9% --- ## Alternatives ### Alternatives to IBM Informix - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) — 4.4/5 stars (2275 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) — 4.4/5 stars (1675 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) — 4.3/5 stars (1010 reviews) - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) — 4.4/5 stars (678 reviews) - [Veeam Data Platform](https://www.g2.com/products/veeam-data-platform/reviews) — 4.6/5 stars (717 reviews) - [SAP HANA Cloud](https://www.g2.com/products/sap-hana-cloud-2025-10-01/reviews) — 4.3/5 stars (621 reviews) - [Amazon Relational Database Service (RDS)](https://www.g2.com/products/amazon-relational-database-service-rds/reviews) — 4.5/5 stars (906 reviews) - [MariaDB](https://www.g2.com/products/mariadb/reviews) — 4.4/5 stars (226 reviews) - [SQLite](https://www.g2.com/products/sqlite/reviews) — 4.3/5 stars (260 reviews) - [Teradata Vantage](https://www.g2.com/products/teradata-teradata-vantage/reviews) — 4.3/5 stars (373 reviews) ### Alternatives to SingleStore - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) — 4.4/5 stars (678 reviews) - [CockroachDB](https://www.g2.com/products/cockroachdb/reviews) — 4.3/5 stars (29 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) — 4.4/5 stars (1675 reviews) - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) — 4.4/5 stars (2275 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) — 4.3/5 stars (1010 reviews) - [Amazon Aurora](https://www.g2.com/products/amazon-aurora/reviews) — 4.5/5 stars (457 reviews) - [IBM Db2](https://www.g2.com/products/ibm-db2/reviews) — 4.1/5 stars (682 reviews) - [Teradata Vantage](https://www.g2.com/products/teradata-teradata-vantage/reviews) — 4.3/5 stars (373 reviews) - [Google Cloud SQL](https://www.g2.com/products/google-cloud-sql/reviews) — 4.5/5 stars (366 reviews) - [SAP HANA Cloud](https://www.g2.com/products/sap-hana-cloud-2025-10-01/reviews) — 4.3/5 stars (621 reviews) --- ## Top Discussions ### IBM Informix - Title: [Version 11.70 - Where should look if I am having problems with triggers via a stored procedure?](https://www.g2.com/discussions/version-11-70-where-should-look-if-i-am-having-problems-with-triggers-via-a-stored-procedure) — 2 comments, 1 upvote > **Top comment:** "Hi Rhonda, First of all you should clearly and at least look at upgrading to version 14.10 xC2, because 11.70 maintenance will stop by March 30th..." - Title: [Standard 4GL is still a great product, Why don't add new features?](https://www.g2.com/discussions/standard-4gl-is-still-a-great-product-why-don-t-add-new-features) — 1 comment, 1 upvote > **Top comment:** "IBM made a decision long ago to stop adding features to 4GL. You can get modern versions of 4GL from 4Js (Genero) and Querix (Lycia). Both are proper..." - Title: [How do I program 4GL and Create Mobile Apps.](https://www.g2.com/discussions/how-do-i-program-4gl-and-create-mobile-apps) — 1 comment, 1 upvote > **Top comment:** "Hi Hwee, Form the feedback I received from several people, the best tools to develop mobile apps are the tools initially designed for that: they need to..." ### SingleStore - Title: [What is the relationship between MemSQL and MySQL?](https://www.g2.com/discussions/general-bbf6d738-7616-4865-809c-1fb011651a69) — 2 comments, 1 upvote > **Top comment:** "MemSQL and MySQL are both ANSI SQL-compliant, so the same queries work on both - as is, or with minor changes. In addition, MemSQL directly supports the..." - Title: [Is there provisin forthe software to be open source or will this be only following a Pay for Services model?](https://www.g2.com/discussions/is-there-provisin-forthe-software-to-be-open-source-or-will-this-be-only-following-a-pay-for-services-model) — 1 comment, 1 upvote > **Top comment:** "Run the SingleStoreDB anywhere, free forever. Run it in production up to a capacity limit with no time limits. Available here:..." - Title: [How the complex and internal architecture is different from native MySQL](https://www.g2.com/discussions/how-the-complex-and-internal-architecture-is-different-from-native-mysql) — 1 comment, 1 upvote > **Top comment:** "SingleStoreDB and MySQL do not share any code. SingleStoreDB is a real-time, unified distributed SQL database built from the ground up for maximum..." - Title: [When does it hang running memsql-ops --start sometimes](https://www.g2.com/discussions/when-does-it-hang-running-memsql-ops-start-sometimes) — 1 comment, 1 upvote > **Top comment:** "Comment deleted by user." - Title: [Can we Use Amazon Kinesis to ingest data into memsql](https://www.g2.com/discussions/can-we-use-amazon-kinesis-to-ingest-data-into-memsql) — 1 comment, 1 upvote > **Top comment:** "The answer should certainly be yes, for most use cases. Kinesis is mentioned in this blog post: https://www.memsql.com/content/kafka/. For specifics, please..." --- **Source:** [G2.com](https://www.g2.com) | [Comparison Page](https://www.g2.com/compare/ibm-informix-vs-singlestore)