[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.

The public HAF database currently hosts:

• HAF
• HafSQL
• hivemind
• HAF Block Explorer
• Reputation tracker
• Balance tracker

There are 2 servers dedicated to the public database. A backup server is there to provide more reliable service and also have uninterrupted updates.

You can access the public HAF database which is a PostgreSQL database, using the following information:

host: hafsql-sql.mahdiyari.info
port: 5432
database: haf_block_log
user: hafsql_public
password: hafsql_public

In case you are reading this in the future and the above doesn't work, checkout the documentations hosted at https://mahdiyari.gitlab.io/hafsql/.

Hopefully I will be able to keep HafSQL working with the new versions of HAF and improve or add new features going forward.

HafSQL makes it easier to run SQL queries on the data already present in HAF and it also provides some new set of APIs. You can explore the available APIs at:

• https://hafsql-api.mahdiyari.info/
• https://rpc.mahdiyari.info/hafsql
• https://api.syncad.com/hafsql (or here)

Feel free to ask if you need a certain API and it is not currently available.

Proposal

Asking for $36/day for 365 days

Proposal number 359
Peakd
Ecency