Migrations

I've been exploring different web frameworks, and one thing I truly value about Drogon is its excellent performance. However, I believe there’s room for improvement in the area of database migration tools.

In Rails, for example, commands like rails db:setup are incredibly convenient—it creates the database, loads the schema, and seeds it with initial data. Furthermore, with a single command like rails generate model Author name:string email:string, you can generate both the model and its corresponding migration files automatically.

With Drogon, the alternatives I found typically involve using third-party libraries that rely heavily on raw SQL. This approach can be less maintainable, especially when targeting multiple database systems, as SQL syntax and behavior can vary significantly between databases.

I’d like to contribute to improving this aspect of Drogon, starting with support for PostgreSQL. Once a solid foundation is established, it could be extended to support other databases as well.