Question 1

How to handle transactions with Gendry?

Accepted Answer

Gendry doesn't provide built-in transaction helpers; you use standard database/sql transactions. Start a transaction with db.Begin(), then use Gendry's builder and scanner within it, and commit or rollback manually.

Question 2

Gendry vs GORM for Go databases

Accepted Answer

Gendry is a lightweight SQL builder and scanner focused on MySQL and control, while GORM is a full ORM with migrations, relationships, and multi-database support. Choose Gendry for simplicity and SQL control, GORM for feature-rich ORM capabilities.

Question 3

Can Gendry be used with PostgreSQL?

Accepted Answer

No, Gendry is tightly coupled to MySQL via go-sql-driver/mysql. For PostgreSQL, you'd need to adapt or use other libraries like sqlx or squirrel, as Gendry's manager and builder assume MySQL syntax.

Question 4

How to map JSON fields in Gendry scanner?

Accepted Answer

Implement the ByteUnmarshaler interface on your struct fields. For example, if a column stores JSON, define an UnmarshalByte method that uses json.Unmarshal, as shown in the scanner examples for extraInfo.

Question 5

Is Gendry's builder safe from SQL injection?

Accepted Answer

Yes, the builder uses parameterized queries by default, converting maps to placeholders. However, using builder.Raw for raw SQL snippets requires caution, as it bypasses parameterization and could introduce injection risks if not sanitized.

Question 6

How to generate code with Gendry CLI tool?

Accepted Answer

The CLI tool, gforge, helps automate code generation for database operations. Install it separately from the GitHub repo, then use it to scaffold structs or queries based on your schema, streamlining development workflows.

Question 7

Does Gendry support complex joins or subqueries?

Accepted Answer

Limited support via builder.NamedQuery for templated SQL with placeholders, or using builder.Raw for custom SQL. For complex joins, you might need to write raw SQL and use the scanner for result mapping, as the builder focuses on WHERE conditions and basic operations.

gendry

What is gendry?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions