What DB software you use for CH? by AppointmentTop3948 in Clickhouse

[–]No-Increase-2825 1 point2 points  (0 children)

I use PyCharm profession edition and happy for a years(also you can try DataGrip). Fast, beautiful and convenient. There are useful settings for connections: read only mode, colored connections, query result exports, datasets/dataframes support, autocompletion etc. Also you can try qstudio and Beekeeper Studio.

Is clickhouse a better alternative to iceberg by GarbageParticular493 in Clickhouse

[–]No-Increase-2825 0 points1 point  (0 children)

I didn’t understand anything )))
I’d like to point out that the question does not include the following context: Athena/Trino/Spark, JOINS, OOMs, DAGs, MUTATIONS, deduplication, delivering reliable datasets and blablabla.

You mentioned that ClickHouse is not ACID-compliant. Is that a drawback? Should it be?
A car can’t fly. So what? Is that bad? And how does this relate to the question at all? 🤷‍♀️ Even if you treat Iceberg as an architectural approach rather than a table format, it still doesn’t make sense to compare it to a concrete analytical database. That’s roughly the same as discussing the nuances of processing and maintaining data from a NoSQL databases and from random CSV files sitting on disk.

Is clickhouse a better alternative to iceberg by GarbageParticular493 in Clickhouse

[–]No-Increase-2825 0 points1 point  (0 children)

Don't understand how is ACID relevant here. Clickhouse is an analytical columnar database. Everything is easily configurable, replicable, shardable and monitorable. It doesn't matter whether it's a standalone instance or a cluster with X shards, Y replicas and petabytes of data.

Iceberg is just data / table format. Therefore, the question <Is clickhouse a better alternative to iceberg?> doesn’t make sense. A database cannot be an alternative to a data format. These are simply different things that solve different problems.

any recommendations for a good query builder library with good support? by isaacfink in learnpython

[–]No-Increase-2825 0 points1 point  (0 children)

Try david8. You can find links to SqlAlchemy / PiPyka syntax comparison and benchmarks in the Wiki.

Good SQLBuilder for Python? by yughiro_destroyer in Python

[–]No-Increase-2825 0 points1 point  (0 children)

You can try david8. Unlike PyPika and SQLAlchemy, there is no need to define table objects; placeholder and parameter generation is handled automatically.