Skip to content

Instantly share code, notes, and snippets.

View matus-sabo's full-sized avatar

Matus Sabo matus-sabo

  • Bratislava, Slovakia
View GitHub Profile
import https from "https";
import fs from "fs";
import axios from "axios";
const CERT_URL =
`https://api.zerossl.com/certificates/${certificateId}/download/return?access_key=${accessKey}`;
const run = async () => {
const res = await axios.get(CERT_URL);
@matus-sabo
matus-sabo / generate_uuid_v4_timestamp.sql
Last active January 21, 2023 17:33
Postgres uuid_generate_v4_timestamp
create or replace function generate_uuid_v4_timestamp()
returns uuid
as $$
declare
ts_text text;
uuid_text text;
begin
ts_text = to_char(clock_timestamp() at time zone 'utc', 'YYYYMMDDHH24MISSUS');
uuid_text = gen_random_uuid()::text;
return concat(