create account

HiveSQL Upate - New Blacklists and Mutes tables by arcange

View this thread on: hive.blog |  peakd.com |  ecency.com
hive-139531 · @arcange ·
$31.53
HiveSQL Upate - New Blacklists and Mutes tables
![](https://i.imgur.com/FE9D32t.png)

The concept of [decentralized blacklists and mutes lists](/hive-102930/@blocktrades/hive-improvement-proposal-decentralize-blacklists-on-hive) was introduced by @blocktrades some time ago. These lists are recorded in the blockchain as `custom_json` operations, which makes them hard to track given the large number of such operations issued each day.

Therefore, I created additional tables to make life easier for those who would be interested in such information.

### What's new?

Four new "state" tables have been added to the database. State tables do not store transactions but reflect the result of operations recorded in the blockchain.

**Blacklists**

Blacklists allow anyone to construct a set of blacklisted users and allow each user to use one or more blacklists created by others.

Blacklisting an account implies the blacklister thinks the account is doing something wrong, and is intended to be used as a way to warn others that he thinks they should be careful when dealing with that account.

|Column|Description|
|-|-|
|blacklister|account owning the blacklist|
|blasklisted|account being blacklisted|

**BlacklistsFollows**

This table contains a list of accounts following other account's blacklist.

|Column|Description|
|-|-|
|account|account following a blacklist|
|blacklist|account who created a blacklist|

**Mutes**

Mutes lists allow anyone to construct a set of users and allow each user to use one or more mute lists created by others.

Muting an account means one doesn’t want to see the account’s posts and comments. Most frontends honor muting by preventing those posts from being displayed when its users view the site.

|Column|Description|
|-|-|
|muter|account owning the mutes list|
|muted|account being muted|

**MutesFollows**

This table contains a list of account following other account's mutes list

|Column|Description|
|-|-|
|account|account following a mutes list|
|mutelist|account who created a mutes list|

### What else?

**Support for reblogs deletion**

Hivemind has recently added support for undoing Reblogs.

This allows users to remove old reblogs they don't want to appear on their feed or posts they mistakenly reblogged.

HiveSQL will also manage such operations and remove related entries from its `Reblogs` state table.

## Support

If you have any questions or remarks, support is provided on the [HiveSQL Discord Channel](https://discord.gg/kyEFDfT).

Thank you for reading.

---
**Let's keep HiveSQL free to use - Support its proposals**!
|HiveSQL|HiveBuzz|
|-|-|
|[Vote for the proposal on PeakD](https://peakd.com/me/proposals/138)<br>[Vote for the proposal on Ecency](https://ecency.com/proposals/138)<br>[Vote for the proposal using HiveSigner](https://hivesigner.com/sign/update_proposal_votes?proposal_ids=%5B%22138%22%5D&approve=true)|[Vote for the proposal on PeakD](https://peakd.com/me/proposals/147)<br>[Vote for the proposal on Ecency](https://ecency.com/proposals/147)<br>[Vote for the proposal using HiveSigner](https://hivesigner.com/sign/update_proposal_votes?proposal_ids=%5B%22147%22%5D&approve=true)|

---
<center>

### Check out my apps and services
<a href="/hive/@hive.engage/stay-connected-with-your-hive-audience-and-catch-attention"><img src="https://i.imgur.com/GiNJqlm.png"></a><a href="/@hivebuzz"><img src="https://i.imgur.com/B4UTun2.png"></a><a href="/@hivesql"><img src="https://i.imgur.com/EPN8RW6.png"></a><a href="/hive/@arcange/introducing-hive-account-recovery"><img src="https://i.imgur.com/6TWeW7V.png"></a><a href="/@hive.autoclaim"><img src="https://i.imgur.com/ih2pEOw.png"></a></center>
<center>

### [Vote for me as a witness ![](https://i.imgur.com/2bi4SnT.png)](https://hivesigner.com/sign/account-witness-vote?witness=arcange&approve=1)
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 123 others
properties (23)
authorarcange
permlinkhivesql-upate-20210508
categoryhive-139531
json_metadata"{"app":"peakd/2021.04.5","format":"markdown","description":"Four new tables have been added to HiveSQL to make life of people who track blacklists, mutes list and reblogs easier.","tags":["hive-139531","hivesql","hive","sql","database","maintenance"],"users":["blocktrades","hive.engage","hivebuzz","hivesql","arcange","hive.autoclaim"],"image":["https://i.imgur.com/FE9D32t.png","https://i.imgur.com/GiNJqlm.png","https://i.imgur.com/B4UTun2.png","https://i.imgur.com/EPN8RW6.png","https://i.imgur.com/6TWeW7V.png","https://i.imgur.com/ih2pEOw.png","https://i.imgur.com/2bi4SnT.png"]}"
created2021-05-08 12:20:33
last_update2021-05-08 12:20:33
depth0
children9
last_payout2021-05-15 12:20:33
cashout_time1969-12-31 23:59:59
total_payout_value16.625 HBD
curator_payout_value14.901 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length3,786
author_reputation1,065,065,779,136,773
root_title"HiveSQL Upate - New Blacklists and Mutes tables"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id103,570,875
net_rshares38,438,166,344,408
author_curate_reward""
vote details (187)
@beerlover · 
<div class='pull-right'>https://files.peakd.com/file/peakd-hive/beerlover/yiuU6bdf-beerlover20gives20BEER.gif<p><sup><a href='https://hive-engine.com/?p=market&t=BEER'>View or trade </a> <code>BEER</code>.</sup></p></div><center><br> <p>Hey @arcange, here is a little bit of <code>BEER</code> from @pixresteemer for you. Enjoy it!</p> <p>Learn how to <a href='https://peakd.com/beer/@beerlover/what-is-proof-of-stake-with-beer'>earn <b>FREE BEER</b> each day </a> by staking your <code>BEER</code>.</p> </center><div></div>
properties (22)
authorbeerlover
permlinkre-arcange-hivesql-upate-20210508-20210508t123145008z
categoryhive-139531
json_metadata{"app":"beerlover/2.0"}
created2021-05-08 12:31:45
last_update2021-05-08 12:31:45
depth1
children0
last_payout2021-05-15 12:31:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length523
author_reputation24,770,396,872,031
root_title"HiveSQL Upate - New Blacklists and Mutes tables"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id103,571,047
net_rshares0
@pixresteemer · 
<center>![pixresteemer_incognito_angel_mini.png](https://files.peakd.com/file/peakd-hive/pixresteemer/8h7BBw1w-pixresteemer_incognito_angel_mini.png)</center><center>Bang, I did it again... I just rehived your post!</center><center>Week 56 of my [contest](/hive-179017/@pixresteemer/the-re-hive-contest-results-week-55-and-start-week-56) just started...you can now check the winners of the previous week!</center><center>!BEER</center><center><sub>5</sub></center>
properties (22)
authorpixresteemer
permlink20210508t123033323z
categoryhive-139531
json_metadata{"tags":["archon","pixresteemer"],"app":"pixresteemer"}
created2021-05-08 12:30:33
last_update2021-05-08 12:30:33
depth1
children0
last_payout2021-05-15 12:30:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length464
author_reputation121,071,247,750,144
root_title"HiveSQL Upate - New Blacklists and Mutes tables"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id103,571,025
net_rshares0
@shmoogleosukami · 
Nice upate. ;)
properties (22)
authorshmoogleosukami
permlinkre-arcange-qssqlt
categoryhive-139531
json_metadata{"tags":["hive-139531"],"app":"peakd/2021.04.5"}
created2021-05-08 16:17:57
last_update2021-05-08 16:17:57
depth1
children1
last_payout2021-05-15 16:17:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length14
author_reputation198,835,952,076,534
root_title"HiveSQL Upate - New Blacklists and Mutes tables"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id103,574,832
net_rshares0
@arcange · 
Thank you @shmoogleosukami<div class="pull-right"><a href="/@hive.engage">![](https://i.imgur.com/XsrNmcl.png)</a></div>
properties (22)
authorarcange
permlinkre-re-arcange-qssqlt
categoryhive-139531
json_metadata{"app":"engage"}
created2021-05-10 03:10:12
last_update2021-05-10 03:10:12
depth2
children0
last_payout2021-05-17 03:10:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length120
author_reputation1,065,065,779,136,773
root_title"HiveSQL Upate - New Blacklists and Mutes tables"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id103,603,228
net_rshares0
@steevc · 
That sounds useful to check for abusers. Already found some interesting data. Thanks
properties (22)
authorsteevc
permlinkre-arcange-qssi9z
categoryhive-139531
json_metadata{"tags":["hive-139531"],"app":"peakd/2021.04.5"}
created2021-05-08 13:18:00
last_update2021-05-08 13:18:00
depth1
children1
last_payout2021-05-15 13:18:00
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length84
author_reputation1,046,992,249,703,195
root_title"HiveSQL Upate - New Blacklists and Mutes tables"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id103,571,808
net_rshares0
@arcange ·
$0.07
> Already found some interesting data

Hehe, glad to read that
👍  
properties (23)
authorarcange
permlinkre-steevc-qsvfio
categoryhive-139531
json_metadata{"tags":["hive-139531"],"app":"peakd/2021.04.5"}
created2021-05-10 03:11:12
last_update2021-05-10 03:11:12
depth2
children0
last_payout2021-05-17 03:11:12
cashout_time1969-12-31 23:59:59
total_payout_value0.036 HBD
curator_payout_value0.037 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length62
author_reputation1,065,065,779,136,773
root_title"HiveSQL Upate - New Blacklists and Mutes tables"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id103,603,234
net_rshares158,226,922,432
author_curate_reward""
vote details (1)
@twistytango · 
What is the criteria for being added to the blocklist and in case one ends up there is there a place to appeal for removal?
properties (22)
authortwistytango
permlinkqssy4k
categoryhive-139531
json_metadata{"app":"hiveblog/0.1"}
created2021-05-08 19:00:27
last_update2021-05-08 19:00:27
depth1
children2
last_payout2021-05-15 19:00:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length123
author_reputation1,700,380,701,776
root_title"HiveSQL Upate - New Blacklists and Mutes tables"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id103,577,645
net_rshares0
@arcange · 
Everyone building their own list can decide on their own criteria. It may even be that it is not a blacklist but a whitelist.
If you find yourself on someone's list and you are concerned about it, the best thing to do is to contact the owner of the list.<div class="pull-right"><a href="/@hive.engage">![](https://i.imgur.com/XsrNmcl.png)</a></div>
properties (22)
authorarcange
permlinkre-qssy4k
categoryhive-139531
json_metadata{"app":"engage"}
created2021-05-10 03:17:15
last_update2021-05-10 03:17:15
depth2
children0
last_payout2021-05-17 03:17:15
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length348
author_reputation1,065,065,779,136,773
root_title"HiveSQL Upate - New Blacklists and Mutes tables"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id103,603,297
net_rshares0
@blocktrades · 
Each person makes up their own personal list (assuming they want to).
properties (22)
authorblocktrades
permlinkqst1eq
categoryhive-139531
json_metadata{"app":"hiveblog/0.1"}
created2021-05-08 20:11:15
last_update2021-05-08 20:11:15
depth2
children0
last_payout2021-05-15 20:11:15
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length69
author_reputation1,156,468,945,234,541
root_title"HiveSQL Upate - New Blacklists and Mutes tables"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id103,578,765
net_rshares0
Help/Feedback