dbnet

DbNet is a Python/VueJS database client to access Oracle, Spark (Hive), Postgres, etc. It is still a work in progess, but should work fine for daily use. MS SQL Server is supported, although with some bugs here and there due to JDBC/JTDS bridge.

Only Chrome and Firefox are supported at the moment.

Install

pip install dbnet

Command dbnet should now be available in the PATH.

Running

dbnet --help

usage: dbnet [-h] [--serve] [--init_db] [--reset_db] [--force] [--port PORT]

DbNet Application

optional arguments:
  -h, --help   show this help message and exit
  --serve      Start the DbNet server
  --init_db    Initiatlize the backend SQLite database
  --reset_db   Reset the backend SQLite database
  --force      Kill any running instance.
  --port PORT  The web application port

dbnet --serve

2019-02-27 10:08:11 -- DB Tables OK.
2019-02-27 10:08:11 -- Main Loop PID is 39685
2019-02-27 10:08:11 -- Monitor Loop PID is 39691
2019-02-27 10:08:11 -- Web Server PID is 39692
2019-02-27 10:08:11 -- URL -> http://macbook:5566/?token=CqPahSJIeg1Nl4Kj
(39692) wsgi starting up on http://0.0.0.0:5566

Setting up Dababase Profile

Your database profile / credentials needs to be set up at ~/profile.yaml or env var PROFILE_YAML. Run command xutil-create-profile to create from template.

Example Entry

PG_XENIAL:
  name: PG_XENIAL
  host: xenial-server
  database: db1
  port: 5432
  user: user
  password: password
  type: postgresql
  url: "jdbc:postgresql://xenial-server:5432/db1?&ssl=false"

Screenshots

Intended Audience
Operating System
- MacOS
- Unix
Programming Language
- Python :: 2
- Python :: 3
Topic
- Utilities

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbnet-0.2.5.tar.gz (4.1 MB view details)

Uploaded Feb 4, 2020 Source

File details

Details for the file dbnet-0.2.5.tar.gz.

File metadata

Download URL: dbnet-0.2.5.tar.gz
Upload date: Feb 4, 2020
Size: 4.1 MB
Tags: Source
Uploaded using Trusted Publishing? No
Uploaded via: twine/3.1.1 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.2.0 requests-toolbelt/0.9.1 tqdm/4.42.1 CPython/3.7.6

File hashes

Hashes for dbnet-0.2.5.tar.gz
Algorithm	Hash digest
SHA256	`a9150cf5acb4aa659f524c5a15627bdce544dfdc768143995740211af6e0aa9b`
MD5	`66a454b7b9175449da0931bca37a255c`
BLAKE2b-256	`0ce7397d2d69766f218535bef5627ebcabe70096f4ddb1c8db78dea71ce83b09`