PostgreSQL Connector

Overview

The PostgreSQL Connector qBit provides optimized PostgreSQL integration for qqq applications. Connection pooling, query optimization, and full support for PostgreSQL-specific features.

Features

• Connection Pooling - HikariCP-based pooling with health checks
• Query Optimization - Automatic index suggestions and query analysis
• JSON Support - Native JSONB field mapping
• Full-Text Search - Built-in support for PostgreSQL text search
• Migrations - Schema versioning with Flyway integration
• Replication - Read replica configuration for scaling

Use Cases

• Applications needing robust relational data storage
• Systems requiring advanced PostgreSQL features
• High-performance transactional applications
• Applications with complex query requirements

Installation

qqq install qbit-postgres --license YOUR_LICENSE_KEY

Configuration

Configure your PostgreSQL connection:

new QInstance()
   .withBackend(new PostgresBackendMetaData()
      .withHost("localhost")
      .withPort(5432)
      .withDatabase("myapp")
      .withUsername(System.getenv("DB_USER"))
      .withPassword(System.getenv("DB_PASSWORD"))
      .withPoolSize(10));

Requirements

• qqq Framework 1.0+
• Java 21+
• PostgreSQL 12+
• QRunIO account with valid license key