/SQLite-View

Web interface to manage multiple SQLite databases

Primary LanguageHTMLMIT LicenseMIT

SQLite-View

A web interface to manage multiple SQLite databases.

Installation

To install SQLite-View first clone this repository and move to that directory.

$ git clone https://github.com/Jason2605/SQLite-View.git

$ cd SQLite-View

Then in your favourite python virtual environment, install the requirements with pip.

$ pip install -r requirements.txt

Running

To run SQLite-View.

$ python3 runserver.py

This will bind to 0.0.0.0:5000 by default, you can change this in runserver.py

Note: If you are running this for the first time, you will be prompted to enter a username and password on the command line, this is the account you log in with on the website.

Features

  • Manage multiple sqlite databases
  • Export databases to an SQL file
  • Delete tables within databases
  • Add table indexes
  • Add/rename/delete columns
  • View table schema
  • View table indexes
  • View data
    • View it in tabular format
    • View it in JSON format
  • Manipulate the data
    • Delete rows
    • Edit rows
    • Run user defined queries
  • Users
    • Separate user accounts

Screenshots