you are viewing a single comment's thread
view the rest of the comments
[–] 9 points 6 months ago* (1 child)

Use a CHAR(1) you can then use it as an enumeration.

Don't use T/F for true/false use it for the actual sematic meaning for the thing that the Boolean is toggling. E g. S for subscribed, U for unsubscribed, or whatever.

It also means when you inevitably grow to needing a tri-state it makes sense.

Unless SQLite actually supports enumerations, then just use them

  • source
  • parent
  • hideshow 1 child comment