SQL Direct access

Quick Start

psql -U USERNAME -h sql.xxx.algonode.net -p YYYY ledgerdb

Note

Postgres is running on non-standard port YYYY without SSL.
Server is running PG version 14. Compatible with v10+ clients and SDKs.

Vs vanilla Indexer

Algorand provides open source Indexer that anyone can run.
Maintaining it might be a (costly) challenge - see current SSD requirement here

If you are interested in running the indexer yourself consider starting with a self contained light version.

Schema diffs

• Table public.txn is a partitioned table
• Table public.txn has extra indexes
• Table public.asset has extra indexes

Schemas:

• vanilla schema
• Nodely’s extended schema

Extras

• Realtime NFT Metadata parser with support for
  • ARC3
  • ARC19
  • ARC69
• Nodely’s Algorand extension
• Citus TOPn extension
• Citus HLL extension

Limitations

• Not compatible with PGAdmin
• SQL statements are limited in execution time
• Not suitable as a SQL backend for Algorand-Indexer
• No ARC72 support

Note

Some values are stored in original binary format. See extra functions below.

SQL ETL

Each dedicated database instance is powered with a highly customized ETL process.

• Blocks are loaded from multiple sources at the same time.
• Hardware is tuned to favor write workloads.

This results in:

• More reliable block delivery (no SPoF)
• Shorter avg time to new block by 150ms
• Faster indexing

Parallel ETL process enriches the dataset with real-time NFT metadata sourced from recursive IPFS fetches.