Jul 31Definition of Ready for Development SanityWe should see the development cycle (sprint) as a sacred place where not everyone can easily get in or out. People must fulfill the qualification (Definition of Ready) before entering it and get out after achieving something (Definition of Done). While the Definition of Done (DoD) prevents the deployment catastrophic…Agile4 min readAgile4 min read
Jul 5Manage Bloated Postgres DatabaseBloated database harm query performance, unnecessary infra cost, and hinder development. We can manage bloated tables by: 1. Drop Unused Tables 2. Archive Old Data 3. Table Partitioning 4. Index Maintenance 5. Vacuuming Identify the Big Tables We can use pg_total_relation_size() to calculate the total disk space used by the specified table, including all…Postgres6 min readPostgres6 min read
Apr 2Simple HelpDesk using Google Forms and Apps ScriptWe can easily create a form/survey using Google Forms including setup the HelpDesk Form (to report issues or ask for support). However, we expect the form can generate unique ticket numbers or send notifications to the reporter/assignee. We can cover this by writing a simple Google App Script. The article…Help Desk Software5 min readHelp Desk Software5 min read
Aug 7, 2022DRY (Don’t Repeat Yourself) can Go WrongDon’t repeat doesn’t mean repeat for typing but repeat for thinking. If the two similar codes serve different purposes/concerns, then it is fine to get WET (Write Everything Twice). When we DRY wrongly, we start to smell change preventers called Shotgun Surgery or Divergent Change. Some tales tell that we…Programming1 min readProgramming1 min read
Aug 7, 2022Premature Optimization is Not (always) the Root of All EvilWe should forget about small efficiencies, say about 97% of the time: premature optimization is the root of all evil. Yet we should not pass up our opportunities in that critical 3%. ~Donald E. Knuth We quoted too little by only saying “Premature optimization is the root of all evil.”…Programming2 min readProgramming2 min read
Aug 6, 2022Dunning-Krugger Effect & Imposter SyndromWe are constantly in a work-and-learn situation. The more we learn, the easier we should be at work. With continued work, we can’t stop learning. How good are we? TBH it is not important at all. Good or bad, we keep working and learning (there is no escape). Our competency…Cognitive Bias2 min readCognitive Bias2 min read
Aug 6, 2022Tell Don’t Ask & CouplingIn OOP, Encapsulation is bundling the data with logic within the class. In short, we tell the object what to do rather than ask for the data (Tell Don’t Ask Principle).Oop2 min readOop2 min read
Feb 6, 2022Testivus: Unit Testing PhilosophyIs unit testing really guarantees good code? Am I a good coder by writing one? Is my test good enough? Is it redundant with QA tasks? What’s the truth behind it? We are questioning Unit Testing like questioning life, maybe we should think more philosophical when discussing it. The author…Tdd9 min readTdd9 min read
Dec 5, 2021Database By PurposeWe have many database options in the market and by understanding our needs, hopefully, we make the right buying decision. The author tries to explain the database based on its purpose from his years of working experience in the industry. Persistent Database We want the data never lost Persistence database makes sure…Database6 min readDatabase6 min read
Jul 31, 2021Gracefully Shutdown Your Go ServiceMake sure to tidy up your belonging and stop your activity when arrived at the destination before you leaving the train. Or else, you will lose your favorite toy (except if you all sleeping during the trip). We should do the same thing when stopping the application. It should not…Go3 min readGo3 min read
