2color

1 CID, multiple gateways

• https://bafybeicklkqcnlvtiscr2hzkubjwnwjinvskffn4xorqeduft3wq7vm5u4.ipfs.dweb.link/
• https://bafybeicklkqcnlvtiscr2hzkubjwnwjinvskffn4xorqeduft3wq7vm5u4.ipfs.w3s.link/
• https://bafybeicklkqcnlvtiscr2hzkubjwnwjinvskffn4xorqeduft3wq7vm5u4.ipfs.cf-ipfs.com/
• https://bafybeicklkqcnlvtiscr2hzkubjwnwjinvskffn4xorqeduft3wq7vm5u4.ipfs.4everland.io/
• https://bafybeicklkqcnlvtiscr2hzkubjwnwjinvskffn4xorqeduft3wq7vm5u4.ipfs.nftstorage.link/

2color

dig +noall +answer TXT \_dnslink.chat.thedisco.zone

2color

use std::collections::HashMap;
fn main() {
    let v: Vec<u32> = vec![10, 20, 20, 30, 38, 42, 48, 51, 62, 70];

    println!("vector: {:?}", v);
    println!("mean: {}", mean(&v));
    // println!("median: {}", median(&mut v));
    println!("median: {}", median_1(&v));
    // println!("median: {}", median_2(v.clone()));
    println!("mode: {}", mode(&v));

2color

Comparing B-Tree and Hash indices

Operation	B-Tree	Hash
Lookup single record	O(log(n))	O(1)
Lookup range	O(log(n))	O(n) full table scan
Insertion	O(log(n)	O(1)
Deletion	O(log(n)	O(1)

2color

SELECT `main`.`User`.`id`, `main`.`User`.`email`, `main`.`User`.`city`, `main`.`User`.`name`, `aggr_selection_0_Post`.`_aggr_count_posts` FROM `main`.`User` LEFT JOIN (SELECT `main`.`Post`.`authorId`, COUNT(*) AS `orderby_aggregator` FROM `main`.`Post` GROUP BY `main`.`Post`.`authorId`) AS `orderby_0_Post` ON (`main`.`User`.`id` = `orderby_0_Post`.`authorId`) LEFT JOIN (SELECT `main`.`Post`.`authorId`, COUNT(*) AS `_aggr_count_posts` FROM `main`.`Post` GROUP BY `main`.`Post`.`authorId`) AS `aggr_selection_0_Post` ON (`main`.`User`.`id` = `aggr_selection_0_Post`.`authorId`) WHERE 1=1 ORDER BY COALESCE(`orderby_0_Post`.`orderby_aggregator`, ?) DESC LIMIT ? OFFSET ?

2color

# .github/workflows/test.yaml
name: test
on: push
jobs:
  test:
    runs-on: ubuntu-latest
    # Service containers to run with `container-job`
    services:
      # Label used to access the service container
      postgres:

2color

Learnings

Types as sets of values

keyof with union (|) and intersection (&)

There are no keys that TypeScript can guarantee belong to a value in the union type, so keyof for the union must be the empty set (never). Or, more formally:

2color

REVOKE ALL ON DATABASE example_database FROM example_user;
GRANT CONNECT ON DATABASE example_database TO example_user;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO example_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO example_user;

2color

import { PrismaClient } from '@prisma/client'

export const prisma = new PrismaClient()

export function createContext() {
  return { prisma }
}

2color

Useful linux commands

• List files recursively: find input/ -type f | wc -l