Pure Python · No CSDK · No JVM · No libcrypt.so.1

Talk to Informix without linking against IBM's 92 MB tarball.

Every other Informix driver wraps IBM's C SDK or the JDBC JAR. We weren't into that. So we read the protocol and wrote it ourselves — PEP 249, sync + async, pooled, TLS. Within 10% of IBM's own C driver on bulk fetches, 1.6× faster on bulk inserts. No compile step. No LD_LIBRARY_PATH ritual. No libcrypt.so.1 from 2018.

Get started → Compared to IfxPy GitHub

pip install informix-driver

> OUT 01 c3 01 3c 00 00 00 64 00 65 00 00 00 3d 00 06 49 45 45 45 4d 00 00 6c 73 71 6c 65 78 65 63 00 IEEEM..lsqlexec. 00 00 00 00 00 00 06 39 2e 32 38 30 00 00 0c 52 .......9.280...R 44 53 23 52 30 30 30 30 30 30 00 00 05 73 71 6c DS#R000000...sql 69 00 00 00 01 3c 00 00 00 00 00 00 00 00 00 01 i....<......... 00 09 69 6e 66 6f 72 6d 69 78 00 00 07 69 6e 34 ..informix...in4 < IN 01 14 02 3c 10 00 00 64 00 65 00 00 00 3d 00 06 49 45 45 45 49 00 00 6c 73 72 76 69 6e 66 78 00 IEEEI..lsrvinfx. 00 00 00 00 00 00 2f 49 42 4d 20 49 6e 66 6f 72 ....../IBM Infor 6d 69 78 20 44 79 6e 61 6d 69 63 20 53 65 72 76 mix Dynamic Serv 65 72 20 56 65 72 73 69 6f 6e 20 31 35 2e 30 2e er Version 15.0. > OUT 00 02 00 00 00 00 00 49 73 65 6c 65 63 74 20 46 .......Iselect F 49 52 53 54 20 31 20 73 69 74 65 20 66 72 6f 6d IRST 1 site from 20 69 6e 66 6f 72 6d 69 78 2e 73 79 73 74 61 62 informix.systab 6c 65 73 20 77 68 65 72 65 20 74 61 62 6e 61 6d les where tabnam 65 20 3d 20 27 20 47 4c 5f 43 4f 4c 4c 41 54 45 e = ' GL_COLLATE

live capture · 01-connect-only.socat · sqli/9088

1.6× faster bulk inserts than IfxPy

Pipelined executemany sends every BIND+EXECUTE PDU before draining responses. IBM’s C driver still pays one round-trip per row. We figured we could do better.

~10% behind IfxPy on bulk fetches

Phase 39’s buffered reader closed the gap from 2.4× to within measurement noise of the C driver. The remaining ~10% is honest physics — for now.

50 KB wheel. Zero native deps.

No 92 MB OneDB tarball. No libcrypt.so.1 from 2018. No LD_LIBRARY_PATH ritual. Works on Python 3.10–3.14 — including the versions IfxPy doesn’t.

Async, like a modern driver should be

FastAPI, aiohttp, asyncio. Pool, connections, cursors all have async def versions. IfxPy has none of this.

PEP 249, no surprises

connect(), Connection, Cursor, description, rowcount, the full DB-API exception hierarchy — and threadsafe sharing through a per-connection wire lock.

Clean-room reverse engineering

Decompiled IBM JDBC. Annotated socat captures. Differential testing against IfxPy on every codec path. Every architectural decision lives in the phase log. Receipts.

A query, end to end

import informix_db

with informix_db.connect(
    host="db.example.com", port=9088,
    user="informix", password="...",
    database="mydb", server="informix",
) as conn:
    cur = conn.cursor()
    cur.execute("SELECT id, name FROM users WHERE id = ?", (42,))
    user_id, name = cur.fetchone()

That’s it. No IBM_DB_HOME. No DSN file. No libcrypt.so.1.

WTF did you build this for?

The existing tools were not my style.

Every other Informix driver in any language wraps either IBM’s C Client SDK or the JDBC JAR. IfxPy, the legacy informixdb, ODBC bridges, JPype/JDBC, Perl DBD::Informix — all of them. To our knowledge informix-db is the first pure-socket Informix driver in any language.

The OneDB CSDK is a 92 MB tarball. It needs libcrypt.so.1 (deprecated 2018, missing on Arch, Fedora 35+, RHEL 9). It needs four LD_LIBRARY_PATH entries. It needs setuptools < 58. And IfxPy itself is broken on Python 3.12+. For containerized deployments, ETL pipelines, FastAPI services, or anywhere a build toolchain on the runtime is friction, this driver is the alternative that didn’t previously exist. Now it does.