www/sqlpage 0.46.3 DragonFly

SQL-only webapp builder.

System: DragonFly
Repository: DPorts
Maintainer: [email protected] (as in FreeBSD)
License: MIT
Categories: databases, www
Package size: 9415.0 KiB, 35006.2 KiB installed

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.

In the other systems

The newest version among them is 0.46.3, as upstream numbers it.

System

Port

Version

Vulnerabilities

Status

Maintainer

Last update

DragonFly

www/sqlpage

0.46.3 newest

none known

[email protected]

FreeBSD

www/sqlpage

0.46.3_1 newest

none known

[email protected]

2026-10-14

HardenedBSD

www/sqlpage

0.46.3_1 newest

no data

[email protected]

GhostBSD

www/sqlpage

0.46.3_1 newest

no data

[email protected]

Version history 1

0.46.3 2026-11-11

Upstream's version as each commit to the port's Makefile set it, or as this site first saw it in the system's packages; the tree's own revisions are not versions here.

Install

Binary package:

pkg install sqlpage

From DPorts:

cd /usr/dports/www/sqlpage && make install clean

Dependency graph

Ports that need it on the left, what it needs to run on the right; at most 8 of each. "Dependencies" below lists them all.

graph LR
  me["www/sqlpage"]
  me --> d0["archivers/zstd"]
  me --> d1["databases/unixODBC"]
  classDef this fill:#ab2b28,color:#ffffff,stroke:#ab2b28
  class me this

Dependencies

Run dependencies 2

No port depends on this one.

Configuration

No options to configure.

Service scripts: none

Message after installing

To get started, configure /usr/local/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.