New answers tagged

2 votes

Handling Back-dated Transactions and "Online" Transactions on ERP/Banking Systems

It's a great question, and one that reveals many of the subtleties about banking that we rarely see here. I can't answer all the questions, but I can say something on a couple which involve ...
Steve's user avatar
  • 8,428
5 votes
Accepted

When should I be worried of Time of check time of use vulnerabilities during database queries?

So, the best option that came to my mind is asking myself whether the portion of code would really harm if exploited. In this case the user may delete a post milliseconds after another process strips ...
JimmyJames's user avatar
  • 26.7k
2 votes

When should I be worried of Time of check time of use vulnerabilities during database queries?

using the one which is the safest would slow down the code. If you think correct code is slow, you want to see the performance of incorrect code, once you factor all the business malfunction, ...
Steve's user avatar
  • 8,428
2 votes

Synchronize data between old on premise application and new cloud system

Especially considering that they will likely have different database structures and database systems Do not do this. They have (almost?) identical functionality, so they should have identical ...
pjc50's user avatar
  • 13.1k
2 votes

Synchronize data between old on premise application and new cloud system

Frankly the proposal sounds like a recipe for disaster. If you have a perfectly working application for the time being, and you have several years to complete a transition "to the cloud", ...
Steve's user avatar
  • 8,428
3 votes
Accepted

Clarification on using timestamp without time zone and LocalDateTime in UTC-centric systems

Storing a date in UTC, Posix or any other universal time scale means that everyone in the world can easily agree that two events happened at the same time, of that one happened before the other, and ...
gnasher729's user avatar
  • 44.7k
1 vote

Database dictionary table versus code defined enum

There is only one situation that I should store my enum values to a database: they are unimportant and tend to change frequently. If a value actually controlls your processing flow, e.g. appears in ...
Will Phi's user avatar

Top 50 recent answers are included