Patrick

How to create a todo list using postgres queries You can use psql directly or create an interactive command line tool Bash script that runs psql commands python script that runs psql commands

How to install postgres What is happening? ^ is this more readable outside the code block? So by default, psql automatically tries to connect to– a postgres role also named after your username– a database also named after your username When you install and initialize Postgres via Homebrew:It sets up:– A data directory where all…

I love mind mapping. It helps arrange and rearrange new information so a brief glance is enough to spur the memory of the content. Chapter 2 goes over tooling and setting up the books companion repository. Chapter 3 goes over the Data Engineering workflow with emphasis on chapter 5

You should write scripts for your computer. They could be your favorite language. Put aliases in zshrc to call them Here is “lsp.py”

Who owns data on you? Google Maps has tracked nearly every location you’ve been in the last decade. But you cannot query it in any way. Have you ever wanted to know: “How many times have I been to the gym this week?” or “How many days did I spend in California this year?” You…

[list] -> [list] [list] -> num