Skip to main content

The MyPythonDB project

Project description

MyPythonDB

Python is at the heart of most data analysis but to share analysis's most users have been uploading data to SQL databases, until now. MyPythonDB turns your python instance into an SQL database. Existing tools can query data directly at faster than database speeds.

  • PythonDB provides a MySQL interface that allows every BI tool to just work.
  • With DuckDB and Polars-SQL you can directly query in-memory dataframes, S3 or on-disk parquet files using SQL.
  • Via the simple SQL editor web interface, you can share links to results with colleagues.

Modern tools and libraries are arriving and providing capabilities and performance only previously available accessible by paying for huge enterprise licenses $$$. Given these changes, We believe data analysts will increasingly be performed using these tools in future.

Uses

  1. Import package to expose your python instance as a MySQL Database.
  2. pythondb.exe mydb.duckdb - Load a duckdb database and make it remotely accessible.
  3. pythondb --language duckdb - A new in-memory duckdb instance
  4. pythondb code.py --language polars - A polars instance

Python as MySQL

import mypythondb

mypythondb.start(port=3145, webport=9090, language='POLARS')

Command Line Options

Options:
  -l, --language LANG    Language to interpret code as.  [default: PYTHON]
  -c, --command COMMAND  Run COMMAND
  -P, --port SQLPORT     Port for MySQL compatible server to listen on
  -w, --webport WEBPORT  Port for webserver to listen on
  -q, --quiet            Quiet, don't show banner
  -v, --verbose          Display debugging information
  --version              Show the version and exit.
  --help                 Show this message and exit.

Development Info

Facts

  • Python is the language for data analysis.
  • Polars / DuckDB provides extremely fast DataFrame operations previously only accessible at great cost.
  • Many libraries and databases are converging on common data formats
    • Apache Arrow in memory
    • Apache Parquet on disk

Commands

poetry install --sync
poetry lock
poetry run pythondb
poetry run pytest
poetry run pyinstaller --onefile  launcher.py

Optional TODO

  • Ability to set duckdb conn to one of users choosing.

  • Ability to set polars context to one of users choosing.

  • QWEB

    • autocomplete for duckdb / polars / python?
    • Sharing link to show correct chart type fix.
    • Server Tree Working
  • MySQL

    • Test with tableau / dbeaver / ?
    • Server Tree Working
    • Security - Allow setting authentication function
  • Tutorials/Website

    • Using QDB to enable DuckDB IPC
    • Using QDB to query python direct from tableau / every popular combo......
    • Using QDB to enable polars SQL IPC
  • Deploy

    • Provide mac built package
    • Provide linux built package
    • Get into linux package managers
    • Get into mac package managers
  • KDB

    • Subscribe to streaming data
    • KDB Server ability to allow users to send data in from a kdb+ process?
    • Q Language?
  • Misc

    • K Language?
    • Other languages?

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

mypythondb-0.2.4.tar.gz (15.0 kB view details)

Uploaded Source

Built Distribution

mypythondb-0.2.4-py3-none-any.whl (15.6 kB view details)

Uploaded Python 3

File details

Details for the file mypythondb-0.2.4.tar.gz.

File metadata

  • Download URL: mypythondb-0.2.4.tar.gz
  • Upload date:
  • Size: 15.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.8.3 CPython/3.11.9 Linux/6.5.0-1024-azure

File hashes

Hashes for mypythondb-0.2.4.tar.gz
Algorithm Hash digest
SHA256 25a2218a3c29689ad0e3f871f862a068bfcaecd6d88eaaacdeff4e1e4309e4b7
MD5 20bffb9f4f10b7402ca04c9c3fd13bac
BLAKE2b-256 90dc8f506228d4c0388e9749040a70789136bb223bfffc98012d800cb29b8f5e

See more details on using hashes here.

File details

Details for the file mypythondb-0.2.4-py3-none-any.whl.

File metadata

  • Download URL: mypythondb-0.2.4-py3-none-any.whl
  • Upload date:
  • Size: 15.6 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.8.3 CPython/3.11.9 Linux/6.5.0-1024-azure

File hashes

Hashes for mypythondb-0.2.4-py3-none-any.whl
Algorithm Hash digest
SHA256 4bf583f8c7b9542d72aa8749a487e23ed9f27ccfb7ef67f41d9cd6ed95bf1d89
MD5 32aa8bca31e55cb6e7f0cab26b596377
BLAKE2b-256 3910a09271065e31b95e6312785d59594f463be24bb8c71fe476127df2db0ae4

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page