#hafsql

At its core, this is what I’d call a curation cockpit.

A roundup of the main PeakD for this week, including a new Analytics page, image proxy, blog filtering, and more

A revamped unified analytics page coming soon to PeakD powered by a new open source backend project

deutsch: bitte runterscrollen Dear Hivians! I would like to introduce you to @stayout.bot, a small bot on Hive that can (currently) do four things: provide some user stats, information about downvotes,

Hey everyone, today while I was doing some research for Worldmappin I ran into something that I really did not expect. I was looking through some of my older posts from years ago, especially posts that

HiveTool – a modern, fast, and responsive blockchain explorer designed specifically for the Hive ecosystem.

你知道如何从HIVE链上获取数据嘛？直接访问各个DAPP（比如hive.blog, peakd.com等）无疑是个办法，或者访问区块链浏览器获取一些更底层的数据，又或者我们可以通过API直接从hived节点获取数据。 (图源 ：pixabay) 但当我们想获取一些更为复杂的数据时，以上方法都显得无能为力，比如说统计中文区失联（长时间没有发帖）用户的情况，或者查询HP代理（代理进来），等等等。

Hey everyone! Some time ago, I created a small tool that lets you search for posts on the Hive blockchain using specific keywords. The idea was to help people quickly find posts that include certain words

Hey everyone! I just released a new version of the Hive Keywords Fetcher Tool. This is a small project I have been working on to make it easier to search for content on the Hive blockchain. It is especially

Today, during the day, I received a request from a friend who sometimes uses the search function on Ecency to find specific content on the Hive blockchain. He uses it mainly to curate posts more effectively.

Starting from today Hivemind and HAF block explorer (which also includes balance_tracker and rep_tracker) will be available on my public HAF database. To access the database see the documentations at:

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

A notice to people using the new HafSQL node hafsql-sql.mahdiyari.info: There is a minor breaking change incoming. The following functions don't exist anymore: hive.operation_id_to_block_num()

As some of you already know, I'm currently trying out the wonderful Github Copilot to improve my programming skills and I have to say that it's working really well. As I've been in IT for a very long time,

It was a nice idea but in the end it didn't work out. I spent the whole day yesterday developing a small but nice piece of software that I actually wanted to make available to you all at the end of the

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. You can find the article

HafSQL went through a big update. This is a release candidate and not a final release as HAF 1.27.6 is not released yet. This version of HafSQL is compatible with HAF 1.27.6-rc9. There are a lot of breaking

Hacer consultas directas a la Blockchain de Hive es muy fácil. Aquí muestro cómo.

I did announce how my public HAF/HafSQL node was down in the last post and how it is going to be back up in 2 days. Well, I was wrong. As it turns out the main server is broken somehow. I don't know what

Downtime The public HAF/HafSQL node that I'm operating, hafsql.mahdiyari.info, will be down for 2 days. More info on the node is here. This morning the HAF node on the main server died. This wouldn't be