All posts by theptrk
Todolist in postgres
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
Downloading postgres with brew
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…
Notes: LLM Engineers Handbook
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
scripts folder
You should write scripts for your computer. They could be your favorite language. Put aliases in zshrc to call them Here is “lsp.py”
Arc Prize problem type: the transformation
The arc prize problems are visual – naturally they encounter similar situations that visual editors do. Q: Taken a shape, can you flood fill it? Q: Can you take a shape and transform it by a consistent transform – scaling? Q: Can you take a shape and transform it by a relative transform – relative…
Me Database – Master Plan
You should own your own data. If you do, you can hopefully shed light on this short period we call life. God forbid, you have trouble remembering in the future, you might want a helper. What type of data should you own? Part 1: Collecting it Apps collect: location, voice recordings, writing, photos Integrations collect:…
Data Ownership
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…
python reference sheet
[list] -> [list] [list] -> num
Install, Upgrade Postgres on Mac with homebrew
There are many options to install Postgres. Here we use “homebrew” (brew.sh). How to: Install Postgres on Mac with brew GOTCHA: “Wait, I just installed an older Postgres version(postgresql@14)? If you don’t specify a Postgres version, it downloads a default version that might not be the newest version or an older target version. How to:…