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

Ranter

Comments

4

Mr-Myrk

532

5y

Also, postgresql is much better for more complicated queries, fight me
0

dmonkey

2195

5y

@Mr-Myrk like which ones? I'm thinking to give it a look, I need someone to convince me to 😁
4

Gregozor2121

5190

5y

Because this is how memory in a pc is implemented?
1

kescherRant

23851

5y

Isn't there a "bit"?
1

nitwhiz

11608

5y

@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

fx2000

9

5y

I like the flexibility of using tinyints, 0: false, 1: true, 2: mmmmmaaaaybee
2

AlgoRythm

50243

5y

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

AlmondSauce

16133

5y

At least you only have to use a tinyint!
0

Mr-Myrk

532

5y

@AlgoRythm you could keep 8 booleans per row in a single byte
0

Mr-Myrk

532

5y

@dmonkey postgres supports arrays for one

Related Rants

devRant © 2021 Hexical Labs LLC
Privacy Policy | Terms of Service