HAF & HafSQL

Oct 18, 2026• mahdiyari

[Proposal] Public HAF database & HafSQL maintenance for one year

This proposal is asking for funding to maintain the access to the public HAF database

Oct 18, 2026• mahdiyari

HafSQL v2.7.0

reward hive balance , reward hbd balance , reward vests balance , to withdraw , vesting withdraw rate , withdrawn and proxy are gone

Jul 17, 2026• hdev

HDev Team Updates — New Developers Cohort, New Hive Apps, and Vylor (Voice-First AI Finance)

This is the third post in our development-update series for June

Jul 13, 2026• hdev

HDev Team HAF Updates - Waggle & HAF FYP: A For You Feed for Hive

This is the second post in our development-update series

Jul 8, 2026• hdev

HDev Team HAF Updates June - New HAF Analytics & Explorer Dashboards

It's been a little while since our last large-scale update, so over the next few days we'll be sharing a short series of posts covering what our development team has been building across the Hive ecosystem over the past

May 18, 2026• hdev

HDev Team HAF Updates May 2026 - Front End, Expanded APIs, FYP & Stats HAF Apps

It has been a while since our last update on HAF work, frontend and backend, so this one covers intensive work across multiple projects

Dec 28, 2025• louis88

Introducing Vest_Core - A Tool to See & Filter Hive Power Ups

Yesterday, I saw a short message and immediately thought, “Wait a minute, this could definitely be implemented quite well with hafSQL from @mahdiyari.” So, the short message triggered me and prompted me to reopen Google

Sep 25, 2025• mahdiyari

[Proposal] Public HAF database & HafSQL maintenance

This proposal is asking for funding to help maintain the access to public HAF database and to partially fund the maintenance of HafSQL

May 25, 2025• mahdiyari

[Update] Public HAF, HafSQL, Hivemind, and Hafbe database

Starting from today Hivemind and HAF block explorer (which also includes balance tracker and rep tracker) will be available on my public HAF database

May 10, 2025• louis88

Updates on my Hive Post Payout Dashboard (using HafSQL) / New Endpoint for mahdiyari.info

I have just updated the small help tool “Hive Post Payout Dashboard (using HafSQL)” to a new host endpoint, as the dear @mahdiyari will soon deactivate the old version at hafsql.mahdiyari.info and the new version will

Jan 15, 2025• mahdiyari

HafSQL public node update

A notice to people using the new HafSQL node hafsql-sql.mahdiyari.info : There is a minor breaking change incoming

Jan 14, 2025• makerhacks

Getting HiveSQL to Work with Python on Linux

Using one of the best developer resources Hive has to offer

Dec 30, 2024• louis88

Hive Analytics Dashboard (using HafSQL) - Next Version crazy fast and easy to use.

A few days ago, I converted my original script, which is written in Python and only ran locally on my computer, into an application that can run in a browser with an interface

Dec 28, 2024• louis88

A single file Analytics Tool to find Post-Payouts from a List of Users

At the end of October 2024, I became aware of a large-scale spam attack targeting Hive

Dec 14, 2024• mahdiyari

HafSQL update 2.0.0-rc1 - Breaking changes

This is a release candidate and not a final release as HAF 1.27.6 is not released yet

Mar 26, 2024• mahdiyari

[Proposal] Public HAF/HafSQL database maintenance & development of HafSQL

I have been providing public access to a HAF + HafSQL database for the past 3 months

Jan 29, 2024• disregardfiat

Haf API Node Setup

Setting up a "full API node" has never been so easy. Let's walk through it

Dec 25, 2023• mahdiyari

Public HafSQL database on HAF

The endpoint listed in this post is deprecated and will be dropped soon

Oct 3, 2023• peak.open

Standalone HAF Apps - Upgradeability

Creating infrastructure to help make building apps on Hive fast and easy

Sep 9, 2023• peak.open

Standalone HAF Apps- A Request for Feedback

Unlocking Hive's potential with lightweight nodes for global data dispersion and developer ease

Sep 7, 2023• postgres

Speeding up PostgreSQL data loading

Greetings Hive minds! I'm a long time PostgreSQL contributor and author specializing in performance tuning. Now that @mahdiyari has the PostgreSQL based HafSQL in beta, I noticed index building is becoming

Aug 6, 2023• mahdiyari

Running Hivemind & HAfAH on HAF + Jussi - 2023

I assume you are here after following the previous post

Aug 4, 2023• mahdiyari

How to run a HAF node - 2023

It is highly recommended to setup ZFS compression with LZ4

Jun 28, 2023• mahdiyari

HafSQL V1.0.0-beta

HafSQL runs on a HAF node and makes it possible to run certain queries on the HAF data

Jun 2, 2023• howo

Hivemind / HAF how to save and restore the database for development purposes

How to save and restore a Hivemind/HAF database to speed up development work

May 7, 2023• mahdiyari

HAF application development - progress report

I have been developing views for all the operations including the virtual operations

Mar 30, 2023• freebeings

GNS: Keychain Login, New Notifications and User Preferences

You can now login to the GNS preview site using Hive Keychain and see notifications for your account

Mar 15, 2023• howo

HAF-powered Hivemind dev environment setup guide (according to my findings, it may or may not be the best way)

If you're an astute reader, you probably realized this title was similar to my previous post here

Feb 2, 2023• freebeings

HAF Plug & Play: Delegations API

Vesting Delegations API is now live

Oct 18, 2022• arcange

HiveSQL Update - RC Delegations data available

HiveSQL has been updated with a new table that helps find information about RC delegations faster and easier.

Oct 15, 2022• arcange

Hive SQL - Hardfork 26 support

HiveSQL has been updated to fully support the new operation implemented for the hardfork 26 of the blockchain

Apr 28, 2022• arcange

HiveSQL Infrastructure Upgrade Complete

The HiveSQL infrastructure upgrade is no complete and HiveSQL is back alive and kicking!

Apr 27, 2022• arcange

HiveSQL Infrastructure Upgrade

HiveSQL will be under maintenance and unavailable as of 2022-04-27 22:00 UTC. The maintenance should last 1 day.

Feb 9, 2022• blocktrades

A developer’s introduction to the Hive Application Framework

A framework to ease the process of creating decentralized apps with Hive.

Jun 29, 2021• arcange

Hive SQL is ready for the hardfork 25 - Addendum

My API servers have also been upgraded to the new code and are now providing HiveSQL with new data.

May 31, 2021• arcange

Hive SQL is ready for the hardfork 25

HiveSQL has undergo a lot of updates to manage the new data generated by the blockchain after the hardfork 25.

May 25, 2021• arcange

The HiveSQL documentation is now available

Check out the HiveSQL documentation. Whether you are a HiveSQL user or not, you will for sure find useful information.

May 17, 2021• arcange

HiveSQL Upate - New Virtual Operation tables

Two virtual operation tables have been added and a major change has been made to TxCustoms table. Check it out!

May 14, 2021• arcange

HiveSQL Upate - Changes to the Internal Market tables

I am actively continuing the work of reorganizing the HiveSQL database that I started a few days ago. Lately, I tackled the tables related to the internal market.

May 11, 2021• arcange

HiveSQL Upate - Database maintenance and new Account Recovery Tables

Find out about the database maintenance work I have undertaken and the recent changes to the account recovery tables.

May 8, 2021• arcange

HiveSQL Upate - New Blacklists and Mutes tables

Four new tables have been added to HiveSQL to make life of people who track blacklists, mutes list and reblogs easier.

May 6, 2021• arcange

HiveSQL Update - New Status Page

To enable users to monitor HiveSQL, I created a new HiveSQL status page.

Nov 12, 2020• arcange

HiveSQL is free again - Thank you for your support!

Today, thanks to your amazing support, I'm glad to announce that HiveSQL is free again! Thank you to all its supporters!

Mar 20, 2020• arcange