Hive

Comments

mahdiyari (72)in Snaps • 2 days ago
RE: Snaps Container // 10/30/2025, 1:48:00 AM
No. This also reduces the inflation going into the DHF. What I meant was DHF already has some HBD in it and when that gets distributed to the proposals, the actual inflation…
$0.00
0 0
mahdiyari (72)in Snaps • 2 days ago
RE: Snaps Container // 10/30/2025, 1:48:00 AM
Next Hard fork on Hive has been scheduled for November 19. One of the changes will indirectly lower the inflation of Hive. By how much? 23% at the current price Should I…
$0.04
Pending payout amount: $0.04
Breakdown: 0.02 HBD, 0.15 HP
Payout in 5 days
4 5
mahdiyari (72)in #life • 11 days ago
RE: I have returned.
Hope you get well soon. Life sometimes be like that.
$1.30
Past Payouts $1.30
- Author $0.65
- Curators $0.65
4 0
mahdiyari (72)in #hive • 13 days ago
RE: Proof of Gatekeeping #1
APIs have been getting documented recently and you can say all of them are now documented on the API side. The specific problem you posted as an example is a rare case. It is not…
$0.36
Past Payouts $0.36
- Author $0.18
- Curators $0.18
5 2
mahdiyari (72)in PRAETORIA • 29 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
Past Payouts $0.06
- Author $0.03
- Curators $0.03
1 0
mahdiyari (72)in PRAETORIA • 29 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 • 29 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 • 29 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
Past Payouts $0.06
- Author $0.03
- Curators $0.03
1 4
mahdiyari (72)in PRAETORIA • 29 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 • 29 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.73
Past Payouts $1.73
- Author $0.87
- Curators $0.87
3 11
mahdiyari (72)Testing...does it workin HiveDevs • last month
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 • last month
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 • last month
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 • last month
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 • last month
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 • last month
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 • last month
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 • last month
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 • last month
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 • 4 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