WOW! 30 people at your first meetup. That's a sign that the community is there but not being served!

attendees at first PG Madagascar meetup

I want to make sure that BPD is sponsoring their next conference (oh yeah they've also successfully ran a conference too!)

I'm passionate about PostgreSQL, but did not see it around me in Madagascar. I believed a community could change that. I started one...

Global Map of Recognized Postgres User groups

Replace PostgreSQL with many other topics and Madagascar with many neighborhoods. It doesn't take much to get started. But it takes a lot of community and feedback to keep things going! Support those willing to do the work ❤.

From PGDayChicago 2025

Note-to-self

If you try to ingest vectors into opensearch withouth creating the index settings for them first... it will not work.

Instructions for OpenSearch-RAG-Demo --> https://github.com/Aiven-Labs/preparing-data-for-opensearch-and-rag/blob/main/workshop/1-setup-your-index.ipynb

It was an honor to be the afternoon Keynote at PyTexas today. Thank you to an amazing audience for playing my silly game and vibing (no-code) with me.

Reminder, if you are doing something, it is helpful!

Jay Speaking at PyTexas 2025 Image of a person with hands on their head blurred with the reminder written above

Last week, I gave a 2 hour workshop called - Terraform Ain't Terrafying!

https://www.youtube.com/watch?v=yg8wyJt5O1k

I would love to give a modified version of this workshop at conferences as I have come to actually like writing terraform.

For the second time, I'm tried to use HTMX for server-sent-events and for the second time, I resorted to just doing it with 10 lines of javascript.

Man saying I don't think it's worth it

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...

God and Anime on my side meme but with the power of Python SQL and AI

Dear PSF:

I feel like "Thank you for your submission" and a pre-canned message from a form response is a better user experience than this.

I definitely don't feel like I want to nominate more individuals from this response.

Maybe a form that you need to log in with your PSF membership account to access or something is a way to validate users.

Moderation Bounced Email Response post PSF Fellow Nomination

I really don't care this much to install this extension but the fact that I thought to myself, I wonder if there is chrome extension that.... Yup!

https://chromewebstore.google.com/detail/gulf-of-mexico-forever/lodphjgkcmajmkiepljfkelgnhfbkhmh?hl=en-US

gulfofmexicoforever

I added all of the podcasts that I'm subscribed to (All 400 of them) into both the new Reeder and Tapestry...

Neither app will refresh now without crashing... 🙃

homescreen with reeder and tapestry

Happy to test the betas of either app...

I was reminded by a friend of Kojo's keynote of PyGotham 2019 -

https://www.youtube.com/watch?v=TOG6bmt6SrM

Been watching it this morning an was instantly reminded that communities out here always need help.

The likely first big help you can do is first and foremost be a friendly welcoming face in the community that works to make everyone who enters feel welcome.

Then it can expand to doing simple tasks with no need of writing code.

So take a look at your local community and see if you can offer a little bit of help.

I've been writing a lot more and I'm pretty happy about that. Even when it kicks my butt.

The reality is I need to write more for work and the more I write for fun the easier/better my professional stuff will be.

I made mistakes in my running through the data points in my last post.

The updated information shows that 4 more events, including one in the US requested over the soon to be capped amount. This brings the total potentially saved from 4% to close to 10%.

I updated the data and apologize for this oversight.

I was reminded today that when creating case-insensitive strings, Use .casefold() instead lower().

I probably would have continued to use lower() had it not been for hypothesis, which I've been trying to use more and more for testing.

People complained and even sued. Instead of fixing the issues, paying better, and offering adequate mental health (or even better not exposing workers to traumatic content), they shut down the program in that area and went to another one that didn't complain.

https://youtu.be/qZS50KXjAX0

The major companies pay these 3rd party companies to train their (in their words) trillion dollar industry AIs are basically doing it to absolve themselves from culpability. Those training companies outsource keeping checks notes 85% of the agreed payment terms that companies are offering.

I would ask that major companies require a minimum contract payment and term length and offering the same mental health care resources or equivalent to those training.

I'm over a year late on this one but there was a Steam sale and I wound up getting Brotato.

Brotato label

It's super addictive and one of those games that I can turn my brain off.

https://store.steampowered.com/app/1942280/Brotato/

I'm so interested in how one foundation can be responsible for so many massive projects.

I'm not saying they aren't doing a good job, I'm amazed at the sheer number.

Seeing two more additions this week (one being Jupyter with creation of the new Jupyter foundation)

https://www.linuxfoundation.org/projects

And with a minor tweak to render-engine, I should now have my posts being autosent to Mastodon/BlueSky as well as webmentions enabled

I've always been against analytics on my personal site but as I have been less and less on social media I need a way to still connect with people talking about my stuff (and I'm not adding comments to my website...)

Shoutout to @robb@social.lol for making Echofeed which I'm switching to (if I can make it work) and @sethmlarson@fosstodon.org for showing it to me in action on his website.

I recently added a linkding container and I'm happy about two things.

  1. It's django behind the scenes (maybe I can tinker)

  2. https://nojack.easydns.ca/@ttscoff/ created a custom tiling css layout. It looks great!

Layout of my linkding