Apollo SQL is a lightweight Oracle database manager developed by a group of students from Málaga's University.

This CLI program written in Python allows you to connect to remote database to query and relate data with predesigned queries (modify custom/queries.sql and custom/db_data_.py), show whole tables, and insert data into them.

Requirements

• Python 3
• cx-Oracle module
• Oracle Instant Client

Installation

git clone https://github.com/olegbrz/Apollo-SQL.git

Usage

The usage is pretty simple, just launch the main.py file:

python main.py

It works with a CLI (command-line interface), so you just need a command line to work with it.

In the first start, you will need to setup in settings the following connection parameters:

• host
• port
• sid
• username
• password

The settings persist in memory in the config.ini file, which will be created automatically on first start.

Demo

Here are some examples from the interface (main menu, settings, and a query) running on Windows Powershell 5.1:

The program also allows to perform customized queries from the menu:

Relate (1:1, 1:N and N:M relationships) and insert data functionalities:

External packages (included)

The program uses external open-source packages (license included in every package in extra/):

• tabulate 0.8.7