It would be really FUCKING great if NodeJS or mysql could give me a FUCKING shout or ERROR MESSAGE when one of the parameters I'm giving is not the RIGHT FUCKING DATA TYPE INSTEAD OF THROWING A RANDOM ERROR THAT DOESN'T INDICATE A WRONG MOTHERFUCKING DATA TYPE. Five FUCKING hours of debugging later.

Have a look at TypeScript 😉

Well it does for me... Error handling

@vzqzac Yeah I do that but the error I got was a simple syntax error while one of the insert params was an object, which should throw some kind of row count error but not the thing I got

Oh I see, by the way, are you using raw queries or an ORM?

@vzqzac tbvh, I have no clue what an ORM is...

Its called "use an orm, not raw sql queries"

Does CoffeeScript support types "natively" ?

@linuxxx object-relational mapping, a programming technique that can help you with this issue, most popular library for node and SQL databases is sequelize, but there are plenty of them

Related to MySQL: https://youtu.be/emgJtr9tIME

here's where they tell u there's something that's gonna make ur life better. but it may not. but it maaaay. :)

@puerto what's that something? 😄

@linuxxx in this case, looks like sequelize. which btw, I hear is very good. I'm still Chucking normal old sql queries like u, I'm fine with it but u gotta do what works for u. just make sure it's not injectable. good luck either way.

@puerto Tbh, next to programming I'm the main cyber sec guy so making sure it's not injectable is always my first prio :)

.

MySQL has strict mode.

Activate it.

Has nothing to do with ORM at all... Nothing.

MySQL ignores all errors if no strict mode configuration applies and, what makes it worse, strict mode or better SQL mode as MySQL calls it, can be overridden per session / connection, so make sure nothing interferes.

This is database specific, the ORM can help little to none.

@IntrusionCM k then 😔 haha