this post was submitted on 10 May 2026

299 points (99.0% liked)

Programmer Humor

31683 readers

1719 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

Keep content in english
No advertisements
Posts must be related to programming or programmer topics

founded 3 years ago

MODERATORS

anzo@programming.dev

Feyter@programming.dev

BurningTurtle@programming.dev

pylapp@programming.dev

299

: ( (lemmy.dbzer0.com)

submitted 3 weeks ago by irelephant@lemmy.dbzer0.com to c/programmer_humor@programming.dev

33 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] deadbeef79000@lemmy.nz 11 points 3 weeks ago* (last edited 3 weeks ago) (1 children)

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

[–] SpaceNoodle@lemmy.world 5 points 3 weeks ago

I think you could use a CHECK constraint to effectively create en enum