Skip to content

Web 🌐 based Admin Interface for SQLite πŸ—‚οΈ Database.

License

Notifications You must be signed in to change notification settings

johnhorsema/SQLite-UI

Β 
Β 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

47 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

About

Web 🌐 based Admin Interface for SQLite πŸ—‚οΈ Database.

Resources

License

Code of conduct

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • HTML 65.1%
  • Go 33.0%
  • Dockerfile 1.3%
  • Other 0.6%