Port details |
- sqlpage SQL-only webapp builder.
- 0.33.1 www
=2 0.31.0_1Version of this port present on the latest quarterly branch. - Maintainer: girgen@FreeBSD.org
 - Port Added: 2024-01-15 10:12:05
- Last Update: 2025-02-25 20:42:02
- Commit Hash: 082847d
- People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py39-PyOpenGL, p5-Sane
- Also Listed In: databases
- License: MIT
- WWW:
- https://github.com/lovasoa/SQLPage
- Description:
- 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.
¦ ¦ ¦ ¦ 
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - Dependency lines:
-
- To install the port:
- cd /usr/ports/www/sqlpage/ && make install clean
- To add the package, run one of these commands:
- pkg install www/sqlpage
- pkg install sqlpage
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: sqlpage
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1740474003
SHA256 (apexcharts@4.5.0/dist/apexcharts.min.js) = 0f5f6e63bad9b7324f56c656629bd33a86368579a07e0f8c95a7fe00b6074e08
SIZE (apexcharts@4.5.0/dist/apexcharts.min.js) = 574941
Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- rust>=1.85.0 : lang/rust
- pkgconf>=1.3.0_1 : devel/pkgconf
- Library dependencies:
-
- libzstd.so : archivers/zstd
- There are no ports dependent upon this port
Configuration Options:
- No options to configure
- Options name:
- www_sqlpage
- USES:
- cargo
- pkg-message:
- For install:
- 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.
- Master Sites:
|