freeborough
sebastiancarlos
/ silence-autocd.sh
Last active
November 15, 2024 07:55
Hack to suppress the default output of autocd in Bash.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # All my gist code is licensed under the terms of the MIT license. | |
| # Video demo: https://www.youtube.com/shorts/ojhaUNYetsU | |
| shopt -s autocd | |
| # silence_autocd | |
| # - Hack to stop autocd from printing the directory after autocd'ing. | |
| # - Unfortunately there is no clean way to do this except messing with | |
| # BASH_XTRACEFD, a poorly understood file descriptor that we are better not |
kjmph
/ A_UUID_v7_for_Postgres.sql
Last active
February 26, 2026 23:14
Postgres PL/pgSQL function for UUID v7 and a bonus custom UUID v8 to support microsecond precision as well. Read more here: https://datatracker.ietf.org/doc/rfc9562/
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Based off IETF draft, https://datatracker.ietf.org/doc/draft-peabody-dispatch-new-uuid-format/ | |
| create or replace function uuid_generate_v7() | |
| returns uuid | |
| as $$ | |
| begin | |
| -- use random v4 uuid as starting point (which has the same variant we need) | |
| -- then overlay timestamp | |
| -- then set version 7 by flipping the 2 and 1 bit in the version 4 string | |
| return encode( |