Mach Database Warehouse examples
Every example is a normal program or setup for the original database. Pointing it at MachWarehouse changes only the connection setting shown in its README (“before” and “after”). None of them uses a MachWarehouse-specific library.
All examples use the demo table in dataset/. They are not run on development machines; the EXM campaign runs them against the test server and against the originals.
| Area | Example | Library (version) | Protocol |
|---|---|---|---|
| ClickHouse | clickhouse/python | clickhouse-connect 1.11.0 | HTTP |
| ClickHouse | clickhouse/node | @clickhouse/client 1.24.1 | HTTP |
| ClickHouse | clickhouse/go | clickhouse-go v2.50.0 | native TCP |
| ClickHouse | clickhouse/java-jdbc | clickhouse-jdbc 0.11.0 | HTTP |
| ClickHouse | clickhouse/dotnet | ClickHouse.Client 7.14.0 | HTTP |
| ClickHouse | clickhouse/rust | clickhouse 0.15.3 | HTTP |
| Snowflake | snowflake/python | snowflake-connector-python 5.1.0 | Snowflake REST |
| Snowflake | snowflake/node | snowflake-sdk 3.4.1 | Snowflake REST |
| Snowflake | snowflake/go | gosnowflake v2.3.0 | Snowflake REST |
| Snowflake | snowflake/java-jdbc | snowflake-jdbc 4.4.0 | Snowflake REST |
| BigQuery dialect | bigquery | psql / DBeaver | PostgreSQL wire, dialect = googlesql |
| Flight SQL | flight-sql/python | adbc-driver-flightsql 1.13.0, pyarrow 26, pandas 3.1, polars 2.1 | Arrow Flight SQL |
| Flight SQL | flight-sql/go | arrow-adbc Go v1.13.0 | Arrow Flight SQL |
| Flight SQL | flight-sql/java | flight-sql-jdbc-driver 19.0.0 | Arrow Flight SQL |
| PostgreSQL wire | postgres/python | psycopg 3.3.6 | PostgreSQL |
| PostgreSQL wire | postgres/node | pg 8.23.1 | PostgreSQL |
| PostgreSQL wire | postgres/go | pgx v5.11.0 | PostgreSQL |
| PostgreSQL wire | postgres/java-jdbc | pgjdbc 42.7.14 | PostgreSQL |
| dbt | dbt | dbt-core 1.12.6 with dbt-clickhouse 1.10.3 / dbt-snowflake 1.12.4 / dbt-postgres 1.11.0 | per adapter |
| BI | Superset, Metabase, Grafana, Tableau, Power BI | the tools’ own connectors | PG, ClickHouse, Snowflake, Flight SQL |
Runtimes: Python 3.10+ (3.15 current), Node.js 20+ (26 LTS current), Go 1.27, Java 25 LTS, .NET 10, Rust stable.
Pointing an example at a server
Section titled “Pointing an example at a server”Each README lists the environment variables. Credentials come from the environment, never from files in git. Endpoints of a MachWarehouse server:
| Protocol | Default port |
|---|---|
| ClickHouse native TCP (TLS) | 9440 (plain 9000 only on loopback) |
| ClickHouse HTTP (TLS) | 8443 (plain 8123 only on loopback) |
| Snowflake REST | 443 |
| Arrow Flight SQL | 32010 |
| PostgreSQL wire | 5432 |