Month: April 2024
-
Today, I had to pivot (pun intended) from my usual tasks to help a colleague with a query. The task is deceptively simple: Collect metadata about all columns of a table in a single query. This was to be a function in PostgreSQL that would return a table with the following columns: You can imagine…
-
I learned React by looking at it. Yes, really. I inherited some React codebase since I was the only dev with JS knowledge on my team, and I had to figure out how to make it work. Since most change requests were small there was no need to reach out to the docs, and after…
-
I always assumed that the COPY command in PostgreSQL bypassed triggers. I didn’t know that, I just assumed it. It felt correct. My experience with copy is bulk importing data and that usually meant creating either temporary tables as staging area or importing into new tables. In any case, it seems I’ve never copied data…
-
Today I learned more about React memoization. I was stuck optimizing a component that was re-rendering too often and after digging a bit, some things stuck out to me. Memoization, for the uninitiated, is the process of storing the results of expensive function calls and returning the cached result when the same inputs occur again.…