I’m thinking of this as a lightweight (single node) alternative in the same way duckdb is focused on data that can be processed by a single node.
I think / hope sqlflow will be a viable/lightweight/cost effective/easy to operate alternative to flink when working with small-medium sized data (on the orders of <10,000 messages / second)
pyiceberg does the heavy lifting. It is a great project with a lot of active development.
It's interesting to see how immature iceberg ecosystem is. For example duckdb iceberg does not support writing to tables, neither does the go iceberg project. Iceberg writing was just recently added to the pyiceberg project!
Would love to learn more about peoples actual use of iceberg in the wild.
Are you using iceberg? How are you writing data to it? Which iceberg features are you using? Do you leverage snapshots at all?
I just added support for websocket sources which enables sql over the Bluesky firehouse.
https://github.com/turbolytics/sql-flow?tab=readme-ov-file#c...
Duckdb does all the sql execution, and python is responsible for sourcing the data.
The project is still quite young and I’m very much still experimenting, but I’d love any feedback. Thank you.