You are viewing a single comment's thread from:

RE: [Proposal] Public HAF database & HafSQL maintenance

in HiveDevs14 days ago

This proposal (#359) seeks $36 per day for 365 days to support the maintenance and development of the public HAF (Hive Application Framework) database and HafSQL, a powerful SQL interface built on top of it.

🔧 What’s Being Funded?

  • Public HAF Database Access: A live PostgreSQL database containing the entire Hive blockchain data, updated in real time.
  • HafSQL Tooling: An open-source layer that simplifies querying Hive data using standard SQL and exposes REST/gRPC APIs for developers.
  • Infrastructure: Two dedicated servers (primary + backup) ensuring reliability, uptime, and seamless updates.

🌐 Current Services Hosted

The public HAF instance powers:

  • HAF & HafSQL
  • hivemind (backend for apps like PeakD)
  • HAF Block Explorer
  • Reputation tracker
  • Balance tracker

📡 Access Details (Public & Free)

Anyone can connect directly:

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

APIs are also publicly available at:

🚀 Benefits to the Hive Ecosystem

  1. Lower Barrier to Entry: Developers can query blockchain data using simple SQL—no need to parse raw block logs or run full nodes.
  2. Faster App Development: Enables rapid prototyping and deployment of dApps, analytics tools, and front-ends.
  3. Reliable Infrastructure: Public access reduces duplication of effort; teams can build on a shared, well-maintained data layer.
  4. Innovation Catalyst: Opens doors for advanced analytics, dashboards, bot systems, and research on Hive activity, reputation, and token flows.
  5. Decentralized Tooling: Complements Hive’s decentralization by providing an open, transparent data access point.

In short: this proposal sustains a critical piece of Hive’s developer infrastructure—keeping data open, accessible, and usable for everyone.

Your thoughts? Worth supporting for a healthier Hive tech stack? 💡