Port details |
- sqlpage SQL-only webapp builder.
- 0.37.0 www
=2 0.35.2Version of this port present on the latest quarterly branch. - Maintainer: girgen@FreeBSD.org
 - Port Added: 2024-01-15 10:12:05
- Last Update: 2025-09-06 12:03:36
- Commit Hash: 1f5abc5
- People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py311-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 - USE_RC_SUBR (Service Scripts)
-
- 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 = 1757108950
SHA256 (apexcharts@5.3.0/dist/apexcharts.min.js) = 3ad7c7f22806e3f5d5316575d79e5d0a5f241a1aeea302125549bb6591745705
SIZE (apexcharts@5.3.0/dist/apexcharts.min.js) = 580851
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.89.0 : lang/rust
- cmake : devel/cmake-core
- pkgconf>=1.3.0_1 : devel/pkgconf
- llvm-config19 : devel/llvm19
- 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 llvm
- 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:
|