Learn More
Resend Email
1
Mr-Myrk
4y

Why the hell does mysql not have boolean fields? why do I have to use a whole integer for a bit? REEEEEEEEEEEEE

rant

autism

mysql

reee
Favorite
Ranter
Comments
  • 4
    4y
    Also, postgresql is much better for more complicated queries, fight me
  • 0
    4y
    @Mr-Myrk like which ones? I'm thinking to give it a look, I need someone to convince me to 😁
  • 4
    4y
    Because this is how memory in a pc is implemented?
  • 1
    4y
    Isn't there a "bit"?
  • 1
    4y
    @Gregozor2121 as genius as i think this answer is, i don't think memory is thought out to be used as "dis number is an INTeger but it has max 5 digits"
  • 0
    4y
    I like the flexibility of using tinyints, 0: false, 1: true, 2: mmmmmaaaaybee
  • 2
    4y
    Byte is the smallest unit of memory addressable by a computer. Bit fields in a database aren't really bits they're integers anyways. MySQL just doesn't lie to you.
  • 0
    4y
    At least you only have to use a tinyint!
  • 0
    4y
    @AlgoRythm you could keep 8 booleans per row in a single byte
  • 0
    4y
    @dmonkey postgres supports arrays for one
Related Rants
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment