I’m working through the vulkan tutorial and came across GLFW_TRUE and GLFW_FALSE. I presume there’s a good reason but in looking at the docs it’s just defining 1 and 0, so I’m sorta at a loss as to why some libraries do this (especially in cpp?).

Tangentially related is having things like vk_result which is a struct that stores an enum full of integer codes.

Wouldn’t it be easier to replace these variables with raw int codes or in the case of GLFW just 1 and 0?

Coming mostly from C, and having my caps lock bound to escape for vim, the amount of all caps variables is arduous for my admittedly short fingers.

Anyway hopefully one of you knows why libraries do this thanks!

You are viewing a single thread.
View all comments
50 points
*

My boss insisted, before I arrived at the company, that everything in the database be coded so that 1 = Yes and 2 = No, because that’s the way he likes to think of it. It causes us daily pain.

permalink
report
reply
18 points

If that is something your boss is managing, get the fuck out of there.

permalink
report
parent
reply
13 points
*

Something like if (stupid_bool & 0x01) should work for those.

permalink
report
parent
reply
12 points

Yeah of course we convert, but it effectively means you need this little custom conversion layer between every application and its database. It’s a pain.

permalink
report
parent
reply

I imagine this would still lead to a never ending stream of subtle logic errors.

from bossland import billysbool, billysand
from geography import latlong
import telephony

def send_missile_alert(missiles_incoming: billysbool, is_drill: billysbool, target: latlong):
  if billysand(missiles_incoming, not is_drill):
    for phone in telephony.get_all_residents(target):
      phone.send_alert("Missiles are inbound to your location")

Can you spot the bug?

permalink
report
parent
reply
6 points

The conventional ‘not’ would not behave differently for the two non-zero values. Insidious.

permalink
report
parent
reply
9 points

I’m reminded of an old job’s database where every key was named “id_foo” instead of “foo_id”

You didn’t have user_id. You had id_user. You didn’t have project_id, you had id_project. Most of the time, anyway. It was weird and no one could remember why it was like that. (Also changes to the DB were kind of just yolo, there wasn’t like a list of migrations or anything)

permalink
report
parent
reply
8 points

Does your boss frequently browse the database table records outside the API?

permalink
report
parent
reply
4 points

Oh you have no idea. There is no teaching this guy.

permalink
report
parent
reply
6 points

Get a better boss

permalink
report
parent
reply
3 points

why not just take it a step further and make true = “Yes” and false = “No”

permalink
report
parent
reply
2 points

It would probably carry less risk, but in terms of bytes used this would be even worse. And we have other problems there that I’d tell you about but it would make me too sad.

permalink
report
parent
reply
2 points
*

I have seen this, but with “Y”, “N” instead. That was the way the database stored it and the way the UI displayed it, but everything inbetween converted to boolean instead, because there was logic depending on those choices. It wasn’t that bad, all things considered, just a weird quirk in the system. I think there was another system that did just use those strings plain (like WHERE foo = 'Y' in stored procedures), but nothing I had to work with. We just mapped “Y” to true when reading the query results and were done with it.

(And before anyone asks, yes, we considered any other value false. If anyone complained that their “Yes”, “y” or empty was seen as false, we told them they used it wrong. They always accepted that, though they didn’t necessarily learn from it.)

permalink
report
parent
reply
2 points
*

Microsoft SQL Server has a bit type and you always use 0 and 1 and cast/convert them. No native bool type. It’s a hassle.

permalink
report
parent
reply
4 points

Well that would be ok, because any standard tool for interfacing with the database would transparently treat bit in the DB as bool in the code. I think many DBs call it a bit rather than a bool.

permalink
report
parent
reply
2 points

that assumes you don’t write any SQL

permalink
report
parent
reply
1 point

Now I have heard everything. What is zero? Missing value?

permalink
report
parent
reply
7 points

Zero is something you always have to watch out for and handle, because he likes to use NULL for “don’t know”. I should really have deleted the database while it was still young, before they had backups.

permalink
report
parent
reply

Programming

!programming@programming.dev

Create post

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person’s post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you’re posting long videos try to add in some form of tldr for those who don’t want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev



Community stats

  • 2.4K

    Monthly active users

  • 1.9K

    Posts

  • 30K

    Comments