Skip to content

Database Connection Library for DataFrames from SQL and CSVs. Built on Polars.

Notifications You must be signed in to change notification settings

jacobdwyer16/dbconnect

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

"Coming soon" :)

CSVEngine: CSV data DatabaseEngine: database engine

Make sure you have a db.env saved at the root of the directory with the following parameters:

DBUSER=jacob
DBPASSWORD=password
DBHOST=host
DBPORT=1234
DBNAME=database_name
QUERYFOLDER=query

polars and polars-lts-cpu are mutually exclusive packages that are required for running Polars. polars should be the default.

However, the code may generate the following error if the CPU is not within the specification range for polars:

The following required CPU featurese were not detected: avx2, fma, bmi1, bmi2, ...

...

Install the `polars-lts-cpu` package to run polars with better compatibility.

This requires the use of a different distribution with Polars, so uninstall polars and install polars-lts-cpu without any code changes.

To convert polars to pandas, use .to_pandas() at the end of a function.

About

Database Connection Library for DataFrames from SQL and CSVs. Built on Polars.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages