Swap out tortoise-orm with... something else about ultimateinvestigator HOT 4 CLOSED

The database has been switched to one that uses IPv4 properly. Thus, I'll likely end up using Prisma.

from ultimateinvestigator.

Turns out Prisma doesn't have case-insensitive comparisons for scalar lists/arrays, as noted by prisma/prisma#8387.

This unfortunately means we're forced to use another ORM, as said comparisons are used often in Ultimate Investigator.

from ultimateinvestigator.

Seems like most ORMs can't support this simple feature, ugh.

If anyone finds one that can, link it here. Otherwise, I'll keep using tortoise until/unless Prisma finally gets a move on with the above PR (seems unlikely, since it's been dead for a while).

from ultimateinvestigator.

Decided to just make my own queries for case-insensitive comparisons against arrays.

from ultimateinvestigator.