pydbhub
A Python library for accessing and using SQLite databases on DBHub.io. This is an early stage work in progress
What works now
- Run read-only queries (eg SELECT statements) on databases, returning the results as JSON
- Upload and download your databases
- List the databases in your account
- List the tables, views, and indexes present in a database
- List the columns in a table, view or index, along with their details
- List the branches, releases, tags, and commits for a database
- Generate diffs between two databases, or database revisions
- Download the database metadata (size, branches, commit list, etc.)
- Retrieve the web page URL of a database
Still to do
- Anything else people suggest and seems like a good idea. Please try it out, submits PRs to extend or fix things, and report any weirdness or bugs you encounter. 😄
Pre-requisites
- Python version 3.7
- Older Python releases should NOT be OK. Newer Python releases should be OK, but only Python 3.7 has been tested (so far).
- A DBHub.io API key
- These can be generated in your Settings page, when logged in.
Installation
pip install pydbhub
Further examples
- SQL Query - Run a SQL query, return the results as JSON
- List databases - List the databases present in your account
- List tables - List the tables present in a database
- List views - List the views present in a database
- List indexes - List the indexes present in a database
- Retrieve column details - Retrieve the details of columns in a table
- List branches - List all branches of a database
- List releases - Display the releases for a database
- List tags - Display the tags for a database
- List commits - Display the commits for a database
- Generate diff between two revisions - Figure out the differences between two databases or two versions of one database
- Upload database - Upload a new database file
- Download database - Download the complete database file
- Delete database - Delete a database
- Retrieve metadata - Download the database metadata (size, branches, commit list, etc)
- Web page - Get the URL of the database file in the webUI. eg. for web browsers
1 maintainer
Metadata
1 maintainer
Release files for pydbhub 0.0.4
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| pydbhub-0.0.4.tar.gz | 15.9 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| pydbhub-0.0.4-py2.py3-none-any.whl | Python 2, Python 3 | none | any | Details |
Total release size: 23.9 kB
Release files / pydbhub-0.0.4.tar.gz
| Download URL | pydbhub-0.0.4.tar.gz |
|---|---|
| Size | 15.9 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
57b184a0f67de70b1bdda56af30e24b8b93c4f6b36e73e0049b28092a0060fb9
|
|
BLAKE2b-256 checksum How to use checksums |
1eaba3aeab312b4a1e04ed97306e0888628dc28f6dbdd93d77e292dcc071b6df
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
python-requests/2.26.0
|
Release files / pydbhub-0.0.4-py2.py3-none-any.whl
| Download URL | pydbhub-0.0.4-py2.py3-none-any.whl |
|---|---|
| Size | 8.1 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
a0e5e26261b5bd806a1a028f6d5db3931de2a32a81bc68a897a961a8535396aa
|
|
BLAKE2b-256 checksum How to use checksums |
e85393ca421bdb4dfc315e4bb042c1b64d5c3f01f69cdc927c78d650149d3728
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
python-requests/2.26.0
|
Security for pydbhub 0.0.4
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
