And then there is pgfmt, a CLI based Postgres SQL and PL/PgSQL formatter that is built on top of libpgfmt. If you're looking for river-based SQL formatting, look no further (3/3).
#postgres #rust
Next up is libpgfmt, a Rust library for formatting PostgreSQL SQL and PL/pgSQL, powered by tree-sitter-postgres (2/3).
Supports 6 popular SQL formatting styles, and our own river-based AWeber style guide based off of sqlstyle.guide.
github.com/gmr/libpgfmt
#postgres #rust
I've been rebuilding some internal Postgres related tools in Rust and have a few things to share (1/3).
1. tree-sitter-postgres - tree-sitter grammar for Postgres specific SQL and PL/PgSQL. Complete grammar created using codegen from the Postgres source
github.com/gmr/tree-sit...
#postgres
Here's the first of my video short series.
AI won't fix your data problems.
youtu.be/bwwaYd9b6lM
Claude Status 1.2.1 has been released with a bugfix for the new rust based session monitor.
github.com/gmr/claude-s...
#claude #claude-code #macos
I just released 1.0.0 of an app that I created with Claude's help called Claude Status.
I wrote it because when I have a bunch of Claude sessions going it's easy to miss ones that are waiting for my input or permission to do something.
github.com/gmr/claude-s...
#claude #claude-code
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
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
Yup, lmk if you have any issues.
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...
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.
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."
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
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.
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"
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
What does it say about me that I’ve reached the point in life where I value a good letter opener?
Did I mention it defaults to writing tests for all of its work?
No diffs, just editing code in the editor as if we were two programmers working on the same code base.
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.
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.
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!
My neighborhood in DC is feeling rather dystopian leading up to this weekend.
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.
I really wish there was a way to turn off the streaming response behavior of LLM UIs. It’s slow and I am impatient.
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
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.
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.
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.
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.