> Did you use a regex to verify the data looks like a uuid before putting it into the database? Is your database (like sqlite) using a case sensitive collation for the column? Then you have a problem.
yeah, it seems like the premise is flawed. I don't know that there's actually a problem here.
Might be related to the use of SQLite which doesn't really support data types to begin with and allows to store anything in a column regardless of the declared data type (e.g. you can store 'fourty two' in a column declared as integer).
Apparently it's a deliberate decision because they don't really want to be a "database" just something better then "a file".
yeah, it seems like the premise is flawed. I don't know that there's actually a problem here.