Skip to content

Instantly share code, notes, and snippets.

View arthurgousset's full-sized avatar

Arthur Gousset arthurgousset

View GitHub Profile
with
dau as (
-- This part of the query can be pretty much anything.
-- The only requirement is that it have three columns:
-- dt, user_id, inc_amt
-- Where dt is a date and user_id is some unique identifier for a user.
-- Each dt-user_id pair should be unique in this table.
-- inc_amt represents the amount of value that this user created on dt.
-- The most common case is
-- inc_amt = incremental revenue from the user on dt
did:3:kjzl6cwe1jw149grwovz7jlsf5i81x2tbbr9lu1c9rtm4cwedhi4tlz18doaq8f

Keybase proof

I hereby claim:

  • I am 0xarthurxyz on github.
  • I am 0xarthurxyz (https://keybase.io/0xarthurxyz) on keybase.
  • I have a public key ASD1ZMFhIlz9Wr4RAzLGkZ2aRdeA4pCx-VVjdVm35TCeVgo

To claim this, I am signing this object:

A few links I researched to support Ukraine financially (if you’re interested):

Humanitarian donations:

  • “Help Ukraine’s refugees to make a new start” [1] by “Women’s Federation for World Peace”, Source: GQ [2]
  • “Ukraine Crisis” [3] by “International Committee of the Red Cross”, Source: GQ [2] 
  • “Help children in Ukraine” [4] by “Saved the Children”, Source: Googling
  • “Ukraine Humanitarian Fund” [5] by “United Nations Office for the Coordination of Humanitarian Affairs”, Source: GQ [2] 
  • “Revived Soldiers Ukraine” [6] by organisation with same name, Source: GQ [2] 

Military donations: 

@arthurgousset
arthurgousset / a16z-crypto-canon.md
Last active May 21, 2022 14:53
a16z's Crypto Canon (markdown)
@arthurgousset
arthurgousset / celo-celi-identity.md
Last active June 1, 2022 15:36
Identity Celo CLI Commands

💡 Celo CLI for Identity

Use

Cheat sheet:

  • use --node https://forno.celo.org to use forno node
  • use --help for useful options whenever you're stuck
  • use --columns=Name,Version,State to restrict what's displayed
  • use --sort=-Version to sort by field
  • use --filter=State=Valid to filter by field value
@arthurgousset
arthurgousset / java.md
Last active April 26, 2023 09:17
Java Noob Notes #noob

🤷‍♂️ Java (noob notes)

Quick link: Oracle Java 19 Docs

Formatting and style

Indentation

Line wrapping for if statements should generally use the 8-space rule, since conventional (4 space) indentation makes seeing the body difficult. For example:

@arthurgousset
arthurgousset / python.md
Last active October 29, 2022 18:30
Python (noob notes)
@arthurgousset
arthurgousset / sql.md
Last active February 8, 2024 11:41
SQL (noob notess)
@arthurgousset
arthurgousset / js.md
Last active May 30, 2023 22:06
JavaScript (noob notes)