SQL

451 readers

1 users here now

Related Fediverse communities:

#sql on Mastodon
#postgresql on Mastodon
c/PostgreSQL on programming.dev

Icon base by Delapouite under CC BY 3.0 with modifications to add a gradient

founded 1 year ago

MODERATORS

[email protected]

Is there a programming language specifically designed for interacting with SQL databases? (lemmy.one)

submitted 4 months ago by [email protected] to c/[email protected]

43 comments fedilink hide all child comments

Is there a programming language specifically designed for interacting with SQL databases that avoids the need for Object-Relational Mappers (ORMs) to solve impedance mismatch from the start?

If such a language exists, would it be a viable alternative to PHP or Go for a web backend project?

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 5 points 4 months ago (13 children)

Have you considered raw queries (properly parametrized and escaped and all that)? You can’t beat the speed of getting exactly what you need with no overhead.

What you’re describing is basically a fancy ORM.

[–] [email protected] 0 points 4 months ago (2 children)

properly parametrized and escaped and all that

I'm not sure if what I use is proper enough in your sense. So, can you elaborate more?

[–] [email protected] 2 points 4 months ago (1 children)

Parameterization: https://cheatsheetseries.owasp.org/cheatsheets/Query_Parameterization_Cheat_Sheet.html

[–] [email protected] 1 points 4 months ago* (last edited 4 months ago)

Yes, I've used this.

load more comments (10 replies)