Skip to content

Instantly share code, notes, and snippets.

View 2color's full-sized avatar
🍕

Daniel Norman 2color

🍕
335 followers · 212 following
View GitHub Profile
@2color
2color / .gitignore_global
Created October 2, 2024 09:12 — forked from swyxio/.gitignore_global
my dotfiles - more info here https://www.swyx.io/new-mac-setup
.DS_Store
._.DS_Store
**/.DS_Store
**/._.DS_Store
.vscode
.idea
Thumbs.db
# used to need to run git config --global core.excludesfile ~/.gitignore_global to set this but apparently no longer needed https://x.com/bate5a55/status/1840594630972191118
@2color
2color / useful-cids-debugging.csv
Created September 11, 2024 12:08
CID Name Tags
bafyreidyjlqwe7dmvnk5ts2c4firtfaordiy5pzywmtavcqv5lvosa46lu DAG with same 3 blocks balooning into ~444TB
bafybeib66nyby767evpqrnpen4u7jeflavtmrhcdkazptyrxaxhlt4qyaa Monkey JPGs at nft.storage
bafybeifcd5ysgcmgsn3l3nebo3wu7jsuf7xumnsfup55dk2ikis3ujsnue Malformed UnixFS discuss.ipfs.tech
ESM Metagenomic Atlas dataset (around 30TiB total)
bafyaabakaieac Inlined Empty UnixFS dir
bafkqaaa Inlined Empty File
bafybeifiq5oapwiv55ss6vlqpck3mbsh4mzbal35s6zw5yrskphzjm7ypa 1M JSONs: NFT drop that hits wantlist overflow bug
QmeV8PDCHC1HRY3wjDC1WKXu66VyLfYJajMpzYNAgig5Vp IPTV OFFLINE video
QmNwDj9iUY3yJyDUP9yGagF6vFiorXEqx74pGn6RH2uTnz 2.1TB trusted-setup.filecoin.io
@2color
2color / libp2p-peer-ids.md
Last active May 22, 2024 11:31
@2color
2color / webrtc.md
Last active May 17, 2024 10:51

Sequence diagram for universal connectivity app

sequenceDiagram
    participant a as Browser1
    participant cr as Bootstrapper & Relay
    note over cr: With CircuitRelayV2 subscribed to GossipSub discovery, and messages topic
    participant b as Browser2
    participant stun as STUN Server
@2color
2color / js-libp2p.ts
Created May 2, 2024 16:00
persistent libp2p peerid
import { IDBDatastore } from 'datastore-idb'
import {
createDelegatedRoutingV1HttpApiClient,
DelegatedRoutingV1HttpApiClient,
} from '@helia/delegated-routing-v1-http-api-client'
import { createLibp2p, Libp2p } from 'libp2p'
import { identify } from '@libp2p/identify'
import { peerIdFromString } from '@libp2p/peer-id'
import { noise } from '@chainsafe/libp2p-noise'
import { yamux } from '@chainsafe/libp2p-yamux'
@2color
2color / ipfs-multiple-gateways.md
Last active January 5, 2023 14:34
@2color
2color / ipfs-commands.md
Created May 31, 2022 14:08
Useful IPFS commands

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

@2color
2color / main.rs
Created January 4, 2022 14:37
Mean, median, and mode of a vector with Rust
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
2color / main.md
Last active December 2, 2021 16:01

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
2color / query.sql
Created September 9, 2021 16:06
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 ?