HiveSQL
Search…
Reblogs
Reblog related operations are not associated with a dedicated transaction, they are stored in the blockchain using custom_json transactions (see TxCustoms).
Storing the details of a "reblog" operation in a JSON string is pretty annoying because this requires deserializing the content of the JSON string before you can analyze its contents. Even if the SQL server has JSON functions to perform such operation, this will slow down queries as the server has to process every row before being able to filter data. Unfortunately, it is not possible to create an index on values contained in the JSON string.
Searching for reblogs is all but efficient, especially when you know that the TxCustoms table contains several million rows!
Moreover, the format of the JSON string of "reblog" operations has changed over time. This has to be taken into account when parsing the data. Writing an efficient query can quickly become cumbersome.
The table is a non-transactional table that enables one to know who has reblogged which post. It does not store transactions, meaning it does not expose historical data and does not allow to know when an account reblogged a post or removed the reblog.

Columns

Name
Description
account
account doing a reblog
author
author of the reblogged post
permlink
permlink of the reblogged post
timestamp
when the post has been reblogged
Last modified 4mo ago
Copy link