Hello, I'm wondering, is MySQL support planned for patchwork-next? It seems to me that patchwork-next does not work with MySQL at all, despite the documentation suggesting that it does. I gave implementing it a shot, but there are a couple of problems: - Text fields default to VARCHAR(255). Index key length has to be specified for the unlimited TEXT type. bun does not support that in the model field tags. So changing unique/indexed fields to the TEXT type requires creating the indexes manually. - RETURNING is not supported - CONFLICT targets are not supported
To be fair, while working with Patchwork I thought that it would be pretty convenient to support only a single database. patchwork-next requires a migration either way. On the other hand, I'm not sure if projects that use Patchwork right now would be happy if MySQL support was dropped from 4.x. Migrating a small database may be easy, but having to set up a larger cluster again... Regards, Franek Stachura _______________________________________________ Patchwork mailing list [email protected] https://lists.ozlabs.org/listinfo/patchwork
