Crash when viewing UUIDs about sqlite-web HOT 5 CLOSED

SQLite does not natively support a UUID data-type. SQLite knows about BLOB, TEXT, INTEGER, REAL and NULL...that's it. Is the UUID stored in a BLOB column?

from sqlite-web.

Hmm, since the column type isn't TEXT then I'll assume that yes, it's a BLOB…

SQLite version 3.20.1 2017-08-24 16:21:36
Enter ".help" for usage hints.
sqlite> .schema
[…]
CREATE TABLE IF NOT EXISTS "chans" ("id" UUID PRIMARY KEY, "name" TEXT NOT NULL, "inserted_at" NAIVE_DATETIME NOT NULL, "updated_at" NAIVE_DATETIME NOT NULL);

Moreover:

from sqlite-web.

With SQLite you can specify arbitrary/bogus types, but internally it has only the type "affinities" I listed earlier. UUID is not recognized, and is thus treated as TEXT (hence why the app is trying to decode it as UTF-8). Might try specifying id BLOB and checking if that fixes it?

from sqlite-web.

I changed the type in my migration file, but it didn't help peewee :/

  File "/home/tchoutri/.local/lib/python2.7/site-packages/peewee.py", line 3830, in execute_sql
    cursor.execute(sql, params or ())
OperationalError: Could not decode to UTF-8 column 'id' with text '}�˅
�G��3i��@'

Instead of wanting to decode that, wouldn't it be easier to catch the exception and display a placeholder text like "binary data"? It's a rough guess, I never wrote python but I heard that the language uses exception-based programming a lot. :)

from sqlite-web.

Hmm... I'm sorry to have wasted your time, I thought that would fix it.

from sqlite-web.