Skip to main content

pydbhub

Project description

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

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

pydbhub-0.0.4.tar.gz (15.9 kB view hashes)

Uploaded source

Built Distribution

pydbhub-0.0.4-py2.py3-none-any.whl (8.1 kB view hashes)

Uploaded py2 py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page