connection-helper
usage
install / update package
uv add connection-helper -U
include in python
from connection_helper import sql, pgp
why use connection-helper
connection-helper bundles some packages for connecting to sql databases
sqlis added as convenience wrapper for retrieving data from sql databasesconnect_sql()to get get data from['mssql', 'sqlite','postgres']load_sql_to_sqliteconnect to a sql db and transfer a list of tables tosqliteload_sqlite_to_parquet()to get all tables from a sqlite file as parquetsunpack_files_to_duckdb()return a tuple of all files of a dir (csv or parquet) into high performance duckdb objectsprint_meta()print meta information of a certain database (niche case)load_from_mssql()load data from an MSSQL database into a Pandas DataFramesave_to_mssql()save data from a Pandas DataFrame to an MSSQL databaseload_file_to_duckdb()load data from various sources into a duckdb database, using pandas read functions (experimental)load_sqlite_to_duckdb()converts a SQLite database to a DuckDB databaseload_mssql_to_duckdb()converts a MSSQL database to a DuckDB databaseapply_duckdb_type_overrides()applies column type overrides to tables in an existing DuckDB databaseadd_duckdb_meta_table()adds a meta table to an existing DuckDB databaseoptimize_duckdb()copies a DuckDB database into a new one and applies optimizations to reduce size
pgpcryptographic tools adapted from python-gnupg. this is a wrapper aroundgnupg, but only offers some convenience or tailored options. feel free to use the original library or the GNU Privacy Guard.encrypt()a message for one or more recipient(s) with a public keydecrypt()a message with a private key. Passphrase must be provided via env variablefind_key()in keyring- ...
💡 The pgp methods require a pgp public/private key in the keyring
secsecrets module. ⚠️ this package is optional and must be extra installed withpip install 'connection-helper[sec]'(enclose in '')
1 maintainer
Metadata
1 maintainer
Release files for connection-helper 0.15.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| connection_helper-0.15.0.tar.gz | 20.3 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| connection_helper-0.15.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 42.3 kB
Release files / connection_helper-0.15.0.tar.gz
| Download URL | connection_helper-0.15.0.tar.gz |
|---|---|
| Size | 20.3 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
d20f50713af73fd5563c324794c2a4565535a014ef0389e8854ece75dd8b523b
|
|
BLAKE2b-256 checksum How to use checksums |
f3d4ff404c009cdcb26c92cc930c31ae450e755db462b9355a99c3b6111d8d3a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Release files / connection_helper-0.15.0-py3-none-any.whl
| Download URL | connection_helper-0.15.0-py3-none-any.whl |
|---|---|
| Size | 22.0 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
07628bbf47456d6b1d1e6cd246c416dfd348ee733116ba786aabe15b22652038
|
|
BLAKE2b-256 checksum How to use checksums |
a695c72ff250e4876afa6f0d57a82c7577bcd8009de5e48c10b6052080fc6e96
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
