Auxten Wang

BTW, here is the REAL screenshot from PyData 

chDB v2.1.1 has updated ClickHouse engine to v24.8. As a result the new JSON type is supported. And also we are working on make Pandas Dataframe works well with the...

Should work in latest chdb

Forgive my ignorance, I really didn't know that a DataFrame can have its index set. I will debug the issue you mentioned. BTW, I'm curious about the application scenarios and...

This should be fixed by change the default database type. Currently it's `memory` engine.

Table and Database both have engine type. If Database is memory engine, Table with MergeTree will also not persist

You can check docs here: https://clickhouse.com/docs/en/engines/database-engines/postgresql and https://clickhouse.com/docs/en/engines/table-engines/integrations/postgresql

Try use session ```python from chdb import session as chs ## Create DB, Table, View in temp session, auto cleanup when session is deleted. sess = chs.Session() sess.query("CREATE DATABASE IF...

1. You can create a view, It's more ordinary SQL 2. There is an insert example: https://clickhouse.com/docs/en/engines/database-engines/postgresql#examples-of-use There are also some full examples: https://clickhouse.com/blog/migrating-data-between-clickhouse-postgres https://clickhouse.com/blog/migrating-data-between-clickhouse-postgres-part-2

The default _local db is not persist, you should create a new one to save your modifications. See: https://github.com/chdb-io/chdb/blob/50fd104a12b422c4ef1cb45f8026721b0ea9f6d5/tests/test_usedb.py#L26-L38