Asklemmy

43757 readers

1857 users here now

A loosely moderated place to ask open-ended questions

Search asklemmy 🔍

If your post meets the following criteria, it's welcome here!

Open-ended question
Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
Not ad nauseam inducing: please make sure it is a question that would be new to most members
An actual topic of discussion

Looking for support?

Looking for a community?

Lemmyverse: community search
sub.rehab: maps old subreddits to fediverse options, marks official as such
[email protected]: a community for finding communities

~Icon~ ~by~ ~@Double_[email protected]~

founded 5 years ago

MODERATORS

[email protected]

175

What is the worst IT setup you have seen at a company? (sh.itjust.works)

submitted 3 months ago* (last edited 3 months ago) by [email protected] to c/[email protected]

125 comments fedilink hide all child comments

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

[–] [email protected] 29 points 3 months ago (1 children)

I was hired to implement a CRM for an insurance company to replace their current system.

Of course no documentation or functional requirements where provided, so part of the task was to reverse engineer the current CRM.

After a couple of hours trying to find some type of backend code on the server, I discovered the bizarre truth: every bit of business logic was implemented in Stored Procedures and Triggers on a MSSQL database. There were no frontend code either on the server, users have some ActiveX controls installed locally that accessed the DB.

[–] [email protected] 5 points 3 months ago (1 children)

every bit of business logic was implemented in Stored Procedures and Triggers on a MSSQL database.

Provided the SP’s are managed in a CVS and pushed to the DB via migrations (similar to Entity Framework), this is simply laborious to the devs. Provided the business rules are simple to express in SQL, this can actually be more performant than doing it in code (although it rarely ever is that simple).

There were no frontend code either on the server, users have some ActiveX controls installed locally that accessed the DB.

This is the actual WTF for me.

[–] [email protected] 5 points 3 months ago

There was no version control at all. The company that provided the software was really shady, and the implementation was so bad that the (only) developer was there full time fixing the code and data directly in production when the users had any issue (which was several times a day).