Package net.blockhost.commons.database.core

@NullMarked package net.blockhost.commons.database.core

Core database utilities for 6b6t plugins.

This package provides dialect-independent database connectivity using HikariCP connection pooling. It provides a unified API for connection management that works with any SQL database.

Quick Start with SQLManager (Recommended)

Use the database-specific modules (commons-database-mariadb, commons-database-postgres) for configuration that provides the JDBC URL and driver class:

// Using MariaDbConfig from commons-database-mariadb
MariaDbConfig dbConfig = config.database();

SQLManager sqlManager = SQLManager.create(dbConfig)
    .poolName("MyPlugin-Pool")
    .logger(plugin.getLogger())
    .build();

sqlManager.registerTable("CREATE TABLE IF NOT EXISTS players (...)");
sqlManager.connect();

sqlManager.withConnection(connection -> {
    // Use connection
});

sqlManager.shutdown();

Database-Specific Modules

For database-specific configuration, use the specialized modules:

• commons-database-mariadb - MariaDB/MySQL configuration
• commons-database-postgres - PostgreSQL configuration
• commons-database-redis - Redis connectivity

See Also:

• SQLManager
• DatabaseCredentials
• HikariDataSourceBuilder

Class	Description
DatabaseCredentials	Immutable holder for database connection credentials and configuration.
DatabaseCredentials.DatabaseCredentialsBuilder	Custom builder with validation.
HikariDataSourceBuilder	Builder for creating HikariCP connection pool data sources.
PooledDatabaseConfig	Interface for database configurations that support HikariCP connection pooling.
SQLManager	Generic SQL connection manager with HikariCP connection pooling.
SQLManager.Builder	Builder for creating SQLManager instances.
SQLManager.ConnectionConsumer	Functional interface for connection consumers that may throw SQLException.
SQLManager.ConnectionFunction<T>	Functional interface for connection functions that may throw SQLException.