Musing about my account creations using @hivesql

View this thread on: d.buzz | hive.blog | peakd.com | ecency.com
·@demotruk·
0.000 HBD
Musing about my account creations using @hivesql
Over the years on Hive I've created quite a few Hive accounts manually with my primary account @demotruk. Using @hivesql, I can see that it has been 83 in total.

![image.png](https://files.peakd.com/file/peakd-hive/demotruk/48KbB1CZwiLTj8EXqsob181bYdjGohGegaFwQXpRJPJeMpXSTYrXXNB5mRnUKaMniP.png)

>SELECT Count(DISTINCT new_account_name) FROM TxAccountCreates WHERE creator = 'demotruk'
>
>83

Reviewing the names, three categories emerge.

>SELECT new_account_name FROM TxAccountCreates WHERE creator = 'demotruk'

There are my own accounts, gift accounts for friends and family, and users I helped to onboard, generally on Hive Telegram.

Sadly, of the 83 created accounts, only 6 are still making transactions since Nov 1.

>SELECT Count(DISTINCT author) FROM TxComments JOIN TxAccountCreates ON author = new_account_name  WHERE TxAccountCreates.creator = 'demotruk' AND TxComments.timestamp > '2021-11-01 00:00:00.000'
>
>6

Of those, one is my own account and another is my wifes, so of the others only 4 are active, and none of the gift accounts are active.

>SELECT DISTINCT author FROM TxComments JOIN TxAccountCreates ON author = new_account_name  WHERE TxAccountCreates.creator = 'demotruk' AND TxComments.timestamp > '2021-11-01 00:00:00.000'
>
>@jianil90
>@lucieagboola
>@demotruktrade
>@ruscom
>@golodriga
>@yunnie

Of the 4 still recently active, they are still pretty new. 2 at least, @jianil90 and @ruscom are still working away trying to get started in the difficult social game that is Hive.

Of the less recently created accounts, not a single one is still active.

### Conclusion

It's hard to get going on Hive. Aside from creating the account itself and often a small Hive Power delegation, I didn't really help any of these users to get going. I see some groups of new users getting kick started straight to the front page (eg. the group from Cebu, Philippines, and many from Vietnam recently), but without the kind of camaraderie and/or assistance from established users, it is a struggle. Yet, objectively it is less difficult here to reach earnings than on other platforms based on simple numbers - it's a much smaller percentage of Youtube creators that even see a single penny, on the other hand the median payout on posts here is now above $2, ie. half of all posts make enough money to buy a can of coca cola.

My hope is that the apps themselves are worth sticking around for on Hive in the future, even if most users don't make a significant monetary return on the time they spend here.

👍 , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,