Question 1

How does Darwin compare to Goose for Go migrations?

Accepted Answer

Darwin focuses on a minimal, library-only approach with programmatic control and no CLI, while Goose offers both a CLI and library with features like down migrations. Choose Darwin for tight integration in Go apps, Goose for more tooling flexibility.

Question 2

How to handle migration rollbacks with Darwin?

Accepted Answer

Darwin does not support downgrade migrations out of the box. You need to implement custom logic or follow strategies like forward-only migrations, as suggested in the FAQ referencing Flyway's approach.

Question 3

What databases are supported by Darwin?

Accepted Answer

Darwin supports multiple SQL databases through dialects, including MySQL and PostgreSQL. You use the GenericDriver with appropriate dialect implementations to connect to different backends.

Question 4

How to read migrations from files in Darwin?

Accepted Answer

Darwin requires you to read migration files using Go's standard library, then build the migration list programmatically. There's no built-in file loader, so you need to handle parsing and loading yourself.

Question 5

Can I use Darwin in a CI/CD pipeline?

Accepted Answer

Yes, since Darwin is a Go library, you can integrate it into your application's build or deployment scripts. Migrations run programmatically, making it suitable for automated environments, but lack of CLI might require custom wrapping.

Question 6

Does Darwin support transactional migrations?

Accepted Answer

Darwin encourages single-statement migrations and notes that only PostgreSQL handles DDL rollbacks well in transactions. For other databases, migrations may not be transactional, so plan accordingly to avoid partial failures.

darwin

What is darwin?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Open Source Alternative To

Frequently Asked Questions