Description:
A real-time dashboard leveraging both Goldsky pipelines and subgraphs to provide scalable, low-latency analytics across multiple Hyperliquid stablecoins. This project solves the challenge of limited query capacity and latency in subgraphs by streaming large volumes of token transfer data into a PostgreSQL warehouse for advanced querying.
How It Works:
The project combines:
- Goldsky pipelines: Streaming on-chain transfer data directly into dedicated PostgreSQL tables, enabling unlimited, performant SQL queries on high-volume blockchain data.
- Subgraphs: Providing structured GraphQL APIs for focused, developer-friendly queries.
- Dockerized PostgreSQL: Hosting the relational database for stable, scalable storage.
- Secure remote access: Using tools like ngrok during development or VPNs for production.
- Telegram bot (optional): Demoing data access and whale alert subscriptions based on indexed pipeline data.
This dual approach demonstrates the practical advantages and trade-offs of pipelines versus subgraphs in real-world DeFi data analytics.
Key Features:
- Real-time streaming of multi-token stablecoin transfers via Goldsky pipelines.
- Powerful SQL querying on PostgreSQL data warehouse without query limits.
- Complementary GraphQL APIs via subgraphs for structured queries.
- Embedded wallet creation with seamless Privy-based multi-method login.
- Wallet identity display using Hyperliquid Names (.hl) for user-friendly experience.
- Configurable whale alert notifications via Telegram (and future multi-channel support).
- Dockerized infrastructure for easy local setup and scalable deployments.
- Secure remote database access using VPN
DEMO: https://screenrec.com/share/bh4Gf2soEk
Project Links: (Repo only accessible by @HL-Hackathon)
Code Repo: https://github.com/YuvrajSHAD/goldsky-dashboard
Telegram-Bot Repo: https://github.com/YuvrajSHAD/golsky_bot
Docs: https://hypernexus.gitbook.io/hyper-nexus
Live Demo URL: https://goldsky-dashboard.vercel.app/