Tag: PostGreSQL

  • Tropeçando 101

    Minimal safe Bash script template Bash scripts. Almost anyone needs to write one sooner or later. Almost no one says “yeah, I love writing them”. And that’s why almost everyone is putting low attention while writing them. I won’t try to make you a Bash expert (since I’m not a one either), but I will […]

  • Tropeçando 99

    Diataxis A SYSTEMATIC FRAMEWORK FOR TECHNICAL DOCUMENTATION AUTHORING. The Diátaxis framework aims to solve the problem of structure in technical documentation. It adopts a systematic approach to understanding the needs of documentation users in their cycle of interaction with a product. Conventional Commits The Conventional Commits specification is a lightweight convention on top of commit […]

  • Tropeçando 97

    The Missing Guide to AWS API Gateway Access Logs In this post, we’re continuing the deep dive on API Gateway. Here, we’ll be looking at API Gateway access logging. Access logging can save your bacon when debugging a gnarly API Gateway issue, but you need to understand some nuance before you can use it correctly. […]

  • Tropeçando 96

    Refinement Code Review With the right environment, I can look a bit of code written six months ago, see some problems with how it’s written, and quickly fix them. This may be because this code was flawed when it was written, or that changes in the code base since led to the code no longer […]

  • Tropeçando 92

    Mocking/stubbing the current Date in Jest tests This post goes through multiple approaches to mocking, stubbing and spying on the date constructor using Jest. Don’t get stuck A history about the importance of know your time and to not get stuck. For this special history guide, we are going to take a trip back in […]

  • Tropeçando 91

    Introducing the MDN Web Docs Front-end developer learning pathway The MDN Web Docs Learning Area (LA) was first launched in 2015, with the aim of providing a useful counterpart to the regular MDN reference and guide material. MDN had traditionally been aimed at web professionals, but we were getting regular feedback that a lot of […]

  • PostgreSQL – pg_upgrade from 10 to 12

    I have some PostgreSQL databases running pretty well but we need to keep our software updated. This is a mandatory practice for a high-quality service. Those servers are running version 10 and they need to be upgraded to version 12. I have used pg_dump / pg_restore strategy for a long time, but this time I […]

  • Tropeçando 89

    Upgrading Postgres major versions using Logical Replication Arch Fun Statistics Everyday Hacks for Docker In this post, I’ve decided to share with you some useful commands and tools I frequently use when working with awesome Docker technology. There is no particular order or “coolness level” for every “hack.” I will simply present the use case and how […]

  • Tropeçando 88

    Intro Guide to Dockerfile Best Practices There are over one million Dockerfiles on GitHub today, but not all Dockerfiles are created equally. Efficiency is critical, and this blog series will cover five areas for Dockerfile best practices to help you write better Dockerfiles: incremental build time, image size, maintainability, security and repeatability. If you’re just […]

  • Tropeçando 85

    Good Engineering Practices while Working Solo How Much maintenance_work_mem Do I Need? While I generally like PostgreSQL’s documentation quite a bit, there are some areas where it is not nearly specific enough for users to understand what they need to do. The documentation for maintenance_work_mem is one of those places. It says, and I quote, […]