Skip to content

Shivansh-yadav13/SQLite-UI

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

46 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

SQLite-UI

🌐 SQLite UI

SQLite UI is a web user interface for SQLite database built with Golang. It is built in Golang using the Fiber package. Fiber is an Express inspired web framework You can read more about it here. Project is right now at it's very intial stage and under developement. Our plan is to make this a Good Open Source project, where people can easily start contributing, fix bugs and add more features πŸ™‚.

πŸ”§ Usage

Step 1:

Pull Docker Image.

docker pull ghcr.io/shivansh-yadav13/sqlite-ui:latest

Step 2:

Start Docker container using:

docker run -p 3000:3000 -v { location of db file }:/app -e SQLITE_NAME=/app/{ db file name } shivansh-yadav13/sqlite-ui:latest

Optional: You can also use the --name and -d for the name of the container and for running in detached mode.

πŸ’» Set up Project Locally

1.) Fork the repository by click the Fork button at the top right of the page.

Screenshot from 2022-09-22 12-07-47

2.) Navigate to a directory, open the terminal and paste the following command and replace your-github-username with your GitHub username:

git clone https://github.com/your-github-username/SQLite-UI.git

3.) Build the TailwindCSS bundle, see https://tailwindcss.com/docs/installation for instruction to install the cli.

./tailwindcss -i ./static/css/app.css -o ./static/css/build.min.css --minify

4.) Now we are ready to start the server, run the following:

$ go run main.go

This will create an empty data.db in the current directory. Alternatively, you can also pass in an existing database file as follow:

$ SQLITE_NAME=<path-to-db-file> go run main.go

5.) Now you can visit localhost:3000 and you will be able to see:

Screenshot from 2022-09-22 12-21-21

πŸ‘₯ Contributors

Contributors