this post was submitted on 19 Oct 2023
1715 points (98.8% liked)

Programmer Humor

32725 readers
69 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

founded 5 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] Stumblinbear@pawb.social 8 points 1 year ago* (last edited 1 year ago) (3 children)

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.

[–] hedgehog@ttrpg.network 4 points 1 year ago (1 children)

JetBrains IDEs - IntelliJ, WebStorm, PyCharm, GoLand, etc., all support highlighting SQL embedded in another source file or even inside markup files like YAML. Does your IDE not support this?

[–] Stumblinbear@pawb.social 1 points 1 year ago

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

[–] xmunk@sh.itjust.works 2 points 1 year ago* (last edited 1 year ago)

Sublime is actually great at that especially when I keep my SQL in heredocs.

[–] hikaru755@feddit.de 2 points 1 year ago (1 children)

As the other commenter said, the Jetbrains IDEs do this perfectly fine. Although I'd also argue that if you're working with SQL from within another language already, a DSL wrapper is probably gonna be the better way to go about this.

[–] Stumblinbear@pawb.social 2 points 1 year ago* (last edited 1 year ago) (1 children)

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.

[–] hikaru755@feddit.de 2 points 1 year ago (1 children)

I'm not talking full blown ORM here, not a fan of those either. I'm talking about some light weight wrapper that basically just assembles SQL statements for you, while giving you just a little more type safety and automatic protection against SQL injection, and not sacrificing any performance. I'm coming from the JVM world, where Jooq and Exposed are examples of that kind of thing.

[–] Stumblinbear@pawb.social 1 points 1 year ago* (last edited 1 year ago) (1 children)

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

[–] hikaru755@feddit.de 2 points 1 year ago (1 children)

Oh, that sounds really cool! At what time does this validation happen? While you code, or later at build time?

[–] Stumblinbear@pawb.social 3 points 1 year ago

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