With the power of PostgreSQL, Python, and claude, I:

• Transposed some blog analytics by year from our company analytics service (exported to csv)
• Uploaded that raw data into Postgres
• Created a function that looked at each month and found the top three posts
• Moved those results into a temp_table that can use to get more information and do more analysis

Genuinely the most helpful AI has been and it still took about 2 hours of feeding the errors back in and explaining what it did wrong... Now I will have it explain each line of that gnarly function to me so I can write a new blog post...

on 2025-02-13 01:49:19.419329+00:00