+-+-+ +-+ +-+-+-+-+
|G|O| |4| |H|I|V|E|
+-+-+ +-+ +-+-+-+-+

 --- A GOPHER-LIKE INTERFACE FOR HIVE BLOCKCHAIN ---

HiveSQL Upate - New Blacklists and Mutes tables

BY: @arcange | CREATED: May 8, 2021, 12:20 p.m. | VOTES: 187 | PAYOUT: $31.53 | [ VOTE ]

[IMAGE: https://i.imgur.com/FE9D32t.png]

The concept of decentralized blacklists and mutes lists 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.

Thank you for reading.

Let's keep HiveSQL free to use - Support its proposals!
|HiveSQL|HiveBuzz|
|-|-|
|Vote for the proposal on PeakDVote for the proposal on EcencyVote for the proposal using HiveSigner|Vote for the proposal on PeakDVote for the proposal on EcencyVote for the proposal using HiveSigner|

Check out my apps and services

Vote for me as a witness [IMAGE: https://i.imgur.com/2bi4SnT.png]

TAGS: [ #HiveDevs ] [ #hivesql ] [ #hive ] [ #sql ] [ #database ] [ #maintenance ]

Replies

@pixresteemer | May 8, 2021, 12:30 p.m. | Votes: 0 | [ VOTE ]

[IMAGE: https://files.peakd.com/file/peakd-hive/pixresteemer/8h7BBw1w-pixresteemer_incognito_angel_mini.png]Bang, I did it again... I just rehived your post!Week 56 of my contest just started...you can now check the winners of the previous week!!BEER5

@beerlover | May 8, 2021, 12:31 p.m. | Votes: 0 | [ VOTE ]

https://files.peakd.com/file/peakd-hive/beerlover/yiuU6bdf-beerlover20gives20BEER.gif
View or trade BEER.
Hey @arcange, here is a little bit of BEER from @pixresteemer for you. Enjoy it!
Learn how to earn FREE BEER each day by staking your BEER.

@steevc | May 8, 2021, 1:18 p.m. | Votes: 0 | [ VOTE ]

That sounds useful to check for abusers. Already found some interesting data. Thanks

@arcange | May 10, 2021, 3:11 a.m. | Votes: 1 | [ VOTE ]

> Already found some interesting data

Hehe, glad to read that

@shmoogleosukami | May 8, 2021, 4:17 p.m. | Votes: 0 | [ VOTE ]

Nice upate. ;)

@arcange | May 10, 2021, 3:10 a.m. | Votes: 0 | [ VOTE ]

Thank you @shmoogleosukami[IMAGE: https://i.imgur.com/XsrNmcl.png]

@twistytango | May 8, 2021, 7 p.m. | Votes: 0 | [ VOTE ]

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?

@blocktrades | May 8, 2021, 8:11 p.m. | Votes: 0 | [ VOTE ]

Each person makes up their own personal list (assuming they want to).

@arcange | May 10, 2021, 3:17 a.m. | Votes: 0 | [ VOTE ]

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.[IMAGE: https://i.imgur.com/XsrNmcl.png]

[ BACK TO TRENDING ] [ BACK TO MENU ]
CMD>