Hacker News: trsthales

New comment by trsthales in "I built an engine to migrate Oracle PL/SQL to Java"

trsthales — Tue, 24 Feb 2026 21:28:23 +0000

Hey HN, OP here. I've spent the last few months building a tool to help migrate legacy Oracle systems, specifically the heavy business logic trapped in PL/SQL packages. The Problem: Most migration tools fail on complex logic like CONNECT BY (recursion), SELECT FOR UPDATE (locking), or extensive cursor loops. LLMs alone hallucinate variables or forget context. The Solution: I built a pipeline that mixes AST parsing with LLMs (Claude Sonnet/Gemini). It works in stages: Pre-Analysis: Maps the schema and detects complexity patterns. Planning: Decides the architecture (Services, DTOs). Generation: Converts SQL to Java 17/Spring Boot 3.3. Self-Healing: A feedback loop that tries to compile the code in a Docker sandbox and fixes syntax errors automatically before delivering. It handles recursive queries by converting them to WITH RECURSIVE CTEs in JPQL/Native Query, and maps FOR UPDATE to JPA Pessimistic Locks. It's running on Node.js with BullMQ/Redis for the async processing queue. I'd love to hear your feedback on the generated code quality. Link to demo: https://blog.thalesouza.com.br/en/blog/logic-migration/

I built an engine to migrate Oracle PL/SQL to Java

trsthales — Tue, 24 Feb 2026 21:27:31 +0000

Article URL: https://blog.thalesouza.com.br/en/blog/logic-migration/

Comments URL: https://news.ycombinator.com/item?id=47143331

Points: 3

# Comments: 1

New comment by trsthales in "StackForge – Visual full-stack generator using JSON Logic"

trsthales — Sun, 18 Jan 2026 13:09:20 +0000

Hello HN, maker here.

I built StackForge because I was tired of the "Day 1" problem: setting up Auth, Stripe, Prisma, and Docker configurations for every new SaaS idea.

Most low-code tools lock you into their ecosystem. I wanted an "accelerator" that outputs standard, clean code that I can eject and host anywhere.

The Stack: - Frontend: React 19 + Vite 7 (Tailwind) - Backend: Node.js + Express 5 - ORM: Prisma (with auto-generated schemas) - DB: PostgreSQL (via Docker Compose)

The interesting technical challenge was handling business rules safely. Instead of using LLMs to write execute-only code (which is dangerous), I use Llama 3 to translate natural language rules into "JSON Logic". This creates a portable logic layer that runs on both the Frontend (for instant UI feedback) and Backend (for Zod validation), without using eval().

It is currently in Public Beta. The output is a standard ZIP file.

I would love your feedback on the generated folder structure and the developer experience.

StackForge – Visual full-stack generator using JSON Logic

trsthales — Sun, 18 Jan 2026 13:08:31 +0000

Article URL: https://stackforge.com.br

Comments URL: https://news.ycombinator.com/item?id=46667534

Points: 1

# Comments: 1