5 ms·
> 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
by solumos 5y ago
> 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.
- hans_castorp 5y agoMight 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".
- DougBTX 5y agoStrict table support came in last year to help address this: https://www.sqlite.org/stricttables.html https://www.sqlite.org/stricttables.html