Version 0.3.1-beta | Jakarta EE 10

Enterprise Java Framework for Rapid Development

Build secure, scalable enterprise applications with advanced RBAC, Row-Level Security, Column-Level Security, and multi-database support. Accelerate development with low-code CRUD generation powered by metadata-driven architecture.

Explore Features View on GitHub
42K+
Lines of Code
8+
Database Vendors
131
Action Controllers
4
Languages
GalaoSystem
Core Capabilities

Enterprise-Grade Features

A comprehensive framework designed for mission-critical enterprise applications with built-in security, scalability, and developer productivity.

Advanced Security Model

Complete RBAC implementation with Role-Based Access Control, Row-Level Security (RLS), and Column-Level Security (CLS) for granular data protection.

Low-Code CRUD Generation

Metadata-driven dynamic CRUD operations. Generate complete data management interfaces from database schemas with minimal code.

Multi-Database Support

Connect to 8+ database vendors including PostgreSQL, MySQL, MariaDB, H2, SQLite, HSQLDB, Derby, and Firebird with unified API.

Full Internationalization

Built-in i18n support with 4 languages ready (pt_PT, en_US, es_ES, fr_FR). Easily extensible for additional locales.

High Performance

Optimized with HikariCP connection pooling and multi-level caching strategy for exceptional throughput and low latency.

Complete Audit Trail

Automatic audit logging for all operations. Track who did what, when, and from where with comprehensive audit service.

System Design

Layered Architecture

Clean separation of concerns with well-defined layers for maintainability and scalability.

Presentation Layer

Velocity Templates • JSON API • 80+ Templates

Web Layer (Filters)

IP Block → Rate Limit → Locale → Auth → CSRF → Authorization

Controller Layer

FrontController Pattern • ActionRegistry • 131 Actions

Service Layer

37 Services • SecurityService • AuthorizationService • RLS/CLS Interceptors

DAO Layer

26+ DAOs • GalãoJDBC V6 Type-Safe SQL

Database Layer

HikariCP Connection Pool • Multi-Database Support

Security First

Multi-Level Security Model

Enterprise-grade security with three complementary security layers working together to protect your data.

RBAC

Role-Based Access Control

Define roles with specific permissions. Assign users to roles and control access to actions, modules, and features based on organizational hierarchy.

RLS

Row-Level Security

Restrict data visibility at the row level. Users see only the records they're authorized to access based on dynamic SQL conditions.

CLS

Column-Level Security

Control which columns users can see or modify. Hide sensitive fields like salaries, SSN, or confidential data based on role policies.

Time-Based Access Policies
IP-Based Restrictions
Attribute-Based Conditions
Data Persistence

Multi-Database Support

Connect to your preferred database vendor with a unified, type-safe API.

PostgreSQL
MySQL
MariaDB
H2 Database
SQLite
HSQLDB
Apache Derby
Firebird
Type-Safe SQL

Galão JDBC V6

A modern, type-safe JDBC abstraction layer with fluent API for building complex SQL queries programmatically.

Fluent Query Builder

Write SQL queries using a fluent, type-safe API. Benefit from compile-time validation, IDE auto-completion, and protection against SQL injection.

24K
Lines of Code
116
Java Classes
100%
Type-Safe
Java 21
Records Support
// Type-safe query with fluent API
var query = GalaoQueryBuilder.derby("SALES")
    .select(
        ProductsRecord.NAME,
        ProductsRecord.SALEPRICE,
        AggregateField.count(ProductStockRecord.WAREHOUSEID)
            .as("warehouse_count")
    )
    .from(ProductsRecord.class)
    .autoJoin(ProductStockRecord.class)
    .where(ProductsRecord.ISACTIVE, true)
    .and(ProductsRecord.SALEPRICE, OperatorV1.GT, 
         new BigDecimal("50"))
    .groupBy(ProductsRecord.NAME, ProductsRecord.SALEPRICE)
    .having(AggregateField.count(ProductStockRecord.WAREHOUSEID), 
           OperatorV1.GT, 2)
    .orderBy(ProductsRecord.NAME)
    .limit(10)
    .buildQuery();

Builder Pattern

Fluent interface for progressive query construction with method chaining.

Auto-Join

Automatic JOIN resolution based on foreign key relationships.

Smart Caching

Built-in LRU cache for joins, primary keys, and compiled SQL.

JSON Serialization

Full Jackson integration for query state persistence and transfer.

Technical Specifications

Project Metrics

Java 21
Runtime
Jakarta EE 10
Platform
26
Database Tables
37
Services
80+
Velocity Templates
7
Functional Modules

Ready to Build Enterprise Applications?

Get started with GalaoSystem today and accelerate your development workflow with built-in security, multi-database support, and low-code capabilities.

Contact Us Star on GitHub