<center>https://i.imgsafe.org/77e5fc4a12.png</center> ### <center>Enjoy new features and performance improvement for your queries.</center> <br> SteemSQL is a public MS-SQL database with all the blockchain data in it. ##### Previous posts: * [Introduction post](https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data) * [SteemSQL - Update 1](https://steemit.com/steemit/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-1) * [SteemSQL - Update 2 - Language detection](https://steemit.com/steemit/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-new-language-detection) * [SteemSQL - Update 3](https://steemit.com/steemit/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update3) * [SteemSQL - Update 4](https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-2) * [SteemSQL - Update 5](https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-5) * [SteemSQL - Update 6](https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-6) * [SteemSQL - Update 7](https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-7) * [SteemSQL - Update 8](https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-8) * [SteemSQL - Update 9](https://steemit.com/steemsql/@arcange/steemsql-update-9-performances-improvement) # Whatβs new? Many people use SteemSQL to get information about followers or posts that have been resteemed. The problem is that these operations are not associated with a dedicated transaction, but are stored in the blockchain using `custom_json` transactions. In the SteemSQL database, You will find these transaction in the the `TxCustoms` table. Storing the details of a follow or reblog operation in a JSON string is pretty annoying because this requires deserializing the content of the JSON string before you can analyze its contents. Even if SQL server has JSON functions to perform such operation, queries are quite slow as the server has to process every row before being able to filter data. Unfortunately, it is not possible to create an index on values contained in the JSON string. Searching for followers or resteemed posts is all but efficient, especially when you know that the `TxCustoms` table contains almost 14 million records. But that's not all, the format of the JSON string for 'follow' operations has changed over time. This has to be taken into account when parsing the data and writing an efficient query quickly becomes cumbersome. Long story made short, it is really a mess when you want to analyze followers or reblogs! Fortunately, SteemSQL comes to the rescue with new features. ### The Followers and the Reblogs views Two new views have been created that will allow faster and easier analysis of followers and resteemed posts #### 1. The Followers view This is a very simple view, which contains only 2 columns: * `follower` : the name of the follower * `following` : the name of the followed user The Followers view is not a transaction view, meaning it does not expose historical data and does not allow to know when a user start or stop to follow another account. Knowing how many followers I have is now as simple as issuing a query like ``` SELECT COUNT(*) FROM Followers (NOLOCK) WHERE following = 'arcange' ``` #### 2. The Reblogs view This view is also very simple and contains the following columns: * `account` : the user who resteemed a post * `author` : the author of the resteemed post * `permlink` : the permlink of resteemed post * `timestamp` : when the post has been resteemed Knowing how many of my posts have been resteemed is now as simple as issuing a query like ``` SELECT COUNT(DISTINCT permlink) FROM Reblogs (NOLOCK) WHERE author = 'arcange' ``` ### Future performance improvements As more and more are using SteemSQL, I plan to continue my work on improving SteemSQL performances. However, I will first take some well deserved vacation. In the meantime, do not hesitate to send me your suggestions or comments. contact me in the dedicated SteemSQL channel on [steemit.chat](https://steemit.chat/channel/steemsql) or via Telegram (@VIM_Arcange) Thanks for reading. --- ##### <center>All payout from this post will be dedicated to keep SteemSQL running. </center> ##### <center>Thanks for your support.</center> --- <center>[](http://steemitboard.com/@arcange)</center> ###### <center>_footer created with **[steemitboard](steemitboard.com)** - click any award to see my board of honor_</center> ### <center>Support me and my work as a witness by voting for me [here!](https://steemit.com/~witnesses)</center> <center>http://i.cubeupload.com/dlkwkk.png</center> You Like this post, do not forget to **upvote** or **[follow me](https://steemit.com/@arcange)** or **resteem**
author | arcange |
---|---|
permlink | steemsql-update-10 |
category | steemsql |
json_metadata | {"tags":["steemsql","steemit","database","sql","programming"],"image":["https://i.imgsafe.org/77e5fc4a12.png","http://i.cubeupload.com/HbDjmH.png","http://i.cubeupload.com/dlkwkk.png"],"links":["https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data","https://steemit.com/steemit/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-1","https://steemit.com/steemit/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-new-language-detection","https://steemit.com/steemit/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update3","https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-2","https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-5","https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-6","https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-7","https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-8","https://steemit.com/steemsql/@arcange/steemsql-update-9-performances-improvement","https://steemit.chat/channel/steemsql","http://steemitboard.com/@arcange","steemitboard.com","https://steemit.com/~witnesses","https://steemit.com/@arcange"],"app":"steemit/0.1","format":"markdown"} |
created | 2017-08-07 18:07:33 |
last_update | 2017-08-07 18:08:27 |
depth | 0 |
children | 18 |
last_payout | 2017-08-14 18:07:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 82.948 HBD |
curator_payout_value | 22.672 HBD |
pending_payout_value | 0.000 HBD |
promoted | 1.000 HBD |
body_length | 5,050 |
author_reputation | 1,146,633,668,945,473 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,083,645 |
net_rshares | 28,519,425,808,414 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
proctologic | 0 | 3,848,157,847 | 2% | ||
fractalnode | 0 | 339,093,753,131 | 100% | ||
patrice | 0 | 52,920,163,244 | 100% | ||
ninzacode | 0 | 470,686,093,868 | 100% | ||
teamsteem | 0 | 16,142,889,921,426 | 100% | ||
writewords | 0 | 1,845,674,720 | 14% | ||
g-dubs | 0 | 4,542,588,054 | 7% | ||
lukestokes | 0 | 1,501,114,911,003 | 100% | ||
pmartynov | 0 | 519,588,540,184 | 100% | ||
michaellamden68 | 0 | 899,911,531 | 1% | ||
stompy | 0 | 51,033,748,008 | 100% | ||
roelandp | 0 | 4,190,374,094,418 | 100% | ||
joshbreslauer | 0 | 93,700,011,312 | 60% | ||
inertia | 0 | 1,017,366,977,673 | 100% | ||
arcange | 0 | 276,736,489,840 | 100% | ||
heimindanger | 0 | 111,221,237,976 | 100% | ||
raphaelle | 0 | 50,294,624,498 | 100% | ||
yogi | 0 | 60,289,899,039 | 100% | ||
team-leibniz | 0 | 73,422,769,633 | 75% | ||
ace108 | 0 | 86,730,978,819 | 5% | ||
dez1337 | 0 | 27,671,615,392 | 49% | ||
letc | 0 | 365,289,707 | 10% | ||
sc-steemit | 0 | 7,860,780,202 | 15% | ||
canadian-coconut | 0 | 2,237,967,991,414 | 15% | ||
profitgenerator | 0 | 14,472,713,941 | 100% | ||
teamhumble | 0 | 6,255,604,795 | 20% | ||
leongkhan | 0 | 185,634,057,184 | 75% | ||
aleturen | 0 | 1,106,397,978 | 100% | ||
darth-azrael | 0 | 4,438,835,801 | 13% | ||
nomadsteem | 0 | 14,530,699,159 | 100% | ||
ades | 0 | 11,225,186,174 | 100% | ||
dimitrisp | 0 | 10,394,096,967 | 100% | ||
darth-cryptic | 0 | 794,912,655 | 13% | ||
radiv | 0 | 10,551,551,583 | 100% | ||
lances | 0 | 80,909,410,192 | 100% | ||
kanedizzle08 | 0 | 67,620,334,668 | 100% | ||
cybertiger | 0 | 250,535,610 | 100% | ||
olegst | 0 | 26,455,699,303 | 50% | ||
oneshot | 0 | 5,940,083,294 | 100% | ||
maryfavour | 0 | 35,623,571,359 | 17% | ||
marteta | 0 | 2,582,001,062 | 100% | ||
fityan | 0 | 0 | 100% | ||
andrianna | 0 | 17,421,759,411 | 100% | ||
bibek | 0 | 2,272,214,697 | 100% | ||
hammadakhtar | 0 | 954,776,189 | 10% | ||
gordonovich | 0 | 837,175,071 | 5% | ||
riott | 0 | 420,632,571,745 | 100% | ||
marcusxman | 0 | 424,563,474 | 1% | ||
xubadom | 0 | 690,511,342 | 100% | ||
sv67216721 | 0 | 3,910,034,673 | 5% | ||
sacred-agent | 0 | 10,438,483,093 | 11% | ||
greenacrehome | 0 | 20,713,238,144 | 100% | ||
me-do | 0 | 2,774,930,187 | 15% | ||
forykw | 0 | 41,125,387,967 | 100% | ||
emble | 0 | 2,280,293,047 | 100% | ||
oroger | 0 | 6,066,549,717 | 100% | ||
woosungchoi | 0 | 3,155,573,717 | 1% | ||
drakkomaximo1234 | 0 | 2,552,779,861 | 100% | ||
amirl | 0 | 3,462,877,337 | 9% | ||
artedellavita | 0 | 967,129,695 | 100% | ||
smart3dweb | 0 | 0 | 100% | ||
liudasbutkus | 0 | 1,228,049,664 | 100% | ||
dehenne | 0 | 19,495,491,499 | 100% | ||
coco357i | 0 | 2,833,527,051 | 100% | ||
paulag | 0 | 9,326,197,287 | 100% | ||
novale | 0 | 4,144,134,387 | 100% | ||
evolved08gsr | 0 | 3,335,644,700 | 100% | ||
steppingout23 | 0 | 21,208,381,679 | 4% | ||
polaleye50 | 0 | 1,159,208,114 | 100% | ||
redfishpillar | 0 | 3,534,710,400 | 100% | ||
bastomi27 | 0 | 50,427,194 | 13% | ||
promoted | 0 | 94,278,051,243 | 3.34% | ||
lukakorba | 0 | 3,338,770,056 | 100% | ||
woz.software | 0 | 4,763,769,293 | 100% | ||
mister-futurist | 0 | 138,702,057 | 100% | ||
gossipmill | 0 | 1,751,464,818 | 100% | ||
daniel007 | 0 | 0 | 100% | ||
jackyx2clic | 0 | 106,222,464 | 100% | ||
ramzialhaddadtm | 0 | 428,466,617 | 100% | ||
daneftaly | 0 | 415,425,285 | 100% | ||
a1n21t | 0 | 578,279,626 | 100% | ||
jcgoez | 0 | 1,438,307,499 | 100% | ||
iarumas | 0 | 647,768,819 | 100% | ||
elfaisal | 0 | 496,892,144 | 100% | ||
hamet123 | 0 | 119,149,475 | 100% | ||
techybear | 0 | 548,275,200 | 100% | ||
revo | 0 | 658,050,954 | 100% | ||
rahmi | 0 | 455,114,041 | 100% | ||
davor27 | 0 | 358,339,349 | 100% | ||
dillibabu | 0 | 98,655,468 | 100% | ||
waffledough | 0 | 557,568,000 | 100% | ||
marnee | 0 | 0 | 100% | ||
utpoldebnath | 0 | 0 | 100% | ||
farukcom | 0 | 0 | 100% | ||
hojaraskita | 0 | 0 | 100% | ||
jap60 | 0 | 0 | 100% | ||
mycryptow | 0 | 0 | 100% | ||
horlly | 0 | 0 | 100% | ||
saumyabratadutt | 0 | 0 | 100% | ||
jain | 0 | 0 | 100% | ||
uccdoc | 0 | 0 | 100% | ||
noralynasuncion | 0 | 0 | 100% | ||
qadri.mag | 0 | 0 | 100% | ||
qanon1111 | 0 | 0 | 100% | ||
abgaryhabibi | 0 | 0 | 100% | ||
deman | 0 | 0 | 100% | ||
fauzanlexa | 0 | 0 | 100% | ||
nine-gags | 0 | 0 | 100% |
thats nice work.
author | amanjain2k |
---|---|
permlink | re-arcange-steemsql-update-10-20170807t194614127z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2017-08-07 19:46:15 |
last_update | 2017-08-07 19:46:15 |
depth | 1 |
children | 0 |
last_payout | 2017-08-14 19:46:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.048 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 16 |
author_reputation | 3,335,258,446,767 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,092,180 |
net_rshares | 13,193,731,286 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
smart3dweb | 0 | 0 | 100% | ||
amanjain2k | 0 | 13,193,731,286 | 100% | ||
horlly | 0 | 0 | 100% |
Do you have the logic you used to generate the follow/following logic? I was about to start working on that code and am curious if you did the same method I was going to use or if you used another method. Thanks!
author | evolved08gsr |
---|---|
permlink | re-arcange-steemsql-update-10-20170807t181200940z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2017-08-07 18:12:00 |
last_update | 2017-08-07 18:12:00 |
depth | 1 |
children | 0 |
last_payout | 2017-08-14 18:12:00 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 213 |
author_reputation | 4,411,583,250,238 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,084,020 |
net_rshares | 0 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
smart3dweb | 0 | 0 | 100% |
you are correct about some people use SteemSQL to get information about followers or posts that have been resteemed. as we know There is a problem these operations are not associated with a dedicated transaction . Congratulation & 
author | farukcom |
---|---|
permlink | re-arcange-steemsql-update-10-20171108t130144512z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"image":["https://steemitimages.com/DQmZPwSR3PAs2roRszbfr4oceGDjWUhyrLjwKRF3wQqirf3/thank-you-.jpg"],"app":"steemit/0.1"} |
created | 2017-11-08 13:01:48 |
last_update | 2017-11-08 13:01:48 |
depth | 1 |
children | 0 |
last_payout | 2017-11-15 13:01:48 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 342 |
author_reputation | 32,897,128,085,525 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 19,779,486 |
net_rshares | 0 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
fauzanlexa | 0 | 0 | 100% |
Mantap that lagenyan
author | fauzanlexa |
---|---|
permlink | re-arcange-steemsql-update-10-20180609t173803126z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2018-06-09 17:38:06 |
last_update | 2018-06-09 17:38:06 |
depth | 1 |
children | 0 |
last_payout | 2018-06-16 17:38:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 20 |
author_reputation | 277,045,670 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 60,024,208 |
net_rshares | 64,020,625 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
fauzanlexa | 0 | 64,020,625 | 100% |
Hi there @arcange, tell me something is it me or have you shifted your choice of colour for the steemit reward plaques from bllue to green ??
author | gomeravibz |
---|---|
permlink | re-arcange-steemsql-update-10-20171103t233536261z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"users":["arcange"],"app":"steemit/0.1"} |
created | 2017-11-03 23:35:36 |
last_update | 2017-11-03 23:35:36 |
depth | 1 |
children | 0 |
last_payout | 2017-11-10 23:35:36 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 141 |
author_reputation | 53,218,725,520,811 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 19,391,072 |
net_rshares | 0 |
As a SteemSQL user, thank you again for this and keeping with updating us on it, too!
author | greenacrehome |
---|---|
permlink | re-arcange-steemsql-update-10-20170807t183331916z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2017-08-07 18:33:30 |
last_update | 2017-08-07 18:33:30 |
depth | 1 |
children | 0 |
last_payout | 2017-08-14 18:33:30 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 85 |
author_reputation | 5,550,811,725,482 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,085,876 |
net_rshares | 0 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
smart3dweb | 0 | 0 | 100% |
A nice and cool post ,a good writer of a good articles that cool more of these from you ,...you can also comment ,upvote and follow my posts @horlly..
author | horlly |
---|---|
permlink | re-arcange-steemsql-update-10-20171220t162335656z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"users":["horlly"],"app":"steemit/0.1"} |
created | 2017-12-20 16:24:15 |
last_update | 2017-12-20 16:24:15 |
depth | 1 |
children | 0 |
last_payout | 2017-12-27 16:24:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 150 |
author_reputation | 1,105,467,232 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 24,375,479 |
net_rshares | 145,063,781 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
smart3dweb | 0 | 0 | 100% | ||
horlly | 0 | 145,063,781 | 100% | ||
fauzanlexa | 0 | 0 | 100% |
nice post I follow you, please follow me. I'll upvote to all of your posts and hope you will
author | hottipsbd |
---|---|
permlink | re-arcange-steemsql-update-10-20170813t091920814z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2017-08-13 09:19:24 |
last_update | 2017-08-13 09:19:24 |
depth | 1 |
children | 0 |
last_payout | 2017-08-20 09:19:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 96 |
author_reputation | 2,829,054,498 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,672,310 |
net_rshares | 0 |
Is there a PHPmyadmin GUI available?
author | liudasbutkus |
---|---|
permlink | re-arcange-steemsql-update-10-20170807t183648499z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2017-08-07 18:36:54 |
last_update | 2017-08-07 18:36:54 |
depth | 1 |
children | 0 |
last_payout | 2017-08-14 18:36:54 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 36 |
author_reputation | 1,093,333,067,528 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,086,171 |
net_rshares | 0 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
fauzanlexa | 0 | 0 | 100% |
Bereh postingan lage Nyoe I like
author | muhajirnyakcut |
---|---|
permlink | re-arcange-steemsql-update-10-20170807t185226530z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2017-08-07 18:52:36 |
last_update | 2017-08-07 18:52:36 |
depth | 1 |
children | 0 |
last_payout | 2017-08-14 18:52:36 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 32 |
author_reputation | 193,360,099,051 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,087,520 |
net_rshares | 0 |
brill, thank you. I have been able to work with the json using powerbi but this make things a lot simpler for me now
author | paulag |
---|---|
permlink | re-arcange-steemsql-update-10-20170807t212628033z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2017-08-07 21:26:27 |
last_update | 2017-08-07 21:26:27 |
depth | 1 |
children | 0 |
last_payout | 2017-08-14 21:26:27 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 117 |
author_reputation | 274,264,287,951,003 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,102,916 |
net_rshares | 0 |
Great post, thanks for sharing, regards
author | rindi118 |
---|---|
permlink | re-arcange-steemsql-update-10-20170807t194535288z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2017-08-07 19:45:42 |
last_update | 2017-08-07 19:45:42 |
depth | 1 |
children | 0 |
last_payout | 2017-08-14 19:45:42 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 39 |
author_reputation | 393,894,096,212 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,092,127 |
net_rshares | 0 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
smart3dweb | 0 | 0 | 100% |
cool, you make some bad ass stuff! :)
author | teamhumble |
---|---|
permlink | re-arcange-steemsql-update-10-20170807t181752303z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2017-08-07 18:17:51 |
last_update | 2017-08-07 18:17:51 |
depth | 1 |
children | 1 |
last_payout | 2017-08-14 18:17:51 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 37 |
author_reputation | 315,232,864,758,316 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,084,515 |
net_rshares | 0 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
smart3dweb | 0 | 0 | 100% | ||
fauzanlexa | 0 | 0 | 100% |
Thanks
author | arcange |
---|---|
permlink | re-teamhumble-re-arcange-steemsql-update-10-20170807t211530896z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2017-08-07 21:15:33 |
last_update | 2017-08-07 21:15:33 |
depth | 2 |
children | 0 |
last_payout | 2017-08-14 21:15:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 6 |
author_reputation | 1,146,633,668,945,473 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,102,092 |
net_rshares | 0 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
smart3dweb | 0 | 0 | 100% | ||
fauzanlexa | 0 | 0 | 100% |
Thanks for this Database. Great work! Resteemed and voted.
author | techybear |
---|---|
permlink | re-arcange-steemsql-update-10-20170807t183753324z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2017-08-07 18:37:54 |
last_update | 2017-08-07 20:19:54 |
depth | 1 |
children | 1 |
last_payout | 2017-08-14 18:37:54 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.050 HBD |
curator_payout_value | 0.014 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 59 |
author_reputation | 12,922,993,911 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,086,259 |
net_rshares | 17,703,243,010 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
arcange | 0 | 14,959,899,856 | 5% | ||
raphaelle | 0 | 2,743,343,154 | 5% | ||
smart3dweb | 0 | 0 | 100% | ||
horlly | 0 | 0 | 100% |
Thank you ; )
author | arcange |
---|---|
permlink | re-techybear-re-arcange-steemsql-update-10-20170807t211453202z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2017-08-07 21:14:54 |
last_update | 2017-08-07 21:14:54 |
depth | 2 |
children | 0 |
last_payout | 2017-08-14 21:14:54 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 14 |
author_reputation | 1,146,633,668,945,473 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,102,045 |
net_rshares | 0 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
smart3dweb | 0 | 0 | 100% |
Cool! I'm learning SQL just to be able to make some stats :) Needless to say I'm very happy with your SteemSQL.
author | yogi |
---|---|
permlink | re-arcange-steemsql-update-10-20170807t191252738z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"app":"steemit/0.1"} |
created | 2017-08-07 19:12:51 |
last_update | 2017-08-07 19:12:51 |
depth | 1 |
children | 1 |
last_payout | 2017-08-14 19:12:51 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.184 HBD |
curator_payout_value | 0.061 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 112 |
author_reputation | 24,631,816,177,191 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 11,089,341 |
net_rshares | 66,839,736,146 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
yogi | 0 | 66,839,736,146 | 98% | ||
horlly | 0 | 0 | 100% |
What a nice,cool and interesting post,i will like to see more of this you can also follow ,comment and upvote @horlly
author | horlly |
---|---|
permlink | re-yogi-re-arcange-steemsql-update-10-20171220t162053629z |
category | steemsql |
json_metadata | {"tags":["steemsql"],"users":["horlly"],"app":"steemit/0.1"} |
created | 2017-12-20 16:21:03 |
last_update | 2017-12-20 16:21:03 |
depth | 2 |
children | 0 |
last_payout | 2017-12-27 16:21:03 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 117 |
author_reputation | 1,105,467,232 |
root_title | "STEEMSQL - Update 10 - New features and performances" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 24,375,030 |
net_rshares | 156,668,884 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
smart3dweb | 0 | 0 | 100% | ||
horlly | 0 | 156,668,884 | 100% |