How to write from Xpages to PostgreSql database?

I have to create an Xpage web application which directly inputs data in a PostgreSql database. I've never worked with a PostgreSql database so I have absolutely no idea on how to approach this.

The application will be used through a browser if that matters.

Any help would be highly appreciated.

Solution

or, if you do not want to use the extLib for this purpose only, take a look at http://www.eknori.de/2011-07-03/using-mysql-data-in-xpages/ The article describes, how to access MySQL, but you can use the same code even for PstGreSQL with the correct JDBC drive. The article also contains a link to OpenNTF where you can download the full source code.

How to perform read queries on read replica in postgres?
How can I query what security labels exist on a table?
PostgreSQL, bulk update using data from another table
Django 5.1 + Postgresql (debian server)
How to use values from CTE in ON CONFLICT UPDATE
checking java date with postgresql timestamp without timezone
Enable debugging of postgresql functions on database inside a docker container using pgAdmin
TypeORM: Custom Many To Many Relationship
Delete json object from jsonb type column based on key of json object in postgresql
Docker runs PostgreSQL in "trust" mode
How to fix Postgres error "operator does not exist" using pgvector
Rails 4 scope NOTNULL refactor
postgreSQL index not found why?
Select on self-referencing table where all chains meet a condition
How to successfully save data to another database column in postgresql using jetpack compose?
In a join, fields with null values are not getting shown but in normal query they are
Install pgAgent on AWS RDS for Postgres
Spring JBDC bad SQL grammar on PostgreSQL
Using IF in function for different queries as a result
Variables in looping condition in a postgreSQL while loop
SQL query for returning rows with only certain values in list but not others?
How to insert data into a code-first database with a SQL script?
How do I insert a record into a Postgres DB based off the MAX of one column?
Pyspark JDBC read with partitions
Quarkus dev postgresql container not shutting down with quarkus
Permission issue with PostgreSQL in docker container
Starting application development using Docker or configuring Docker during development?
Postgres vs MySQL index locking: Should I expect MySQL to be more tolerant to parallel write-heavy applications?
postgresql - replace all instances of a string within text field
migrate data from MS SQL to PostgreSQL?