Subsquid Logo

Deploy a double processor squid

This is a quest to run a squid with two processors. Here is how to run it:

I. Install dependencies: Node.js, Docker, Git.

On Windows

Enable Hyper-V.
Install Docker for Windows.
Install NodeJS LTS using the official installer.
Install Git for Windows.

In all installs it is OK to leave all the options at their default values. You will need a terminal to complete this tutorial - WSL bash is the preferred option.

On Mac

Install Docker for Mac.
Install Git using the installer or by other means.
Install NodeJS LTS using the official installer.

We recommend configuring NodeJS to install global packages to a folder owned by an unprivileged account. Create the folder by running

mkdir ~/global-node-packages

then configure NodeJS to use it

npm config set prefix ~/global-node-packages

Make sure that the folder ~/global-node-packages/bin is in PATH. That allows running globally installed NodeJS executables from any terminal. Here is a one-liner that detects your shell and takes care of setting PATH:

CURSHELL=`ps -hp $$ | awk '{print $5}'`; case `basename $CURSHELL` in 'bash') DEST="$HOME/.bash_profile";; 'zsh') DEST="$HOME/.zshenv";; esac; echo 'export PATH="${HOME}/global-node-packages/bin:$PATH"' >> "$DEST"

Alternatively you can add the following line to ~/.zshenv (if you are using zsh) or ~/.bash_profile (if you are using bash) manually:

export PATH="${HOME}/global-node-packages/bin:$PATH"

Re-open the terminal to apply the changes.

On Linux

Install NodeJS (v16 or newer), Git and Docker using your distro's package manager.

We recommend configuring NodeJS to install global packages to a folder owned by an unprivileged account. Create the folder by running

mkdir ~/global-node-packages

then configure NodeJS to use it

npm config set prefix ~/global-node-packages

Make sure that any executables globally installed by NodeJS are in PATH. That allows running them from any terminal. Open the ~/.bashrc file in a text editor and add the following line at the end:

export PATH="${HOME}/global-node-packages/bin:$PATH"

Re-open the terminal to apply the changes.

II. Install Subsquid CLI

Open a terminal and run

npm install --global @subsquid/cli@latest

This adds the sqd command. Verify that the installation was successful by running

sqd --version

A healthy response should look similar to

@subsquid/cli/2.5.0 linux-x64 node-v20.5.1

III. Run the squid

Open a terminal and run the following commands to create the squid and enter its folder:
```
sqd init my-double-proc-squid -t https://github.com/subsquid-quests/double-chain-squid
```
```
cd my-double-proc-squid
```
You can replace my-double-proc-squid with any name you choose for your squid. If a squid with that name already exists in Aquarium, the first command will throw an error; if that happens simply think of another name and repeat the commands.
Press "Get Key" button in the quest card to obtain the doubleProc.key key file. Save it to the ./query-gateway/keys subfolder of the squid folder. The file will be used by the query gateway container.

The template squid uses a PostgreSQL database and a query gateway. Start Docker containers that run these with

sqd up

Wait for about a minute before proceeding to the next step.

If you get an error message about unknown shorthand flag: 'd' in -d, that means that you're using an old version of docker that does not support the compose command yet. Update Docker or edit the commands.json file as follows:

         "up": {
         "deps": ["check-key"],
         "description": "Start a PG database",
-        "cmd": ["docker", "compose", "up", "-d"]
+        "cmd": ["docker-compose", "up", "-d"]
       },
       "down": {
         "description": "Drop a PG database",
-        "cmd": ["docker", "compose", "down"]
+        "cmd": ["docker-compose", "down"]
       },

Prepare the squid for running by installing dependencies, building the source code and creating all the necessary database tables:
```
npm ci
sqd build
sqd migration:apply
```

Start your squid with

sqd run .

The command should output lines like these:

[api] 22:00:36 WARN  sqd:graphql-server enabling dumb in-memory cache (size: 100mb, ttl: 1000ms, max-age: 1000ms)
[api] 22:00:36 INFO  sqd:graphql-server listening on port 4350
[eth-processor] 22:00:36 INFO  sqd:processor processing blocks from 16000000
[eth-processor] 22:00:36 INFO  sqd:processor using archive data source
[eth-processor] 22:00:36 INFO  sqd:processor prometheus metrics are served at port 40163
[bsc-processor] 22:00:36 INFO  sqd:processor processing blocks from 28000000
[bsc-processor] 22:00:36 INFO  sqd:processor using archive data source
[bsc-processor] 22:00:36 INFO  sqd:processor prometheus metrics are served at port 39533
[bsc-processor] 22:00:39 INFO  sqd:processor 28004339 / 32107455, rate: 1537 blocks/sec, mapping: 603 blocks/sec, 1157 items/sec, eta: 45m
[eth-processor] 22:00:40 INFO  sqd:processor 16005819 / 18226899, rate: 1686 blocks/sec, mapping: 644 blocks/sec, 1224 items/sec, eta: 22m
[bsc-processor] 22:00:44 INFO  sqd:processor 28011319 / 32107455, rate: 1503 blocks/sec, mapping: 648 blocks/sec, 1250 items/sec, eta: 46m

The squid should sync in 25-30 minutes. When it's done, stop it with Ctrl-C, then stop and remove the auxiliary containers with

sqd down

Quest Info

Category	Skill Level	Time required (minutes)	Max Participants	Reward	Status
Squid Deployment	$\textcolor{green}{\textsf{Simple}}$	~40	-	$\textcolor{red}{\textsf{750tSQD}}$	open

Acceptance critera

Sync this squid using the key from the quest card. The syncing progress is tracked by the amount of data the squid has retrieved from Subsquid Network.

About this squid

This squid captures USDC Transfer events on ETH and BSC, stores them in the same database and serves the data over a common GraphQL API.

The Ethereum data ingester ("processor") is located in src/eth and similarly the Binance Chain processor can be found in src/bsc. The scripts file commands.json was updated with the commands process:eth and process:bsc that run the processors. GraphQL server runs as a separate process started by sqd serve. You can also use sqd run to run all the services at once.

The squid uses Subsquid Network as its primary data source.