Hacker News new | ask | show | jobs
by mrits 1048 days ago
What do you think stored procedures are written in if not code? Some of them are written in even C++ (I've done plenty myself).

I understand the sentiment but there is not anything inherently wrong with a stored procedure. If they came out today we'd probably call it edge computing.

1 comments

Harder to test and debug than code.
It is actually the exact same level of effort as code as it is code.

If you mean stored procedures are harder to test than something like ORM in Django than that is just a huge misunderstanding of how you properly write stored procedures while also not understanding how hard it is to actually test a lot of ORM logic.

You dont test orm logic, it is being done by orm makers.

You test your app.

Also, not abusing database and writing code doesnt mean lets get deep into the ORMs madness.

You can do not write logic in db and still write raw sql

"You dont test orm logic" this explains a lot of your confusion