dbtpl
dbtpl is a command line tool that generates Go code based on the template by examining database schemas and custom queries. It supports PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server databases; it can create schema creation scripts, JSON or YAML definitions, and Graphviz diagrams. In schema mode, the database detects types and relationships using metadata and SQL internal observation queries.
xo · ORM & Database Tooling
- By examining your database schema or custom SQL queries, you generate a template-based Go code.
- You prepare schema creation scripts, JSON/YAML definitions and Graphviz diagrams for database schemas.
- By connecting to PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server databases, you provide type security.
- ↓ NegativeGitHub Issue
error: Error 1242: Subquery returns more than 1 row
“I get the error described in the header when I try to run xo against my MySQL schema. Is there any flags/env vars to print debug info, e.g. so I could finding out which query that crashes it? I found: which might be related to the issue.”
- • NeutralGitHub Issue
Fails to generate ByID methods for some tables
“Let me start by saying that I'm thrilled with the work being done on this utility. I see XO as being an integral part of bootstrapping web applications written in GO, and I'd love to see how it continues to grow. Unfortunately I'm having a problem. I've got a schema for MySQL…”