Skip to main content

SQLITE3 CLI wrapper build on python.

Project description

🍥 aoi

A simple python based sqlite3 CLI.

$python -m pip install aoi

Usage

$aoi [-c "path to connect"]
# if the above fails try executing using full python path. ( read note below image. )
$python -m aoi [-c "path to connect"]

using the -c/--connect option will connect the application to the provided db file path.

If no option is provided, :memory: ( in memory database ) will be used.

Additional Features

Apart from normal sqlite queries you can run the following commands within the CLI:

:h/:help: Get help for commands.

:q/:quit: Exit the CLI.

:r/:recent [amount=5]: Show last [amount=5] queries.

:t/:tables: Shows the tables inside the database

NOTE

The aoi command may fail if the executeable's path wasn't added to the terminal's/system's PATH, however running the library as a module ( python -m aoi ) will always work as long as python is added to path.


Installation

  • Requires Python (3.8 or later)

Installing aoi in your environment using pip, poetry or any favourable package manager

# pip
$pip install aoi # from pypi
$python -m pip install git+https://github.com/sarthhh/aoi.git # from source
# poetry
$poetry add aoi # from pypi
$poetry add git+https://github.com/sarthhh/aoi.git # from source

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

aoi-0.1.2.tar.gz (5.4 kB view hashes)

Uploaded Source

Built Distribution

aoi-0.1.2-py3-none-any.whl (6.4 kB view hashes)

Uploaded Python 3

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