试用一下SteemData SBDS

in #cn3 years ago

想写这篇文章已经很久很久,久远到4个月之前SBDS上线。

之所以对这个SteemData SBDS特别感兴趣,是因为它使用的是MySQL——没错,我最最最最喜欢的数据库管理系统。如果这个MySQL数据库好用,再搭配世界上最好的语言PHP,那一定是令人极其愉悦的事情。

然而,这个数据库上线之初,我简单的测试了一下,被泼了一头冷水,为何?一切都很完美,连接上去,选择数据库,查询,返回结果,唯一令人遗憾的是,结果缺失严重。数据库数据库,缺失数据,那么对我们而言,几乎就没用了。

但是毕竟刚刚上线,有了Steemdata MongoDB的成功先例,我还是对这个MySQL满怀期待的,于是隔三差五我就登陆一下,看看有没有什么新变化。然而有段时间无法连接,有段时间数据库整个被清空。

直到上个月@furion 宣布:SteemData SBDS hosting is making a comeback

我上去连了一下,依然缺数据。但是那一时期,官方的第三方的节点总出问题,包括Steemdata MongoDB也各种缺数据,这个MySQL数据库不好用也情有可原。

继续等待继续试,直到 @furion 为数据库创建了新的私有RPC steemd节点
furion's new toy: A full RPC steemd node for SteemData

我很愉快地看到MongoDB 一切正常了,然而SteemData MySQL还是缺很多很多数据。

所以我这篇文章就一拖再拖,足足拖了4个月之久。

这几天又测试了几次,MySQL一如既往的缺数据,我想,等正常估摸要好久以后了,因为 @furion 正在搞view.ly 的ICO ,估摸没时间和精力搞SteemData SBDS。我把我之前做了一些测试在这里记录一下吧,以免几个月后,我都忘记了有SteemData SBDS 这么回事。


测试SteemData SBDS

前言有点啰嗦,步入正题:

SteemData SBDS 连接信息

https://steemdata.com/sbds

Host: mysql.steemdata.com
Port: 3306
Databases: sbds, hive
Username: steemit
Password: steemit

让我们链接一下试试

mysql -h sbds-mysql.steemdata.com -usteemit -psteemit -P 3306

成功连接。

来看看都有哪些数据库

show databases;

可以看到除了系统数据库以外还有sbdshive两个数据库

选择sbds

use sbds;

来看看都有哪些表

show tables;

来看看sbds_core_blocks这个表中记录的数量

SELECT count(block_num) FROM sbds_core_blocks;

而从steemd.com上我们可以查得,当前head_block_number:16,223,539
也就是说,SteemData SBDS 缺失了大致3/4的内容!!!!

再来看看延迟了多久

select block_num, timestamp from sbds_core_blocks order by timestamp DESC limit 10;

最新数据是3天以前的了,也就是说除了缺失还有超大延迟, 卖糕的,这还咋用。

将就试试吧,反正就是个测试

查一下我最近十条主题贴

select timestamp, author, title from sbds_tx_comments where author='oflyhigh' and parent_author='' order by timestamp DESC limit 10;

我晕,这得丢多少帖子啊,还好我的帖子都在区块链上好好活着呢,不然真的要哭了。

查查和 @deanliu 美女在网上的打情骂俏

select timestamp,body from sbds_tx_comments where author='deanliu' and parent_author='oflyhigh' limit 10;

select timestamp,body from sbds_tx_comments where author='oflyhigh' and parent_author='deanliu' limit 10;

可惜的是,那些时光一去不返,@deanliu 已经从美女变成了老太婆。

查查最早期的几个帖子

select author, timestamp, title from sbds_tx_comments where parent_author='' limit 10;

呃,看到A神的身影了。

其实最早的帖子应该是这个:
https://steemit.com/meta/@steemit/firstpost
发布于:2016-03-30 18:30:18
SteemData SBDS,竟然把最早的一个帖子都弄丢了,情何以堪啊。

好了,也没啥可以试的了。

结论

SteemData SBDS 的MySQL数据库,应该很好玩,应该有很多玩法。奈何缺数据、延迟大,目前看来,除了做做测试,没啥实际用途。至于那个HIVE更是糟糕

帮我把声望分调到25了,我能说啥啥?

好在SteemData MongoDB 安好,期待 @furion 有时间的时候能把sbds和hive完善一下吧。

他弄了这么多东西,也够辛苦的。大家手里还有见证人票的,不妨去投他一票,好让他有动力去改善sbds和hive 😀
投票地址:https://steemit.com/~witnesses

拖了4个月之久的文章,终于写完了,但愿有朝一日,SteemData SBDS变得可用吧。

Sort:  

我的投票代理给o哥很久了。哈哈。

哇咔咔,万分感激啊:)

剛投了他。

这个数据库确实是很无语呀

期望早日能用吧

哥,我看你发这个贴的感受是,我觉得你好像对它已经绝望了哈哈哈

大神都是这么厉害,能搞出这么多东西来,希望成立个团队搞这个数据库,MySQL熟悉的人比较多,我以前就学习过,用phpMyAdmin界面管理很方便,几乎不用写啥查询语句,可惜现在全忘光了。

相当厉害了

我刚试了,怪不得查不到自己,数据延迟和缺失的确太大了

Congratulations @oflyhigh, this post is the most rewarded post (based on pending payouts) in the last 12 hours written by a Hero account holder (accounts that hold between 10 and 100 Mega Vests). The total number of posts by Hero account holders during this period was 159 and the total pending payments to posts in this category was $3236.17. To see the full list of highest paid posts across all accounts categories, click here.

If you do not wish to receive these messages in future, please reply stop to this comment.

I read your article well. That's a lot of help to me. Thank you.

I really don't think that they should be focusing on making too many updates or improvements to SteemIt.com. Right now the whole Steem ecosystem is far too dependent on SteemIt.com as the only front-end as was evident from the recent DDOS events.

The idea behind the Steem platform is that any number of different front-end sites can be created on top of it. I think the SteemIt, Inc team should be focusing on creating tools, frameworks, etc to make it as easy as possible for others to create their own front ends to the Steem blockchain such as busy.org and chainbb.com.

When SMTs come out I think it would be great to not only have an easy way to create your own tokens, but also to have an easy way to launch your own front-end site using those tokens. If you create your own site on top of Steem then you can fix all of the "issues" you may see with SteemIt.com however you see fit. Then if others also like your changes they can switch to using your site.

This is where I think the real future of the Steem platform is - a whole series of different sites / communities etc built on top of the Steem blockchain, using their own tokens and SteemIt.com fading into the background.

Both sbds and hive are pre-production software, and have bugs preventing them to sync properly.

Thank you for your comment.
Hope sbds and hive can work soon. 😀

thanks for @oflyhigh , advise in cn-programming.
great work.
upvoted.

之前steemsql 有试过用但发现数据超过时的。跟 furion 反应过。 之后,steemsql 回复就没想这回事。

估计 furion 挺委屈 😭

怎么说?是贵人事忙吧。

follow me back

之前 PHP 连接 MSSQL真是各种麻烦,就没试成功过,这下有了MYSQL的可能就好多了

Thanks for your post

没数据、延迟大,这可能是数据库最致命的缺点了!

your airticle is just awsome

我的投票代理给o哥很久了。哈哈。

已經投了呢,有在為Steemit努力的都要支持

我眼花花((點藥水去 @@