title: Storing UUIDs in sqlite using Pylons and SQLalchemy
body: <p>I'm working on my first Pylons project using SQLalchemy and sqlite.
  I'd like to use UUIDs as the primary key for one of my tables. I found the question below and I used the code to add a custom UUID() type to SQLalchemy. (the second solution, I wasn't able to figure out how to use the suggestion by zzzeek.)</p>
  
  <p><a href="https://stackoverflow.com/questions/1521686/random-ids-in-sqlalchemy-pylons">Random ids in sqlalchemy (pylons)</a></p>
  
  <p>However, when I try it out, I get ValueError('bytes is not a 16-char string')
  I suspect this has to do with the fact that I'm trying to store this UUID in a sqlite VARCHAR type field.
  Does anyone know what type of field I should use in sqlite that would work for these UUIDs from SQLalchemy?</p>
  
  <p>Thanks,
  Erik</p>