SQLPage transforms your SQL queries into stunning websites
SQLPage is a tool that allows you to build websites using nothing more than SQL
queries. You write simple text files containing SQL queries, SQLPage runs them
on your database, and renders the results as a website.
You can display the information you SELECT from your database in lists, tables,
cards and other user interface widgets. But you can also INSERT, UPDATE and
DELETE data from your database using SQLPage, and build a full webapp with
Create, Read, Update, Delete functionality.
To get started, configure ${PREFIX}/etc/sqlpage/sqlpage.json and at least set
your database source and create a database. If using SQLite, set ownership
appropriately. SQLPage runs as user sqlpage per default. Once the datasource is
set, you can start the sqlpage using normal rc script:
sysrc sqlpage_enable=yes
service sqlpage start
This will start a web server on port 8080. See
https://github.com/lovasoa/SQLpage/blob/main/configuration.md for more
configuration details.
For more ambitous setups, set up a rev proxy using your favourite web server,
e.g. nginx or apache, and use PostgreSQL as the backend database.
*/*: remove STRIP_CMD calls in rust based ports
This is not needed after bc4fedc1fec0d359365c04d43be9e32bf101a50e
PR: 246993
Differential Revision: https://reviews.freebsd.org/D46503
www/sqlpage: Update to 0.19.1
This includes a security issue. There is no CVE and since the port is
brand new, there is no reason to add a vuln entry. Check the release
notes if you use the port.
Release notes: https://github.com/lovasoa/SQLpage/releases/tag/v0.19.1
www/sqlpage: Add new port for SQLPage
SQLPage is an Open-source low-code web application server. It allows
you to create full websites writing only simple database queries.
