vladbatushkov

MATCH (n) DETACH DELETE n;
CREATE (b:Block {hash: 'block1'});

// Coinbase 1
MATCH (b:Block {hash: 'block1'})
CREATE
  (i:Input {coinbase: 'coinbase1'}),
  (tx:Transaction {id: 'tx1-1'}),
  (o:Output {n: 0, value: 11}),
  (a:Address {address: 'addr1-1'})

vladbatushkov

PROFILE MATCH (:Address {address: "addr1-2"})-[:OUT]->(:Output)<-[:OUT]-(t:Transaction)
CALL apoc.path.expandConfig(t, { sequence:'Transaction, <IN, Input, <UNLOCK, Output, <OUT' })
YIELD path
UNWIND nodes(path) as tx
MATCH (tx:Transaction)-[:OUT]->(o:Output)<-[:OUT]-(a:Address)
WHERE (o)-[:UNLOCK]->(:Input)
RETURN DISTINCT *

// check tx chain, 3 - min number of hops in the chain, 6 - max
// where is no chains longer than 3 hops = 2 tx. (each (tx)-to->(tx) step required 3 hops).

vladbatushkov

Database Schema

CALL db.schema.visualization();

Graph Size

CALL apoc.meta.stats();

vladbatushkov

Max De Marzi Modeling Guidelines:

1. Don’t use the same Relationship Type for everything
2. Don’t use two relationships when one will do
3. Keep the same Direction for paths
4. Use different Relationship Types between label pairs
5. Pre-Split densely related nodes by relationship types
6. Try to stick to One Label per Node
7. Create Indexes on any properties used to Find a Node

vladbatushkov

Relationships

10k Posts, 2 Tags, 1 Emoji. Explore impact of :CONTAINS rel on query.

Option 1

Schema: (:Emoji)<-[:CONTAINS]-(:Post)-[:CONTAINS]->(:Tag)

vladbatushkov

MATCH (n) DETACH DELETE n;
//DROP INDEX person_name;
CREATE (me:Person { name: "Vlad" })
CREATE (p1:Person { name: "Max" })
CREATE (p2:Person { name: "Peter" })
CREATE (p3:Person { name: "Alex" })
CREATE (po1:Post { content: "What a lovely day." })
CREATE (po2:Post { content: "New challenge - new learnings." })
CREATE (po3:Post { content: "Never give up!" })
CREATE (p1)-[:POSTED]->(po1)

vladbatushkov

type alias Model =
    { screen : Screen
    , hero : Hero
    , foodPanel : FoodPanel
    , hp : Hp
    , score : Int
    , bestResults : List BestResult
    }

vladbatushkov

type Msg
    = Idle
    | Eat (List Tags)
    | Damage Int
    | HpCheck Int
    | ChangeHero Hero
    | ShuffleFood
    | Shuffle (List Food)
    | Animate AnimatedObject Animation.Msg
    

vladbatushkov

heroList : Model -> List (Html Msg)
heroList model =
    List.map
        (\x ->
            card [ style "margin-top" "1.5rem" ]
                [ cardContent []
                    [ media [ onClick <| ChangeHero x ]
                        [ mediaLeft [ style "width" "40%" ]
                            [ image (OneByOne Unbounded)
                                []

vladbatushkov

add : Int -> Int -> Int
add a b =
    a + b


dashify : String -> String -> String
dashify a b =
    if a == "" then
        b