Merge statements in SQL.
Sadly i have to work with piece of shit called firebird, which is both slow and full of exceptions. If you are forced to pick a file based DB - pick sqlite, don't touch firebird.
I also have to work with a database schema designed by someone mentally handicapped - i know for fact that it was designed in early 90s by someone self taught.. and it never had a single refactor. They just migrated their own file-based 'database' to firebird. Sadly this piece of shit software is used very commonly in my field.
Merge statements make complicated updates blazing fast compared to any other way.
That my engineering field is basically dead and i should've changed to software development sooner.
I also have to work with a database schema designed by someone mentally handicapped - i know for fact that it was designed in early 90s by someone self taught.. and it never had a single refactor. They just migrated their own file-based 'database' to firebird. Sadly this piece of shit software is used very commonly in my field.
Merge statements make complicated updates blazing fast compared to any other way.
That my engineering field is basically dead and i should've changed to software development sooner.