Connecting to the SteemSQL database via R by verodato

View this thread on: hive.blog | peakd.com | ecency.com

cryptocurrency · @verodato · Jun 9 '18

$263.00

Connecting to the SteemSQL database via R

![](https://cdn.steemitimages.com/DQmZVSnnRjPEkgZzQVtoEFokRmUEQBYTDdvxfNbHuvvDYz3/image.png)

As discussed in the previous post (https://busy.org/@verodato/steem-blockchain-the-forest-and-the-trees), we’re going to use the SteemSQL service to get the Steem blockchain data. The connection to the database will be made using the R software (https://www.r-project.org/). It’s a widely used open source statics and programming language and environment. Remember to download the free version of the RStudio editor if it is your first time trying R (https://www.rstudio.com/). You’ll need to install the RJDBC package too. 

The R code to connect to the SQL server is the following (“user” and “password” are supplied by the SteemSQL service upon payment):

````
    require(RJDBC)
    drv <- JDBC("net.sourceforge.jtds.jdbc.Driver",
             "/home/user/Downloads/jtds-1.2.8-dist/jtds-1.2.8.jar") 
    conn <- dbConnect(drv, "jdbc:jtds:sqlserver://vip.steemsql.com;DatabaseName=DBSteem", domain="windows domain", user="username", password="userpassword")
````

Once connected, we can make a query, for example, to check what is the total number of accounts in the Steem blockchain:

````
    sqltxt <- "SELECT COUNT(ID) FROM Accounts"
    dbGetQuery(conn, sqltxt)
````

That’s it! Quite easy (if you had no trouble installing stuff). In the next post we’ll see how to get Steem delegation data and how to calculate time series from it. If you have any doubt about installing R, R packages, RStudio, MS drive, put it in the comments below and I’ll try to help you.

👍 upme, booster, promobot, buildawhale, therising, rocky1, postpromoter, appreciator, upmewhale, verodato, boxmining, g-dubs, maxbullion, oregonpop, reko, icedrum, grey580, rest100, dickdeepdog, mrslauren, vannfrik, crypto2day, wilbur, drakmin, frontrunner, steemcollator, tonimarco, decebal2dac, jguzman394, natra, outerground, minnowpond, kralizec, fiveboringgames, arcange, joklahoma, vizualsamuri, belgarath, agoric.systems, eaglespirit, cifer, agr8buzz, jimjam1210, ant884, derkon, deemarshall, curiositybot, lawyerup, emas-jiujitsu, battlemountain2k, bjjworldtraveler, mikegun, pravda, blessing786, andrecarothers, forever-gala, mrright, itchykitten, cryptoclick, eileenbeach, ladyrednails, treebuilder, realcodysimon, treasuregnome, and 228 others

`author`	verodato
`permlink`	connecting-to-the-steemsql-database-via-r
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency","blockchain","steem","finance","investing"],"image":["https://cdn.steemitimages.com/DQmZVSnnRjPEkgZzQVtoEFokRmUEQBYTDdvxfNbHuvvDYz3/image.png"],"links":["https://busy.org/@verodato/steem-blockchain-the-forest-and-the-trees","https://www.r-project.org/","https://www.rstudio.com/"],"app":"steemit/0.1","format":"markdown"}
`created`	2018-06-09 17:13:12
`last_update`	2018-06-09 17:13:12
`depth`	0
`children`	10
`last_payout`	2018-06-16 17:13:12
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	205.938 HBD
`curator_payout_value`	57.058 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,563
`author_reputation`	18,143,558,301,797
`root_title`	"Connecting to the SteemSQL database via R"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	60,021,092
`net_rshares`	98,534,056,389,150
`author_curate_reward`	""

properties (23)vote details (292)

voter	rshares	pct
framelalife	2,149,008,521	37.73%
g-dubs	122,460,940,384	37.73%
tim-rumford	147,874,621	37.73%
grey580	33,798,106,174	37.73%
cmtzco	296,599,217	3%
biglipsmama	1,196,110,624	37.73%
arcange	13,026,793,673	2%
fiveboringgames	13,645,317,098	37.73%
desmonid	505,311,940	3%
cryptohustlin	1,058,593,434	3%
raphaelle	958,726,615	2%
jasonmiller2134	165,316,956	37.73%
transhuman	3,879,164,109	37.73%
bofadeez	133,809,480	3%
zentat	183,231,656	37.73%
sethlinson	852,651,210	37.73%
eileenbeach	4,725,285,546	3%
jimjam1210	8,751,489,378	37.73%
kralizec	13,847,682,157	37.73%
dickdeepdog	22,447,541,020	37.73%
royrodgers	119,349,924	3%
forever-gala	5,476,120,741	37.73%
drakmin	17,007,178,058	37.73%
geggi632	109,171,917	37.73%
decebal2dac	14,619,206,414	37.73%
sqube	1,203,800,162	37.73%
steemcollator	15,382,422,880	37.73%
wilbur	17,089,203,670	37.73%
spurious-claims	1,523,802,882	37.73%
marcosespes1	1,654,484,119	37.73%
eaposztrof	1,012,339,940	37.73%
qxl	1,371,974,461	37.73%
abso	304,082,869	37.73%
nicnicy	3,930,249,576	37.73%
businesswri	1,127,310,286	37.73%
treebuilder	4,338,088,798	37.73%
boxmining	122,912,919,714	37.73%
brains1ck	602,235,933	37.73%
nuad01	343,459,639	37.73%
evesick	1,011,521,789	37.73%
mrright	5,284,636,591	37.73%
outerground	14,015,782,469	37.73%
olgavdovskikh	239,805,553	37.73%
frankydoodle	3,710,393,345	37.73%
itchykitten	5,194,336,865	37.73%
kishan	322,146,219	37.73%
vannfrik	20,317,447,252	37.73%
joklahoma	12,695,743,754	37.73%
vizualsamuri	12,561,053,189	37.73%
kingyus	266,580,646	37.73%
shawnfishbit	95,343,984	37.73%
agoric.systems	11,987,569,894	37.73%
realcodysimon	3,994,270,772	37.73%
senor	726,650,143	37.73%
mikegun	7,601,086,355	37.73%
epikcoin	418,358,251	37.73%
deemarshall	7,980,222,893	37.73%
abdulrehman	182,355,949	37.73%
natra	14,142,860,355	37.73%
wishmaiden	928,019,465	37.73%
cldgrf	232,619,255	37.73%
benniebanana	265,033,900	37.73%
booster	16,270,602,440,554	39.97%
ragnartheking	177,660,258	37.73%
hausbau	333,925,361	37.73%
kenhudoy	3,338,542,103	37.73%
mustafeez	232,407,090	37.73%
zaiyn	375,870,211	37.73%
sphinx	233,755,900	100%
mohsan0073	3,109,921,825	37.73%
chingpherd	1,923,431,072	37.73%
satfit	128,293,242	37.73%
agr8buzz	10,322,796,255	37.73%
reko	39,804,050,927	4%
pjcswart	1,854,593,818	37.73%
freecreative	56,377,265	37.73%
stock84	656,008,305	37.73%
truth-be-told	327,310,216	37.73%
philip.willemse	231,948,351	37.73%
funfacts	90,462,397	37.73%
iamnotageek	2,217,230,977	37.73%
cryptojake	983,541,699	37.73%
rest100	29,533,535,757	37.73%
bien	2,369,120,849	37.73%
crypto2day	20,302,967,136	37.73%
mrslauren	21,156,134,020	37.73%
oregonpop	53,786,014,981	37.73%
heelzkinu	66,281,728	37.73%
gamerpool	216,404,677	37.73%
onza	451,014,994	37.73%
icedrum	38,848,502,666	37.73%
minnowpond	13,868,263,040	3%
reborn99	231,968,695	37.73%
animapaddy	232,564,517	37.73%
minnowpond1	136,311,925	3%
abenike	659,025,586	37.73%
appreciator	5,173,280,266,483	4.15%
helmirenggrik	173,322,765	37.73%
mmagreat	858,605,623	37.73%
thelifestyler	2,252,875,284	37.73%
jasmadiyunus	300,977,807	37.73%
kyawsantun	1,778,908,364	37.73%
ladyrednails	4,598,057,050	37.73%
madcool	74,513,013	37.73%
driva	134,478,006	3%
mamata	232,986,541	37.73%
ronnybat	229,099,926	37.73%
ahmad.rezk	231,948,351	37.73%
omrii	231,890,673	37.73%
simplygorgeous	189,398,568	37.73%
jonasthomas	275,879,164	37.73%
amlehtnewo	231,948,351	37.73%
showtime	333,685,575	37.73%
pickled	3,554,412,834	37.73%
finesse203	935,926,237	37.73%
tonimarco	14,658,826,900	37.73%
steemdrivingman	634,986,343	37.73%
aek081969	330,026,200	37.73%
iliketoast	132,253,809	37.73%
tomtom87	232,986,541	37.73%
saini11	63,865,763	37.73%
hellmerlin	232,493,028	37.73%
youngfuego	343,543,164	37.73%
andysmancave	443,894,228	37.73%
treasuregnome	3,992,673,946	37.73%
frontrunner	15,933,197,528	37.73%
cifer	11,485,958,171	60%
mustafa4101996	219,740,543	37.73%
maxbullion	68,970,303,693	37.73%
upvoted	166,519,516	37.73%
ketikasharma	228,609,039	37.73%
dorthmaen	387,204,626	37.73%
gellany	232,986,541	37.73%
scorpionking	108,330,753	37.73%
ganandoenbtc	233,713,385	37.73%
eosint	676,802,522	37.73%
voltsrage	232,365,057	37.73%
rocky1	8,744,767,545,686	14.35%
joulia	228,984,226	37.73%
mightywarrior	109,197,207	37.73%
saadithya	81,692,916	37.73%
tastytrade	232,272,476	37.73%
buildawhale	13,378,084,391,422	17.82%
merosalah	78,541,250	37.73%
ravenrillay	232,272,476	37.73%
jim-borasso-band	232,986,541	37.73%
benjy87	319,940,610	37.73%
belgarath	12,197,200,156	37.73%
alidervash	443,165,751	37.73%
pravda	7,438,044,879	37.73%
corganmusic	105,740,199	37.73%
coingyan	70,799,666	37.73%
serfis	149,659,165	37.73%
kimph	207,642,596	37.73%
nakedtrader	93,286,652	37.73%
jovial-grace	76,872,426	37.73%
zuhrareza	220,098,187	37.73%
phuresh	163,841,494	37.73%
erikkun28	182,143,502	37.73%
videogeek	894,679,601	37.73%
s10	341,200,904	37.73%
upme	19,189,782,854,169	30.55%
derkon	8,098,781,451	37.73%
da-primate	232,088,515	37.73%
aser1111	1,728,357,192	37.73%
hillstech	233,052,065	37.73%
amanda46536	220,903,023	37.73%
rksumanthraju	294,195,748	37.73%
melvinlumacad	1,355,095,990	37.73%
travelingdiva	232,520,906	37.73%
happyclappy	232,916,687	37.73%
ianfreeman	238,829,814	37.73%
chucknasty	232,499,298	37.73%
curiositybot	7,968,733,699	37.73%
postpromoter	5,232,124,889,756	4.07%
arunavabiswas	232,541,828	37.73%
nithog	518,190,067	100%
dizzyjay	2,393,379,106	100%
tujan	222,535,123	37.73%
lawyerup	7,947,644,652	37.73%
liberta	862,101,400	37.73%
jfkenndy	1,526,008,142	37.73%
rikip94	136,967,655	37.73%
bjjworldtraveler	7,821,557,426	37.73%
ering	392,770,596	3%
ant884	8,696,825,150	37.73%
belka05	1,380,376,169	100%
harmonicliving	782,424,802	3%
sammyb	1,161,683,999	3%
silasdavid	663,216,473	37.73%
reisronddewereld	2,416,152,595	37.73%
cryptoclick	4,877,725,519	37.73%
crypt0boy	232,396,205	37.73%
futuredigicoin	187,624,816	37.73%
jimmyjemsx	223,311,029	37.73%
schulbz	243,640,343	3%
genya.kharitonov	232,272,476	37.73%
co-op.blogs	232,272,476	37.73%
emas-jiujitsu	7,850,883,821	37.73%
eaglespirit	11,557,076,944	37.73%
freemon	228,658,078	37.73%
billibong	193,814,901	37.73%
sahertanveer	232,013,280	37.73%
vlasmp	232,839,897	37.73%
halfshinigami	220,892,764	37.73%
r351574nc3	716,036,922	2%
upmewhale	2,068,630,284,980	5.92%
pllo3llo	585,276,423	37.73%
graytor	246,078,443	37.73%
ceyksparrow	232,209,660	37.73%
thedrayness	395,018,105	3%
thevark	1,146,839,259	3%
guangzhoulife	93,350,729	12%
voyagesofcarla2	182,155,687	6%
unholyleaf	711,069,118	3%
shamrock017	155,601,739	3%
cjd	88,161,246	12%
protomar	219,668,638	37.73%
cryptotash101	2,022,122,897	37.73%
verodato	625,088,309,154	100%
vivianka	330,883,951	37.73%
drguy	1,495,278,343	3%
mirabdullah	229,146,120	37.73%
dashdipak	231,948,351	37.73%
stonechaisson	232,046,426	37.73%
aylan	2,586,980,587	37.73%
zulbahri	343,293,740	37.73%
blockchaindaily	1,748,974,319	3%
btcbaby	232,198,063	37.73%
uxmanqaxim	200,259,316	37.73%
enkel	232,658,968	37.73%
ozywashere	1,279,108,645	37.73%
osere	233,047,489	37.73%
brunoaco91	232,247,464	37.73%
thaha1	603,841,042	37.73%
hamza77	232,690,723	37.73%
jguzman394	14,551,873,284	37.73%
fantomcee	231,912,043	37.73%
historyfromworld	232,676,915	37.73%
mickeyvera	183,242,314	37.73%
nicholasjohn	173,043,737	37.73%
zulama28	231,779,317	37.73%
salty-mcgriddles	1,204,998,511	2%
hafizalam5556	231,819,573	37.73%
umich	625,073,371	12%
eddy4king	233,109,326	37.73%
nova-nazirah	227,059,159	37.73%
kurtringimages	220,405,381	37.73%
igedeswita	362,822,405	100%
stephanieangel	210,934,554	37.73%
sabarniati.aceh	217,182,318	37.73%
therising	12,870,306,534,068	33.5%
andrecarothers	6,655,688,654	3%
scandinaviaguide	1,935,722,945	37.73%
eloniy	299,183,110	37.73%
paulasands	300,521,786	50%
xunsh1ne	3,960,227,226	100%
nauman944	231,890,673	37.73%
ocxie	203,866,427	37.73%
battlemountain2k	7,830,862,411	37.73%
promobot	13,834,552,833,257	38.12%
zappl-lottery	380,434,810	37.73%
manfaluthi	228,415,108	37.73%
tehmi	231,710,407	37.73%
photobomber	232,469,553	37.73%
hunking	523,942,092	100%
mollythegreat	426,735,114	50%
taisa.gallery	231,746,564	37.73%
merleeyq	232,936,322	37.73%
hawtescc	2,713,304,695	100%
bitcoinmarketss	223,430,228	37.73%
exifr	80,143,377	2%
devondrjackson	300,595,296	50%
deusx	207,265,747	37.73%
zip512	415,132,879	3%
arithmatic	229,404,641	37.73%
gnoori	232,288,367	37.73%
exifr0	54,456,399	2%
wcqyt	161,700,525	100%
wcqyt2	165,000,001	100%
inwas797	201,514,996	100%
habiba234	506,081,268	100%
turboucoin	112,868,229	100%
blessing786	7,120,938,253	100%
kent1905	161,582,516	100%
javiermurillo	97,559,255	100%
gnomba	326,213,759	100%
rgodoy777	115,850,862	100%
alex-steem-it	60,972,024	100%
markex	445,011,110	100%
jasonstatham300	206,984,416	100%
jalvarezgw	0	100%

@a-0-0 · Jun 9 '18

Go here https://steemit.com/@a-a-a to get your post resteemed to over 72,000 followers.

properties (22)

`author`	a-0-0
`permlink`	re-verodato-connecting-to-the-steemsql-database-via-r-20180609t171338538z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"links":["https://steemit.com/@a-a-a"],"app":"steemit/0.1"}
`created`	2018-06-09 17:13:39
`last_update`	2018-06-09 17:13:39
`depth`	1
`children`	0
`last_payout`	2018-06-16 17:13:39
`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`	87
`author_reputation`	-4,863,186,238,920
`root_title`	"Connecting to the SteemSQL database via R"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	60,021,147
`net_rshares`	0

@alelerdici · Jun 10 '18

Hello, world!
Today i will write about MassCoin - software for checking the threshold value of any cryptocurrency with comfort.
masscoinapp.com - start trade with pleasure.

👎 mack-bot, abusereports

`author`	alelerdici
`permlink`	re-verodato-connecting-to-the-steemsql-database-via-r-20180610t185454998z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"app":"steemit/0.1"}
`created`	2018-06-10 18:55:12
`last_update`	2018-06-10 18:55:12
`depth`	1
`children`	1
`last_payout`	2018-06-17 18:55:12
`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`	172
`author_reputation`	-790,378,343,619
`root_title`	"Connecting to the SteemSQL database via R"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	60,181,163
`net_rshares`	-74,336,046,546
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
mack-bot	0 B		-52,338,044,502	-0.03%
abusereports	0 B		-21,998,002,044	-1%

@abusereports · Jun 10 '18

$1.12

@alelerdici you're on the @abusereports naughty list!<br><br>**Bad Steemian! Bad!**

👍 abusereports, randowhale

`author`	abusereports
`permlink`	abusereports-re-alelerdicire-verodato-connecting-to-the-steemsql-database-via-r-20180610t185454998z
`category`	cryptocurrency
`json_metadata`	""
`created`	2018-06-10 18:55:21
`last_update`	2018-06-10 18:55:21
`depth`	2
`children`	0
`last_payout`	2018-06-17 18:55:21
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.845 HBD
`curator_payout_value`	0.279 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	83
`author_reputation`	199,407,425,243,286
`root_title`	"Connecting to the SteemSQL database via R"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	60,181,181
`net_rshares`	429,006,586,433
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
randowhale	0 B		21,618,428,741	20%
abusereports	0 B		407,388,157,692	20%

@anealireki · Jun 9 '18

Want to start trading with comfort?
https://masscoinapp.com/ - the best thing for it.
Read the description on the main page!

properties (22)

`author`	anealireki
`permlink`	re-verodato-connecting-to-the-steemsql-database-via-r-20180609t153945103z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"links":["https://masscoinapp.com/"],"app":"steemit/0.1"}
`created`	2018-06-09 19:39:48
`last_update`	2018-06-09 19:39:48
`depth`	1
`children`	0
`last_payout`	2018-06-16 19:39: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`	124
`author_reputation`	-789,520,197,712
`root_title`	"Connecting to the SteemSQL database via R"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	60,038,760
`net_rshares`	0

@blessing786 · Jun 9 '18

Wonderful and useful information you provided. THANKS FOR THIS

properties (22)

`author`	blessing786
`permlink`	re-verodato-connecting-to-the-steemsql-database-via-r-20180609t171831696z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"app":"steemit/0.1"}
`created`	2018-06-09 17:18:33
`last_update`	2018-06-09 17:18:33
`depth`	1
`children`	0
`last_payout`	2018-06-16 17:18: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`	62
`author_reputation`	1,859,967,886,450
`root_title`	"Connecting to the SteemSQL database via R"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	60,021,776
`net_rshares`	0

@booster · Jun 12 '18

<p>This post has received a 39.98 % upvote from @booster thanks to: @verodato.</p>

properties (22)

`author`	booster
`permlink`	re-verodato-connecting-to-the-steemsql-database-via-r-20180612t010718171z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"app":"drotto/0.0.5pre3"}
`created`	2018-06-12 01:07:18
`last_update`	2018-06-12 01:07:18
`depth`	1
`children`	0
`last_payout`	2018-06-19 01:07:18
`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`	83
`author_reputation`	68,767,115,776,562
`root_title`	"Connecting to the SteemSQL database via R"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	60,375,208
`net_rshares`	0

@habiba234 · Jun 10 '18

This is a nice inquiry!!!!!
950,000 user are on steemit,,
Active user little,,
i waited for your next post..Thanks a lot,,
@follow you as a new,,

👍 habiba234

`author`	habiba234
`permlink`	re-verodato-connecting-to-the-steemsql-database-via-r-20180610t183220234z
`category`	cryptocurrency
`json_metadata`	{"tags":["cryptocurrency"],"users":["follow"],"app":"steemit/0.1"}
`created`	2018-06-10 18:32:24
`last_update`	2018-06-10 18:32:24
`depth`	1
`children`	0
`last_payout`	2018-06-17 18:32: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`	145
`author_reputation`	61,884,223,375
`root_title`	"Connecting to the SteemSQL database via R"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	60,178,382
`net_rshares`	496,823,683
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
habiba234	0 B		496,823,683	100%

@postpromoter · Jun 11 '18

re-verodato-connecting-to-the-steemsql-database-via-r-20180611t163403892z

You got a 4.07% upvote from @postpromoter courtesy of @verodato!

Want to promote your posts too? Check out the [Steem Bot Tracker website](https://steembottracker.com) for more info. If you would like to support the development of @postpromoter and the bot tracker please [vote for @yabapmatt for witness!](https://v2.steemconnect.com/sign/account-witness-vote?witness=yabapmatt&approve=1)

properties (22)

`author`	postpromoter
`permlink`	re-verodato-connecting-to-the-steemsql-database-via-r-20180611t163403892z
`category`	cryptocurrency
`json_metadata`	{"app":"postpromoter/2.0.0"}
`created`	2018-06-11 16:34:03
`last_update`	2018-06-11 16:34:03
`depth`	1
`children`	0
`last_payout`	2018-06-18 16:34: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`	391
`author_reputation`	12,722,616,650,811
`root_title`	"Connecting to the SteemSQL database via R"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	60,320,756
`net_rshares`	0

@upme · Jun 11 '18

re-verodato-connecting-to-the-steemsql-database-via-r-20180611t203008738z

You got a 30.55% upvote from @upme thanks to @verodato! Send at least 3 SBD or 3 STEEM to get upvote for next round. Delegate STEEM POWER and start earning 100% daily payouts ( no commission ).

properties (22)

`author`	upme
`permlink`	re-verodato-connecting-to-the-steemsql-database-via-r-20180611t203008738z
`category`	cryptocurrency
`json_metadata`	{"app":"postpromoter/2.0.0"}
`created`	2018-06-11 20:30:18
`last_update`	2018-06-11 20:30:18
`depth`	1
`children`	0
`last_payout`	2018-06-18 20:30:18
`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`	194
`author_reputation`	584,696,346,293
`root_title`	"Connecting to the SteemSQL database via R"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	60,348,388
`net_rshares`	0

@upmewhale · Jun 9 '18

re-verodato-connecting-to-the-steemsql-database-via-r-20180609t172152754z

You got a 5.92% upvote from @upmewhale courtesy of @verodato!

Earn 100% earning payout by delegating SP to @upmewhale. Visit http://www.upmewhale.com for details!

properties (22)