Utilities for making connections easier.
Project description
dot-connect
A Python package designed to simplify the way you fetch connection configurations and establish connections to various database and cloud systems.
🚀 Features
- Unified Interface: Single interface - no need to remember different APIs for databases or cloud providers.
- Easy Configuration: Fetch connection configurations from multiple sources like JSON files, environment variables, etc.
- Supported Backends: MySQL, Postgres, and Snowflake. More coming soon.
💽 Installation
pip install dot-connect
📚 Quickstart
- Create a .env file.
SNOWFLAKE_ACCOUNT=orgname-accountname
SNOWFLAKE_USER=username
SNOWFLAKE_PASSWORD=password
- Connect and query various backends!
import dot_connect
con = dot_connect.snowflake.connect()
con.cursor().execute("SELECT 1;").fetchall()
con = dot_connect.snowpark.connect()
con.sql("SELECT 1").show()
con = dot_connect.mysql.connect()
cursor = con.cursor()
cursor.execute("SELECT 1")
cursor.fetchall()
con = dot_connect.postgres.connect()
cursor = con.cursor()
cursor.execute("SELECT 1")
cursor.fetchall()
🤝 Contributing
We welcome contributions! Please see our CONTRIBUTING.md for guidelines.
⚖️ License
Licensed under the Apache License, Version 2.0. See LICENSE for the full text.
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
dot-connect-0.2.0.tar.gz
(8.9 kB
view hashes)
Built Distribution
Close
Hashes for dot_connect-0.2.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6a67ad172168c1f8dda0335e983ef154f13faf18525a94bc052b16c48a24048b |
|
MD5 | e695361263852a16c811da74c5f69e5c |
|
BLAKE2b-256 | 3db34e49ec5ca12b7afa6f5017f73d89be076854bbe475e6f8fc2a30f1195379 |