helium-etl-queries
A collection of SQL views used to enrich data produced by a Helium blockchain-etl (by jamiew)
blockchain-etl
Blockchain follower that follows and stores the Helium blockchain (by helium)
| helium-etl-queries | blockchain-etl | |
|---|---|---|
| 1 | 5 | |
| 15 | 63 | |
| - | - | |
| 0.0 | 5.2 | |
| over 1 year ago | 6 months ago | |
| PLpgSQL | Erlang | |
| - | Apache License 2.0 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
helium-etl-queries
Posts with mentions or reviews of helium-etl-queries.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-08-10.
blockchain-etl
Posts with mentions or reviews of blockchain-etl.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-04-27.
-
Light hotspots pushed back another week
The Light Hotspots activation is the largest update to the Helium network since Validators last year and the core developers have been working hard to ensure a smooth deployment. This week the core team identified a few changes that require another update by various network participants and is moving the activation date to provide participants ample time to upgrade. No action required by Hotspot owners. To ensure blockchain components continue to work as expected we request all network participants upgrade their software to the appropriate version listed below by 2022-05-11 00:00:00 UTC. Activation of Light Hotspots will take place shortly after. Note some components will have releases later this week but we wanted to communicate this change early. We’ll continue to update this announcement as releases become available. - Validators: currently beta (https://github.com/helium/miner/releases/tag/validator1.9.1) - Blockchain Node: https://github.com/helium/blockchain-node/releases/tag/1.1.62 - Router: TBD (later this week) - Hotspot Firmware / Makers: TBD (later this week) - ETL: https://github.com/helium/blockchain-etl/releases/tag/1.1.140 Thanks for updating and we look forward to this launch!
-
Is there a tool (a map?) to see the data usage of the helium network
If you know (or want to learn) Erlang, Helium maintain an open source ETL project for the network: https://github.com/helium/blockchain-etl
-
I used to be in the Hex with 2 spots, now I’m in the one that has 8. How did it change on its own?
Link: https://github.com/helium/blockchain-etl/releases/tag/1.1.116 Bug: https://github.com/helium/blockchain-etl/issues/191
-
Blockchain Historical Data?
Blockchain follower: https://github.com/helium/blockchain-etl
-
Number of Hotspots Data
That’s pretty data/transfer intensive, though, so depending on your use case, you may want to build your own database with an appropriate ETL. https://github.com/helium/blockchain-etl
What are some alternatives?
When comparing helium-etl-queries and blockchain-etl you can also consider the following projects:
ethereum-etl - Python scripts for ETL (extract, transform and load) jobs for Ethereum blocks, transactions, ERC20 / ERC721 tokens, transfers, receipts, logs, contracts, internal transactions. Data is available in Google BigQuery https://goo.gl/oY5BCQ
HIP - Helium Improvement Proposals
zombodb - Making Postgres and Elasticsearch work together like it's 2023
miner - Miner for the helium blockchain
metorikku - A simplified, lightweight ETL Framework based on Apache Spark
blockchain-node - A Heilum Blockchain Node
helium-payment-calculator - Web application that can calculate the exact amount of HNT to pay someone that is hosting your hotspot.
LINQ to DB - Linq to database provider.
practical-sql - Code and Data for the First Edition of "Practical SQL" by Anthony DeBarros, published by No Starch Press (2018).