ryanmearns / sqlite3

SQLite Template

SQLite3 is a lightweight, serverless, open-source database engine used for local storage in applications. It requires no configuration and supports SQL for data manipulation.

✨ Features

• SQLite3 database
• SQLite Web Interface
• trains table with sample data about Thomas & Friends (do you still need more features?)

🤔 How to use

🌎 WebUI Usage

1. Open the project named "SQLite Template"

2. Go to the "Variables" tab and view the SQLITE_WEB_UI_PASSWORD variable, this is the password you'll need to access the web interface

3. Back to Deployments, in the top you'll see a URL which you can use to access the web interface

4. Click on the URL and you'll be redirected to the web interface, type your password and you'll be able to manage your database

That's it! You can now manage your SQLite3.

⚙️ seed_db.sql Usage

After you've deployed this template, you'll find a copy of this project in your Github.
From there you can populate seed_db.sql with your own SQL code.
The file will only be executed when you change anything in it and will run only once.

⚙️ init_db.sql Usage

This file is used to initialize the database.
It includes sample data for a trains table.

📙 Learn more

• SQLite3
• SQLite Web