DevLog: National Parks SQLite

One thing that I love to do is visit National Parks. Visiting them all is on my bucketlist. Some people really like to collect the cancellation stamps; I am more concerned with witnessing and experienceing all these amazing natural areas. At the time of writing this, there are 63 parks, and I have been to about 18 of them. I say “about” because I am not 100% sure that I went to certain ones since I went when I was a kid (Grand Teton, Haleakala)....

November 16, 2024 · 5 min

The SQL Function That Cost Me a Job Offer

I was doing a bit of job searching recently, and I applied to a company throgh a referral from a friend who worked there, so it was a little more high stakes than just a run-of-the-mill interview, as I wanted to leave a good impression at the very minimum. This was a full stack position, and I made it to the technical assessment. There was a database component, a backend component (python), and a front end component (Vue....

October 24, 2024 · 3 min

Don't Use Redshift

Several years ago, I took over partial data ownership a web application at work. The front end was a mishmash of Javascript and PHP, and the backend was C#. There were some areas for improvement there, but it was workable. However, the most glaring problem was the database. The entire application was backed by as single node Amazon Redshift database. I am here to spread the word: DON’T USE AMAZON REDSHIFT… …as the only database for your entire modern web application....

October 24, 2024 · 5 min