“Anything that you do more than twice has to be automated.” That sounds like a great quote. But, be careful. Automation is costlier than just the process of automating it.
This is speaking from a real case I’m sharing below.
A Real Case Story
There was a piece of code in our early days of mobile development that was relatively repetitive. It’s creating an SQL table and a set of functions such as insert, update, delete, etc., and connecting to a data model for the table.
Every time a table is created, one must go through creating and duplicating the table contents and their SQL commands function.
Repetitive process identified
As we’re starting development, more requests are coming in for new data to be stored, and hence likely to have more new tables and SQL to program.