Re:Stochastic gradient descent written in SQL
by nonethewiser on Tuesday March 07, 2023 @10:23AM
(#35056309)
> Databases are much more powerful than we think
And a function of what people think is attitudes towards working at the DB level. I see this often with ORM's in the web dev sphere (rather than Dat Science). Yes, ORM's are great but many people rely on them to completely abstract away the database and are terrified by raw sql or even query building. You also see it with services that abstract away the backend like PocketBase, Fireship, etc. Writing a window function or even a sub select looks like black magic to many.
I say this after several experiences with codebases where joins and filtering were often done at the application layer and raw sql was seen as the devil.
And a function of what people think is attitudes towards working at the DB level. I see this often with ORM's in the web dev sphere (rather than Dat Science). Yes, ORM's are great but many people rely on them to completely abstract away the database and are terrified by raw sql or even query building. You also see it with services that abstract away the backend like PocketBase, Fireship, etc. Writing a window function or even a sub select looks like black magic to many.
I say this after several experiences with codebases where joins and filtering were often done at the application layer and raw sql was seen as the devil.