chdb


Namechdb JSON
Version 1.2.1 PyPI version JSON
download
home_pagehttps://github.com/auxten/chdb
SummarychDB is an in-process SQL OLAP Engine powered by ClickHouse
upload_time2024-02-03 05:19:45
maintainer
docs_urlNone
authorauxten
requires_python>=3.8
licenseApache-2.0
keywords
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage
            <div align="center">
<picture>
  <source media="(prefers-color-scheme: dark)" srcset="docs/_static/snake-chdb-dark.png" height="130">
  <img src="docs/_static/snake-chdb.png" height="130">
</picture>
  
[![Build X86](https://github.com/chdb-io/chdb/actions/workflows/build_wheels.yml/badge.svg?event=release)](https://github.com/chdb-io/chdb/actions/workflows/build_wheels.yml)
[![PyPI](https://img.shields.io/pypi/v/chdb.svg)](https://pypi.org/project/chdb/)
[![Downloads](https://static.pepy.tech/badge/chdb)](https://pepy.tech/project/chdb)
[![Discord](https://img.shields.io/discord/1098133460310294528?logo=Discord)](https://discord.gg/D2Daa2fM5K)
[![Twitter](https://img.shields.io/twitter/url/http/shields.io.svg?style=social&label=Twitter)](https://twitter.com/chdb_io)
</div>

# chDB

[中文](README-zh.md)

> chDB is an embedded SQL OLAP Engine powered by ClickHouse  [^1]
> For more details: [The birth of chDB](https://auxten.com/the-birth-of-chdb/) 


## Features
     
* In-process SQL OLAP Engine, powered by ClickHouse
* No need to install ClickHouse
* Minimized data copy from C++ to Python with [python memoryview](https://docs.python.org/3/c-api/memoryview.html)
* Input&Output support Parquet, CSV, JSON, Arrow, ORC and 60+[more](https://clickhouse.com/docs/en/interfaces/formats) formats, [samples](tests/format_output.py)
* Support Python DB API 2.0, [example](examples/dbapi.py)



## Arch
<div align="center">
  <img src="docs/_static/arch-chdb2.png" width="450">
</div>

## Get Started
Get started with **chdb** using our [Installation and Usage Examples](https://doc.chdb.io)

<br>

## Installation
Currently, chDB supports Python 3.8+ on macOS and Linux (x86_64 and ARM64).
```bash
pip install chdb
```

## Usage

### Run in command line
> `python3 -m chdb SQL [OutputFormat]`
```bash
python3 -m chdb "SELECT 1,'abc'" Pretty
```

<br>

### Data Input
The following methods are available to access on-disk and in-memory data formats:

<details>
    <summary><h4>🗂️ Query On File</h4> (Parquet, CSV, JSON, Arrow, ORC and 60+)</summary>

You can execute SQL and return desired format data.

```python
import chdb
res = chdb.query('select version()', 'Pretty'); print(res)
```

### Work with Parquet or CSV
```python
# See more data type format in tests/format_output.py
res = chdb.query('select * from file("data.parquet", Parquet)', 'JSON'); print(res)
res = chdb.query('select * from file("data.csv", CSV)', 'CSV');  print(res)
print(f"SQL read {res.rows_read()} rows, {res.bytes_read()} bytes, elapsed {res.elapsed()} seconds")
```

### Pandas dataframe output
```python
# See more in https://clickhouse.com/docs/en/interfaces/formats
chdb.query('select * from file("data.parquet", Parquet)', 'Dataframe')
```
</details>

<details>
    <summary><h4>🗂️ Query On Table</h4> (Pandas DataFrame, Parquet file/bytes, Arrow bytes) </summary>

### Query On Pandas DataFrame
```python
import chdb.dataframe as cdf
import pandas as pd
# Join 2 DataFrames
df1 = pd.DataFrame({'a': [1, 2, 3], 'b': ["one", "two", "three"]})
df2 = pd.DataFrame({'c': [1, 2, 3], 'd': ["①", "②", "③"]})
ret_tbl = cdf.query(sql="select * from __tbl1__ t1 join __tbl2__ t2 on t1.a = t2.c",
                  tbl1=df1, tbl2=df2)
print(ret_tbl)
# Query on the DataFrame Table
print(ret_tbl.query('select b, sum(a) from __table__ group by b'))
```
</details>

<details>
  <summary><h4>🗂️ Query with Stateful Session</h4></summary>

```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 NOT EXISTS db_xxx ENGINE = Atomic")
sess.query("CREATE TABLE IF NOT EXISTS db_xxx.log_table_xxx (x String, y Int) ENGINE = Log;")
sess.query("INSERT INTO db_xxx.log_table_xxx VALUES ('a', 1), ('b', 3), ('c', 2), ('d', 5);")
sess.query(
    "CREATE VIEW db_xxx.view_xxx AS SELECT * FROM db_xxx.log_table_xxx LIMIT 4;"
)
print("Select from view:\n")
print(sess.query("SELECT * FROM db_xxx.view_xxx", "Pretty"))
```

see also: [test_stateful.py](tests/test_stateful.py).
</details>

<details>
    <summary><h4>🗂️ Query with Python DB-API 2.0</h4></summary>

```python
import chdb.dbapi as dbapi
print("chdb driver version: {0}".format(dbapi.get_client_info()))

conn1 = dbapi.connect()
cur1 = conn1.cursor()
cur1.execute('select version()')
print("description: ", cur1.description)
print("data: ", cur1.fetchone())
cur1.close()
conn1.close()
```
</details>


<details>
    <summary><h4>🗂️ Query with UDF (User Defined Functions)</h4></summary>

```python
from chdb.udf import chdb_udf
from chdb import query

@chdb_udf()
def sum_udf(lhs, rhs):
    return int(lhs) + int(rhs)

print(query("select sum_udf(12,22)"))
```

see also: [test_udf.py](tests/test_udf.py).
</details>

For more examples, see [examples](examples) and [tests](tests).

<br>

## Demos and Examples

- [Project Documentation](https://doc.chdb.io) and [Usage Examples](https://chdb-io.github.io/#/install?id=installation-1)
- [Colab Notebooks](https://colab.research.google.com/drive/1-zKB6oKfXeptggXi0kUX87iR8ZTSr4P3?usp=sharing) and other [Script Examples](examples)

## Benchmark

- [ClickBench of embedded engines](https://benchmark.clickhouse.com/#eyJzeXN0ZW0iOnsiQXRoZW5hIChwYXJ0aXRpb25lZCkiOnRydWUsIkF0aGVuYSAoc2luZ2xlKSI6dHJ1ZSwiQXVyb3JhIGZvciBNeVNRTCI6dHJ1ZSwiQXVyb3JhIGZvciBQb3N0Z3JlU1FMIjp0cnVlLCJCeXRlSG91c2UiOnRydWUsImNoREIiOnRydWUsIkNpdHVzIjp0cnVlLCJjbGlja2hvdXNlLWxvY2FsIChwYXJ0aXRpb25lZCkiOnRydWUsImNsaWNraG91c2UtbG9jYWwgKHNpbmdsZSkiOnRydWUsIkNsaWNrSG91c2UiOnRydWUsIkNsaWNrSG91c2UgKHR1bmVkKSI6dHJ1ZSwiQ2xpY2tIb3VzZSAoenN0ZCkiOnRydWUsIkNsaWNrSG91c2UgQ2xvdWQiOnRydWUsIkNsaWNrSG91c2UgKHdlYikiOnRydWUsIkNyYXRlREIiOnRydWUsIkRhdGFiZW5kIjp0cnVlLCJEYXRhRnVzaW9uIChzaW5nbGUpIjp0cnVlLCJBcGFjaGUgRG9yaXMiOnRydWUsIkRydWlkIjp0cnVlLCJEdWNrREIgKFBhcnF1ZXQpIjp0cnVlLCJEdWNrREIiOnRydWUsIkVsYXN0aWNzZWFyY2giOnRydWUsIkVsYXN0aWNzZWFyY2ggKHR1bmVkKSI6ZmFsc2UsIkdyZWVucGx1bSI6dHJ1ZSwiSGVhdnlBSSI6dHJ1ZSwiSHlkcmEiOnRydWUsIkluZm9icmlnaHQiOnRydWUsIktpbmV0aWNhIjp0cnVlLCJNYXJpYURCIENvbHVtblN0b3JlIjp0cnVlLCJNYXJpYURCIjpmYWxzZSwiTW9uZXREQiI6dHJ1ZSwiTW9uZ29EQiI6dHJ1ZSwiTXlTUUwgKE15SVNBTSkiOnRydWUsIk15U1FMIjp0cnVlLCJQaW5vdCI6dHJ1ZSwiUG9zdGdyZVNRTCI6dHJ1ZSwiUG9zdGdyZVNRTCAodHVuZWQpIjpmYWxzZSwiUXVlc3REQiAocGFydGl0aW9uZWQpIjp0cnVlLCJRdWVzdERCIjp0cnVlLCJSZWRzaGlmdCI6dHJ1ZSwiU2VsZWN0REIiOnRydWUsIlNpbmdsZVN0b3JlIjp0cnVlLCJTbm93Zmxha2UiOnRydWUsIlNRTGl0ZSI6dHJ1ZSwiU3RhclJvY2tzIjp0cnVlLCJUaW1lc2NhbGVEQiAoY29tcHJlc3Npb24pIjp0cnVlLCJUaW1lc2NhbGVEQiI6dHJ1ZX0sInR5cGUiOnsic3RhdGVsZXNzIjpmYWxzZSwibWFuYWdlZCI6ZmFsc2UsIkphdmEiOmZhbHNlLCJjb2x1bW4tb3JpZW50ZWQiOmZhbHNlLCJDKysiOmZhbHNlLCJNeVNRTCBjb21wYXRpYmxlIjpmYWxzZSwicm93LW9yaWVudGVkIjpmYWxzZSwiQyI6ZmFsc2UsIlBvc3RncmVTUUwgY29tcGF0aWJsZSI6ZmFsc2UsIkNsaWNrSG91c2UgZGVyaXZhdGl2ZSI6ZmFsc2UsImVtYmVkZGVkIjp0cnVlLCJzZXJ2ZXJsZXNzIjpmYWxzZSwiUnVzdCI6ZmFsc2UsInNlYXJjaCI6ZmFsc2UsImRvY3VtZW50IjpmYWxzZSwidGltZS1zZXJpZXMiOmZhbHNlfSwibWFjaGluZSI6eyJzZXJ2ZXJsZXNzIjp0cnVlLCIxNmFjdSI6dHJ1ZSwiTCI6dHJ1ZSwiTSI6dHJ1ZSwiUyI6dHJ1ZSwiWFMiOnRydWUsImM2YS5tZXRhbCwgNTAwZ2IgZ3AyIjp0cnVlLCJjNmEuNHhsYXJnZSwgNTAwZ2IgZ3AyIjp0cnVlLCJjNS40eGxhcmdlLCA1MDBnYiBncDIiOnRydWUsIjE2IHRocmVhZHMiOnRydWUsIjIwIHRocmVhZHMiOnRydWUsIjI0IHRocmVhZHMiOnRydWUsIjI4IHRocmVhZHMiOnRydWUsIjMwIHRocmVhZHMiOnRydWUsIjQ4IHRocmVhZHMiOnRydWUsIjYwIHRocmVhZHMiOnRydWUsIm01ZC4yNHhsYXJnZSI6dHJ1ZSwiYzVuLjR4bGFyZ2UsIDIwMGdiIGdwMiI6dHJ1ZSwiYzZhLjR4bGFyZ2UsIDE1MDBnYiBncDIiOnRydWUsImRjMi44eGxhcmdlIjp0cnVlLCJyYTMuMTZ4bGFyZ2UiOnRydWUsInJhMy40eGxhcmdlIjp0cnVlLCJyYTMueGxwbHVzIjp0cnVlLCJTMjQiOnRydWUsIlMyIjp0cnVlLCIyWEwiOnRydWUsIjNYTCI6dHJ1ZSwiNFhMIjp0cnVlLCJYTCI6dHJ1ZX0sImNsdXN0ZXJfc2l6ZSI6eyIxIjp0cnVlLCIyIjp0cnVlLCI0Ijp0cnVlLCI4Ijp0cnVlLCIxNiI6dHJ1ZSwiMzIiOnRydWUsIjY0Ijp0cnVlLCIxMjgiOnRydWUsInNlcnZlcmxlc3MiOnRydWUsInVuZGVmaW5lZCI6dHJ1ZX0sIm1ldHJpYyI6ImhvdCIsInF1ZXJpZXMiOlt0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlXX0=)

## Documentation
- For chdb specific examples and documentation refer to [doc.chdb.io](https://doc.chdb.io)
- For SQL syntax, please refer to [ClickHouse SQL Reference](https://clickhouse.com/docs/en/sql-reference/syntax)


## Events

- Demo chDB at [ClickHouse v23.7 livehouse!](https://t.co/todc13Kn19) and [Slides](https://docs.google.com/presentation/d/1ikqjOlimRa7QAg588TAB_Fna-Tad2WMg7_4AgnbQbFA/edit?usp=sharing)

## Contributing
Contributions are what make the open source community such an amazing place to be learn, inspire, and create. Any contributions you make are **greatly appreciated**.
There are something you can help:
- [ ] Help test and report bugs
- [ ] Help improve documentation
- [ ] Help improve code quality and performance

### Bindings

We welcome bindings for other languages, please refer to [bindings](bindings.md) for more details.

## License
Apache 2.0, see [LICENSE](LICENSE.txt) for more information.

## Acknowledgments
chDB is mainly based on [ClickHouse](https://github.com/ClickHouse/ClickHouse) [^1]
for trade mark and other reasons, I named it chDB.

## Contact
- Discord: [https://discord.gg/D2Daa2fM5K](https://discord.gg/D2Daa2fM5K)
- Email: auxtenwpc@gmail.com
- Twitter: [@chdb](https://twitter.com/chdb_io)


<br>

[^1]: ClickHouse® is a trademark of ClickHouse Inc. All trademarks, service marks, and logos mentioned or depicted are the property of their respective owners. The use of any third-party trademarks, brand names, product names, and company names does not imply endorsement, affiliation, or association with the respective owners.

            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/auxten/chdb",
    "name": "chdb",
    "maintainer": "",
    "docs_url": null,
    "requires_python": ">=3.8",
    "maintainer_email": "",
    "keywords": "",
    "author": "auxten",
    "author_email": "auxtenwpc@gmail.com",
    "download_url": "",
    "platform": "Mac",
    "description": "<div align=\"center\">\n<picture>\n  <source media=\"(prefers-color-scheme: dark)\" srcset=\"docs/_static/snake-chdb-dark.png\" height=\"130\">\n  <img src=\"docs/_static/snake-chdb.png\" height=\"130\">\n</picture>\n  \n[![Build X86](https://github.com/chdb-io/chdb/actions/workflows/build_wheels.yml/badge.svg?event=release)](https://github.com/chdb-io/chdb/actions/workflows/build_wheels.yml)\n[![PyPI](https://img.shields.io/pypi/v/chdb.svg)](https://pypi.org/project/chdb/)\n[![Downloads](https://static.pepy.tech/badge/chdb)](https://pepy.tech/project/chdb)\n[![Discord](https://img.shields.io/discord/1098133460310294528?logo=Discord)](https://discord.gg/D2Daa2fM5K)\n[![Twitter](https://img.shields.io/twitter/url/http/shields.io.svg?style=social&label=Twitter)](https://twitter.com/chdb_io)\n</div>\n\n# chDB\n\n[\u4e2d\u6587](README-zh.md)\n\n> chDB is an embedded SQL OLAP Engine powered by ClickHouse  [^1]\n> For more details: [The birth of chDB](https://auxten.com/the-birth-of-chdb/) \n\n\n## Features\n     \n* In-process SQL OLAP Engine, powered by ClickHouse\n* No need to install ClickHouse\n* Minimized data copy from C++ to Python with [python memoryview](https://docs.python.org/3/c-api/memoryview.html)\n* Input&Output support Parquet, CSV, JSON, Arrow, ORC and 60+[more](https://clickhouse.com/docs/en/interfaces/formats) formats, [samples](tests/format_output.py)\n* Support Python DB API 2.0, [example](examples/dbapi.py)\n\n\n\n## Arch\n<div align=\"center\">\n  <img src=\"docs/_static/arch-chdb2.png\" width=\"450\">\n</div>\n\n## Get Started\nGet started with **chdb** using our [Installation and Usage Examples](https://doc.chdb.io)\n\n<br>\n\n## Installation\nCurrently, chDB supports Python 3.8+ on macOS and Linux (x86_64 and ARM64).\n```bash\npip install chdb\n```\n\n## Usage\n\n### Run in command line\n> `python3 -m chdb SQL [OutputFormat]`\n```bash\npython3 -m chdb \"SELECT 1,'abc'\" Pretty\n```\n\n<br>\n\n### Data Input\nThe following methods are available to access on-disk and in-memory data formats:\n\n<details>\n    <summary><h4>\ud83d\uddc2\ufe0f Query On File</h4> (Parquet, CSV, JSON, Arrow, ORC and 60+)</summary>\n\nYou can execute SQL and return desired format data.\n\n```python\nimport chdb\nres = chdb.query('select version()', 'Pretty'); print(res)\n```\n\n### Work with Parquet or CSV\n```python\n# See more data type format in tests/format_output.py\nres = chdb.query('select * from file(\"data.parquet\", Parquet)', 'JSON'); print(res)\nres = chdb.query('select * from file(\"data.csv\", CSV)', 'CSV');  print(res)\nprint(f\"SQL read {res.rows_read()} rows, {res.bytes_read()} bytes, elapsed {res.elapsed()} seconds\")\n```\n\n### Pandas dataframe output\n```python\n# See more in https://clickhouse.com/docs/en/interfaces/formats\nchdb.query('select * from file(\"data.parquet\", Parquet)', 'Dataframe')\n```\n</details>\n\n<details>\n    <summary><h4>\ud83d\uddc2\ufe0f Query On Table</h4> (Pandas DataFrame, Parquet file/bytes, Arrow bytes) </summary>\n\n### Query On Pandas DataFrame\n```python\nimport chdb.dataframe as cdf\nimport pandas as pd\n# Join 2 DataFrames\ndf1 = pd.DataFrame({'a': [1, 2, 3], 'b': [\"one\", \"two\", \"three\"]})\ndf2 = pd.DataFrame({'c': [1, 2, 3], 'd': [\"\u2460\", \"\u2461\", \"\u2462\"]})\nret_tbl = cdf.query(sql=\"select * from __tbl1__ t1 join __tbl2__ t2 on t1.a = t2.c\",\n                  tbl1=df1, tbl2=df2)\nprint(ret_tbl)\n# Query on the DataFrame Table\nprint(ret_tbl.query('select b, sum(a) from __table__ group by b'))\n```\n</details>\n\n<details>\n  <summary><h4>\ud83d\uddc2\ufe0f Query with Stateful Session</h4></summary>\n\n```python\nfrom chdb import session as chs\n\n## Create DB, Table, View in temp session, auto cleanup when session is deleted.\nsess = chs.Session()\nsess.query(\"CREATE DATABASE IF NOT EXISTS db_xxx ENGINE = Atomic\")\nsess.query(\"CREATE TABLE IF NOT EXISTS db_xxx.log_table_xxx (x String, y Int) ENGINE = Log;\")\nsess.query(\"INSERT INTO db_xxx.log_table_xxx VALUES ('a', 1), ('b', 3), ('c', 2), ('d', 5);\")\nsess.query(\n    \"CREATE VIEW db_xxx.view_xxx AS SELECT * FROM db_xxx.log_table_xxx LIMIT 4;\"\n)\nprint(\"Select from view:\\n\")\nprint(sess.query(\"SELECT * FROM db_xxx.view_xxx\", \"Pretty\"))\n```\n\nsee also: [test_stateful.py](tests/test_stateful.py).\n</details>\n\n<details>\n    <summary><h4>\ud83d\uddc2\ufe0f Query with Python DB-API 2.0</h4></summary>\n\n```python\nimport chdb.dbapi as dbapi\nprint(\"chdb driver version: {0}\".format(dbapi.get_client_info()))\n\nconn1 = dbapi.connect()\ncur1 = conn1.cursor()\ncur1.execute('select version()')\nprint(\"description: \", cur1.description)\nprint(\"data: \", cur1.fetchone())\ncur1.close()\nconn1.close()\n```\n</details>\n\n\n<details>\n    <summary><h4>\ud83d\uddc2\ufe0f Query with UDF (User Defined Functions)</h4></summary>\n\n```python\nfrom chdb.udf import chdb_udf\nfrom chdb import query\n\n@chdb_udf()\ndef sum_udf(lhs, rhs):\n    return int(lhs) + int(rhs)\n\nprint(query(\"select sum_udf(12,22)\"))\n```\n\nsee also: [test_udf.py](tests/test_udf.py).\n</details>\n\nFor more examples, see [examples](examples) and [tests](tests).\n\n<br>\n\n## Demos and Examples\n\n- [Project Documentation](https://doc.chdb.io) and [Usage Examples](https://chdb-io.github.io/#/install?id=installation-1)\n- [Colab Notebooks](https://colab.research.google.com/drive/1-zKB6oKfXeptggXi0kUX87iR8ZTSr4P3?usp=sharing) and other [Script Examples](examples)\n\n## Benchmark\n\n- [ClickBench of embedded engines](https://benchmark.clickhouse.com/#eyJzeXN0ZW0iOnsiQXRoZW5hIChwYXJ0aXRpb25lZCkiOnRydWUsIkF0aGVuYSAoc2luZ2xlKSI6dHJ1ZSwiQXVyb3JhIGZvciBNeVNRTCI6dHJ1ZSwiQXVyb3JhIGZvciBQb3N0Z3JlU1FMIjp0cnVlLCJCeXRlSG91c2UiOnRydWUsImNoREIiOnRydWUsIkNpdHVzIjp0cnVlLCJjbGlja2hvdXNlLWxvY2FsIChwYXJ0aXRpb25lZCkiOnRydWUsImNsaWNraG91c2UtbG9jYWwgKHNpbmdsZSkiOnRydWUsIkNsaWNrSG91c2UiOnRydWUsIkNsaWNrSG91c2UgKHR1bmVkKSI6dHJ1ZSwiQ2xpY2tIb3VzZSAoenN0ZCkiOnRydWUsIkNsaWNrSG91c2UgQ2xvdWQiOnRydWUsIkNsaWNrSG91c2UgKHdlYikiOnRydWUsIkNyYXRlREIiOnRydWUsIkRhdGFiZW5kIjp0cnVlLCJEYXRhRnVzaW9uIChzaW5nbGUpIjp0cnVlLCJBcGFjaGUgRG9yaXMiOnRydWUsIkRydWlkIjp0cnVlLCJEdWNrREIgKFBhcnF1ZXQpIjp0cnVlLCJEdWNrREIiOnRydWUsIkVsYXN0aWNzZWFyY2giOnRydWUsIkVsYXN0aWNzZWFyY2ggKHR1bmVkKSI6ZmFsc2UsIkdyZWVucGx1bSI6dHJ1ZSwiSGVhdnlBSSI6dHJ1ZSwiSHlkcmEiOnRydWUsIkluZm9icmlnaHQiOnRydWUsIktpbmV0aWNhIjp0cnVlLCJNYXJpYURCIENvbHVtblN0b3JlIjp0cnVlLCJNYXJpYURCIjpmYWxzZSwiTW9uZXREQiI6dHJ1ZSwiTW9uZ29EQiI6dHJ1ZSwiTXlTUUwgKE15SVNBTSkiOnRydWUsIk15U1FMIjp0cnVlLCJQaW5vdCI6dHJ1ZSwiUG9zdGdyZVNRTCI6dHJ1ZSwiUG9zdGdyZVNRTCAodHVuZWQpIjpmYWxzZSwiUXVlc3REQiAocGFydGl0aW9uZWQpIjp0cnVlLCJRdWVzdERCIjp0cnVlLCJSZWRzaGlmdCI6dHJ1ZSwiU2VsZWN0REIiOnRydWUsIlNpbmdsZVN0b3JlIjp0cnVlLCJTbm93Zmxha2UiOnRydWUsIlNRTGl0ZSI6dHJ1ZSwiU3RhclJvY2tzIjp0cnVlLCJUaW1lc2NhbGVEQiAoY29tcHJlc3Npb24pIjp0cnVlLCJUaW1lc2NhbGVEQiI6dHJ1ZX0sInR5cGUiOnsic3RhdGVsZXNzIjpmYWxzZSwibWFuYWdlZCI6ZmFsc2UsIkphdmEiOmZhbHNlLCJjb2x1bW4tb3JpZW50ZWQiOmZhbHNlLCJDKysiOmZhbHNlLCJNeVNRTCBjb21wYXRpYmxlIjpmYWxzZSwicm93LW9yaWVudGVkIjpmYWxzZSwiQyI6ZmFsc2UsIlBvc3RncmVTUUwgY29tcGF0aWJsZSI6ZmFsc2UsIkNsaWNrSG91c2UgZGVyaXZhdGl2ZSI6ZmFsc2UsImVtYmVkZGVkIjp0cnVlLCJzZXJ2ZXJsZXNzIjpmYWxzZSwiUnVzdCI6ZmFsc2UsInNlYXJjaCI6ZmFsc2UsImRvY3VtZW50IjpmYWxzZSwidGltZS1zZXJpZXMiOmZhbHNlfSwibWFjaGluZSI6eyJzZXJ2ZXJsZXNzIjp0cnVlLCIxNmFjdSI6dHJ1ZSwiTCI6dHJ1ZSwiTSI6dHJ1ZSwiUyI6dHJ1ZSwiWFMiOnRydWUsImM2YS5tZXRhbCwgNTAwZ2IgZ3AyIjp0cnVlLCJjNmEuNHhsYXJnZSwgNTAwZ2IgZ3AyIjp0cnVlLCJjNS40eGxhcmdlLCA1MDBnYiBncDIiOnRydWUsIjE2IHRocmVhZHMiOnRydWUsIjIwIHRocmVhZHMiOnRydWUsIjI0IHRocmVhZHMiOnRydWUsIjI4IHRocmVhZHMiOnRydWUsIjMwIHRocmVhZHMiOnRydWUsIjQ4IHRocmVhZHMiOnRydWUsIjYwIHRocmVhZHMiOnRydWUsIm01ZC4yNHhsYXJnZSI6dHJ1ZSwiYzVuLjR4bGFyZ2UsIDIwMGdiIGdwMiI6dHJ1ZSwiYzZhLjR4bGFyZ2UsIDE1MDBnYiBncDIiOnRydWUsImRjMi44eGxhcmdlIjp0cnVlLCJyYTMuMTZ4bGFyZ2UiOnRydWUsInJhMy40eGxhcmdlIjp0cnVlLCJyYTMueGxwbHVzIjp0cnVlLCJTMjQiOnRydWUsIlMyIjp0cnVlLCIyWEwiOnRydWUsIjNYTCI6dHJ1ZSwiNFhMIjp0cnVlLCJYTCI6dHJ1ZX0sImNsdXN0ZXJfc2l6ZSI6eyIxIjp0cnVlLCIyIjp0cnVlLCI0Ijp0cnVlLCI4Ijp0cnVlLCIxNiI6dHJ1ZSwiMzIiOnRydWUsIjY0Ijp0cnVlLCIxMjgiOnRydWUsInNlcnZlcmxlc3MiOnRydWUsInVuZGVmaW5lZCI6dHJ1ZX0sIm1ldHJpYyI6ImhvdCIsInF1ZXJpZXMiOlt0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlXX0=)\n\n## Documentation\n- For chdb specific examples and documentation refer to [doc.chdb.io](https://doc.chdb.io)\n- For SQL syntax, please refer to [ClickHouse SQL Reference](https://clickhouse.com/docs/en/sql-reference/syntax)\n\n\n## Events\n\n- Demo chDB at [ClickHouse v23.7 livehouse!](https://t.co/todc13Kn19) and [Slides](https://docs.google.com/presentation/d/1ikqjOlimRa7QAg588TAB_Fna-Tad2WMg7_4AgnbQbFA/edit?usp=sharing)\n\n## Contributing\nContributions are what make the open source community such an amazing place to be learn, inspire, and create. Any contributions you make are **greatly appreciated**.\nThere are something you can help:\n- [ ] Help test and report bugs\n- [ ] Help improve documentation\n- [ ] Help improve code quality and performance\n\n### Bindings\n\nWe welcome bindings for other languages, please refer to [bindings](bindings.md) for more details.\n\n## License\nApache 2.0, see [LICENSE](LICENSE.txt) for more information.\n\n## Acknowledgments\nchDB is mainly based on [ClickHouse](https://github.com/ClickHouse/ClickHouse) [^1]\nfor trade mark and other reasons, I named it chDB.\n\n## Contact\n- Discord: [https://discord.gg/D2Daa2fM5K](https://discord.gg/D2Daa2fM5K)\n- Email: auxtenwpc@gmail.com\n- Twitter: [@chdb](https://twitter.com/chdb_io)\n\n\n<br>\n\n[^1]: ClickHouse\u00ae is a trademark of ClickHouse Inc. All trademarks, service marks, and logos mentioned or depicted are the property of their respective owners. The use of any third-party trademarks, brand names, product names, and company names does not imply endorsement, affiliation, or association with the respective owners.\n",
    "bugtrack_url": null,
    "license": "Apache-2.0",
    "summary": "chDB is an in-process SQL OLAP Engine powered by ClickHouse",
    "version": "1.2.1",
    "project_urls": {
        "Documentation": "https://github.com/auxten/chdb",
        "Homepage": "https://github.com/auxten/chdb"
    },
    "split_keywords": [],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "0a01291a41a67dce32f5de4c65013731b706c598668ae26aa0c805b708fc7a56",
                "md5": "0421eee69a429d71f2038700cf9918c2",
                "sha256": "5d7858769192694493b2b607db73daac5ca3df89b7be9c814657d936278da5dd"
            },
            "downloads": -1,
            "filename": "chdb-1.2.1-cp310-cp310-macosx_10_15_x86_64.whl",
            "has_sig": false,
            "md5_digest": "0421eee69a429d71f2038700cf9918c2",
            "packagetype": "bdist_wheel",
            "python_version": "cp310",
            "requires_python": ">=3.8",
            "size": 91829407,
            "upload_time": "2024-02-03T05:19:45",
            "upload_time_iso_8601": "2024-02-03T05:19:45.277577Z",
            "url": "https://files.pythonhosted.org/packages/0a/01/291a41a67dce32f5de4c65013731b706c598668ae26aa0c805b708fc7a56/chdb-1.2.1-cp310-cp310-macosx_10_15_x86_64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "264c352aae55ce9083abcacb6c1b4658a43b13e0f6bd7102ee6dd82928518453",
                "md5": "1f0ee7ce5b40feea877c6531348b6c76",
                "sha256": "59c44c29bf21325e32e5158bfd7a9413920e25e3630afe06d6106500f6010938"
            },
            "downloads": -1,
            "filename": "chdb-1.2.1-cp310-cp310-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
            "has_sig": false,
            "md5_digest": "1f0ee7ce5b40feea877c6531348b6c76",
            "packagetype": "bdist_wheel",
            "python_version": "cp310",
            "requires_python": ">=3.8",
            "size": 126298208,
            "upload_time": "2024-02-03T04:57:04",
            "upload_time_iso_8601": "2024-02-03T04:57:04.022329Z",
            "url": "https://files.pythonhosted.org/packages/26/4c/352aae55ce9083abcacb6c1b4658a43b13e0f6bd7102ee6dd82928518453/chdb-1.2.1-cp310-cp310-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "09b33d384641647672330480f546733693eed3779c6d9e9f6d2d52dbe3556108",
                "md5": "b7177d057f0a38155b6d8be2a221d771",
                "sha256": "9fed280ebd14934dcdf0ec35b45211fa87acbc440f40df1ad253449759d53cf4"
            },
            "downloads": -1,
            "filename": "chdb-1.2.1-cp311-cp311-macosx_10_15_x86_64.whl",
            "has_sig": false,
            "md5_digest": "b7177d057f0a38155b6d8be2a221d771",
            "packagetype": "bdist_wheel",
            "python_version": "cp311",
            "requires_python": ">=3.8",
            "size": 91834909,
            "upload_time": "2024-02-03T05:42:26",
            "upload_time_iso_8601": "2024-02-03T05:42:26.427351Z",
            "url": "https://files.pythonhosted.org/packages/09/b3/3d384641647672330480f546733693eed3779c6d9e9f6d2d52dbe3556108/chdb-1.2.1-cp311-cp311-macosx_10_15_x86_64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "5ac63ef974f8f1200f738bfce3d644f65c665f54f2e008c23889597fe09809df",
                "md5": "4e30d90c59ab07e30a4896a29ee5a847",
                "sha256": "41d62f4a02f04245c8865f921767db0fa8912a4a030e93a111855518b242c40a"
            },
            "downloads": -1,
            "filename": "chdb-1.2.1-cp311-cp311-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
            "has_sig": false,
            "md5_digest": "4e30d90c59ab07e30a4896a29ee5a847",
            "packagetype": "bdist_wheel",
            "python_version": "cp311",
            "requires_python": ">=3.8",
            "size": 126302376,
            "upload_time": "2024-02-03T04:56:41",
            "upload_time_iso_8601": "2024-02-03T04:56:41.850775Z",
            "url": "https://files.pythonhosted.org/packages/5a/c6/3ef974f8f1200f738bfce3d644f65c665f54f2e008c23889597fe09809df/chdb-1.2.1-cp311-cp311-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "1e01095c6534f157d5a429772fdb83103c1fb147e112f98643e6b61d348152da",
                "md5": "60057f95db91f7471664f70207f5092d",
                "sha256": "243cdc4c8055dad3745922ad94c48986460dee7b4af5a95b19a0fead95fad86a"
            },
            "downloads": -1,
            "filename": "chdb-1.2.1-cp312-cp312-macosx_10_15_x86_64.whl",
            "has_sig": false,
            "md5_digest": "60057f95db91f7471664f70207f5092d",
            "packagetype": "bdist_wheel",
            "python_version": "cp312",
            "requires_python": ">=3.8",
            "size": 91836943,
            "upload_time": "2024-02-03T05:19:07",
            "upload_time_iso_8601": "2024-02-03T05:19:07.761073Z",
            "url": "https://files.pythonhosted.org/packages/1e/01/095c6534f157d5a429772fdb83103c1fb147e112f98643e6b61d348152da/chdb-1.2.1-cp312-cp312-macosx_10_15_x86_64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "e1773ab8e7a77873d6053eded2811b26f147586aab7f3dc98f177d715ef1573a",
                "md5": "8ca6e99e86aa4cbd6b656aba6c7f2562",
                "sha256": "6d57d5b15ebc5d4158d75f3a19e50631513b1da57524c3ec7c0a48c2baf48836"
            },
            "downloads": -1,
            "filename": "chdb-1.2.1-cp312-cp312-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
            "has_sig": false,
            "md5_digest": "8ca6e99e86aa4cbd6b656aba6c7f2562",
            "packagetype": "bdist_wheel",
            "python_version": "cp312",
            "requires_python": ">=3.8",
            "size": 126302753,
            "upload_time": "2024-02-03T04:57:34",
            "upload_time_iso_8601": "2024-02-03T04:57:34.264954Z",
            "url": "https://files.pythonhosted.org/packages/e1/77/3ab8e7a77873d6053eded2811b26f147586aab7f3dc98f177d715ef1573a/chdb-1.2.1-cp312-cp312-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "3e92db08dede1b67b3d9d66d05cc7abbfede3aa96a687211817fb4a58a676a6b",
                "md5": "98680b85a6861e7d8299af094c5f0861",
                "sha256": "e66646cf75d37fc61f530ca238fe89a8fcf527a7eed6524bf93d5db273948856"
            },
            "downloads": -1,
            "filename": "chdb-1.2.1-cp38-cp38-macosx_10_15_x86_64.whl",
            "has_sig": false,
            "md5_digest": "98680b85a6861e7d8299af094c5f0861",
            "packagetype": "bdist_wheel",
            "python_version": "cp38",
            "requires_python": ">=3.8",
            "size": 91828156,
            "upload_time": "2024-02-03T05:43:26",
            "upload_time_iso_8601": "2024-02-03T05:43:26.774388Z",
            "url": "https://files.pythonhosted.org/packages/3e/92/db08dede1b67b3d9d66d05cc7abbfede3aa96a687211817fb4a58a676a6b/chdb-1.2.1-cp38-cp38-macosx_10_15_x86_64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "039a840bae56ed8215b3c07c8d1cfb46a6fb53f79e220c36aed1e0a5a8b7ba61",
                "md5": "a69955337fde3f4a3f4795b32a7281d8",
                "sha256": "da243218bacf811e4d4ab0f2f26ac7a26c6dee0c3778739032bf93a3529725ae"
            },
            "downloads": -1,
            "filename": "chdb-1.2.1-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
            "has_sig": false,
            "md5_digest": "a69955337fde3f4a3f4795b32a7281d8",
            "packagetype": "bdist_wheel",
            "python_version": "cp38",
            "requires_python": ">=3.8",
            "size": 126297990,
            "upload_time": "2024-02-03T04:56:30",
            "upload_time_iso_8601": "2024-02-03T04:56:30.173409Z",
            "url": "https://files.pythonhosted.org/packages/03/9a/840bae56ed8215b3c07c8d1cfb46a6fb53f79e220c36aed1e0a5a8b7ba61/chdb-1.2.1-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "46915bbb09997fa84bc4c9403f71e46dba8f5fb5e365299d3e8811f0405485d4",
                "md5": "e532df7ee74b0cc8468035da3d0dc85d",
                "sha256": "3e62a3d8767cabfaca789d88b051d8f57f8d4ad21d238854e38e8f614d72551b"
            },
            "downloads": -1,
            "filename": "chdb-1.2.1-cp39-cp39-macosx_10_15_x86_64.whl",
            "has_sig": false,
            "md5_digest": "e532df7ee74b0cc8468035da3d0dc85d",
            "packagetype": "bdist_wheel",
            "python_version": "cp39",
            "requires_python": ">=3.8",
            "size": 91830538,
            "upload_time": "2024-02-03T05:41:49",
            "upload_time_iso_8601": "2024-02-03T05:41:49.919474Z",
            "url": "https://files.pythonhosted.org/packages/46/91/5bbb09997fa84bc4c9403f71e46dba8f5fb5e365299d3e8811f0405485d4/chdb-1.2.1-cp39-cp39-macosx_10_15_x86_64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "08cd35140f720b77cdb95d0aad8de47ecca394f1df2d5dc722afef96abcbdf56",
                "md5": "1fc5cda98f62e54ef6e89176856a32e7",
                "sha256": "aa0595ad7b37a9d1344daca7a8b33ed52cc9ce5994def3b3ee5a197007e151da"
            },
            "downloads": -1,
            "filename": "chdb-1.2.1-cp39-cp39-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
            "has_sig": false,
            "md5_digest": "1fc5cda98f62e54ef6e89176856a32e7",
            "packagetype": "bdist_wheel",
            "python_version": "cp39",
            "requires_python": ">=3.8",
            "size": 126297651,
            "upload_time": "2024-02-03T04:56:32",
            "upload_time_iso_8601": "2024-02-03T04:56:32.406284Z",
            "url": "https://files.pythonhosted.org/packages/08/cd/35140f720b77cdb95d0aad8de47ecca394f1df2d5dc722afef96abcbdf56/chdb-1.2.1-cp39-cp39-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-02-03 05:19:45",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "auxten",
    "github_project": "chdb",
    "travis_ci": false,
    "coveralls": true,
    "github_actions": true,
    "tox": true,
    "lcname": "chdb"
}
        
Elapsed time: 0.20057s