array handling: javascript to sql

2019-06-15

 | 

~2 min read

 | 

298 words

Yesterday we updated a Postgres record’s details based on the and returned the update in a single query. What if the details was not a…

postgres `returning` statement

2019-06-14

 | 

~2 min read

 | 

239 words

Often, after making a change to a database, we want to verify that the change was made and use the updated rows. A naïve approach would be…

optional params with json stringify

2019-06-13

 | 

~3 min read

 | 

467 words

I’ve gotten in the habit recently of printing my variables as object literals. For example, if I have a variable, , that I want to inspect…

adding comments to a sql statement

2019-06-12

 | 

~1 min read

 | 

123 words

There are two ways to add a comment to a SQL query - using and . The differences are as follows: With a comment surrounded by and , the…

marathon pace and stumbling forward

2019-06-11

 | 

~2 min read

 | 

396 words

The topic of life as a journey has been on my mind lately - evidenced by my last two essays Defense of Detours and Arrive Safely And Avoid…

Hi there and thanks for reading! My name's Stephen. I live in Chicago with my wife, Kate, and dog, Finn. Want more? See about and get in touch!