Gavin M. Roy
banner
gavinroy.com
Gavin M. Roy
@gavinroy.com
CTO @ AWeber. Author of RabbitMQ in Depth. Opinions are obviously my own and not that of my employer.

https://github.com/gmr/

(he/him/his)
Leveraging Imbi Automations, I built a 30-step AI workflow that automatically modernizes our Python projects @aweber.com

Migrates configs ➡️ Fixes dependencies ➡️ Runs tests ➡️ Creates PRs

All automated. All validated.

#AI #DevOps #Python #Claude #Automation
Imbi Automations
aweber-imbi.github.io
October 4, 2025 at 7:14 PM
With Claude Code's help, today I've released g2g-scim-sync, a tool to enable organizations using Google Workspaces to work with GitHub Enterprise's SCIM based user provisioning.

github.com/gmr/g2g-scim...
Release g2g-scim-sync v1.0.0 - First Stable Release · gmr/g2g-scim-sync
🎉 First Stable Release g2g-scim-sync v1.0.0 represents the first stable release of our Google Workspace to GitHub Enterprise SCIM synchronization tool. This release includes comprehensive features ...
github.com
August 13, 2025 at 8:02 PM
I have billing access for another company in @gitlab.com's customer portal and their tech support doesn't consider it an urgent security issue. How very disappointing. I'm sure the other customer wouldn't feel that way.

I wonder who has access to my corporate account.
August 6, 2025 at 12:21 AM
350B rows in is a bit late to realize this Clickhouse gotcha:

"Due to historical reasons, UUIDs are sorted by their second half. UUIDs should therefore not be used directly in a primary key, sorting key, or partition key of a table."
August 5, 2025 at 7:46 PM
I've just uploaded the 2nd release of pgraf (gmr.github.io/pgraf/) - a property graph library optimized for AI Agent use in Python and Postgres. It uses common graph patters to implement RAG based database search with both sentence transformers based vectorization and tsearch. #postgres #python #ai
pgraf
PostgreSQL-based property graph engine with vector search capabilities
gmr.github.io
May 11, 2025 at 1:46 AM
I don't know what changed, but I'm finding Junie to be much less reliable, and slower, since they brought it out of EAP.
April 18, 2025 at 11:20 PM
I asked Claude Code to increase the test coverage for a module today. It did so by adding `#pragma: nocover` to a bunch of the branches along with a bunch of skipped empty tests with the comment "Skip this test since we're having mocking issues"
March 24, 2025 at 9:26 PM
I just released a FastAPI middleware for safe-listing IP addresses with:

- IP address filtering based on exact match or network ranges
- Support for AWS IP ranges from specified regions
- Path-based access control using regex patterns

pypi.org/project/ip-s...

#python #fastapi
Client Challenge
pypi.org
March 14, 2025 at 9:57 PM
What does it say about me that I’ve reached the point in life where I value a good letter opener?
March 11, 2025 at 3:52 PM
I got access to the Junie EAP from @jetbrains.com. This is the first time working with AI in an IDE has felt like pair programming instead of just having a tool that generates some code for me. It’s a game changer!
February 19, 2025 at 11:56 PM
My neighborhood in DC is feeling rather dystopian leading up to this weekend.
January 17, 2025 at 4:55 PM
The state of AI is pretty impressive these days. In less than a day I was able to build a prototype Slackbot trained on internal Confluence data. It uses Postgres + pg_vector, OpenAI’s text-embedding-3-small to create the embeddings, and Claude 3.5 Sonnet. I used Claude to help me build it.
January 15, 2025 at 10:49 PM
I really wish there was a way to turn off the streaming response behavior of LLM UIs. It’s slow and I am impatient.
December 12, 2024 at 7:45 PM
Reposted by Gavin M. Roy
Want to improve your public speaking skills in a safe environment? Well look no further! We're always looking for speakers for our monthly virtual Meetups. Drop us a DM and you could be our next speaker!

#speaker #postgres #PostgreSQL #bayareapostgres
December 2, 2024 at 6:34 PM
Is anyone aware of an emerging pattern or standard for context files for LLM coding tools? Something like EditorConfig? Cursor has rules files and they're great, but I'd love to see something open that can eventually be used across IDEs.
November 27, 2024 at 3:48 PM
Reposted by Gavin M. Roy
If you are a trans person in Illinois arrested, harassed, or discriminated against for using a public bathroom, I can represent you pro bono. Email me at [email protected].
November 21, 2024 at 3:42 AM
I'm quite impressed by the Mac Mini M4. Geekbench scores have it faster than my MBP with the M2 Pro chipset. Hands on it's a beast. Oh and I've only touched the power button once since unboxing.
November 21, 2024 at 6:16 PM
I was playing around with #ChatGPT and asked it to draw how it pictured what my life would look like in 2035 based on what it knows about me 🤣
October 27, 2024 at 2:09 AM
I’ve been waiting for something to take over for Twitter for open source and tech related things. It’s nice to see some movement here in that area. I’ll have to start posting over here!
October 21, 2024 at 11:37 PM