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.
- SQLite3 database
- SQLite Web Interface
trainstable with sample data about Thomas & Friends (do you still need more features?)
-
Open the project named "SQLite Template"
-
Go to the "Variables" tab and view the
SQLITE_WEB_UI_PASSWORDvariable, this is the password you'll need to access the web interface -
Back to
Deployments, in the top you'll see a URL which you can use to access the web interface -
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.
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.
This file is used to initialize the database.
It includes sample data for a trains table.