www/sqlpage 0.46.3_1 FreeBSD

SQL-only webapp builder.

System: FreeBSD
Repository: FreeBSD ports
Maintainer: [email protected]
Last update: 2026-10-14
Commit: 9c878207a1
License: MIT
Categories: www, databases
Package size: 7560.7 KiB, 21040.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.

Install

Binary package:

pkg install sqlpage

From the ports tree:

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

To depend on this port in another port's Makefile:

RUN_DEPENDS=	sqlpage>0:www/sqlpage

Packages

The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.

Repository

aarch64

amd64

armv6

armv7

i386

FreeBSD:14:latest

0.46.3

0.46.3_1

0.36.1

0.46.3_1

FreeBSD:14:quarterly

0.46.3

n/a

0.35.2

0.46.3

FreeBSD:15:latest

0.46.3_1

n/a

0.36.1

FreeBSD:15:quarterly

0.46.3

n/a

FreeBSD:16:latest

0.46.3

0.46.3_1

n/a

FreeBSD:16:quarterly

n/a

Dependencies

As this port's Makefile names them.

Library 2

libzstd.so : archivers/zstd
libodbc.so : databases/unixODBC

The full lists below include those, and their dependencies in turn.

Build dependencies 21

Run dependencies 3

No port depends on this one.

Configuration

No options to configure.

USES: cargo llvm
Service scripts: sqlpage

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.

Files

pkg-plist 7

bin/sqlpage
@sample etc/sqlpage/sqlpage.json.sample
@sample etc/newsyslog.conf.d/sqlpage.conf.sample
@preunexec if cmp -s %D/www/sqlpage/index.sql %D/share/sqlpage/index.sql; then rm -f %D/www/sqlpage/index.sql; fi
share/sqlpage/index.sql
@postexec [ -f %D/www/sqlpage/index.sql ] || cp %D/share/sqlpage/index.sql %D/www/sqlpage/index.sql
@dir www/sqlpage

distinfo 573

File

Size

SHA256

[email protected]/dist/apexcharts.min.js

936826

44f6a2129104bf6ee9f29f0399ecc725990d007d8a89e754ddc250ce27d3f47b

@tabler/[email protected]/dist/css/tabler.min.css

691465

4cdeade29286540dff94acfeb6ea9ea6a16bad4a64ff5604f659414b7c954cd5

@tabler/[email protected]/dist/css/tabler-vendors.min.css

12330

4cf98ce815f55ff04ac27942b923f4870a43c6029f854f31759879b2a6f165b2

@tabler/[email protected]/dist/js/tabler.min.js

85439

0273fadc362ae4ddc8b68e9bd1fd98ae7c835b82fd9b6a4ff6ae2b7064839e55

@tabler/[email protected]/dist/tabler-sprite.svg

2.174951e+06

51bab6fa61b2a527793e0a5f41b2ab065e52d1d1e4e91283554aa7a9456d7118

[email protected]/dist/css/tom-select.bootstrap5.css

18691

336992587f7ae126732979ce01bc11078af593c78071fe6dd976a78fb98a1969

[email protected]/dist/js/tom-select.popular.min.js

44549

6e42464ea2200289f7cafc1d4cb21f9e73e1e2a4ae6c67cad238228279a83049

rust/crates/actix-codec-0.5.4.crate

21920

4c13df95297bcf9014dc89162b0cc69431e192e34e3b419612fc124cfcd45dbf

rust/crates/actix-http-3.13.6.crate

180919

3c4f07a021937af76abef4c458a0d6b25f63f82eec5394354deeb7de0551f523

rust/crates/actix-macros-0.2.4.crate

8380

e01ed3140b2f8d422c68afa1ed2e85d996ea619c988ac834d255db32138655cb

rust/crates/actix-multipart-0.8.2.crate

56447

7bd51a7e04a5e6c84efa4b45ecc5c36f6769ff5b936537c988d39560df0bb5eb

rust/crates/actix-router-0.5.4.crate

40683

14f8c75c51892f18d9c46150c5ac7beb81c95f78c8b83a634d49f4ca32551fe7

rust/crates/actix-rt-2.15.0.crate

21956

e5f794807f82bbd36430c12cd600c73bbab0f52fdde4f0ed49978df113f4807f

rust/crates/actix-server-2.9.5.crate

45826

aec21d555b23ee78a1c0e4ed61667935de7d61664caba878226a081b1ac20a74

rust/crates/actix-service-2.0.3.crate

28409

9e46f36bf0e5af44bdc4bdb36fbbd421aa98c79a9bce724e1edeb3894e10dc7f

rust/crates/actix-tls-3.6.0.crate

51457

21d0a5de50893252dfa9d7c4bf83761bcc1920651916cd9da24c974cf8ee1b92

rust/crates/actix-utils-3.0.2.crate

12647

0128396dd7313f697ad05b21b1a7be7d4cbb81888704f55996e4a27db196bb4d

rust/crates/actix-web-4.15.0.crate

277473

bbacab3593b6b4f7be815076fc52d60a83c873426824675417e2abdd229e2e36

rust/crates/actix-web-codegen-4.3.0.crate

20382

f591380e2e68490b5dfaf1dd1aa0ebe78d84ba7067078512b4ea6e4492d622b8

rust/crates/actix-web-httpauth-0.8.3.crate

29363

7cc7d1a844a6e987662f0cb5a2a7571cde1def4581a8dd2b9ccb1fd326e84cac

Master sites 1

https://cdn.jsdelivr.net/npm/:npm

Commit history 8

Date Commit Credits Log message

2026-10-14

9c878207a1

Mikael Urankar

lang/rust: Bump revisions after 1.99.0

PR: 299016

2026-09-18

c06f8271d2

Palle Girgensohn

www/sqlpage: Update to 0.46.3

Release note: https://github.com/sqlpage/SQLPage/releases/tag/v0.46.3

2026-09-13

7e324d8ee5

Palle Girgensohn

www/sqlpage: Update to 0.46.2

Release notes: https://github.com/sqlpage/SQLPage/releases/tag/v0.46.2

2026-09-08

7316461925

Mikael Urankar

lang/rust: Bump revisions after 1.98.1

PR: 298139

2026-09-06

7efe1a832a

Palle Girgensohn

www/sqlpage: Update to 0.46.1

Release notes: https://github.com/sqlpage/SQLPage/releases/tag/v0.46.1

The latest 5 of 8 in the history this site was built from.