Try   HackMD

Required Queries for the Anti Sybil Workstream

tags: gitcoin Notes

Updated by August 2021

Authors: Danilo Lessa Bernardineli

Input / Output

Input

  • A table where each row represents independent and valid contributions. Required fields:

    • contrib_id (PK)
    • created_on (timestamp)
    • match (bool)
    • user_handle (FK, string)
    • amount_in_usdt (float)
    • token_unit (string)

  • A table where each row represents Gitcoin user handles. Required fields:

    • user_handle (PK, string)
    • github_created_at (timestamp)
    • github_updated_at (timestamp)
    • github_public_repos_count (int)
    • github_followers_count (int)
    • github_following_count (int)
    • github_bio_length (int)

Queries


/*
Obs: normalized_data must contains the following fields:
- grant_id, user_handle, created_on, token_symbol, last_known_ip, amount_per_period, amount_per_period_usdt,
  amount_per_period_minus_gas_price
*/

select
    grants_contribution.created_on, 
    grants_contribution.profile_for_clr_id AS user_id, /* user id */
    grants_contribution.match, /* CLR match is on or off */
    grants_contribution.normalized_data /* JSON string */
from grants_contribution

/*
Collect any user stat, like Github profile info
*/

/* Retrieve */
Last changed by 
 
bsci-gitcoin
0
40

Read more

Sybil Detection Interfaces with Other Groups

(TODO: write interface points with DevOps/DataOps, stewards, and so on)

Aug 24, 2023
Gitcoin Sybil Detection Book

Summary

Aug 24, 2023
2nd research iteration results & roadmapping

:::info Updated by December 2021 ::: Authors: Danilo Lessa Bernardineli Results under the original scope The definitions & methodology of the research plan were sucessfully implementedThis includes creating rewiring optimizers based on Hill Climbing and Simulated Annealing that were pushed to the NetworkX module <sup><sub>Source: https://github.com/gitcoinco/gitcoin_cadcad_model/tree/main/optimality_gap</sub></sup>

May 23, 2023
Sybil Report on Gitcoin Grants Rounds 11

:::info Updated by September 2021 ::: Authors: Danilo Lessa Bernardineli Summary The combined FDD process is effective at catching about 83% of the Sybil Users (between 100% to 57% under 95% CI) according to blind human evaluations. The best estimate for Sybil Incidence on Gitcoin is 6.4%, and is contained between 3.6% to 9.3% with 95% CI. IP clusters together with GitHub account creation date are the most relevant features for detecting sybil users programatically right now. The Fraud Tax is computed as 0.61% of the Funding Amount. Links

May 23, 2023
Read more from bsci-gitcoin
Published on HackMD