Skip to content

Instantly share code, notes, and snippets.

View ice09's full-sized avatar

Alexander C. ice09

View GitHub Profile

y8zm1lynyq

@ice09
ice09 / circles.csv
Created April 25, 2021 08:55
Some CirclesUBI Numbers
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 1 column, instead of 2 in line 2.
# Users with most outgoing trusts
# MATCH (tr:User)-[r:TRUSTS]->(te:User)
# RETURN tr AS Truster, COUNT(r)
# ORDER BY COUNT(r) DESC
Truster,COUNT(r)
"{""name"":cuinima1,""address"":0xBFB9749A89376565C79e17050842413F3AB43821,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/285246319f75cbb68f35154d4fa019043ded41ea2ae6010b7156e7ea8c6c099e.jpg}",3297
"{""name"":cuinima3,""address"":0x674Ee4c8B66f54c91e62fe49EadFA1A70b5b8DA4,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/609392f19687b3f5c6454b467a539843258bff229fc270c8b7624b575034b850.jpg}",2843
"{""name"":cuinima,""address"":0xD5eFcB307623728989E0431277C6230c2666cA69,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/22072a6eafe63a2a10e6dbd7acf6ed72fa4d0d79e6ca4adbcb0c919626dcf8b4.jpg}",2330
"{""name"":f4az3zl8ek,""address"":0xCb5D036b9661D119003C487915b18F7118Cdb8eE}",967
@ice09
ice09 / anyblock_analytics_sql.sql
Last active April 1, 2021 15:20 — forked from jugf/load_events_from_csv.cypher
Visualizing Trust: Trustgraphs of CirclesUBI in Neo4j
SELECT event.block_number, args->0->>'hex' as "from",
args->1->>'hex' as "to",
CAST(args->2->'num' AS NUMERIC) AS "value"
FROM event
WHERE event.address = '0x29b9a7fBb8995b2423a71cC17cf9810798F6C543'
AND event.event = 'Trust'
AND event.block_number > 12529458
order by event.block_number desc
@ice09
ice09 / xDaiComp.md
Last active February 1, 2021 07:02
xDaiComp

Evaluating xDai Stable Chain for B2B Use Cases

The xDai Stable Chain is an Ethereum sidechain with a native stable coin and a bridge to the Ethereum Mainnet for the native currency xDai, which represents DAI on the Ethereum Mainnet.

A native stable coin is a distinctive feature for financial and other Enterprise use cases which could profit of decentralized aspects of Blockchains, but cannot accept the usage of a highly volatile native crypto currencies.

The xDai Stable Chain is very cheap in transaction fees and very fast, but lacks other important features of the Ethereum Mainnet. This post will try to give enough information to enable the reader to decide if the xDai Stable Chain can be of use for her prototype, PoC, MVP or even a working product.

Intention

// SPDX-License-Identifier: AGPL
pragma solidity ^0.7.0;
abstract contract ICirclesToken {
function look() virtual public view returns (uint256);
/// @notice receive a ubi payout
/// @dev this is the method to actually update storage with new token balance
function update() virtual public;
@ice09
ice09 / BinaryTreePrinter.java
Last active October 11, 2020 14:27
MerkleTree Implementation with very simple testing, implements proofPath creation and proofPath validation. Is heavily influenced by https://github.com/SimoneStefani/merkle-tree-java.
package tech.blockchainers.crypyapi.http.common;
import org.web3j.utils.Numeric;
import java.io.PrintStream;
// taken from https://github.com/eugenp/tutorials/blob/master/data-structures/src/main/java/com/baeldung/printbinarytree/BinaryTreePrinter.java
public class BinaryTreePrinter {
This post links my 3Box profile to my Github account! Web3 social profiles by 3Box.
✅ did:3:bafyreigdyuhhpczzveh5lf2gxqhys7gldhxh3qcscdremttjpdvdxl5i7i ✅
Create your profile today to start building social connection and trust online at https://3Box.io/
@ice09
ice09 / ECRecover.java
Last active May 22, 2022 09:18
Creates a signature from a private key, signs a message and ecrecover in Java. Hashes are equal to Solidity and recoverSigner works with values generated in Java in Solidity ECTools below. Uses web3j.
public class ECRecover {
private void pkDisplay() {
//0x627306090abaB3A6e1400e9345bC60c78a8BEf57
String privateKey1 = "c87509a1c067bbde78beb793e6fa76530b6382a4c0241e5e4a9ec0a0f44dc0d3";
Credentials credentials = Credentials.create(privateKey1);
System.out.println("pk:" + Numeric.toHexStringNoPrefix(credentials.getEcKeyPair().getPublicKey()));
String message = "now that's a text";
String label = "\u0019Ethereum Signed Message:\n"+ String.valueOf(message.getBytes().length) + message;
@ice09
ice09 / extra-accounts.json
Created May 22, 2018 18:39
Cliquebait, start Geth private network in docker with customizable extra accounts (to sync eg. with Rinkeby without changing app code)
[
{
"password":"123654789",
"keystore": {
"address":"627306090abab3a6e1400e9345bc60c78a8bef57",
"crypto":{
"cipher":"aes-128-ctr",
"ciphertext":"9e1d0c1693db4b0b6a3d0ee8a81ea21e20dc5fa894437144e0b6e72748f2165b",
"cipherparams":{
"iv":"b0da55dd00ecc9f5d161f66b67394ed5"
@ice09
ice09 / uRaiden.java
Last active January 14, 2021 13:45
uRaiden balance proof with web3j
private void pkDisplay(Web3j web3j) throws Exception {
String privateKey1 = "1587352d059682a7ebb86e4aecc86f73cf418d33f9af4178ce344a3dd41a813b";
Credentials credentials = Credentials.create(privateKey1);
log.info("Address: " + credentials.getAddress());
List<String> labels = Arrays.asList(
"string message_id",
"address receiver",
"uint32 block_created",
"uint192 balance",