Skip to content

README.md

Latest commit

 

History

History
55 lines (33 loc) · 2.09 KB

README.md

File metadata and controls

55 lines (33 loc) · 2.09 KB

LOBac SQL

MIT license top language Code size commit activity tag

Based on : DOI

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

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/LOBac/LOBac-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
  • database
  • 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

External packages (included)

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