Sep 2019
23 Mon
24 Tue
25 Wed
26 Thu
27 Fri 08:55 AM – 05:00 PM IST
28 Sat 08:55 AM – 05:45 PM IST
29 Sun
Swanand Pagnis
@swanand
Submitted Feb 28, 2019
An experience report on how DB constraints helped our team perform profound structural changes to our application data through 4 large refactorings that happened over 30 months.
Relational databases are robust, reliable, and battle-tested. However, they truly shine when it comes to maintaining data integrity. This talk demonstrates the powerful nature of constraints in the context of large scale data refactorings, with real-life examples and code samples, all to make a central point: They cannot be an afterthought. You have to make them a part of your development process, and you get rewarded for doing so.
Since the context is around four refactorings, the talk is also made up of as many sections.
Apart from talking about constraints, I will also touch upon “adjacent” principles that were a part of this process, such as idempotency, iterative development, and testability.
Intro and conclusion together: ~5 minutes.
Buffer time for adjustments: ~5 minutes.
This talk is most benefical to two kinds of people:
Some experience or understanding of the process of writing web-based applications is required.
Swanand is a Principal Engineer at First.io, a Durham based startup. He is a self-proclaimed “gnosiophile” and a fan of continuous improvement. He loves writing software, building communities, and mentoring people. He’s currently helping people get better at PostgreSQL through https://postgres-workshop.com/
{{ gettext('Login to leave a comment') }}
{{ gettext('Post a comment…') }}{{ errorMsg }}
{{ gettext('No comments posted yet') }}