Hive

Comments

mahdiyari (72)in PRAETORIA • 2 days ago
RE: How SPS Stakeholders and Staking HP and HBD?
You are not spamming. This one takes too long for top witnesses.
$0.06
Pending payout amount: $0.06
Breakdown: 0.03 HBD, 0.16 HP
Payout in 5 days
1 0
mahdiyari (72)in PRAETORIA • 2 days ago
RE: How SPS Stakeholders and Staking HP and HBD?
There is a limit on how many concurrent connections you can have per IP. Currently it is set to 6. So it's not a problem on the database side but your will get errors so you…
$0.00
0 1
mahdiyari (72)in PRAETORIA • 2 days ago
RE: How SPS Stakeholders and Staking HP and HBD?
I can take a look later to see if I can come up with a query that tracks historical delegations and make that a materialized view which can refresh once an hour or so depending on the query.
$0.00
0 2
mahdiyari (72)in PRAETORIA • 2 days ago
RE: How SPS Stakeholders and Staking HP and HBD?
There is no historical tracking of delegations. There are only current values available.
$0.06
Pending payout amount: $0.06
Breakdown: 0.03 HBD, 0.16 HP
Payout in 5 days
1 4
mahdiyari (72)in PRAETORIA • 2 days ago
RE: How SPS Stakeholders and Staking HP and HBD?
This query seems better but still takes too long for "spammy" accounts. It's fine though. Those tables are not created by me. They are from haf balance tracker . Those…
$0.00
0 9
mahdiyari (72)in PRAETORIA • 2 days ago
RE: How SPS Stakeholders and Staking HP and HBD?
@beaker007 I saw your code. You might want to use hafbe_bal.balance_history_by_day and hafbe_bal.saving_history_by_day to get the data faster. There is also _by_month for…
$1.74
Pending payout amount: $1.74
Breakdown: 0.87 HBD, 4.68 HP
Payout in 5 days
3 11
mahdiyari (72)Testing...does it workin HiveDevs • 8 days ago
RE: [Proposal] Public HAF database & HafSQL maintenance
Anyways. Feel free to share your queries that you want them to become APIs. Also for the example you gave we already have an API call from Hivesense See the similar posts.
$0.00
0 1
mahdiyari (72)Testing...does it workin HiveDevs • 8 days ago
RE: [Proposal] Public HAF database & HafSQL maintenance
Where is your website hosted then? You are not processing private information. It is publicly available data. You can't expect your activity to be hidden while visiting a website…
$0.00
0 3
mahdiyari (72)Testing...does it workin HiveDevs • 8 days ago
RE: [Proposal] Public HAF database & HafSQL maintenance
What is the difference between your server running the query vs my server? Making an API doesn't stop the query from running in a server. You could say you are making an API by…
$0.00
1 5
mahdiyari (72)Testing...does it workin HiveDevs • 8 days ago
RE: [Proposal] Public HAF database & HafSQL maintenance
I should remove that. I don't think like that anymore.
$0.00
0 7
mahdiyari (72)Testing...does it workin HiveDevs • 9 days ago
RE: [Proposal] Public HAF database & HafSQL maintenance
Yes that is possible. The data is there. I could make it an API call. You could run the following query to find users with Germany location: SELECT name FROM hafsql.accounts
$0.06
Past Payouts $0.06
- Author $0.03
- Curators $0.03
2 1
mahdiyari (72)Testing...does it workin HiveDevs • 9 days ago
RE: [Proposal] Public HAF database & HafSQL maintenance
128GB RAM 7TB NVMe The main thing you need is the fast NVMe storage. Right now with ZFS + LZ4 compression HAF + apps take 3TB. You could probably make it work with 32GB of RAM…
$0.08
Past Payouts $0.08
- Author $0.04
- Curators $0.04
3 10
mahdiyari (72)Testing...does it workin HiveDevs • 9 days ago
RE: [Proposal] Public HAF database & HafSQL maintenance
You can't get an exact answer to this question because it is impossible to track with the current setup. But from interactions I had with people, I can tell peakd is one of the…
$0.22
Past Payouts $0.22
- Author $0.11
- Curators $0.11
3 3
mahdiyari (72)Testing...does it workin HiveDevs • 9 days ago
RE: [Proposal] Public HAF database & HafSQL maintenance
is powered by the same instance. So yes it is suitable for use by the apps. The availability is high but it will be improved over time with smart switches to the backup server…
$0.09
Past Payouts $0.09
- Author $0.05
- Curators $0.05
2 12
mahdiyari (72)in Snaps • 10 days ago
RE: Snaps Container // 9/25/2025, 2:00:00 PM
I just noticed this. Keep it that way please.
$0.00
4 6
mahdiyari (72)in Snaps • 3 months ago
RE: Snaps Container // 1752318720
The first vote stays on no matter how it was cast. So if fanbase vote was faster it would be the one on the post.
$0.14
Past Payouts $0.14
- Author $0.07
- Curators $0.07
4 1
mahdiyari (72)in Hive Improvement • 4 months ago
RE: Pegging HBD to the most-performant asset from a group of assets
HBD is not a reserve currency. It is a pegged currency and it is a debt. You could say HBD or dollar losing value is a good thing for Hive as it means lower debt. Imagine pegging…
$0.00
2 1
mahdiyari (72)in #hello • 4 months ago
RE: Hello, Hive!
Hi and welcome.
$0.00
0 0
mahdiyari (72)in #proposal • 4 months ago
RE: Zypto × Hive Integration Proposal: Full Suite of Global Financial Tools
Are they aware that Hive doesn't have paper wallets and they have to pay 3 HIVE fee for each non-custodial wallet they create for Hive? This is their current system. They have…
$0.07
Past Payouts $0.07
- Author $0.03
- Curators $0.03
5 2
mahdiyari (72)in Proof of Brain • 4 months ago
RE: NO ACCOUNT ACCESS. ASKING FOR HELP WITH ACCOUNT RECOVERY.
It is the same name. You can find me in the hive server or just say hi in one of the channels there.
$0.00
1 0