first-last-agg is a simple extension providing two aggregate functions, last and first, operating on any element type and returning the last or the first value of the group.

This library enables control of NuHeat Signature radiant floor thermostats. It connects to the NuHeat web-based API to manage and monitor thermostat settings remotely. Users can fetch the current temperature, set target temperatures, and switch between different modes such as auto, temporary hold, or permanent hold. The library facilitates interactions with the thermostat’s functionalities including setting temperature until a specified time, resuming programmed schedules, and retrieving thermostat properties like heating status and online status. An internet connection is required to use the API.

pgRouting extends the PostGIS/PostgreSQL geospatial database to provide geospatial routing and other network analysis functionality.

pgRouting extends the PostGIS/PostgreSQL geospatial database to provide geospatial routing and other network analysis functionality.

OGR is the vector half of the GDAL spatial data access library. It allows access to a large number of GIS data formats using a simple C API for data reading and writing. Since OGR exposes a simple table structure and PostgreSQL foreign data wrappers allow access to table structures, the fit seems pretty perfect.

pgTAP is a suite of database functions that make it easy to write TAP-emitting unit tests in psql scripts suitable for harvesting, analysis, and reporting by a TAP harness, such as those used in Perl and PHP applications.