Hivemind, a tool by Steemit inc., is a backend API service currently replace some of the endpoints of steemd
. It's in use for a good amount time.
I've been running a public Hivemind node, distributing daily database snapshots almost 9 months. There is also tower, a REST interface for Hivemind data, is developed and maintained by me, so far.
RPC and REST interfaces are just the tip of the iceberg since the underlying database -PostgreSQL- offers much more flexible queries. (Check some examples)
I want to offer read-only public accounts to query the Hivemind database. This requires new infrastructure planning. Can't offer public accounts on the master
PostgreSQL instance due to obvious reasons, I need new at least one or two replica instances where people can query and benefit the power of the Hivemind.
These come with additional development/maintenance/server costs. While I am happy to do that with my witness earnings, I already run a lot of dedicated servers.
Didn't really do the math, but probably get into a loss if we compare the costs with witness earnings. Here is my server list for STEEM related things:
- Two dedicated servers for witness
- One dedicated server for Hivemind
- One medium-sized virtual private server dPoll
- One small-sized virtual private server for scripts (witness backup failover, etc.)
TL;DR What will be delivered?
A reliable, fast, public SQL service (direct connection) of the Hivemind. I expect to deliver it before 2020. The plan is exposing Hivemind's database directly to the public with a good, old PostgreSQL user. (read-only)
Timeframe of the funding
1 year
Daily request amount of SBD
12 SBD
Q.A
- What will happen when the funding window is closed? Will you shut down the service?
1 year is a lot, I cannot promise anything at this time. But, worth to mention, I already served free public Hivemind node for 9 months, and I expect to keep this service is up as long as I can, financially.
- Will you cash out the funding instantly?
My plan is to power up the SBD, instantly after converting to STEEM. I will cover the server costs with fiat and don't create sell pressure on STEEM with the steem dao funds. However, this might change in upcoming months depending on the costs, my financial status, etc.
- Are you eligible for that kind of thing?
I am a software engineer with 10+ years of experience. Also, experienced with Python (the language powers Hivemind), and PostgreSQL. (My github account @emre might be a good indicator about what can I do.)
- What will be the outcome for community?
This is useful mostly for software developers, data people. Applications, dapps, reports can benefit this direct SQL access.
- Difference between SteemSQL?
SteemSQL is a general blockchain data service, while Hivemind only stores a partition of the blockchain data. Mostly social part like posts, accounts, votes, relationships (follow, ignore, resteem), etc. It's also planned to store communities
data at Hivemind.
Voting for the proposal
Vote via Steemconnect
Vote via steemproposals.com
You can view all the proposals on:
- https://steemproposals.com/proposals
- https://steemitwallet.com/proposals
- https://steempeak.com/proposals
If you have any questions or suggestions, shoot in the comments section.
I'm in ;)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@proxy.token supports your proposal !! I've already upvoted.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you, that's great news!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Güzel bi aksiyon Üstad, eline sağlık. Bütün oylar senin olsun.
Keşke yazılımcılardan parti kuran çıksa da siyasi oylarımızı da ona versek ;)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Tesekkurler Murat :-)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Selamun Aleyküm Katılıyorum sisteme yeni katildim ancak boyle basarili turk kardeslerimi az goruyorum birbirimize destek ciksak daha iyi olur diye düşünüyorum. Başarilarinin devamini dilerim.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Voted, what a great idea
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@organduo A good one to vote on. Will be helpful for our @untersatz witness activities.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Done...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
!SHADE 5
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@emrebeyler you have received
5 SHADE
from contrabourdon!View and trade the tokens on Steem Engine.
This tip bot is powered by witness untersatz!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
voted :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Please explain to the average guy like me who has no idea of what your saying
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Outcome of this project is that software developers, app owners, data people can have access to blockchain data via something called SQL.
SQL helps to query the data in a practical way in comparison to what we have in public resources.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
So you wanna implement it on Steemit?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Not sure if I understand the question :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Just curious how many people are using your hivemind? or how many services?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Didn’t check the numbers so far since it has a health check monitored and running flawlessly since its lunch.
Regarding apps, https://steemappsdb.com and https://steemproposals.com uses Tower. Also my recent tool https://flags.dpoll.xyz uses my hivemind db.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This would be awesome.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for the support 🎉
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
20.05 USD has been spent to promote this content using Steemium .
Learn more here!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for the reminder about tower.
I'd like to see a hive mind all db.
Posted using Partiko Android
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Then you should definitely vote for the proposal! :-)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Yes I should, you are right 😁
Posted using Partiko Android
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I have voted for your proposal.
What kind of hardware resources would I need if I wanted to run my own copy of Hivemind/Tower?
Thanks for all the hard work you do.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I would suggest a dedicated server with at least 16gb ram and 256gb SSD. For me, I run it at a box with 32 gb ram and nvme.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Your proposal is lacking... to 99% of us.
It seems to be a proposal written directly for developers... and maybe that's smart because maybe you're only here to get the votes of whales and developers but you could at least tell the rest of us why we'd care about SQL hivemind and how it will impact our day to day activities... or don't because our votes aren't gonna really get you anywhere and maybe you only care about the votes of those who know the value of this database you're talking about.
Anyway thought you may want to know what most of us think about these proposals. We want to go through and vote on stuff but then we see that the proposers just don't care to write a post directed at us. But then again they're all being done by developers and I mean that's not their strong suite i guess. So i mean I'm not castigating you (you're doing what you need to do) i'm just saying it just sucks for us.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That’s a good feedback, I’ll try to explain these stuff better if I create another proposal in the future.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You have only me to blame for bringing this post to the trending.
Sorry if the post didn't include an explanation for non-dev people.
To sum it up, This lower the barrier of entry for developers to start experimenting. I don't see it as subsidizing resources but more as a playground to later develop more serious stuff that won't depend on this service.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You got a 78.95% upvote from @minnowvotes courtesy of @steemium!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Is this similar to the @arcange database but for PostgreSQL?
Posted using Partiko iOS
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Yes, it will be the same except Hivemind doesn't store whole blockchain data like SteemSQL. Instead, it focuses on social aspects like votes, comments, posts, resteems, relationships. (ignore, follow, etc.)
In the future, communities data is also planned to store at Hivemind.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Sounds great! Looking forward to be one of the first to test :) You already have my witness vote and I will support this proposal.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks! 🎉
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
It is available with a subscription fee.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Post includes a Q/A section explains the main difference.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I run my own hivemind node as well as pay for SteemSQL access. I find that hivemind is often better for querying certain things as compared to SteemSQL.
In some cases, results come back faster in hivemind because of how the indices are arranged.
One of the major benefits of hivemind is how tags are tracked. If you’re doing content specific queries, it’s usually better to use hivemind.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I have used SteemSQL, it is awesome. However, it is not affordable for an average user, especially with the current Steem prices.
Building a free alternative for users and independent developers should be welcomed.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for the post.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I voted your proposal!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@tipu curate
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Upvoted 👌 (Mana: 0/30)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Support this!
Posted using Partiko iOS
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks! 🎉
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit