connector-x
connector-x copied to clipboard
sfu-db
Fastest library to load data from DB to DataFrames in Rust and Python
### The problem When loading postgres JSONB columns to polars, connectorx currently throws ``` RuntimeError: No conversion rule from JSONB(true) to connectorx::destinations::arrow::typesystem::ArrowTypeSystem. ``` Related: #121 ### The solution For sqlite...
Hello, Using mysql interface with Clickhouse to load data into polars, etc. It works fine as long as I don't add the LIMIT clause at the end of the query:...
#### Describe your feature request It would be great if ConnectorX can be made into a more generic DB client and be PEP 249 compliant. Many existing tools and applications...
#### What language are you using? Rust #### What version are you using? 1.67.1 #### What database are you using? mysql #### What dataframe are you using? arrow #### Can...
I cannot get connectorx to work on Colab. The following code sections execute fine locally in Jupyter Lab, but produce errors when run in Colab. I thought this feedback might...
#### What language are you using? Python #### What version are you using? 0.3.1 #### What database are you using? sqlite #### What dataframe are you using? N/A #### Can...
#### What language are you using? Replace this text with the Rust What version are you using? rustc 1.67.0-nightly (70f8737b2 2022-11-23) Replace this text with the version. rustc 1.67.0-nightly (70f8737b2...
Currently we cannot use MSSQL `uniqueidentifier` type columns for partitioning. But this datatype is actually comparable, and you can run queries like this, and get results on newer SQLs: ```sql...
I tried to establish a connection to my sqlite3 database which is located on my laptop's hard drive. I used the follwing example code from https://sfu-db.github.io/connector-x/databases/sqlite.html: ~~~ import connectorx as...
Is it possible to add DB2 as a supported database? We use ConnectorX for MS SQL, we'd also like to use it for DB2, but it doesn't look like its...
