Gavin M. Roy's Avatar

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)

550
Followers
63
Following
24
Posts
08.02.2024
Joined
Posts Following

Latest posts by Gavin M. Roy @gavinroy.com

Preview
Release pgdumplib 4.0.0 Β· gmr/pgdumplib pgdumplib 4.0.0 We're excited to announce pgdumplib 4.0.0, a major release bringing PostgreSQL 16-18 support, Python 3.11-3.14 compatibility, critical bug fixes, and proper handling of PostgreSQL C...

pgdumplib 4.0.0 Released with support for Postgres 18 πŸŽ‰

pgdumplib is a Python 3.11+ library for reading and writing pg_dump custom format files.

Release Notes: github.com/gmr/pgdumpli...

#python #postgresql

19.11.2025 22:29 πŸ‘ 4 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Imbi Automations

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

04.10.2025 19:14 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Yup, lmk if you have any issues.

14.09.2025 18:05 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
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 ...

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

13.08.2025 20:02 πŸ‘ 2 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

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.

06.08.2025 00:21 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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

05.08.2025 19:46 πŸ‘ 1 πŸ” 1 πŸ’¬ 2 πŸ“Œ 0
pgraf PostgreSQL-based property graph engine with vector search capabilities

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

11.05.2025 01:46 πŸ‘ 3 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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.

18.04.2025 23:20 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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"

24.03.2025 21:26 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Client Challenge

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

14.03.2025 21:57 πŸ‘ 1 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

What does it say about me that I’ve reached the point in life where I value a good letter opener?

11.03.2025 15:52 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Did I mention it defaults to writing tests for all of its work?

20.02.2025 00:09 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

No diffs, just editing code in the editor as if we were two programmers working on the same code base.

20.02.2025 00:08 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

My latest β€œprompt” to it was β€œWe need to update the function to include the thread timestamp so it renders in the thread, not just in the channel” - that’s it.

It went out and examined all the code in the project, found the right places to implement the change, and implemented the change.

20.02.2025 00:08 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

I don’t think that’s in the stars. Many people have tried and have ideas there. My past experience in making a large social media site was enough for me.

20.02.2025 00:00 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

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!

19.02.2025 23:56 πŸ‘ 2 πŸ” 0 πŸ’¬ 3 πŸ“Œ 0
Post image

My neighborhood in DC is feeling rather dystopian leading up to this weekend.

17.01.2025 16:55 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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.

15.01.2025 22:49 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

I really wish there was a way to turn off the streaming response behavior of LLM UIs. It’s slow and I am impatient.

12.12.2024 19:45 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Post image

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

02.12.2024 18:34 πŸ‘ 7 πŸ” 3 πŸ’¬ 0 πŸ“Œ 0

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.

27.11.2024 15:48 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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 sheryl@weikallaw.com.

21.11.2024 03:42 πŸ‘ 4316 πŸ” 2559 πŸ’¬ 39 πŸ“Œ 21

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.

21.11.2024 18:16 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Looks like there is an Elixir driver so Rabbit into duck looks possible and Duck extensions look to be C++ do Duck into Rabbit should be possible. I don’t know if it’s Duck season or Rabbit season, but it sounds fun. Name it Fudd.

17.11.2024 19:36 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

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 🀣

27.10.2024 02:09 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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!

21.10.2024 23:37 πŸ‘ 3 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0