What databases are supported by default?

The JUDO runtime core provides built-in support for HSQLDB (for development) and PostgreSQL (for production).

What is a JUDO RDBMS Dialect?

A Dialect is an interface in the JUDO framework that acts as a bridge, translating generic DAO operations into database-specific SQL syntax and behavior.

Can I handle database-specific types like JSON?

Yes, by overriding the RdbmsParameterMapper, you can define custom logic to map specific database column types to Java SQL Types.

How do I register a new dialect in my application?

You must implement the Dialect interface, create a Dialect Provider, and then bind that provider within a Guice AbstractModule to make it available to the runtime.

How do I execute database-specific initialization commands?

Implement the RdbmsInit interface to execute setup logic, such as setting session variables or creating custom functions, during the data source connection phase.

JUDO RDBMS Dialect Extension

Name: JUDO RDBMS Dialect Extension
Author: BlackBeltTechnology

byBlackBeltTechnology

0•

Database Management

Extends the JUDO DAO framework to support new database dialects like MySQL, Oracle, and custom RDBMS systems.

The JUDO RDBMS Dialect Extension skill equips Claude with the technical patterns and architectural knowledge needed to integrate new databases into the JUDO runtime. It provides step-by-step guidance on implementing the Dialect interface, configuring Guice modules for dependency injection, and handling database-specific nuances such as custom SQL type mappings and syntax variations for limits or offsets. This skill is essential for developers who need to move beyond standard PostgreSQL or HSQLDB support to implement specialized database logic or migrate JUDO applications to different relational database environments.

Key Features

01SQL syntax customization for limit, offset, and concatenation

020 GitHub stars

03Database-specific SQL type mapping and parameter handling

04Standardized Dialect interface implementation patterns

05Guice module registration for custom database providers

06RdbmsInit implementation for session and schema initialization

Use Cases

01Integrating a new database like MySQL or MariaDB into a JUDO project

02Overriding default type mappings for specialized data types like JSON

03Customizing SQL generation for legacy or proprietary RDBMS systems

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add blackbelttechnology/judo-runtime-core dialect-extension

For use in Claude.ai and ChatGPT

Download Skill