Posts
SQL EXIST
Posted on:August 27, 2020A way to think about EXIST is by comparing it to JOIN. The difference between them is that EXIST is SQL’s way of expressing semijoins (and…
Time Intervals in Scala
Posted on:August 24, 2020Having recently felt compelled to start using tstzrange to represent time intervals in Postgres (instead of two separate start and end…
Turkish Cilbir - Eggs with Garlic Yoghurt
Posted on:August 11, 2020Simple to make, and so good. Ingredients: 1 cup Greek yoghurt1 clove fresh garlic (or equivalently, 1/2 teaspoon of pre-minced garlic)Olive…
Notes on "SQLite: The Database at the Edge of the Network"
Posted on:August 9, 2020Recently watched a great presentation and introduction to SQLite by its creator, Dr. Richard Hipp. A short summary of the video below. SQLite…
Tree Folds
Posted on:August 2, 2020In Section 3. 5 of Functional Programming in Scala, trees were introduced as an example of an algebraic data type. One of the exercises…
学び方を学ぶ (Learning How To Learn)
Posted on:July 30, 2020最近、「Learning How to Learn」 という本を読み終わりました。そして、本の要旨は自分の意見を追加して下記の通りまとまりました（重要度の高い順ではありません）。I recently read “Learning How To Learn”. Below, I…
Dark-mode Responsive SVGs
Posted on:June 28, 2020SVGs can be made to work with dark mode by using currentcolor. currentcolor allows an SVG to take the color value from its ancestors (usual…
Stubbing GraphQL requests with Cypress
Posted on:June 15, 2020Having started using Cypress recently, I’ve been impressed at how easy it was to write integration tests that just work. That said, there are…