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...
More updates at kjaymiller.com
Latest Blog Post - Three Resources to Start your journey in the PostgreSQL Community
More Posts: https://kjaymiller.com/blog/blog1.html.
Subscribe to the RSS Feed
Jay needed a hole in the ceiling fixed. So they flew in Britnie’s dad to show them how to do electric and house things. Much was learned.
- https://github.com/blackpythondevs/blackpythondevs.github.io
- https://github.com/render-engine/render-engine
- https://github.com/kjaymiller/frontmattter-check
Render Engine is a static-site generator with Flask/Django like flavor to it. With Render Engine, you work with classes that build from one another to create web-sites quickly that you can use for prototypes for full time use!
This and much of the work that I do is made possible by those that sponsor me on github.