Query BitClout Postgres DB with public key

bitclout-pg.js

const bs58check = require('bs58check')

const getPublicKeyBase64 = (publicKeyBase58Check) => {
  const decoded = bs58check.decode(publicKeyBase58Check);
  const payload = Uint8Array.from(decoded).slice(3);
  return Buffer.from(payload).toString('base64');
}

const getPublicKeyBase58Check = (bytea) => {
  const prefix = [0xcd, 0x14, 0x0];
  const prefixAndKey = Uint8Array.from([...prefix, ...bytea]);
  return bs58check.encode(prefixAndKey)
}

// You can then query using the result of getPublicKeyBase64():
// select * from pg_profiles where encode(public_key, 'base64') = [PublicKeyBase64]