This is a very simple example of a website that uses the SQLPage web application framework.
This website illustrates how to create a basic Create-Read-Update-Delete (CRUD) application using SQLPage. It has the following bsic features:
- Displays a list of user names using the list component (in
index.sql
) - Add a new user name to the list through a form (in
index.sql
) - View a user's personal page by clicking on a name in the list (in
user.sql
) - Delete a user from the list by clicking on the delete button in the user's personal page (in
delete.sql
)
To run the example, just launch the sqlpage binary from this directory.
index.sql
: The main page of the website. Contains a form to add a new user and a list of all users.user.sql
: The user's personal page. Contains a link to delete the user.delete.sql
: The page that deletes the user from the database, and the redirects to the main page.sqlpage/migrations/001_create_users_table.sql
: The SQL migration that creates the users table in the database.sqlpage/sqlpage.json
: The SQLPage configuration file.