There was an api endpoint that took json, used xslt to transform to xml. Then called the stored procedure specified in request passing the xml as a parameter.

The stored procedure then queried the xml for parameters, executed the query, and returned results as xml.

Another xslt transformed that to json and returned to the client.

It was impressive how little c# there was.

Despite holding all the business logic, the sql was not in source control.

[–] lordbritishbusiness@lemmy.world 1 points 4 days ago

Worst thing with databases. Used to quote to my interns, "No spooky action at a distance" logic has to be in front of you and in git. Anything else is a recipe for bugs and undetectable errors.

[–] JackbyDev@programming.dev 0 points 4 days ago (1 children)

Seems very secure. As in job security. Because why the fuck did they make it so complicated.

[–] Buckshot@programming.dev 2 points 4 days ago

Yeah, maybe the contractor thought he'd get more work fixing it but he was long gone by the time I got it so i never met him

One of bugs I got was performance because the search didn't work, with about 600,000 assets in database it would timeout searching for one by exact match on ID. It took 45 minutes to return 1 result.