Connect Quarkus (Reactive) to Neon

Quarkus is a Java framework optimized for cloud environments. This guide shows how to connect to Neon from a Quarkus project using a Reactive SQL Client.

To connect to Neon from a Quarkus application:

1. Create a Neon Project
2. Create a Quarkus project and add dependencies
3. Configure a PostgreSQL data source
4. Use the Reactive PostgreSQL client
5. Run the application

Create a Neon project

If you do not have one already, create a Neon project.

1. Navigate to the Projects page in the Neon Console.
2. Click New Project.
3. Specify your project settings and click Create Project.

Create a Quarkus project

Create a Quarkus project using the Quarkus CLI:

You now have a Quarkus project in a folder named neon-with-quarkus with the Reactive Postgres client and RESTEasy Reactive extensions installed.

Configure a PostgreSQL data source

Create a .env file in the root of your Quarkus project directory. Configure a reactive data source using your Neon database connection string and specifying the database kind as shown:

Use the Reactive PostgreSQL client

Create a PostgresResource.java file in the same directory as the GreetingResource.java that was generated by Quarkus during project creation. Paste the following content into the PostgresResource.java file:

This code defines a HTTP endpoint that will query the database version and return it as a response to incoming requests.

Run the application

Start the application in development mode using the Quarkus CLI from the root of the project directory:

Visit localhost:8080/postgres/version in your web browser. Your Neon database's Postgres version will be returned. For example:

Need help?

Join the Neon community forum to ask questions or see what others are doing with Neon. Neon Pro Plan users can open a support ticket from the console. For more detail, see Getting Support.