github.com
The nominatim_fdw is a PostgreSQL extension facilitating the harvesting and resolution of addresses from Nominatim servers. It enables PostgreSQL databases to seamlessly interact with Nominatim servers through a set of SQL commands and functions, supporting a range of operations from server creation to data retrieval. The extension can also be deployed using Docker.
Main Points
nominatim_fdw Overview
Nominatim Foreign Data Wrapper (nominatim_fdw) enables PostgreSQL to access data from Nominatim servers efficiently.
Functionality
It offers streamlined operations like CREATE SERVER, ALTER SERVER, and various functions to directly interact with Nominatim data.
Deployment Options
nominatim_fdw can be deployed traditionally or via Docker, ensuring flexibility in the deployment process.
Insights
Nominatim Foreign Data Wrapper for PostgreSQL (nominatim_fdw) facilitates access to Nominatim servers' data via simple function calls.
The nominatim_fdw is a PostgreSQL Foreign Data Wrapper to access data from Nominatim servers using simple function calls.
The extension supports various functionalities through specific SQL commands and function calls, such as creating servers, altering server options, and performing search, reverse, and lookup operations.
To use the nominatim_fdw you must first create a SERVER to connect to a Nominatim endpoint. After that, you can retrieve the data using the nominatim_fdw functions.
Deployment options include both traditional installation methods and containerization via Docker.
To deploy nominatim_fdw with docker just pick one of the supported PostgreSQL versions, install the requirements and compile the source code.
Links
URL
https://github.com/jimjonesbr/nominatim_fdw