tilekiln VS OSMExpress

Tiles, vector or raster, to be consumed for general use are not really in the scope of the OpenStreetMap project. This is surprising to many because it's the first thing you see on OSM.org; the tiles there are for the explicit purpose of feedback to data editors, and make a best-effort to synchronize the instantaneous state of the database in the tiles, unlike Protomaps which delivers a snapshot.

Paul Norman has a project called Tilekiln to adapt vector rendering for this use case on OSM.org: https://github.com/pnorman/tilekiln

Hi, the value add in the commercial offering is described here:

https://protomaps.com/docs/faq#openstreetmap

I also maintain open source tooling for anyone to replicate and consume all of OSM, as well as a free download portal:

https://github.com/protomaps/OSMExpress

https://app.protomaps.com/downloads

I work a lot with OSM data, and never loaded into PostgreSql… On one project I keep data in https://github.com/protomaps/OSMExpress, another I keep it in .pbf and just handle minutely changes in memory, then even for PostgreSql there are multiple schema tables each optimized for different work, render server schema is very different from API server…

You did not specify what kind of filtering you want to do, but if you are after area extracts like whole cities or similar, best thing is OSMExpress unfortunatly it takes long time to initialize it for whole planet, but after that extracts are done in seconds.

The major open source component that runs on the server (https://github.com/protomaps/OSMExpress) is tricky to package because it depends on S2 Geometry, which itself has some tough dependencies; the users I know out there are compiling it themselves, or using the community-contributed Dockerfile. I would prefer a .deb, do you think a PPA is the right approach?