Viewing profile — pyramation

thanks for sharing! author of pgpm here, we are super excited about pushing e2e and integration testing in the postgres community, a big part of the modular postgres workflows in a…

Hi HN — I’m the founder of Constructive pgpm is a package manager for application-layer PostgreSQL code: schemas, functions, triggers, and Row-Level Security policies written in pu…

thank you! let us know if you need help setting it up!

appreciate it! let us know if you and your team have any feedback, cheers!!!

thank you! much appreciated ;) hope it helps you guys ship secure supabase projects!

thank you! Appreciate that. Always want to make the glide path and ensure folks can run the software replicably on their machines! happy to help if you run into any issues :)

Hi HN — we've built a testing framework for Supabase that spins up fast, isolated Postgres databases for each test case. It’s designed to make RLS policies easy to validate with re…

and fwiw, my opinion comes from attempting to upgrade packages that I've depended on that all of a sudden add the module: true, which essentially requires that ALL packages must up…

ES modules are cancer. I'm fine w the syntax — in fact, I love the syntax. But if you use "module: true" in your package.json, you are splitting the npm ecosystem into two groups, …

I built KubernetesJS because I was frustrated with the state of Kubernetes tooling for TypeScript developers. Most existing clients, like kubernetes-client, were last updated five …

My journey to upgrade pgsql-parser to TypeScript led to an exciting discovery in the pganalyze/libpg_query repository: protobuf files defining PostgreSQL's AST. This discovery insp…

An article about ASTs in postgres, featuring a postgres AST deparser written in pure pgsql

HI all! I wanted to share a useful tool that I built during the pandemic. One of my deepest projects I’ve created in postgres, and I’m excited to share it with the community and ge…

wow, session replays looks pretty slick!

this library is amazing! I couldn't live without it.

for sure there are all sorts of postgres regex tools... You can likely do everything. The main limitations I found in plpgsql were in base encodings (that were missing), which is w…

ok thank you! I just saw this. Adding a reference to the issue. Thanks ;)

yea totally! I love plv8... it's actually how I got started with postgres functions. I ultimately switched to native PG. There were known memory leaks in plv8 and eventually after …

Thanks for the in depth explanation. So it seems that, during the interval (which defaults to 30s) they could possibly determine the TOTP value. It seems possible to brute force, h…

yea! I LOVE sqitch. As a person who likes to write pure sql with no ORM, sqitch is the absolute best choice

https://github.com/pyramation/totp/blob/master/packages/totp... yes in the notes of the source here The first TOTP implementation I wrote was here was much less efficient, literall…

agree, this is exactly why the code was written. I had originally tried to use plv8 or others, but as my postgres experience matured and I built testing harnesses, I decided to thr…