Apache Empire-db

Apache Empire-db is a lightweight Java framework that provides full SQL freedom for working with relational databases. Unlike traditional ORM solutions, Empire-db allows developers to write complex, type-safe SQL queries directly in Java code without relying on annotations, mapping files, or string literals. It offers a clean and intuitive API that supports advanced SQL features while maintaining high code maintainability and compile-time safety. Empire-db is designed for developers who need full control over their database interactions and prefer a code-centric approach to data access.

Features

• Full SQL control with type-safe Java API.
• No need for annotations, mapping files, or bytecode proxies.
• Supports complex SQL constructs including joins, subqueries, aggregations, unions, and intersections.
• Dynamic record handling with generic getters and setters.
• Metadata access and DDL operations.
• Identity management and concurrency control.
• Code generation tools for database-first development.
• Support for multiple databases including Oracle, SQL Server, PostgreSQL, MySQL, HSQLDB, Derby, and H2.

Capabilities

• Write DBMS-independent code with full SQL expressiveness.
• Perform advanced queries and data manipulation directly in Java.
• Customize and extend the API through subclassing and overriding.
• Generate Java code from existing databases using Maven plugins or API-based tools.
• Integrate with JSF and RESTful services for web-based applications.
• Use dynamic records for flexible data access and manipulation.

Benefits

• Eliminates ORM limitations and complexity.
• Improves code readability, maintainability, and safety.
• Enables precise control over SQL statements and database behavior.
• Reduces development overhead by avoiding boilerplate and configuration files.
• Facilitates rapid development of complex data-driven applications.
• Offers a lightweight and straightforward alternative to traditional ORM frameworks.