• 1 Post
  • 800 Comments
Joined 3 years ago
cake
Cake day: June 17th, 2023

help-circle



















  • deadbeef79000@lemmy.nztoProgrammer Humor@programming.dev: (
    link
    fedilink
    arrow-up
    12
    arrow-down
    1
    ·
    edit-2
    13 days ago

    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