News for hackers. Stuff that matters.

kjmph

Re:Partitioning Postgres tables by timestamp based UUIDs on Friday January 12, 2024 @10:37AM (#38969298)
While it may not work for all use cases, there is a Postgres PL/pgSQL function that is easy to install. It is being kept here for now:

https://gist.github.com/kjmph/5bd772b2c2df145aa645b837da7eca...

Re:New UUID Formats on Sunday June 12, 2022 @09:30PM (#31719989)
I created a PL/pgSQL function for this purpose. As Starlevel001 mentioned, the UUID format will accept opaque bytes. Perhaps you could find this useful?

https://gist.github.com/kjmph/5bd772b2c2df145aa645b837da7eca...