hiveblockshttps://i.imgsafe.org/77e5fc4a12.png
Did you ever wanted to easily access data contained in the Steem blockchain and perform analysis or find valuable information. But not everybody has programming skills to gather those data and compute the wanted result.
Therefore, I created a **publicly available** SQL database with **all** the blockchain data in it.
## Why use a SQL database?
The main advantage having such a database is the fact data are structured and easily accessible from any application able to connect to a SQL Server database. Having a SQL Server database makes it possible to produce quick answers to queries.
Simply put, a query is a question. You ask the server form something and it sends back an answer (called the query result set).
For example, when dealing with large amounts of data as Steem blockchain data, you might want quick answers to questions (queries) such as:
* What was the Steem power down volume during the past six weeks?
* Which are the top 10 most rewarded post ever?
* Did I get, me or my posts, mentioned in any post or comment?
* How many posts are talking about ants?
Browsing the blockchain over and over to retrieve and compute such information is time and resource consuming.
If you don’t have a local copy of the blockchain, instead of downloading the whole data from some external public node to process it, you will send your query to SteemSQL server and get only the requested information, saving tons of bandwidth.
Let’s have a look at some technical details
## Database diagram
https://i.imgsafe.org/7822f82a67.jpg
The Blocks table contains bare block information (timestamp, witness …)
Each block can contains Transactions
Depending on each transaction type, the associated transaction’s data is stored in the related table.
## Full text search
The database has been full text search enabled. This allow fast search of information within post and replies.
Let say I want to know if anyone mentioned me in a post or comment, the following simple query will do the trick
`SELECT author, title, body, url FROM TxComments WHERE CONTAINS(body, '@arcange')`
## Database Connection information:
Here the information to connect and query the database:
Server: **sql.steemsql.com**
User: **steemit**
Password: **steemit**
Database name: **DBSteem**
## How to retrieve query the database
* Using Microsoft Excel
Check this [tutorial](https://steemit.com/steemit/@arcange/steemsql-com-how-to-create-a-steem-analytic-report-with-microsoft-excel) to see how to create an analysis report with Excel
* If you’re a python programmer
```python
import pypyodbc
connection = pypyodbc.connect('Driver={SQL Server};'
'Server=sql.steemsql.com;'
'Database=DBSteem;'
'uid=steemit;pwd=steemit')
cursor = connection.cursor()
SQLCommand = ("YOUR SQL QUERY”)
cursor.execute(SQLCommand)
# do whatever you want with the retrieved data
connection.close()
```
## Support
If you need help, have any comment or request, join **[steemsql channel](https://steemit.chat/channel/steemsql)** on steemit.chat
## Availability and performance
The SQL server is hosted in a datacenter with 24/7/365 availability.
Available output bandwidth is up to 500Mb/s
New data from the latest blocks are injected in the database every 10 seconds.
The server is currently hosted in a shared infrastructure.
I will monitor server load and if it requires more resources, I will allocate any reward to this post to a dedicated infrastructure.
You like it, please **upvote** or **follow me**| author | arcange |
|---|---|
| permlink | steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data |
| category | steemit |
| json_metadata | {"tags":["steemit","analytics","stats","programming",""],"image":["https://i.imgsafe.org/77e5fc4a12.png","https://i.imgsafe.org/7822f82a67.jpg"],"links":["https://steemit.com/steemit/@arcange/steemsql-com-how-to-create-a-steem-analytic-report-with-microsoft-excel","https://steemit.chat/channel/steemsql"]} |
| created | 2016-09-13 11:50:12 |
| last_update | 2016-09-13 11:50:12 |
| depth | 0 |
| children | 65 |
| last_payout | 2016-10-15 13:25:57 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 297.088 HBD |
| curator_payout_value | 98.161 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 3,634 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,230,772 |
| net_rshares | 81,953,653,020,120 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| steempty | 0 | 7,863,295,162,766 | 100% | ||
| ned | 0 | 39,223,840,396,028 | 60% | ||
| lafona-miner | 0 | 3,067,146,482,661 | 100% | ||
| lafona | 0 | 478,093,186,714 | 100% | ||
| fuzzyvest | 0 | 6,466,302,139,969 | 100% | ||
| sandra | 0 | 118,485,787,519 | 100% | ||
| silver | 0 | 1,715,880,029,357 | 100% | ||
| silversteem | 0 | 4,063,913,772,997 | 100% | ||
| abit | 0 | 7,001,689,019,928 | 100% | ||
| ihashfury | 0 | 1,090,598,864,701 | 100% | ||
| delegate.lafona | 0 | 1,100,788,590,269 | 100% | ||
| lafona5 | 0 | 308,783,444,110 | 100% | ||
| aizensou | 0 | 82,671,772,883 | 100% | ||
| officialfuzzy | 0 | 443,068,373,154 | 100% | ||
| pfunk | 0 | 795,044,559,389 | 100% | ||
| andzzz | 0 | 9,982,440,069 | 100% | ||
| noisy | 0 | 51,332,857,970 | 100% | ||
| morning | 0 | 11,694,560,233 | 100% | ||
| gavvet | 0 | 1,234,583,624,335 | 100% | ||
| joelinux | 0 | 23,563,691,082 | 100% | ||
| fernando-sanz | 0 | 6,583,839,316 | 100% | ||
| richman | 0 | 7,772,229,736 | 100% | ||
| steve-walschot | 0 | 161,221,379,822 | 100% | ||
| murh | 0 | 1,414,282,787 | 55.55% | ||
| marta-zaidel | 0 | 5,385,662,749 | 100% | ||
| aizen01 | 0 | 10,900,823,677 | 100% | ||
| aizen02 | 0 | 6,499,631,007 | 100% | ||
| aizen03 | 0 | 3,552,366,776 | 100% | ||
| aizen04 | 0 | 1,167,908,093 | 100% | ||
| aizen05 | 0 | 494,011,890 | 100% | ||
| aizen07 | 0 | 4,792,657,323 | 100% | ||
| aizen08 | 0 | 2,866,473,700 | 100% | ||
| aizen09 | 0 | 1,018,773,570 | 100% | ||
| aizen10 | 0 | 440,815,198 | 100% | ||
| aizen06 | 0 | 7,251,599,286 | 100% | ||
| aizen11 | 0 | 3,046,354,062 | 100% | ||
| aizen14 | 0 | 2,093,827,993 | 100% | ||
| aizen19 | 0 | 2,462,056,275 | 100% | ||
| aizen15 | 0 | 648,949,628 | 100% | ||
| aizen16 | 0 | 6,424,903,281 | 100% | ||
| aizen20 | 0 | 645,116,104 | 100% | ||
| aizen22 | 0 | 4,217,447,041 | 100% | ||
| aizen23 | 0 | 1,120,999,727 | 100% | ||
| aizen17 | 0 | 2,204,896,687 | 100% | ||
| aizen24 | 0 | 3,470,451,837 | 100% | ||
| aizen18 | 0 | 490,553,110 | 100% | ||
| aizen25 | 0 | 1,314,196,776 | 100% | ||
| aizen28 | 0 | 2,232,430,390 | 100% | ||
| aizen26 | 0 | 3,435,321,135 | 100% | ||
| aizen27 | 0 | 1,127,666,084 | 100% | ||
| aizen32 | 0 | 3,875,699,811 | 100% | ||
| aizen30 | 0 | 2,120,371,796 | 100% | ||
| aizen31 | 0 | 3,922,155,046 | 100% | ||
| aizen33 | 0 | 1,291,018,425 | 100% | ||
| aizen34 | 0 | 1,553,081,360 | 100% | ||
| aizen35 | 0 | 311,774,459 | 100% | ||
| aizen36 | 0 | 5,849,477,524 | 100% | ||
| aizen37 | 0 | 1,459,346,389 | 100% | ||
| aizen29 | 0 | 408,290,923 | 100% | ||
| aizen21 | 0 | 2,872,536,420 | 100% | ||
| aizen12 | 0 | 4,407,557,058 | 100% | ||
| aizen38 | 0 | 1,876,630,383 | 100% | ||
| aizen39 | 0 | 523,210,618 | 100% | ||
| satoshifund | 0 | 615,350,757,031 | 16% | ||
| yan-kovalenko | 0 | 551,178,406,999 | 100% | ||
| tee-em | 0 | 5,046,542,859 | 100% | ||
| michaelx | 0 | 30,495,780,836 | 100% | ||
| publicworker | 0 | 687,463,320,462 | 100% | ||
| kimziv | 0 | 218,877,176,086 | 100% | ||
| lukestokes | 0 | 279,160,474,130 | 100% | ||
| tyler-fletcher | 0 | 6,609,454,107 | 100% | ||
| gtg | 0 | 87,601,887,291 | 100% | ||
| mrhankeh | 0 | 471,516,850 | 100% | ||
| clement | 0 | 38,015,010,258 | 100% | ||
| bacchist | 0 | 68,179,494,663 | 100% | ||
| asmolokalo | 0 | 189,892,594,715 | 100% | ||
| katyakov | 0 | 24,315,591,768 | 100% | ||
| cmtzco | 0 | 8,946,725,100 | 100% | ||
| stranger27 | 0 | 4,442,168,585 | 100% | ||
| r4fken | 0 | 15,227,393,872 | 100% | ||
| picokernel | 0 | 30,824,860,026 | 100% | ||
| aizen13 | 0 | 389,458,625 | 100% | ||
| aizen41 | 0 | 3,344,942,110 | 100% | ||
| aizen42 | 0 | 950,534,210 | 100% | ||
| aizen46 | 0 | 3,238,263,445 | 100% | ||
| aizen47 | 0 | 886,294,877 | 100% | ||
| aizen48 | 0 | 217,253,386 | 100% | ||
| aizen49 | 0 | 113,259,366 | 100% | ||
| furion | 0 | 101,872,592,388 | 100% | ||
| aizen51 | 0 | 941,015,787 | 100% | ||
| aizen43 | 0 | 455,780,965 | 100% | ||
| aizen44 | 0 | 67,659,539 | 100% | ||
| aizen54 | 0 | 763,284,602 | 100% | ||
| sigmajin | 0 | 98,901,463,374 | 100% | ||
| ausbitbank | 0 | 18,352,072,104 | 100% | ||
| mixa | 0 | 1,422,705,803 | 100% | ||
| akareyon | 0 | 23,198,418,990 | 100% | ||
| jesta | 0 | 280,993,319,629 | 100% | ||
| toxonaut | 0 | 33,655,847,643 | 100% | ||
| snowden | 0 | 137,726,541 | 100% | ||
| meiisheree | 0 | 20,363,354,119 | 100% | ||
| igster | 0 | 23,479,564,777 | 100% | ||
| kaptainkrayola | 0 | 10,155,444,826 | 100% | ||
| meesterboom | 0 | 0 | 1% | ||
| aizen52 | 0 | 233,569,693 | 100% | ||
| krystle | 0 | 7,301,073,459 | 100% | ||
| arcange | 0 | 2,223,894,485 | 100% | ||
| wildchild | 0 | 84,865,861 | 100% | ||
| kewpiedoll | 0 | 10,423,688,789 | 100% | ||
| phenom | 0 | 0 | 100% | ||
| aizen55 | 0 | 190,269,483 | 100% | ||
| blueorgy | 0 | 167,219,634,614 | 100% | ||
| poseidon | 0 | 4,892,254,527 | 100% | ||
| heimindanger | 0 | 16,040,198,445 | 100% | ||
| earnest | 0 | 1,736,399,485 | 100% | ||
| bitcoiner | 0 | 5,994,171,994 | 100% | ||
| bento | 0 | 141,429,957 | 100% | ||
| lostnuggett | 0 | 7,455,410,380 | 100% | ||
| raymonjohnstone | 0 | 0 | 100% | ||
| masterinvestor | 0 | 23,815,375,024 | 100% | ||
| steemchain | 0 | 62,123,806 | 100% | ||
| whalepool | 0 | 59,822,924 | 100% | ||
| yogi | 0 | 0 | 100% | ||
| fleuri | 0 | 13,288,729,032 | 100% | ||
| bbrewer | 0 | 5,378,189,892 | 100% | ||
| sisterholics | 0 | 36,087,949,223 | 100% | ||
| hermes7 | 0 | 477,106,677 | 100% | ||
| aizen53 | 0 | 83,707,323 | 100% | ||
| steemster1 | 0 | 153,025,160 | 100% | ||
| fabien | 0 | 26,798,624,260 | 100% | ||
| williambanks | 0 | 27,401,970,749 | 100% | ||
| cryptoz | 0 | 102,065,394 | 100% | ||
| bento04 | 0 | 449,108,428 | 100% | ||
| bento03 | 0 | 753,126,143 | 100% | ||
| aizen | 0 | 1,534,361,646 | 100% | ||
| bento02 | 0 | 239,545,179 | 100% | ||
| bento01 | 0 | 551,525,219 | 100% | ||
| coinbar | 0 | 1,651,135,352 | 100% | ||
| sharon | 0 | 60,565,253 | 100% | ||
| lillianjones | 0 | 61,714,352 | 100% | ||
| laonie | 0 | 1,243,814,826,826 | 100% | ||
| ozchartart | 0 | 248,320,868,548 | 100% | ||
| croatia | 0 | 5,102,415,579 | 100% | ||
| vladimirputin | 0 | 65,300,521 | 100% | ||
| angelamerkel | 0 | 65,308,725 | 100% | ||
| timcliff | 0 | 4,038,742,528 | 100% | ||
| laonie1 | 0 | 24,552,804,860 | 100% | ||
| laonie2 | 0 | 25,067,031,014 | 100% | ||
| laonie3 | 0 | 25,075,820,795 | 100% | ||
| bento06 | 0 | 81,826,244 | 100% | ||
| myfirst | 0 | 41,146,659,560 | 100% | ||
| somebody | 0 | 259,041,166,001 | 100% | ||
| flysaga | 0 | 9,928,202,878 | 100% | ||
| brendio | 0 | 5,477,690,509 | 100% | ||
| midnightoil | 0 | 57,224,965,267 | 100% | ||
| mibenkito | 0 | 81,534,680,767 | 100% | ||
| altucher | 0 | 1,018,538,139 | 100% | ||
| andrew0 | 0 | 2,379,653,408 | 100% | ||
| timferriss | 0 | 101,572,397 | 100% | ||
| michellek | 0 | 59,414,599 | 100% | ||
| laonie4 | 0 | 25,071,217,681 | 100% | ||
| laonie5 | 0 | 25,068,579,591 | 100% | ||
| laonie6 | 0 | 25,065,597,250 | 100% | ||
| laonie7 | 0 | 25,061,528,883 | 100% | ||
| kurtbeil | 0 | 3,489,192,001 | 100% | ||
| laonie8 | 0 | 25,057,888,093 | 100% | ||
| laonie9 | 0 | 25,055,101,904 | 100% | ||
| steemleak | 0 | 3,299,212,767 | 100% | ||
| darrenrowse | 0 | 104,692,799 | 100% | ||
| xiaohui | 0 | 139,516,716,638 | 100% | ||
| ekitcho | 0 | 11,282,355,163 | 100% | ||
| bigsambucca | 0 | 144,762,864 | 100% | ||
| elfkitchen | 0 | 6,969,665,469 | 100% | ||
| paynode | 0 | 2,207,433,525 | 100% | ||
| xiaokongcom | 0 | 4,586,891,562 | 100% | ||
| msjennifer | 0 | 62,201,879 | 100% | ||
| ciao | 0 | 57,196,572 | 100% | ||
| steemo | 0 | 55,449,983 | 100% | ||
| pcashmore | 0 | 179,351,183 | 100% | ||
| xianjun | 0 | 9,246,138,383 | 100% | ||
| steema | 0 | 56,535,984 | 100% | ||
| andrew.sullivan | 0 | 59,618,782 | 100% | ||
| brianclark | 0 | 1,046,049,321 | 100% | ||
| daniel.kahneman | 0 | 831,589,271 | 100% | ||
| tucker.max | 0 | 232,896,636 | 100% | ||
| melek | 0 | 5,529,714,953 | 100% | ||
| darren.rowse | 0 | 740,826,654 | 100% | ||
| chris.dunn | 0 | 55,704,135 | 100% | ||
| confucius | 0 | 72,902,270 | 100% | ||
| mrosenquist | 0 | 29,680,589,057 | 100% | ||
| pat.flynn | 0 | 1,178,246,621 | 100% | ||
| loli | 0 | 50,027,573 | 100% | ||
| mattmarshall | 0 | 1,223,581,698 | 100% | ||
| timothysykes | 0 | 437,783,005 | 100% | ||
| bitcalm | 0 | 44,282,381,365 | 100% | ||
| patflynn | 0 | 106,860,965 | 100% | ||
| jarvis | 0 | 56,157,882 | 100% | ||
| microluck | 0 | 605,788,499 | 100% | ||
| andrewsullivan | 0 | 896,991,635 | 100% | ||
| fortuner | 0 | 55,520,042 | 100% | ||
| kyriacos | 0 | 30,570,344,850 | 100% | ||
| harvey.levin | 0 | 489,129,872 | 100% | ||
| alfaman | 0 | 60,290,273 | 100% | ||
| cryptomental | 0 | 6,768,608,207 | 100% | ||
| johnbyrd | 0 | 54,235,184 | 100% | ||
| thomasaustin | 0 | 54,218,223 | 100% | ||
| thermor | 0 | 54,216,305 | 100% | ||
| ficholl | 0 | 54,227,808 | 100% | ||
| widell | 0 | 54,209,199 | 100% | ||
| shneakysquirrel | 0 | 3,657,683,169 | 100% | ||
| revelbrooks | 0 | 53,821,337 | 100% | ||
| laonie10 | 0 | 25,048,684,602 | 100% | ||
| lasseehlers | 0 | 89,979,862 | 100% | ||
| rand.fishkin | 0 | 194,739,083 | 100% | ||
| bitchplease | 0 | 55,543,445 | 100% | ||
| craigwilliamz | 0 | 9,504,908,244 | 100% | ||
| cryptovpn | 0 | 9,517,931,723 | 100% | ||
| curpose | 0 | 52,708,083 | 100% | ||
| ontofractal | 0 | 1,385,373,482 | 100% | ||
| takethecannoli | 0 | 18,278,767,826 | 100% | ||
| uziriel | 0 | 81,878,649 | 100% | ||
| arandu | 0 | 77,846,143 | 100% | ||
| flashjordan | 0 | 0 | 100% | ||
| laonie11 | 0 | 24,180,906,457 | 100% | ||
| troich | 0 | 52,836,995 | 100% | ||
| crion | 0 | 52,842,496 | 100% | ||
| hitherise | 0 | 52,505,412 | 100% | ||
| wiss | 0 | 52,496,656 | 100% | ||
| l0k1 | 0 | 4,267,365,968 | 100% | ||
| freesteem | 0 | 54,247,498 | 100% | ||
| stroully | 0 | 53,252,658 | 100% | ||
| thadm | 0 | 52,916,909 | 100% | ||
| prof | 0 | 52,915,101 | 100% | ||
| keverw | 0 | 808,370,638 | 100% | ||
| yorsens | 0 | 52,560,790 | 100% | ||
| harveylevin | 0 | 177,656,553 | 100% | ||
| bane | 0 | 52,242,652 | 100% | ||
| vive | 0 | 52,236,265 | 100% | ||
| coad | 0 | 52,230,725 | 100% | ||
| goose | 0 | 9,271,702,156 | 100% | ||
| analyzethis | 0 | 50,931,848 | 100% | ||
| sofa | 0 | 53,003,720 | 100% | ||
| gary.vaynerchuk | 0 | 122,884,931 | 100% | ||
| tracemayer | 0 | 60,103,302,778 | 100% | ||
| ailo | 0 | 53,055,629 | 100% | ||
| steempowerwhale | 0 | 3,162,276,428 | 100% | ||
| anomaly | 0 | 574,180,710 | 100% | ||
| timothy.sykes | 0 | 51,415,300 | 100% | ||
| inarix03 | 0 | 61,292,139 | 100% | ||
| ola1 | 0 | 218,488,504 | 100% | ||
| gamgam | 0 | 2,286,512,384 | 100% | ||
| eavy | 0 | 52,499,943 | 100% | ||
| roto | 0 | 51,484,593 | 100% | ||
| haved | 0 | 50,938,725 | 100% | ||
| ardly | 0 | 50,708,837 | 100% | ||
| yotoh | 0 | 50,704,078 | 100% | ||
| morse | 0 | 50,433,760 | 100% | ||
| carre | 0 | 50,372,583 | 100% | ||
| letstalkliberty | 0 | 244,968,251 | 100% | ||
| igtes | 0 | 74,444,594 | 100% | ||
| olesia83 | 0 | 79,060,987 | 100% | ||
| buffett | 0 | 148,119,740 | 100% | ||
| comeup | 0 | 114,127,036 | 33% | ||
| dealzgal | 0 | 96,638,506 | 100% | ||
| crowkeep | 0 | 158,659,107 | 100% | ||
| storage | 0 | 68,013,381 | 100% | ||
| utibeokodi | 0 | 157,461,346 | 100% | ||
| blackmarket | 0 | 58,460,105 | 100% | ||
| gifts | 0 | 61,530,871 | 100% | ||
| yamadapc | 0 | 155,689,149 | 100% | ||
| onthax | 0 | 0 | 100% | ||
| avpet | 0 | 152,070,894 | 100% | ||
| toddemaher1 | 0 | 138,651,704 | 100% | ||
| joanaltres | 0 | 0 | 100% | ||
| baerdric | 0 | 0 | 100% | ||
| almvide | 0 | 0 | 10% | ||
| luvabi | 0 | 0 | 100% | ||
| mlong168 | 0 | 0 | 100% | ||
| drakos | 0 | 0 | 100% | ||
| konstantint | 0 | 0 | 100% | ||
| segyepark | 0 | 0 | 100% | ||
| pushing.truth | 0 | 0 | 100% | ||
| fahrullah | 0 | 0 | 100% | ||
| leo-87 | 0 | 0 | 100% | ||
| carlgnash | 0 | 0 | 100% | ||
| khuziyad | 0 | 0 | 100% | ||
| rob.roche | 0 | 0 | 100% | ||
| marnee | 0 | 0 | 100% | ||
| paikan | 0 | 0 | 100% | ||
| alketcecaj | 0 | 0 | 100% | ||
| rcdex | 0 | 0 | 100% | ||
| chrislo2004 | 0 | 0 | 100% | ||
| bangol | 0 | 0 | 100% | ||
| statorcrime | 0 | 0 | 100% | ||
| ekonugraha | 0 | 0 | 100% | ||
| nick.freeman | 0 | 0 | 100% | ||
| strenue | 0 | 0 | 100% | ||
| wujekdobrarada | 0 | 0 | 100% | ||
| seghri | 0 | 0 | 100% | ||
| thunderx | 0 | 0 | 100% | ||
| laijihua | 0 | 0 | 100% | ||
| bt1 | 0 | 0 | 100% | ||
| mniazi | 0 | 0 | 100% | ||
| aleinads | 0 | 0 | 100% | ||
| cmplxty | 0 | 0 | 100% | ||
| alvinvoo | 0 | 0 | 100% | ||
| marianozetax | 0 | 0 | 100% |
This is good. Although I like something like PhpMyAdmin more. What hardware is your service running on? I'm curious about the scalability.
| author | abit |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t180712899z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-14 18:07:15 |
| last_update | 2016-09-14 18:10:12 |
| depth | 1 |
| children | 2 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 138 |
| author_reputation | 141,171,499,037,785 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,245,514 |
| net_rshares | 0 |
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.
| author | arcange |
|---|---|
| permlink | re-abit-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t084138837z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-15 08:41:39 |
| last_update | 2016-09-15 08:41:39 |
| depth | 2 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.123 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 177 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,251,972 |
| net_rshares | 1,149,874,116,696 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| abit | 0 | 1,149,874,116,696 | 15% | ||
| bangol | 0 | 0 | 100% |
Sounds great.
| author | abit |
|---|---|
| permlink | re-arcange-re-abit-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160916t082154528z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-16 08:21:54 |
| last_update | 2016-09-16 08:21:54 |
| depth | 3 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 13 |
| author_reputation | 141,171,499,037,785 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,263,496 |
| net_rshares | 0 |
http://steemsql.com/ is not working?
| author | abit |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160918t125123328z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"links":["http://steemsql.com/"]} |
| created | 2016-09-18 12:51:24 |
| last_update | 2016-09-18 12:51:24 |
| depth | 1 |
| children | 4 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 141,171,499,037,785 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,285,748 |
| net_rshares | 0 |
Haven't noticed any problem. Please use [steemsql channel](https://steemit.chat/channel/steemsql) on steemit.chat for help or support
| author | arcange |
|---|---|
| permlink | re-abit-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160919t091958972z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"links":["https://steemit.chat/channel/steemsql"]} |
| created | 2016-09-19 09:19:57 |
| last_update | 2016-09-19 09:19:57 |
| depth | 2 |
| children | 3 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 133 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,294,043 |
| net_rshares | 0 |
Just clicked on the link: http://steemsql.com/ , I got this: ``` This site can’t be reached steemsql.com’s server DNS address could not be found. ```
| author | abit |
|---|---|
| permlink | re-arcange-re-abit-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160919t234137802z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"links":["http://steemsql.com/"]} |
| created | 2016-09-19 23:41:36 |
| last_update | 2016-09-20 22:38:48 |
| depth | 3 |
| children | 2 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 141,171,499,037,785 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,301,728 |
| net_rshares | 0 |
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!
| author | alketcecaj |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20171122t140545891z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2017-11-22 14:05:45 |
| last_update | 2017-11-22 14:05:45 |
| depth | 1 |
| children | 0 |
| last_payout | 2017-11-29 14:05:45 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.055 HBD |
| curator_payout_value | 0.018 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 193 |
| author_reputation | 2,409,013,484,223 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 21,202,693 |
| net_rshares | 30,515,402,309 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| datatreemap | 0 | 30,515,402,309 | 100% |
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 :)
| author | anduweb |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t115214108z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-13 11:52:15 |
| last_update | 2016-09-13 11:52:15 |
| depth | 1 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 160 |
| author_reputation | 11,311,191,021,706 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,230,790 |
| net_rshares | 2,767,082,391 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| bitcoiner | 0 | 2,767,082,391 | 50% |
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.
| author | arcange |
|---|---|
| permlink | re-anduweb-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t115835527z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-13 11:58:36 |
| last_update | 2016-09-13 11:58:36 |
| depth | 2 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 417 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,230,852 |
| net_rshares | 0 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| khuziyad | 0 | 0 | 100% |
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
| author | ausbitbank |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t120702586z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-13 12:07:03 |
| last_update | 2016-09-13 12:07:03 |
| depth | 1 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 287,009,709,424,827 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,230,922 |
| net_rshares | 4,947,371,102 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| arcange | 0 | 2,180,288,711 | 100% | ||
| bitcoiner | 0 | 2,767,082,391 | 50% |
That's exactly the purpose of it: having an efficient alternative to local nodes. Thanks!
| author | arcange |
|---|---|
| permlink | re-ausbitbank-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t121534054z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-13 12:15:33 |
| last_update | 2016-09-13 12:15:33 |
| depth | 2 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 89 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,230,972 |
| net_rshares | 0 |
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.
| author | bbrewer |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t020124789z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-15 02:01:27 |
| last_update | 2016-09-15 02:01:27 |
| depth | 1 |
| children | 2 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 197 |
| author_reputation | 7,852,511,958,185 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,249,728 |
| net_rshares | 0 |
Do not hesitate to contact me on [steemit.chat ](https://steemit.chat/channel/steemsql) if you need any help to create amazing SQL queries.
| author | arcange |
|---|---|
| permlink | re-bbrewer-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t085145659z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"links":["https://steemit.chat/channel/steemsql"]} |
| created | 2016-09-15 08:51:45 |
| last_update | 2016-09-15 08:51:45 |
| depth | 2 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 139 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,252,025 |
| net_rshares | 0 |
Thank you, kindly.
| author | bbrewer |
|---|---|
| permlink | re-arcange-re-bbrewer-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t144851545z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-15 14:48:54 |
| last_update | 2016-09-15 14:48:54 |
| depth | 3 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 18 |
| author_reputation | 7,852,511,958,185 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,254,698 |
| net_rshares | 0 |
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_votes` is empty for all posts after their second payout. You can even see this on steemit.com where old posts have zero upvotes.
| author | bitcalm |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t112453737z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-14 11:24:45 |
| last_update | 2016-09-14 11:24:45 |
| depth | 1 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 280 |
| author_reputation | 24,919,530,803,138 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,242,146 |
| net_rshares | 44,282,381,365 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| bitcalm | 0 | 44,282,381,365 | 100% |
All votes are in transactions and stored in the TxVotes table, even first votes ever : https://s18.postimg.org/mhjtzg7p5/14_09_2016_13_56_49.png
| author | arcange |
|---|---|
| permlink | re-bitcalm-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t120100152z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"image":["https://s18.postimg.org/mhjtzg7p5/14_09_2016_13_56_49.png"]} |
| created | 2016-09-14 12:01:00 |
| last_update | 2016-09-14 12:01:00 |
| depth | 2 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 144 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,242,452 |
| net_rshares | 0 |
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.
| author | bitcoiner |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t223021322z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-13 22:30:21 |
| last_update | 2016-09-13 22:30:21 |
| depth | 1 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 304 |
| author_reputation | 28,017,014,641,958 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,237,117 |
| net_rshares | 2,223,894,485 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| arcange | 0 | 2,223,894,485 | 100% |
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.
| author | arcange |
|---|---|
| permlink | re-bitcoiner-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t224533350z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-13 22:45:33 |
| last_update | 2016-09-13 22:45:33 |
| depth | 2 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 323 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,237,261 |
| net_rshares | 0 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| devsullo | 0 | 0 | 100% |
Thank you so much for hosting this! You are my hero! Successfully connected and doing some poking around in the data for fun tonight :)
| author | carlgnash |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20170730t073008754z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2017-07-30 07:30:09 |
| last_update | 2017-07-30 07:30:09 |
| depth | 1 |
| children | 0 |
| last_payout | 2017-08-06 07:30:09 |
| 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 | 137 |
| author_reputation | 114,786,060,260,950 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 10,195,615 |
| net_rshares | 0 |
hey, I'm playing with it right now. how I can I see the full architecture of the database?
| author | cristi |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t183538815z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-15 18:35:42 |
| last_update | 2016-09-15 18:35:42 |
| depth | 1 |
| children | 3 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 90 |
| author_reputation | 128,305,218,872,904 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,257,133 |
| net_rshares | 0 |
All tables and their relation are shown in the database diagram in this post.
| author | arcange |
|---|---|
| permlink | re-cristi-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t212727328z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-15 21:27:27 |
| last_update | 2016-09-15 21:27:27 |
| depth | 2 |
| children | 2 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 77 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,258,980 |
| net_rshares | 0 |
I thought there was another way as well
| author | cristi |
|---|---|
| permlink | re-arcange-re-cristi-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t213444154z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-15 21:34:48 |
| last_update | 2016-09-15 21:34:48 |
| depth | 3 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 128,305,218,872,904 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,259,036 |
| net_rshares | 0 |
Excellent work
| author | earnest |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t173020900z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-14 17:30:21 |
| last_update | 2016-09-14 17:30:21 |
| depth | 1 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | -2,314,359,161,729 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,245,113 |
| net_rshares | 0 |
Amazing. Glad to found this post. Thank you for providing the infrastructure. I have accessed it and it works well
| author | ekonugraha |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20171211t145519580z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2017-12-11 14:55:21 |
| last_update | 2017-12-11 14:55:21 |
| depth | 1 |
| children | 0 |
| last_payout | 2017-12-18 14:55:21 |
| 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 | 114 |
| author_reputation | 5,370,685,266,189 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 23,122,397 |
| net_rshares | 0 |
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 ?
| author | heimindanger |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t213125094z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-13 21:31:24 |
| last_update | 2016-09-13 21:31:24 |
| depth | 1 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 178 |
| author_reputation | -16,507,408,909,111 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,236,590 |
| net_rshares | 18,492,767,141 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| heimindanger | 0 | 15,725,684,750 | 100% | ||
| bitcoiner | 0 | 2,767,082,391 | 50% |
Post you queries in [steemsql channel](https://steemit.chat/channel/steemsql) I will analyze them and see how to improve DB design/performances
| author | arcange |
|---|---|
| permlink | re-heimindanger-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t215207333z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"links":["https://steemit.chat/channel/steemsql"]} |
| created | 2016-09-13 21:52:06 |
| last_update | 2016-09-13 21:52:06 |
| depth | 2 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 143 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,236,795 |
| net_rshares | 0 |
SQL Server is great - thank you very much for providing this!
| author | kaptainkrayola |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t122851640z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-13 12:28:51 |
| last_update | 2016-09-13 12:28:51 |
| depth | 1 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 61 |
| author_reputation | 2,518,560,260,114 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,231,055 |
| net_rshares | 2,767,082,391 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| bitcoiner | 0 | 2,767,082,391 | 50% |
You're welcome.
| author | arcange |
|---|---|
| permlink | re-kaptainkrayola-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t153923961z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-15 15:39:24 |
| last_update | 2016-09-15 15:39:24 |
| depth | 2 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 15 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,255,284 |
| net_rshares | 10,170,107,883 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| kaptainkrayola | 0 | 10,170,107,883 | 100% |
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! :)
| author | khuziyad |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20170728t194524736z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2017-07-28 19:45:24 |
| last_update | 2017-07-28 19:45:24 |
| depth | 1 |
| children | 0 |
| last_payout | 2017-08-04 19:45: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 | 304 |
| author_reputation | 27,573,572,663 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 10,052,207 |
| net_rshares | 0 |
@arcange this is severely underrated. gave you my full blown 100%. we need this.
| author | kyriacos |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t125847143z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"users":["arcange"]} |
| created | 2016-09-14 12:58:48 |
| last_update | 2016-09-14 12:58:48 |
| depth | 1 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 81 |
| author_reputation | 151,079,958,921,004 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,242,832 |
| net_rshares | 35,193,023,938 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| arcange | 0 | 2,180,772,857 | 100% | ||
| kewpiedoll | 0 | 3,065,790,820 | 30% | ||
| steemiest | 0 | 0 | 100% | ||
| kyriacos | 0 | 29,946,460,261 | 100% |
https://s17.postimg.org/vu16b00rj/angel.gif ### **Thank you !**
| author | arcange |
|---|---|
| permlink | re-kyriacos-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t135307038z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"image":["https://s17.postimg.org/vu16b00rj/angel.gif"]} |
| created | 2016-09-14 13:53:06 |
| last_update | 2016-09-14 13:53:06 |
| depth | 2 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 63 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,243,271 |
| net_rshares | 0 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| alketcecaj | 0 | 0 | 100% |
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.
| author | l0k1 |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t145620337z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-14 14:56:21 |
| last_update | 2016-09-14 14:56:21 |
| depth | 1 |
| children | 7 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 486 |
| author_reputation | 94,800,257,230,993 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,243,842 |
| net_rshares | 10,219,302,734 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| kewpiedoll | 0 | 10,219,302,734 | 100% |
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.
| author | arcange |
|---|---|
| permlink | re-l0k1-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t151754258z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-14 15:17:54 |
| last_update | 2016-09-14 15:17:54 |
| depth | 2 |
| children | 6 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 269 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,244,031 |
| net_rshares | 0 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| khuziyad | 0 | 0 | 100% |
Seriously, Doesn't this defeat the purpose of decentralization?
| author | khuziyad |
|---|---|
| permlink | re-arcange-re-l0k1-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20170729t202522789z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2017-07-29 20:25:24 |
| last_update | 2017-07-29 20:25:24 |
| depth | 3 |
| children | 2 |
| last_payout | 2017-08-05 20:25: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 | 63 |
| author_reputation | 27,573,572,663 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 10,150,596 |
| net_rshares | 0 |
Ah. So it's just another implementation of the graph database protocol, layered on top of a relational database.
| author | l0k1 |
|---|---|
| permlink | re-arcange-re-l0k1-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t152912223z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-14 15:29:12 |
| last_update | 2016-09-14 15:29:12 |
| depth | 3 |
| children | 2 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 112 |
| author_reputation | 94,800,257,230,993 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,244,140 |
| net_rshares | 0 |
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?”]( https://steemit.com/steemit/@lestatisticien/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!
| author | lestatisticien |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20171024t124945801z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"links":["https://steemit.com/steemit/@lestatisticien/can-you-supply-some-block-chain-data-for-payment"],"app":"steemit/0.1"} |
| created | 2017-10-24 12:49:48 |
| last_update | 2017-10-24 12:49:48 |
| depth | 1 |
| children | 0 |
| last_payout | 2017-10-31 12:49: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 | 823 |
| author_reputation | 113,294,543,132 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 18,452,422 |
| net_rshares | 0 |
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?”]( https://steemit.com/steemit/@lestatisticien/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!
| author | lestatisticien |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20171024t131018826z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"links":["https://steemit.com/steemit/@lestatisticien/can-you-supply-some-block-chain-data-for-payment"],"app":"steemit/0.1"} |
| created | 2017-10-24 13:10:21 |
| last_update | 2017-10-24 13:10:21 |
| depth | 1 |
| children | 0 |
| last_payout | 2017-10-31 13:10:21 |
| 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 | 823 |
| author_reputation | 113,294,543,132 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 18,453,707 |
| net_rshares | 0 |
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!
| author | lukestokes |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t021706354z |
| category | steemit |
| json_metadata | {"tags":["dev","steemit"]} |
| created | 2016-09-15 02:17:06 |
| last_update | 2016-09-15 02:17:06 |
| depth | 1 |
| children | 4 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 135 |
| author_reputation | 554,601,966,217,919 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,249,832 |
| net_rshares | 0 |
Thanks ! Hopefully it will be useful to you.
| author | arcange |
|---|---|
| permlink | re-lukestokes-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t084829699z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-15 08:48:30 |
| last_update | 2016-09-15 08:48:30 |
| depth | 2 |
| children | 3 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 44 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,252,007 |
| net_rshares | 0 |
I'm at <a href="http://www.restfest.org/">RESTfest</a> today, and I'm contemplating building a REST interface for the db as part of the hack day today... Hmmmm...
| author | lukestokes |
|---|---|
| permlink | re-arcange-re-lukestokes-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t131749722z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"links":["http://www.restfest.org/"]} |
| created | 2016-09-15 13:17:48 |
| last_update | 2016-09-15 13:17:48 |
| depth | 3 |
| children | 2 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 162 |
| author_reputation | 554,601,966,217,919 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,253,679 |
| net_rshares | 0 |
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!
| author | marianozetax |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20190111t025008323z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2019-01-11 02:50:06 |
| last_update | 2019-01-11 02:50:06 |
| depth | 1 |
| children | 1 |
| last_payout | 2019-01-18 02:50: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 | 164 |
| author_reputation | 25,026,485,169 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 78,209,733 |
| net_rshares | 532,031,354 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| marianozetax | 0 | 532,031,354 | 100% |
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](https://steemit.com/steemsql/@arcange/steemsql-is-moving-to-a-monthly-subscription-model) Please visit [steemsql.com](http://steemsql.com) for more information.
| author | arcange |
|---|---|
| permlink | re-marianozetax-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20190111t090359849z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"links":["https://steemit.com/steemsql/@arcange/steemsql-is-moving-to-a-monthly-subscription-model","http://steemsql.com"],"app":"steemit/0.1"} |
| created | 2019-01-11 09:04:00 |
| last_update | 2019-01-11 09:04:00 |
| depth | 2 |
| children | 0 |
| last_payout | 2019-01-18 09:04: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 | 358 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 78,220,209 |
| net_rshares | 556,000,000 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| marianozetax | 0 | 556,000,000 | 100% |
Hi @arcange. Is this sever offline or no longer available?
| author | mellofello |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20180717t144608006z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"users":["arcange"],"app":"steemit/0.1"} |
| created | 2018-07-17 14:46:09 |
| last_update | 2018-07-17 14:46:09 |
| depth | 1 |
| children | 0 |
| last_payout | 2018-07-24 14:46:09 |
| 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 | 59 |
| author_reputation | 67,078,537,643,577 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 65,000,334 |
| net_rshares | 0 |
This is awesome! Thank you for your effort.
| author | segyepark |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20170707t084359286z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2017-07-07 08:44:00 |
| last_update | 2017-07-07 08:44:00 |
| depth | 1 |
| children | 0 |
| last_payout | 2017-07-14 08:44: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 | 43 |
| author_reputation | 38,236,253,472,970 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 7,619,968 |
| net_rshares | 0 |
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.
| author | steempowerwhale |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t120122950z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-13 12:01:24 |
| last_update | 2016-09-13 12:01:24 |
| depth | 1 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 151 |
| author_reputation | 6,727,613,422,973 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,230,877 |
| net_rshares | 4,947,371,102 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| arcange | 0 | 2,180,288,711 | 100% | ||
| bitcoiner | 0 | 2,767,082,391 | 50% |
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
| author | arcange |
|---|---|
| permlink | re-steempowerwhale-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t121423505z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-13 12:14:24 |
| last_update | 2016-09-13 12:14:24 |
| depth | 2 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 129 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,230,968 |
| net_rshares | 0 |
Why MS SQL server, and not something more open like MySQL or PostgreSQL?
| author | stef |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20171004t084101056z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2017-10-04 08:41:00 |
| last_update | 2017-10-04 08:41:00 |
| depth | 1 |
| children | 1 |
| last_payout | 2017-10-11 08:41:00 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.030 HBD |
| curator_payout_value | 0.009 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 72 |
| author_reputation | 5,748,720,157,910 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 16,744,105 |
| net_rshares | 16,116,801,949 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| stef | 0 | 16,116,801,949 | 100% |
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.
| author | arcange |
|---|---|
| permlink | re-stef-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20171004t105232503z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2017-10-04 10:52:33 |
| last_update | 2017-10-04 10:52:33 |
| depth | 2 |
| children | 0 |
| last_payout | 2017-10-11 10:52: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 | 319 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 16,752,598 |
| net_rshares | 0 |
| author | stef |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20180131t194214130z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2018-01-31 19:42:12 |
| last_update | 2018-01-31 19:42:12 |
| depth | 1 |
| children | 1 |
| last_payout | 2018-02-07 19:42:12 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.520 HBD |
| curator_payout_value | 0.007 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 72 |
| author_reputation | 5,748,720,157,910 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 33,934,203 |
| net_rshares | 85,202,677,085 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| stef | 0 | 75,228,509,229 | 100% | ||
| irena19 | 0 | 9,974,167,856 | 100% |
it has moved to a monthly subscription model.
| author | justyy |
|---|---|
| permlink | re-stef-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20180201t004853991z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2018-02-01 00:48:57 |
| last_update | 2018-02-01 00:48:57 |
| depth | 2 |
| children | 0 |
| last_payout | 2018-02-08 00:48:57 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.066 HBD |
| curator_payout_value | 0.021 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 45 |
| author_reputation | 280,616,224,641,976 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 33,990,927 |
| net_rshares | 14,543,325,426 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| stef | 0 | 14,543,325,426 | 20% | ||
| noble-noah | 0 | 0 | 100% |
Cool!
| author | stranger27 |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t180811653z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-14 18:08:12 |
| last_update | 2016-09-14 18:08:12 |
| depth | 1 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 5 |
| author_reputation | 49,275,349,388,874 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,245,525 |
| net_rshares | 2,710,137,412 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| arcange | 0 | 2,710,137,412 | 100% |
Thanks!
| author | arcange |
|---|---|
| permlink | re-stranger27-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t125723515z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-15 12:57:24 |
| last_update | 2016-09-15 12:57:24 |
| depth | 2 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 7 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,253,480 |
| net_rshares | 0 |
hi @arcange, Is this database still working ? If yes Then I am not able to connect to server using Sql server management studio.
| author | vaibhavshah |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20170704t145415526z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"users":["arcange"],"app":"steemit/0.1"} |
| created | 2017-07-04 14:54:18 |
| last_update | 2017-07-04 14:54:18 |
| depth | 1 |
| children | 1 |
| last_payout | 2017-07-11 14:54:18 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.136 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 128 |
| author_reputation | 3,427,641,457,033 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 7,286,228 |
| net_rshares | 21,580,829,700 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| vaibhavshah | 0 | 21,580,829,700 | 100% |
I am able to connect just fine.
| author | luvabi |
|---|---|
| permlink | re-vaibhavshah-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20170731t055643658z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2017-07-31 05:56:45 |
| last_update | 2017-07-31 05:56:45 |
| depth | 2 |
| children | 0 |
| last_payout | 2017-08-07 05:56:45 |
| 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 | 31 |
| author_reputation | 11,110,964,205,667 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 10,288,431 |
| net_rshares | 0 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| magicmonk | 0 | 0 | 100% |
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!
| author | williambanks |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t190858786z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-14 19:08:51 |
| last_update | 2016-09-14 19:08:51 |
| depth | 1 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 361 |
| author_reputation | 90,708,691,850,244 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,246,073 |
| net_rshares | 2,764,340,160 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| arcange | 0 | 2,764,340,160 | 100% | ||
| steemiest | 0 | 0 | 100% |
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 !
| author | arcange |
|---|---|
| permlink | re-williambanks-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t084720877z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-15 08:47:21 |
| last_update | 2016-09-15 08:47:21 |
| depth | 2 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 292 |
| author_reputation | 1,146,606,926,313,931 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,251,997 |
| net_rshares | 0 |