Git In My SQL's Stead
The present isn't always enough. Some web applications need to keep track not only of now, but also of past changes to all business entities. ORMs can rarely help us with the latter, and we need to reach for hand-crafted solutions.
In this session we'll discuss a recent project in which we implemented a record system for all database entries. Existing tools and libraries didn't fulfil our requirements. This led us to introducing a bespoke versioning mechanism. The solution we built offered not only change history to our users, but also HTTP-based replication to systems consuming our data.
In the talk we'll present the implemented versioning mechanism, discuss its pros and cons, and share lessons we've learned on the way.