v2.2.0b0

What's Changed

• Fix upload pypi and github release by @auxten in #278
• Update PyPi info by @auxten in #279
• Add citation just like ClickHouse, as chDB is mentioned in ClickHouse Paper by @auxten in #280
• New stateful mode in SQLite like API by @auxten in #283

  • SQLite like API: common functions, common connection strings supported

  • Stateful Query with long live clickhouse engine instance bind with connection

  • Python DB-API reimplemented with new API. Both persist and memory engine supported

  • ClickHouse memory engine support

  • Some performance improvement (~43%)
    

  • More details see #283 (comment)

Try with pip install chdb==2.2.0b0

Full Changelog: v2.1.1...v2.2.0b0

v2.1.1

What's Changed

• Use macOS 13 build by @auxten in #273
• Fix jemalloc background_thread caused assert failed by @auxten in #274
• GitHub action cleanup by @auxten in #275

Full Changelog: v2.1.0...v2.1.1

v2.1.0

What's Changed

• Update ClickHouse engine to v24.8.4.13-lts by @auxten in #271
• Fixed JSON_* function not available on macOS @auxten of #270

Full Changelog: v2.0.4...v2.1.0

v2.0.4

What's Changed

• Add: support azure blob storage by @nmreadelf in #266

Full Changelog: v2.0.3...v2.0.4

v2.0.3

What's Changed

• Fix CmakeLists comment by @DemoYeti in #257
• Try to fix gpt example by @xinhuitian in #263
• Fix arrow types handling by @auxten in #264

New Contributors

• @DemoYeti made their first contribution in #257
• @xinhuitian made their first contribution in #263

Full Changelog: v2.0.2...v2.0.3

v2.0.2

What's Changed

• Fix global import dataframe by @auxten in #259

Full Changelog: v2.0.1...v2.0.2

v2.0.1

What's Changed

• Patchset-5 before v2.0.0 by @auxten in #250
• Performace tuning of pipeline running by @auxten in #256
• Better handling of numpy.NaN and complex Python types in Pandas Dataframe @auxten in #256

Full Changelog: v2.0.0b1...v2.0.1

v2.0.0b1

What's Changed

• Fix build on macOS x86 and Linux aarch64 by @auxten in #239
• Build on main updated by @auxten in #240
• Fix float point type pattern by @auxten in #241
• Fix Date and Date32 handling by @auxten in #242

Special thanks to @mneedham!

Full Changelog: v2.0.0b0...v2.0.0b1

v2.0.0b0

Highlight

• 🚀 87x performance boost query on Pandas DataFrame, See Benchmark

• ⬆️ Upgrade ClickHouse engine to 24.5

• 🐍 Query on Pandas DataFrame, ArrowTable, Dict or Any Python object Directly!

import chdb
import pandas as pd
df = pd.DataFrame(
    {
        "a": [1, 2, 3, 4, 5, 6],
        "b": ["tom", "jerry", "auxten", "tom", "jerry", "auxten"],
    }
)

chdb.query("SELECT b, sum(a) FROM Python(df) GROUP BY b ORDER BY b").show()

• For more: test_query_py.py.

Changes

• Use in-process instead of embedded by @auxten in #222
• 226 crash on mergetree background task cleanup by @auxten in #227
• Replace icu with utf8proc by @auxten in #228
• Start agg step stream according to agg_col_cost and group_by_keys_cost by @auxten in #230
• Fix various issues like 190, 229 by @auxten in #231
• Before 2.0 release Patch #1 by @auxten in #232
• Fix python version check in CMakeLists.txt by @auxten in #233
• Fix mistake config.h by @auxten in #234
• Add tests on query python objects by @auxten in #235
• Add docs for Python Table Engine by @auxten in #238

Full Changelog: v1.4.1...v2.0.0b0

v1.4.1

What's Changed

• Disable ICU on macOS by @auxten in #221
• Enable H3 functions by @auxten in #218
• Alias sql method to query by @auxten in #219

Full Changelog: v1.3.0...v1.4.1