News for hackers. Stuff that matters.

A comment on Things to know about databases. Parent comment

Re:Things to know about databases by richardw on Monday June 27, 2022 @03:35PM (#31899665)
Also an old timer. I’ve gone from mostly complex app and no DB logic to mostly heavily optimised DB and lots of procs. They protect the DB, make carefully crafted interfaces available and allow changes to the implementation.

Except for eg infinitely scalable cloud data stores like Google’s, or for ML where it’s just massive data and you need a dumb-ish store of many GB of parquet.

[ Parent | on HN ]
Re:Things to know about databases by SulphurSmell on Monday June 27, 2022 @06:41PM (#31901856)
>protect the DB

I share this sentiment. The apps will come and go, the real value is in the data. If the database can cover its ass, I am less concerned about ham-fisted developers randomly messing it up with ill-conceived DML. It's not that they are malicious...it just happens. I have seen devs that code in Erlang, Haskell and even Assembly...run in terror at doing some SQL. It's weird. Trust but verify. And hire persnickity, passionate DBAs.

[ Parent | on HN ]
Re:Things to know about databases by Aeolun on Monday June 27, 2022 @08:44PM (#31902794)
> and allow changes to the implementation

From my perspective this is a negative. You don’t want your queries to change after deployment.

Procedures are also quite hard to type.

[ Parent | on HN ]
Re:Things to know about databases by SulphurSmell on Tuesday June 28, 2022 @11:28AM (#31908969)
If I publish a stored proc as an API, it leaves me free (within reason) to alter the actual SQL supporting it. Like modern API design, as long as you don't remove functionality, then change it as required.
[ Parent | on HN ]