Wishlist v0.51.0 release notes

🚨 BREAKING CHANGES 🚨

Up until this point, Wishlist has treated usernames and emails as case-sensitive. Generally emails are case insensitive and most platforms treat them that way. This release contains a migration to change usernames and emails to be case-insensitive. Meaning if your username is “testUser”, you can also now log in with “TESTUSER” or “testuser”. Similarly for OIDC login, for accounts not already linked, the linking step is now case-insensitive, so if a user account has an email of “TESTUSER@GMAIL.COM” and the user’s email in the IdP is “testuser@gmail.com”, then the existing user in Wishlist will be found.

This is a breaking change and the migration can fail if you have any users that share similar (only differing by casing) usernames or emails

If you experience a failed migration due to this change or want to check your db proactively, you can execute this sql query against your database to identify the impacted users and update their username and/or email

SELECT LOWER(username), LOWER(email), GROUP_CONCAT(id), GROUP_CONCAT(name)
FROM "user"
GROUP BY 1, 2 HAVING COUNT(DISTINCT id) > 1

What’s Changed

Set supported architectures for sharp by @cmintey in https://github.com/cmintey/wishlist/pull/406
Update actions/setup-node action to v5 by @renovate[bot] in https://github.com/cmintey/wishlist/pull/404
Update node by @renovate[bot] in https://github.com/cmintey/wishlist/pull/403
Update dependency vite to v7.1.5 [SECURITY] by @renovate[bot] in https://github.com/cmintey/wishlist/pull/402
Update dependency @noble/hashes to v2 by @renovate[bot] in https://github.com/cmintey/wishlist/pull/394
Translations update from Hosted Weblate by @weblate in https://github.com/cmintey/wishlist/pull/400
Update packages by @renovate[bot] in https://github.com/cmintey/wishlist/pull/393
fix: link oauth upon user creation by @cmintey in https://github.com/cmintey/wishlist/pull/407
fix: remove email & username case sensitivity by @cmintey in https://github.com/cmintey/wishlist/pull/408

Full Changelog: https://github.com/cmintey/wishlist/compare/v0.50.1…v0.51.0