* wang502

Note: PBSS in Geth >=1.13.0 removes the need to prune manually.

Old content for reference

Overview

Geth (Go-Ethereum) as of July 2022 takes about 650 GiB of space on a fast/snap sync, and then grows by ~ 14 GiB/week with default cache, ~ 8 GiB/week with more cache.

Change your database RDS instance security group to allow your machine to access it.
- Add your ip to the security group to acces the instance via Postgres.
Make a copy of the database using pg_dump
- $ pg_dump -h <public dns> -U <my username> -f <name of dump file .sql> <name of my database>
- you will be asked for postgressql password.
- a dump file(.sql) will be created
Restore that dump file to your local database.
- but you might need to drop the database and create it first
- $ psql -U <postgresql username> -d <database name> -f <dump file that you want to restore>

the database is restored

System Design Cheatsheet

Picking the right architecture = Picking the right battles + Managing trade-offs

Basic Steps

Clarify and agree on the scope of the system

User cases (description of sequences of events that, taken together, lead to a system doing something useful)
- Who is going to use it?
- How are they going to use it?

	package auth

	import (
	"encoding/json"
	"fmt"
	"io"
	"io/ioutil"
	"net"
	"net/http"
	"net/url"

	const ethers = require("ethers")

	const pk =
	"0x0471c746523d16e93d4738f882d9b0beebf66c68caa0f895db15686b57b878cfc7b3e09813ba94f1bbfaa91a06566d3d18bbf69d10bcc947325bbcd6fea97ed692"
	const ad = "0xcD3edF915387E2555A829567cE0dBbC919834B82"

	getPubKey = async () => {
	const infuraProvider = new ethers.providers.JsonRpcProvider(
	"https://ropsten.infura.io/v3/<projectID>"
	)

	package main

	import (
	"fmt"
	"github.com/ethereum/go-ethereum/core/rawdb"
	"github.com/ethereum/go-ethereum/core/types"
	"github.com/ethereum/go-ethereum/core/state"
	"github.com/ethereum/go-ethereum/rlp"
	"github.com/ethereum/go-ethereum/trie"
	_ "github.com/ethereum/go-ethereum/common"

	package main

	import (
	"github.com/syndtr/goleveldb/leveldb"
	"fmt"
	"encoding/binary"
	"github.com/ethereum/go-ethereum/core/types"
	"bytes"
	"github.com/ethereum/go-ethereum/rlp"
	)

	var Web3 = require('web3');
	var web3 = new Web3();
	web3.setProvider(new web3.providers.HttpProvider('http://localhost:8545'));
	var abi = [{
	"constant": false,
	"inputs": [{"name": "jsn", "type": "string"}],
	"name": "deposit",
	"outputs": [{"name": "", "type": "int256"}],
	"payable": false,
	"type": "function"

	# LVDB - LLOOGG Memory DB
	# Copyriht (C) 2009 Salvatore Sanfilippo <[email protected]>
	# All Rights Reserved

	# TODO
	# - cron with cleanup of timedout clients, automatic dump
	# - the dump should use array startsearch to write it line by line
	# and may just use gets to read element by element and load the whole state.
	# - 'help','stopserver','saveandstopserver','save','load','reset','keys' commands.
	# - ttl with milliseconds resolution 'ttl a 1000'. Check ttl in dump!

 package main
 import (
 	"bufio"
 	"fmt"
 	"os"
 	"strings"
 	"time"
 	"golang.org/x/net/context"