whichdb

IBM Informix

active

by IBM (co-developed with HCLSoftware) · since 1981 · also known as Informix, Informix Dynamic Server, IDS

Low-maintenance embeddable RDBMS with built-in TimeSeries, still quietly running retail and telco systems.

relationaltime-seriesdocumentspatialdatabase engineproprietarylegacy
Website Docs Compare Find similar

Overview

Informix is a relational database known for running for years with almost no DBA attention, which made it popular for embedding in retail point-of-sale, telecom and utility systems. Its distinctive pieces are a native TimeSeries storage type that is very compact for meter and sensor data, MACH 11 high-availability clusters, Enterprise Replication for multi-site active-active, and a wire listener that speaks the MongoDB protocol. IBM still owns it and co-develops it with HCLSoftware; version 15 lifted many old size limits and fix packs ship regularly (15.0.1.18 in September 2026). It is a solid choice for existing estates but has a small community for new projects.

Transactional apps (OLTP)Time-series dataIoT & telemetryEmbedded / in-process

Strengths & trade-offs

Strengths

  • +Runs unattended for years in embedded deployments with minimal tuning
  • +Native TimeSeries type stores regular sensor/meter readings very compactly
  • +Enterprise Replication enables multi-site active-active topologies
  • +MongoDB wire listener lets document apps use Informix as a back end

Trade-offs

  • −Small and ageing community; few new tools target it
  • −Docker Hub developer image is no longer updated
  • −Unclear long-term investment compared with Db2

Great for

  • +Retail store and point-of-sale back ends
  • +Smart-meter and utility time-series data
  • +Telecom provisioning systems
  • +Embedded databases inside OEM appliances

Think twice for

  • −Greenfield cloud-native projects
  • −Analytics at warehouse scale
  • −Teams needing a large hiring pool

Capabilities

Native or official first-party support · 14 of 25 tracked

✓Transactions
✓Joins
✓Secondary indexes
✓Full-text search
✓Geospatial
✓JSON
✓Change data capture
✓Triggers
✓Stored procedures
✓Durable persistence
✓Compression
✓Encryption at rest
✓Role-based access
✓Online schema changes
–Vector search
–Materialized views
–TTL / expiry
–Pub/Sub
–Columnar storage
–In-memory
–Time travel
–Branching
–Streaming ingest
–Offline sync
–Runs in WebAssembly

Scale & consistency

Comfortable data size
Medium · ≤ 10 TB
Horizontal scaling
Addon
Multi-region
Active active
Transactions
Full ACID
Consistency
Strong
Schema
Strict
Architecture
Client server, Primary replica, Multi primary, Shared storage
Query languages
SQL, SPL

Enterprise Replication supports multi-site update-anywhere topologies and sharded JSON collections.

Deployment

Self-hosted Vendor-managed cloud Serverless Embedded Edge Kubernetes operator

Ecosystem

compatible withMongoDB
apis & protocolsSQLI, DRDA, ODBC, JDBC, MongoDB wire protocol, REST
client languagesC, Java, Python, JavaScript, C#, ESQL/C

Alternatives to IBM Informix

Compare all→
IBM Db2Relational45.5

IBM's enterprise RDBMS for Linux, UNIX, Windows and z/OS, with BLU columnar and pureScale clustering.

ibm-informix vs ibm-db2 →
PostgreSQLRelational93.2

The extensible, standards-first open-source relational database.

ibm-informix vs postgresql →
TimescaleDBTime-Series47.1

PostgreSQL extension adding hypertables, columnar compression and continuous aggregates for time series.

ibm-informix vs timescaledb →
Oracle DatabaseRelational56.9

The enterprise heavyweight: RAC, Data Guard and a converged engine for SQL, JSON, graph and vectors.

ibm-informix vs oracle-database →
Microsoft SQL ServerRelational71.0

Microsoft's flagship RDBMS: T-SQL, columnstore, Always On, and now native vectors and JSON.

ibm-informix vs sql-server →
GridDBTime-Series10.7

Toshiba's memory-first container database for IoT time series, with per-container ACID and SQL.

ibm-informix vs griddb →

IBM Informix FAQ

What is IBM Informix?

IBM Informix is a relational database by IBM (co-developed with HCLSoftware), first released in 1981. Informix is a relational database known for running for years with almost no DBA attention, which made it popular for embedding in retail point-of-sale, telecom and utility systems. Its distinctive pieces are a native TimeSeries storage type that is very compact for meter and sensor data, MACH 11 high-availability clusters, Enterprise Replication for multi-site active-active, and a wire listener that speaks the MongoDB protocol. IBM still owns it and co-develops it with HCLSoftware; version 15 lifted many old size limits and fix packs ship regularly (15.0.1.18 in September 2026). It is a solid choice for existing estates but has a small community for new projects.

Is IBM Informix open source?

No. IBM Informix is proprietary, closed-source software.

Does IBM Informix support ACID transactions?

Yes. IBM Informix supports full ACID transactions, with strong consistency.

Does IBM Informix scale horizontally?

IBM Informix scales horizontally through an official extension, proxy or edition rather than in the core engine. It is comfortable at medium scale (≤ 10 TB). It supports active-active multi-region writes.

How can I run IBM Informix?

You can self-host it.

What is IBM Informix best for?

IBM Informix is a strong fit for retail store and point-of-sale back ends; smart-meter and utility time-series data; and telecom provisioning systems. Think twice for greenfield cloud-native projects.

What are the best alternatives to IBM Informix?

Common alternatives to IBM Informix include IBM Db2, PostgreSQL, TimescaleDB, Oracle Database and Microsoft SQL Server. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.

How popular is IBM Informix?

IBM Informix ranks #115 of 844 databases on the WhichDB Score (26.0/100), and #37 among relational databases. The score combines public adoption signals such as package downloads, GitHub activity, job posts and developer discussion.