Rust used to be correct in 2014 when this was made. It’s pretty fucking good, now

Happens at compile time! It’s relatively quick. You can also run a command to write the query results to file for offline type checking which is mostly useful for CI

I’m currently using SQLx which you write raw queries in and it validates them against a currently-running db, using the description of the tables to build the typing for the return type instead of relying on the user. It makes it pretty hard to write anything that supports injection

RustRover isn’t ready for actual usage, I’ve tried it

Unfortunately RustRover is still garbage for actual usage. And I refuse to use an ORM when I can just write the SQL in a more common syntax that everyone understands across every language instead of whatever inefficient library-of-the-week there is. Raw SQL is fine and can be significantly more performant. Don’t be scared.

Please tell me what IDE you’re using that’s capable of highlighting SQL syntax that’s embedded inside another language source file

Also please fucking stop with the “it’s current year stop x.” The year is not an argument.

That double indented from is hurting me

Unfortunately it was for a personal project and nobody else understands the system so, haha

I was stuck on a problem for six months, and after figuring that out I banged it out in an afternoon. If anything you get stuck for even longer

This gets funnier the further away from 2003 we get

Enable LTO, abort on panic, and a higher optimization level and it’ll drop that a ton