To GDAL or not to GDAL
GDAL is an incredible geospatial library and underpins so much of what we do, including our databases (PostGIS).
However, sometimes it might be a bit heavyweight for what we are trying to achieve.
Installing it as a base system dependency inevitably installs everything - there are no options.
Install size is especially important when building container images, that we want to be as small as possible for distribution.
GDAL in PostGIS
PostGIS uses GDAL for most of it’s geospatial processing, including reading and writing various geospatial file formats.
FMTM is starting to use FlatGeobuf format for various purposes (OSM data extracts, storing submissions).
It also uses a PostGIS database as part of the software stack.
So today I thought: why not just use the geospatial processing built into PostGIS for reading and writing flatgeobuf data?
The solution was surprisingly painless!
Database Access
First we need a way to access the database.


