this post was submitted on 27 Jul 2023
244 points (98.8% liked)

Programming Humor

2662 readers
2 users here now

Related Communities [email protected] [email protected] [email protected] [email protected]

Other Programming Communities [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected]

founded 1 year ago
MODERATORS
244
DO NOT TOUCH (lemmy.world)
submitted 1 year ago* (last edited 1 year ago) by [email protected] to c/[email protected]
 

Edit: so im done with my preliminary research into this codebase.

Our corporate SSO provider is changing, so I've been updating our tools to take advantage of the new badges. I found this in a web application that I started on today. The original developer is long gone, and according to our PaaS, this app has been running for just under 3 years without an update.

There is no CI/CD, blue-green deployment, or back ups. The database is an H2 db with ddl-auto set to create-drop on startup, meaning that this database will delete itself if the app is restaged but thanks to this guys code, it won't populate itself. ๐Ÿคท

you are viewing a single comment's thread
view the rest of the comments
[โ€“] [email protected] 59 points 1 year ago (1 children)

Dropping the database is not recoverable

This is the real problem

[โ€“] [email protected] 16 points 1 year ago (2 children)

I sure hope they can recover from last night's backup. Right?

[โ€“] kogasa 21 points 1 year ago (1 children)

Recovering a database from a backup is often possible but often a pain in the ass, and depending on the application you may not consider it acceptable to lose a day of data

[โ€“] [email protected] 2 points 1 year ago (1 children)

Then you need more frequent backups and possibly even live failovers imo

[โ€“] kogasa 2 points 1 year ago

Yeah, of course you want restoring from backups to be as easy as possible. It's just sometimes not feasible, usually because someone can't afford the time or equipment to set it up.

[โ€“] [email protected] 11 points 1 year ago (2 children)

that's assuming they tested the backup system

[โ€“] [email protected] 8 points 1 year ago (1 children)

Ohh, valid point. So many organisations not testing their restore procedures.

[โ€“] [email protected] 8 points 1 year ago* (last edited 1 year ago) (1 children)

At one of the businesses I worked at, the backup was very slow, and at some point the daily backup started taking more than 24 hours. You can probably guess what happened after that.

[โ€“] [email protected] 4 points 1 year ago

Hold on I have to go check something

[โ€“] [email protected] 6 points 1 year ago (1 children)

๐Ÿ‘ƒ๐Ÿ‘ˆ

According to the documentation for the app, they got it classified as a shop aid tool, thereby circumventing production requirements.

The whole app is written like some college kids hello world mvc app

[โ€“] [email protected] 5 points 1 year ago (1 children)

[mis-]classified as a shop aid tool

a college kids hello world app

This hits way too close to home.

[โ€“] [email protected] 5 points 1 year ago

This job pays sooo well though, so I just do what I can and try to speak up when appropriate. They never take my advice, but I have a long list of cya emails for when it all goes tits up ๐Ÿค™