Skip to content

README.md

Latest commit

 

History

History
59 lines (35 loc) · 2.28 KB

README.md

File metadata and controls

59 lines (35 loc) · 2.28 KB

banner

MIT license top language Code size commit activity tag DOI

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

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:

demo

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

demo1

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

demo2

External packages (included)

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