{"type": "project", "title": "Open Spellbook", "logoImg": "bafkreigehdeysedsu7mspd7kckfu6yo7w27lxvhjwo5c2jjzcdlkghkgfq", "website": "https://www.openspellbook.xyz/", "bannerImg": "bafkreidhhqwcsziimxbbikgvfqeveoxgnangjqx533od6b2tpgppwfv3dq", "createdAt": 1691765867234, "userGithub": "Outsider-analytics", "credentials": {"github": {"type": ["VerifiableCredential"], "proof": {"jws": "eyJhbGciOiJFZERTQSIsImNyaXQiOlsiYjY0Il0sImI2NCI6ZmFsc2V9..IesEb_ExrFa48wOl0fvIPJisgpFnUAMALsEZ0HU7wTXZHUFBoo3_dPizFOLkp_f1N98gNYOF-lGj8uPPKHgfDA", "type": "Ed25519Signature2018", "created": "2023-08-11T15:04:14.282Z", "proofPurpose": "assertionMethod", "verificationMethod": "did:key:z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC#z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC"}, "issuer": "did:key:z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC", "@context": ["https://www.w3.org/2018/credentials/v1"], "issuanceDate": "2023-08-11T15:04:14.282Z", "expirationDate": "2023-11-09T15:04:14.282Z", "credentialSubject": {"id": "did:pkh:eip155:1:0xA8cadC2268B01395f8573682fb9DD00Bd582E8A0", "hash": "v0.0.0:iygtrBosEO7Uwv3QFzqA/FHIrFR8UuyLqp8dfkNuzio=", "@context": [{"hash": "https://schema.org/Text", "provider": "https://schema.org/Text"}], "provider": "ClearTextGithubOrg#Open-Spellbook#22626267"}}, "twitter": {"type": ["VerifiableCredential"], "proof": {"jws": "eyJhbGciOiJFZERTQSIsImNyaXQiOlsiYjY0Il0sImI2NCI6ZmFsc2V9..DJZcS1-w82oKt9IxuyvjUAF_2qeGpPWk__Up6ySqkjzr7fMhsUpikd-bHbM2P_vgyaqO-bln3aCdK3X2DHbgDw", "type": "Ed25519Signature2018", "created": "2023-08-11T14:57:00.096Z", "proofPurpose": "assertionMethod", "verificationMethod": "did:key:z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC#z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC"}, "issuer": "did:key:z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC", "@context": ["https://www.w3.org/2018/credentials/v1"], "issuanceDate": "2023-08-11T14:57:00.096Z", "expirationDate": "2023-11-09T14:57:00.096Z", "credentialSubject": {"id": "did:pkh:eip155:1:0xA8cadC2268B01395f8573682fb9DD00Bd582E8A0", "hash": "v0.0.0:9CS1au61llFvB+yGJuiB6uHJiDZD0/jSKMfoVN9nlsw=", "@context": [{"hash": "https://schema.org/Text", "provider": "https://schema.org/Text"}], "provider": "ClearTextTwitter#Open_Spellbook"}}}, "description": "# Returning the Spellbook to Open Source MIT \n\n## Intro:\n\nFor years the collective wisdom of hundreds of data wizards has combined to create the \"Spellbook\", an open-source and MIT Licensed DBT project fostered by Dune Analytics. The Spellbook is an abstraction layer allowing raw blockchain data to reveal its valuable insights. Dune abandoned the open-source heritage of this resource in June with two decisions. \n1. They moved from SPARKQL to a closed-source SQL engine called DUNESQL, preventing the Spellbook models from being run on available software  \n2. They put a license on the resource which limits the use of the Spellbook. \n\nOur project is set up to return the Spellbook to open source by forking the last MIT-licensed version, providing retroactive funding to all those who contributed, and raising an initial pool of capital to fund future contributions to updating the OS Spellbook. \n\n## Objectives:\n\n1. Return the Spellbook to where it belongs: Open Source\n2. Provide retroactive funding for those who built the Spellbook\n3. Create a pool of capital to continue funding wizards who maintain Spellbook\n\n\n## Budget:\n\nThe proposed budget for Open Source Spellbook is as follows:\n\n### Retroactive Funding:\n* If <20k is received: 100% of the Grant\n    * We will assume we don't have the interest or capital to fund a DAO moving forward due to the lack of contributions.\n* If >20k is received: 50% of the Grant\n    * We will assume we have sufficient community interest and capital to create a DAO that will continue to fund the initiative.\n    * We will make further efforts to fund future contributions to the OS Spellbook \n* Contributors will have a 1-month window of time to prove their contributions\n* Contributors have two options for rewards.\n    1. Claim rewards\n    2. Forfit claim effectively donating to future efforts.\n* The working theory is to distribute rewards based on GitHub commits, but we will engage the wizard community to ensure the fairest distribution practically possible.\n\n### Future Contributions (only if >20k is raised):\n\n* Only applies if over 20k is raised.\n* 50% of Grant funds into a Multi-Sig Safe.\n* Current working theory is future rewards will be based on quadratic voting using the Gitcoin Grant Stack with support from the team. \n\n\n## Impact:\n\n1. Establishment of an enriched and widely-adopted open-source Spell Book repository. \n2. Increased efficiency in Blockchain data processing and analysis within the Web3 community.\n3. Strengthened collaborative ties among developers, data scientists, and Blockchain projects.\n4. Standardization of data transform techniques in Web3.\n\n## Conclusion:\n\nThe Web3 ecosystem is built around open-source projects getting access to public goods funding. Returning the Spellbook to open source with the assistance of GitCoin funding is a prime example of that ethos in action. Work that has been freely contributed for years is being captured by a single company that has moved fully to licensed and closed-source software. Help create a vibrant and open data ecosystem within Web3 by contributing to this round, or updating a truly OS spellbook not tied to a company.", "logoImgData": {}, "bannerImgData": {}, "projectGithub": "Open-Spellbook", "projectTwitter": "Open_Spellbook"}
Open Spellbook
# Returning the Spellbook to Open Source MIT 

## Intro:

For years the collective wisdom of hundreds of data wizards has combined to create the "Spellbook", an open-source and MIT Licensed DBT project fostered by Dune Analytics. The Spellbook is an abstraction layer allowing raw blockchain data to reveal its valuable insights. Dune abandoned the open-source heritage of this resource in June with two decisions. 
1. They moved from SPARKQL to a closed-source SQL engine called DUNESQL, preventing the Spellbook models from being run on available software  
2. They put a license on the resource which limits the use of the Spellbook. 

Our project is set up to return the Spellbook to open source by forking the last MIT-licensed version, providing retroactive funding to all those who contributed, and raising an initial pool of capital to fund future contributions to updating the OS Spellbook. 

## Objectives:

1. Return the Spellbook to where it belongs: Open Source
2. Provide retroactive funding for those who built the Spellbook
3. Create a pool of capital to continue funding wizards who maintain Spellbook


## Budget:

The proposed budget for Open Source Spellbook is as follows:

### Retroactive Funding:
* If <20k is received: 100% of the Grant
    * We will assume we don't have the interest or capital to fund a DAO moving forward due to the lack of contributions.
* If >20k is received: 50% of the Grant
    * We will assume we have sufficient community interest and capital to create a DAO that will continue to fund the initiative.
    * We will make further efforts to fund future contributions to the OS Spellbook 
* Contributors will have a 1-month window of time to prove their contributions
* Contributors have two options for rewards.
    1. Claim rewards
    2. Forfit claim effectively donating to future efforts.
* The working theory is to distribute rewards based on GitHub commits, but we will engage the wizard community to ensure the fairest distribution practically possible.

### Future Contributions (only if >20k is raised):

* Only applies if over 20k is raised.
* 50% of Grant funds into a Multi-Sig Safe.
* Current working theory is future rewards will be based on quadratic voting using the Gitcoin Grant Stack with support from the team. 


## Impact:

1. Establishment of an enriched and widely-adopted open-source Spell Book repository. 
2. Increased efficiency in Blockchain data processing and analysis within the Web3 community.
3. Strengthened collaborative ties among developers, data scientists, and Blockchain projects.
4. Standardization of data transform techniques in Web3.

## Conclusion:

The Web3 ecosystem is built around open-source projects getting access to public goods funding. Returning the Spellbook to open source with the assistance of GitCoin funding is a prime example of that ethos in action. Work that has been freely contributed for years is being captured by a single company that has moved fully to licensed and closed-source software. Help create a vibrant and open data ecosystem within Web3 by contributing to this round, or updating a truly OS spellbook not tied to a company.
Open Spellbook