Before this PR, we use host name to perform FTS on URLs. This breaks exact-match rejection logic in FTS and is fixed by indexing hosts instead.
Handle edge cases (URLs with port number and http scheme) from opendata when extracting host
BREAKING: This PR modifies migration script (偷懶不想開新 migration); requires clearing and re-seeding the database. Cloudflare pages preview may not work as expected, as the production DB is not migrated yet.
BREAKING: This PR modifies migration script (偷懶不想開新 migration); requires clearing and re-seeding the database. Cloudflare pages preview may not work as expected, as the production DB is not migrated yet.
Before on the left; after on the right.