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. :smile:
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-bjh 0.0.9
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_bjh-0.0.9.tar.gz | 8.6 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| pydbhub_bjh-0.0.9-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 17.4 kB
Release files / pydbhub_bjh-0.0.9.tar.gz
| Download URL | pydbhub_bjh-0.0.9.tar.gz |
|---|---|
| Size | 8.6 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
f045fa140d7db8c270f446a79ae57b7f4d4ab1c11a4dc9e72f72425328c404fa
|
|
BLAKE2b-256 checksum How to use checksums |
af59bed947f1f4549be3efb50e9f068ea9241faff05120178b742897c868071f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
pdm/2.8.2 CPython/3.11.1
|
Release files / pydbhub_bjh-0.0.9-py3-none-any.whl
| Download URL | pydbhub_bjh-0.0.9-py3-none-any.whl |
|---|---|
| Size | 8.8 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
bbc8b6bc80705e0e8f9a7f5de865a4e430a61efb23ad0d4760c979320e9d49a8
|
|
BLAKE2b-256 checksum How to use checksums |
3b80afcddda2c2025f69e44c46227debfc072eea5a6ffe1118f5870d371300dd
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
pdm/2.8.2 CPython/3.11.1
|
Security for pydbhub-bjh 0.0.9
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.
