![hafsql.png](https://files.peakd.com/file/peakd-hive/mahdiyari/23uEsNRBN8VFqNkR4aCSQNwDRgLN2G4wfa9XnM9DyWZQwdrNaay2JikkpGnTU2eaS7JzA.png)
This proposal is asking for funding to help maintain the access to public [HAF](https://gitlab.syncad.com/hive/haf) database and to partially fund the maintenance of [HafSQL](https://gitlab.com/mahdiyari/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](https://api.syncad.com/?urls.primaryName=HafSQL)) 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](https://peakd.com/proposals/359) [Ecency](https://ecency.com/proposals/359)