Apache Iceberg vs Dolt

Apache Iceberg is a free, open-source table format for analytic datasets, including very large analytic tables. It is self-hosted and works through APIs on Linux, macOS, and Windows, using storage you provide. Engines such as Spark, Trino, Flink, Presto, Hive, and Impala can use the same tables. SQL commands support merging new data, updating rows, and targeted deletes. Columns can be added, renamed, or reordered without rewriting a table. Hidden partitioning creates partition values and skips unnecessary partitions and files. Table snapshots can be queried by version or timestamp, and tables can be rolled back. Atomic updates, serializable isolation, consistent snapshot reads, and optimistic concurrency support multiple writers. Integrations include Kafka Connect and catalogs such as AWS Glue, JDBC, and Nessie. Encryption supports AWS, Azure, or GCP KMS clients, including custom clients. Version 1.12.0 removes Spark 3.4 and Flink 2.0 support. The Apache License 2.0 applies.

Dolt is a SQL database for managing data with version-control operations. Users can fork, clone, branch, merge, push and pull databases, then inspect commits, compare diffs, resolve SQL conflicts and revert commits. It can be connected to like a MySQL database or deployed as a versioned MySQL replica. DoltHub hosts public data and provides a web interface for editing and pull-request review; databases are public by default, with private databases available to Pro users or organizations. DoltLab is a self-hosted option for running DoltHub on a private network or development machine. Connector libraries include JDBC, Perl DBI, MySQL Connector/Python and Go sqlx/database/sql; listed framework integrations include Django, SQLAlchemy, Prisma, Laravel, Hibernate, GORM, Rails and FastAPI. Hosted Dolt includes a web SQL workbench, nightly full backups retained for 14 days, and AWS and GCP private networking. Dolt is free and open source. DoltHub Pro is $5 a month; a Hosted Dolt trial instance is $50 a month.