pg_tileserv is a PostGIS-only tile server written in Go. By restricting itself
to only using PostGIS as a data source, pg_tileserv gains the following
features:
- Automatic configuration. The server can discover and automatically publish
as tiles sources all tables it has read access to: just point it at a
PostgreSQL/PostGIS database.
- Full SQL flexibility. Using function layers, the server can run any SQL to
generate tile outputs. Any data processing, feature filtering, or record
aggregation that can be expressed in SQL, can be exposed as parameterized tile
sources.
- Database security model. You can restrict access to tables and functions
using standard database access control. This means you can also use advanced
access control techniques, like row-level security to dynamically filter
access based on the login role.
many: Unsupported Go dep; deprecate and schedule for removal
There are about 75 ports that depend on old, unsupported Go
versions. I've scheduled those Go versions for deletions on
2025/01/01, and so these ports are scheduled for removal on
that same day.
HOWEVER....
Likely NONE or VERY VERY FEW of these ports will actually need
to be deleted! This stems from a misunderstanding:
When go.mod says "go 1.23", it means that it requires AT LEAST
go-1.23. Locking a port to a specific go version should almost
never happen; it is reserved for when a package absolutely
(Only the first 15 lines of the commit message are shown above )
databases/pg_tileserv: PIN to GO 1.20
This port deos not build at the moment unlike the other commits which I
have tested. For now comitting without tests as the other ports works
well with same changes.
There are also reports in portsfallout.
PR: 277776
Approved by: portmgr (blanket)
databases/pg_tileserv: fix build on riscv64
Bump golang.org/x/sys dependency to a version new enough
to support riscv64-freebsd.
Sponsored by: Berliner Linux User Group e.V.
Approved by: portmgr (build fix blanket)
Differential Revision: https://reviews.freebsd.org/D39163
Remove WWW entries moved into port Makefiles
Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.
This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.
Approved by: portmgr (tcberner)
Add WWW entries to port Makefiles
It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.
Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.
There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above )
databases/pg_tilserv: add new port
pg_tileserv is a PostGIS-only tile server written in Go.
By restricting itself to only using PostGIS as a data source,
pg_tileserv gains the following features:
- Automatic configuration. The server can discover and
automatically publish as tiles sources all tables it has read
access to: just point it at a PostgreSQL/PostGIS database.
- Full SQL flexibility. Using function layers, the server can
run any SQL to generate tile outputs. Any data processing,
feature filtering, or record aggregation that can be expressed in SQL,
can be exposed as parameterized tile sources.
- Database security model. You can restrict access to tables and
functions using standard database access control.
This means you can also use advanced access control techniques,
like row-level security to dynamically filter access based on the
login role.
WWW: https://github.com/crunchydata/pg_tileserv/issues
