XRP Ledger and the Xahau network leverage QuestDB for time-series data
The Inclusive Financial Technology Foundation (previously XRP Ledger Foundation) needs fast, modern tooling to keep up with XRP Ledger and the Xahau network. As a rapidly evolving L1 blockchain with over 1500 applications, XRP Ledger, and Xahau, the first smart contract sidechain for the XRPL ecosystem, are set to keep growing.
Storing transactions made on the XRP Ledger
A large amount of transaction data is being processed on the XRP Ledger and the Xahau Network. They use QuestDB to provide an API that formats transaction data based on transaction time, enabling user-facing applications to retrieve data in an organized, human-friendly format.
SELECT *FROM (SELECTts AS timestamp,first(rate) AS open,last(rate) AS close,min(rate) AS low,max(rate) AS high,sum(volume_a) AS base_volume,sum(volume_b) AS counter_volume,count(*) AS exchangesFROMoffer_exchangesWHEREpair = 'rhub8VRN6jmDy1pUykJzF3wq+EUR|XRP'AND ts >= '2022-12-19T02:35:42.000Z'AND ts <= '2024-06-19T13:35:11.169Z'SAMPLE BY 1dFILL (0,PREV,0,0,0,0,0)ALIGN TO CALENDARORDER BY timestamp DESC)WHEREtimestamp >= '2022-12-19T00:00:00.000Z'AND timestamp <= '2024-06-19T00:00:00.000Z'
Fast blockchains, fast queries
This query retrieves 'Candle Stick' market data (OHLC) for the EUR/XRP trading pair on the XRP Ledger. It leverages SAMPLE BY to summarize large datasets into an aggregate of 1D time chunks as part of a SELECT statement. All together, it's organized by time, filled for accuracy and cleanliness, and very fast.
Hardware efficient, clean and tidy
QuestDB lives in XRP Ledger's' architecture for real-time data handling.
QuestDB powers data insights
With QuestDB, charts and analytics are built for over 46,000 unique trading pairs. Interfacing with the XRP Ledger L1 blockchain and the Xahau Network for smart contracts is demanding work. Together, QuestDB and Inclusive Financial Technology Foundation team are well positioned to handle both present and future growth.