Support for PostgreSQL database

[mjanez]

Metadata Repository Setup
pycsw supports the following databases:

• SQLite3
• PostgreSQL (without PostGIS)
• PostgreSQL with PostGIS enabled
• MySQL

Note
The easiest and fastest way to deploy pycsw is to use SQLite3 as the backend. To use an SQLite in-memory database, in the pycsw configuration, set repository.database to sqlite://.

Note
PostgreSQL support includes support for PostGIS functions if enabled

Note
If PostGIS is activated before setting up the pycsw/PostgreSQL database, then native PostGIS geometries will be enabled.

Steps

• Update the script to use PostgreSQL as the backend database instead of cite.db.
• Install and configure the psycopg2 Python package to enable PyCSW to communicate with PostgreSQL.
• Update the .env.example and PyCSW configuration file to use PostgreSQL as the backend database.
• Modify any database queries in the script to work with PostgreSQL syntax.
• Test ckan2pycsw to ensure that it is working correctly with the new database backend.
• Update any relevant documentation to reflect the changes made to the script and how to use PostgreSQL as the backend database.
• Ensure that any dependencies or requirements for using PostgreSQL are clearly documented and included in the project's documentation or installation instructions.

Refs

• ckanext-datagovuk