[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data
8 years ago by arcange (73)
$395.25
- Past Payouts $395.25
- - Author $297.09
- - Curators $98.16
307 votes
- + ned: $189.170 (60%)
- + steempty: $37.923 (100%)
- + abit: $33.768 (100%)
- + fuzzyvest: $31.186 (100%)
- + silversteem: $19.600 (100%)
- + lafona-miner: $14.792 (100%)
- + silver: $8.275 (100%)
- + laonie: $5.999 (100%)
- + gavvet: $5.954 (100%)
- + delegate.lafona: $5.309 (100%)
- + ihashfury: $5.260 (100%)
- + pfunk: $3.834 (100%)
- + publicworker: $3.316 (100%)
- + satoshifund: $2.968 (16%)
- + yan-kovalenko: $2.658 (100%)
- + lafona: $2.306 (100%)
- + officialfuzzy: $2.137 (100%)
- + lafona5: $1.489 (100%)
- + jesta: $1.355 (100%)
- + lukestokes: $1.346 (100%)
- … and 287 more
the steemit account looks suspended, the service is no longer available?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
it has moved to a monthly subscription model.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
hi @arcange,
Is this database still working ?
If yes Then I am not able to connect to server using Sql server management studio.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I am able to connect just fine.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
The database here is not responding!! I'm trying to connect to it from Java code and it says "Communication link failure". Also from comand line I run a ping and none of the packets come back!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Why MS SQL server, and not something more open like MySQL or PostgreSQL?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
The fact the server behind is open or not does not matter to me.
The server itself is not open, only the data in it.
What's important is to have the required skills to manage it (including its security)and have it available to users's requests.
You're free to build your own if you really want an open source server.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
How did you populate the database to begin with? If you're using the RPC mechanism, after 30 days some data is no longer returned. For example,
active_votesis empty for all posts after their second payout. You can even see this on steemit.com where old posts have zero upvotes.Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
All votes are in transactions and stored in the TxVotes table, even first votes ever :
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@arcange
this is severely underrated. gave you my full blown 100%. we need this.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you !
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is pretty good. I've been trying a few queries, sometimes taking a while. Would you consider adding some indexes on a few 'key' fields, or do you want to keep it like that ?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Post you queries in steemsql channel
I will analyze them and see how to improve DB design/performances
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
the differences between the graph database and the monolithinc, intransient relational database takes some compilation of data, and new blocks alter records, in ways that can be difficult to adapt, such as if a poster makes a really big edit, and suddenly the datatype has been overflowed.
But I think this is a cool idea. It might make a model for moving from a memory heavy graphene database to a storage heavy sql, maybe some sort of hybrid to cache data for faster retrieval or so.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
SteemSQL database is a replica of the whole blockchain, not a compilation!
This mean if a user edit a post, you will find 2 or more transactions in TxComments with the same author/permlink but with different bodies/titles.
Compilation of data is made at query time.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Ah. So it's just another implementation of the graph database protocol, layered on top of a relational database.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This isn't a graph database at all, unless I am somehow mistaken.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
No, it however has to implement one to allow the diff-updates that the platform allows, which essentially is a graph database (like CVS or Git). It just gives you the ability to search using SQL queries which are very concise and neat and easy to write, and with that pull all kinds of higher level data out of it. I think that was the purpose of building it - to allow more people to tinker with analytics.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Seriously, Doesn't this defeat the purpose of decentralization?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Why its defeat decentralization?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
No. The essence of data analysis is collecting (aggregating ) data and making meaningful insights from it, which requires centralization by rule. The decentralized nature of the data isn't in jeopardy here because there are still unlimited copies of the Steemit blockchain out there ensuring that there is no vulnerable, mutable, single-source of the truth. This particular copy just happens to facilitate reporting.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thankyou heaps for doing this!
I have a heap of ideas for queries but I've been trying to avoid the overhead of running my own full node - this is a far more efficient way to do it :)
I'll be following, great work
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That's exactly the purpose of it: having an efficient alternative to local nodes.
Thanks!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
As soon as I have some time I will use your steemit database because I am a data fanatic. Thank you for making this available. I am following you now.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks!
I will closely monitor server as I made it a bit quick and dirty. I will now work on tweaking it for best performances
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
SQL Server is great - thank you very much for providing this!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You're welcome.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That's nice of you to make this available. hopefully you won't get flooded with requests that the resources requirements will require too much of an overhead :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That could be, as for every service made public. But worth to experiment as it will be a good test for the infrastructure. This one is scaled for a normal usage.
The risk is indeed have bad response time if the load is to heavy. Then people writing poor queries might go away as they won't get correct response time.
Anyway, I will do my best to educate users on how to perform efficient queries.
Future will tell.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Argh!!!! I was just trying to build one of these!
I'm not sure whether to be upset I spent 2 days trying to make it work or ecstatic that whatever guided me, guided you there first.
Eitherway, I'm glad you did this, but super jealous you managed to pull it off faster than I could :)
Congratulations though, you earned my upvote. I'm following you now too!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I would have been super jealous too if you did it before me ;)
Everything was ready 2 weeks ago, but I wanted to fine tune and check every bit and byte of the infrastructure before releasing it. No worth to publish something if user experience is disappointing.
Many thanks for your support !
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Cool!
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
This is a really great thing you have going here! Kudos for setting up a public node and service for the community. I sincerely believe this post should be upvoted like crazy and end with 3 or 4 figures. This does deserve more notice and appreciation. But from me, you've my upvote and follow. Thank you.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for your support!
The load is low at the moment but I already received lot of positive feedback of people wanting to use it.
I also wish I could get a few reward for this, not to become rich but to be able to put the server on a dedicated infrastructure with HA and DRS and ensure the best service to the community.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hi, I can't connect using SSMS, do you use default port? (1433)
Ping to server is not responding, I'm not sure if i'm doing something wrong :(
Thanks for sharing!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
SteemSQL has moved to a monthly subscription model and the default free account/password “steemit/steemit” has been disabled.
You will find more information about the subscription process here
Please visit steemsql.com for more information.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Here’s a sad scene for you. About 4 people have read this post I made about 3 days ago: “Can you supply some block-chain data for payment?”. Your post suggests that there must be or than 20 people in the community who might have been alerted to my post, and some would have promptly sent me to your service, which clearly needs to be well supported.
New Steemit posts disappear into ‘ether’ 20 minutes, and will turn up on peoples’ Feeds only if they are Following the author!
Anyway, I will be trying to use your service soon, and pay suitably. I am experienced programmer; but have not bothered to learn Python and only occasionally use SQL (inside SAS). I will come back when I have done the needed studying.
Cheers!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
http://steemsql.com/ is not working?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Haven't noticed any problem.
Please use steemsql channel on steemit.chat for help or support
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Just clicked on the link: http://steemsql.com/ , I got this:
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
The link in your first reply works.
The link in your last reply is broken (redirect to "http://steemsql.com/," with a coma at the end)
It is useless to check "http://steemsql.com" website ATM as it redirect to this post
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Still not working for me. No, it doesn't redirect to this post. Anyone else please check? http://steemsql.com/
By the way the comma is a known old issue of steemit.com related to link parsing. It's off-topic though.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is awesome! Thank you for your effort.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Doesn't this defeat the purpose of decentralization? If there is a central database with all the information on the blockchain, then wouldn't that create a vulnerability?
This would be better if the database itself was decentralized... I think I'll code one like this. Thank you for your information! :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you so much for hosting this! You are my hero! Successfully connected and doing some poking around in the data for fun tonight :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I'm late to the party but I am excited about this as I am learning SQL at work and would love to use that knowledge to understand Steemit better and contribute to the community with that knowledge.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Do not hesitate to contact me on steemit.chat if you need any help to create amazing SQL queries.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you, kindly.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
hey, I'm playing with it right now. how I can I see the full architecture of the database?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
All tables and their relation are shown in the database diagram in this post.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I thought there was another way as well
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
If you need help or have any request, please join steemsql channel on steemit.chat
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Here’s a sad scene for you. About 4 people have read this post I made about 3 days ago: “Can you supply some block-chain data for payment?”. Your post suggests that there must be or than 20 people in the community who might have been alerted to my post, and some would have promptly sent me to your service, which clearly needs to be well supported.
New Steemit posts disappear into ‘ether’ 20 minutes, and will turn up on peoples’ Feeds only if they are Following the author!
Anyway, I will be trying to use your service soon, and pay suitably. I am experienced programmer; but have not bothered to learn Python and only occasionally use SQL (inside SAS). I will come back when I have done the needed studying.
Cheers!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is good. Although I like something like PhpMyAdmin more.
What hardware is your service running on? I'm curious about the scalability.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
The server on a Intel Xeon E5-1650 v2 3.5Ghz 6 cores with 64GB memory, 8TB storage with MegaRAID 9271 Cache 1Go + CacheVault. It can be moved to a VMware HA cluster if required.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Sounds great.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Amazing. Glad to found this post. Thank you for providing the infrastructure. I have accessed it and it works well
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hi @arcange. Is this sever offline or no longer available?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is way freaking cool. Man, I fall behind on #dev in steemit.chat by just a couple days and miss amazing gems like this. Well done!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks ! Hopefully it will be useful to you.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I'm at RESTfest today, and I'm contemplating building a REST interface for the db as part of the hack day today... Hmmmm...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Best of luck! Waiting for any feedback.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Unfortunately, I wasn't able to get my local php connecting to mssql. :(
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit