connector-x
connector-x copied to clipboard
sfu-db
Fastest library to load data from DB to DataFrames in Rust and Python
May relate to: * https://github.com/sfu-db/connector-x/discussions/162 * https://github.com/sfu-db/connector-x/discussions/135
The below code connects to an Oracle Database - using tnsnames.ora, in TNS_ADMIN / ORACLE_HOME. ```python from os import getenv from sqlalchemy import create_engine import pandas as pd con_string =...
Concatting the results of the connectorx.read_sql methods results in virtual memory explosion. When deep-copying the Arrow table, the garbage collector can do its work and free the memory. But the...
It's basically a postgresql flavor, the basic query parsing and wire protocol should be the same, the initial handshake might be slightly different
Hi again, Would it be possible to allow downloading tables with multiple columns with the same name? `pd.read_sql` can do this I get: RuntimeError: Token error: 'The column 'x' was...
## Problem: `_read_sql` (used via `polars`) ends up hanging in my production system (specified in the context section), while it works perfectly fine in my local environment (Macos, Posgresql 13,...
## Summary Simple cache support for query result in order to speed up loading the same query multiple times. Extensible to more sophisticated design and implementation. ## Design-level Explanation Actions...
for now we convert uuid to string object in pandas, make it to uuid object (align with pandas)
