Adding a database table index

A common question that pops up is how to add a database table index when creating a table or adding a migration. Fluent doesn't natively support this (yet) due to complications with making it work across all supported databases.

→ blog.vapor.codes/posts/adding-db-table-index/

Fluent, a Swift ORM, lacks native support for adding database table indexes during creation or migration due to complexities across supported databases, but you can achieve this using SQLKit.

In a migration, you can use SQLDatabase to create an index, as shown in an example for Postgres that defines an AsyncMigration to create and drop an index named todo_index on the todos table’s title column.

For MySQL, the revert operation requires specifying the table name with .on("todos"). This approach allows developers to implement indexing directly, ensuring compatibility with specific database requirements.