VOTING POWER100.00%
DOWNVOTE POWER100.00%
RESOURCE CREDITS100.00%
REPUTATION PROGRESS33.84%
Net Worth
4.983USD
STEEM
96.175STEEM
SBD
1.218SBD
Effective Power
5.011SP
├── Own SP
1.758SP
└── Incoming DelegationsDeleg
+3.253SP
Detailed Balance
| STEEM | ||
| balance | 96.175STEEM | STEEM |
| market_balance | 0.000STEEM | STEEM |
| savings_balance | 0.000STEEM | STEEM |
| reward_steem_balance | 0.000STEEM | STEEM |
| STEEM POWER | ||
| Own SP | 1.758SP | SP |
| Delegated Out | 0.000SP | SP |
| Delegation In | 3.253SP | SP |
| Effective Power | 5.011SP | SP |
| Reward SP (pending) | 0.002SP | SP |
| SBD | ||
| sbd_balance | 1.218SBD | SBD |
| sbd_conversions | 0.000SBD | SBD |
| sbd_market_balance | 0.000SBD | SBD |
| savings_sbd_balance | 0.000SBD | SBD |
| reward_sbd_balance | 0.000SBD | SBD |
{
"balance": "96.175 STEEM",
"savings_balance": "0.000 STEEM",
"reward_steem_balance": "0.000 STEEM",
"vesting_shares": "2856.501929 VESTS",
"delegated_vesting_shares": "0.000000 VESTS",
"received_vesting_shares": "5287.157877 VESTS",
"sbd_balance": "1.218 SBD",
"savings_sbd_balance": "0.000 SBD",
"reward_sbd_balance": "0.000 SBD",
"conversions": []
}Account Info
| name | querystorm |
| id | 776688 |
| rank | 542,848 |
| reputation | 23492443601 |
| created | 2018-02-28T12:35:36 |
| recovery_account | steem |
| proxy | None |
| post_count | 2 |
| comment_count | 0 |
| lifetime_vote_count | 0 |
| witnesses_voted_for | 0 |
| last_post | 2018-06-05T17:14:45 |
| last_root_post | 2018-06-05T16:57:57 |
| last_vote_time | 2018-03-26T12:59:00 |
| proxied_vsf_votes | 0, 0, 0, 0 |
| can_vote | 1 |
| voting_power | 0 |
| delayed_votes | 0 |
| balance | 96.175 STEEM |
| savings_balance | 0.000 STEEM |
| sbd_balance | 1.218 SBD |
| savings_sbd_balance | 0.000 SBD |
| vesting_shares | 2856.501929 VESTS |
| delegated_vesting_shares | 0.000000 VESTS |
| received_vesting_shares | 5287.157877 VESTS |
| reward_vesting_balance | 3.698588 VESTS |
| vesting_balance | 0.000 STEEM |
| vesting_withdraw_rate | 0.000000 VESTS |
| next_vesting_withdrawal | 1969-12-31T23:59:59 |
| withdrawn | 0 |
| to_withdraw | 0 |
| withdraw_routes | 0 |
| savings_withdraw_requests | 0 |
| last_account_recovery | 1970-01-01T00:00:00 |
| reset_account | null |
| last_owner_update | 1970-01-01T00:00:00 |
| last_account_update | 1970-01-01T00:00:00 |
| mined | No |
| sbd_seconds | 0 |
| sbd_last_interest_payment | 2021-10-28T10:47:57 |
| savings_sbd_last_interest_payment | 1970-01-01T00:00:00 |
{
"id": 776688,
"name": "querystorm",
"owner": {
"weight_threshold": 1,
"account_auths": [],
"key_auths": [
[
"STM6tkLFx4YpwMWXR5YhEC77WB4nHhZmPjjv1MVoLz27xWwk8AfLn",
1
]
]
},
"active": {
"weight_threshold": 1,
"account_auths": [],
"key_auths": [
[
"STM4z5MxGHgWgmph6F891hu7dDCoMN8XBZAxEPYjbBDyQthSYQYqG",
1
]
]
},
"posting": {
"weight_threshold": 1,
"account_auths": [],
"key_auths": [
[
"STM7bC8hdhFoCyJ2WR4yaLwswkzmY4fd6b6WUrNuQ9NMHmKmAXKAU",
1
]
]
},
"memo_key": "STM7A4d99DUwcLkuCyC9pD25qKqWSUWnnKL2WXnT3iPRjjmRA2Csd",
"json_metadata": "",
"posting_json_metadata": "",
"proxy": "",
"last_owner_update": "1970-01-01T00:00:00",
"last_account_update": "1970-01-01T00:00:00",
"created": "2018-02-28T12:35:36",
"mined": false,
"recovery_account": "steem",
"last_account_recovery": "1970-01-01T00:00:00",
"reset_account": "null",
"comment_count": 0,
"lifetime_vote_count": 0,
"post_count": 2,
"can_vote": true,
"voting_manabar": {
"current_mana": "8143659806",
"last_update_time": 1779081735
},
"downvote_manabar": {
"current_mana": 2035914951,
"last_update_time": 1779081735
},
"voting_power": 0,
"balance": "96.175 STEEM",
"savings_balance": "0.000 STEEM",
"sbd_balance": "1.218 SBD",
"sbd_seconds": "0",
"sbd_seconds_last_update": "2021-10-28T10:47:57",
"sbd_last_interest_payment": "2021-10-28T10:47:57",
"savings_sbd_balance": "0.000 SBD",
"savings_sbd_seconds": "0",
"savings_sbd_seconds_last_update": "1970-01-01T00:00:00",
"savings_sbd_last_interest_payment": "1970-01-01T00:00:00",
"savings_withdraw_requests": 0,
"reward_sbd_balance": "0.000 SBD",
"reward_steem_balance": "0.000 STEEM",
"reward_vesting_balance": "3.698588 VESTS",
"reward_vesting_steem": "0.002 STEEM",
"vesting_shares": "2856.501929 VESTS",
"delegated_vesting_shares": "0.000000 VESTS",
"received_vesting_shares": "5287.157877 VESTS",
"vesting_withdraw_rate": "0.000000 VESTS",
"next_vesting_withdrawal": "1969-12-31T23:59:59",
"withdrawn": 0,
"to_withdraw": 0,
"withdraw_routes": 0,
"curation_rewards": 7,
"posting_rewards": 1791,
"proxied_vsf_votes": [
0,
0,
0,
0
],
"witnesses_voted_for": 0,
"last_post": "2018-06-05T17:14:45",
"last_root_post": "2018-06-05T16:57:57",
"last_vote_time": "2018-03-26T12:59:00",
"post_bandwidth": 0,
"pending_claimed_accounts": 0,
"vesting_balance": "0.000 STEEM",
"reputation": "23492443601",
"transfer_history": [],
"market_history": [],
"post_history": [],
"vote_history": [],
"other_history": [],
"witness_votes": [],
"tags_usage": [],
"guest_bloggers": [],
"rank": 542848
}Withdraw Routes
| Incoming | Outgoing |
|---|---|
Empty | Empty |
{
"incoming": [],
"outgoing": []
}From Date
To Date
steemdelegated 3.253 SP to @querystorm2026/05/18 05:22:15
steemdelegated 3.253 SP to @querystorm
2026/05/18 05:22:15
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 5287.157877 VESTS |
| Transaction Info | Block #106149562/Trx d01cd67ea704a056add3ec0e18f70f10708640cd |
View Raw JSON Data
{
"trx_id": "d01cd67ea704a056add3ec0e18f70f10708640cd",
"block": 106149562,
"trx_in_block": 3,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2026-05-18T05:22:15",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "5287.157877 VESTS"
}
]
}steemdelegated 1.584 SP to @querystorm2026/05/13 00:37:18
steemdelegated 1.584 SP to @querystorm
2026/05/13 00:37:18
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 2574.947472 VESTS |
| Transaction Info | Block #106000592/Trx 757b339f135cac2e205fbc6ef99e626fcc15bd5c |
View Raw JSON Data
{
"trx_id": "757b339f135cac2e205fbc6ef99e626fcc15bd5c",
"block": 106000592,
"trx_in_block": 1,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2026-05-13T00:37:18",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "2574.947472 VESTS"
}
]
}steemdelegated 3.261 SP to @querystorm2026/04/26 04:35:27
steemdelegated 3.261 SP to @querystorm
2026/04/26 04:35:27
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 5299.673633 VESTS |
| Transaction Info | Block #105517074/Trx 5c83b08027c0286242c009482599bde6c0c17606 |
View Raw JSON Data
{
"trx_id": "5c83b08027c0286242c009482599bde6c0c17606",
"block": 105517074,
"trx_in_block": 0,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2026-04-26T04:35:27",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "5299.673633 VESTS"
}
]
}steemdelegated 1.610 SP to @querystorm2026/01/23 21:33:36
steemdelegated 1.610 SP to @querystorm
2026/01/23 21:33:36
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 2616.494291 VESTS |
| Transaction Info | Block #102868294/Trx 5947d220c80731803a5cb4c1f3e65ab1b9c9d503 |
View Raw JSON Data
{
"trx_id": "5947d220c80731803a5cb4c1f3e65ab1b9c9d503",
"block": 102868294,
"trx_in_block": 5,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2026-01-23T21:33:36",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "2616.494291 VESTS"
}
]
}steemdelegated 1.711 SP to @querystorm2024/12/17 16:44:27
steemdelegated 1.711 SP to @querystorm
2024/12/17 16:44:27
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 2780.713488 VESTS |
| Transaction Info | Block #91314524/Trx ab63046ec72f1ad54709d78c41cd03d6d3ccdde2 |
View Raw JSON Data
{
"trx_id": "ab63046ec72f1ad54709d78c41cd03d6d3ccdde2",
"block": 91314524,
"trx_in_block": 0,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2024-12-17T16:44:27",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "2780.713488 VESTS"
}
]
}steemdelegated 1.815 SP to @querystorm2023/11/14 08:25:51
steemdelegated 1.815 SP to @querystorm
2023/11/14 08:25:51
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 2949.847020 VESTS |
| Transaction Info | Block #79868681/Trx 5c157316d5bb9b6a29ee4b6034d68f2b813323b9 |
View Raw JSON Data
{
"trx_id": "5c157316d5bb9b6a29ee4b6034d68f2b813323b9",
"block": 79868681,
"trx_in_block": 4,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2023-11-14T08:25:51",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "2949.847020 VESTS"
}
]
}steemdelegated 3.622 SP to @querystorm2023/09/22 09:18:06
steemdelegated 3.622 SP to @querystorm
2023/09/22 09:18:06
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 5886.755806 VESTS |
| Transaction Info | Block #78361561/Trx c929cd35e1e9c7f4c964761d612b04a8c549de0d |
View Raw JSON Data
{
"trx_id": "c929cd35e1e9c7f4c964761d612b04a8c549de0d",
"block": 78361561,
"trx_in_block": 1,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2023-09-22T09:18:06",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "5886.755806 VESTS"
}
]
}steemdelegated 3.823 SP to @querystorm2022/06/17 22:24:03
steemdelegated 3.823 SP to @querystorm
2022/06/17 22:24:03
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 6212.478187 VESTS |
| Transaction Info | Block #65148196/Trx f511b7d07059c73662335b92f3d98123c051794b |
View Raw JSON Data
{
"trx_id": "f511b7d07059c73662335b92f3d98123c051794b",
"block": 65148196,
"trx_in_block": 5,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2022-06-17T22:24:03",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "6212.478187 VESTS"
}
]
}querystormreceived 0.002 SP benefactor reward from @abandi2021/11/04 10:52:45
querystormreceived 0.002 SP benefactor reward from @abandi
2021/11/04 10:52:45
| benefactor | querystorm |
| author | abandi |
| permlink | are-great-profits-on-the-steem-blockchain-achievable-20211028t105245 |
| sbd payout | 0.000 SBD |
| steem payout | 0.000 STEEM |
| vesting payout | 3.698588 VESTS |
| Transaction Info | Block #58701771/Virtual Operation #8 |
View Raw JSON Data
{
"trx_id": "0000000000000000000000000000000000000000",
"block": 58701771,
"trx_in_block": 4294967295,
"op_in_trx": 0,
"virtual_op": 8,
"timestamp": "2021-11-04T10:52:45",
"op": [
"comment_benefactor_reward",
{
"benefactor": "querystorm",
"author": "abandi",
"permlink": "are-great-profits-on-the-steem-blockchain-achievable-20211028t105245",
"sbd_payout": "0.000 SBD",
"steem_payout": "0.000 STEEM",
"vesting_payout": "3.698588 VESTS"
}
]
}steemdelegated 3.934 SP to @querystorm2021/10/28 11:06:03
steemdelegated 3.934 SP to @querystorm
2021/10/28 11:06:03
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 6394.261006 VESTS |
| Transaction Info | Block #58501769/Trx 43d27a3c9c761185475b031412f8ed430d8954b3 |
View Raw JSON Data
{
"trx_id": "43d27a3c9c761185475b031412f8ed430d8954b3",
"block": 58501769,
"trx_in_block": 3,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2021-10-28T11:06:03",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "6394.261006 VESTS"
}
]
}querystormclaimed reward balance: 0.254 STEEM, 1.217 SBD, 1.120 SP2021/10/28 10:47:57
querystormclaimed reward balance: 0.254 STEEM, 1.217 SBD, 1.120 SP
2021/10/28 10:47:57
| account | querystorm |
| reward steem | 0.254 STEEM |
| reward sbd | 1.217 SBD |
| reward vests | 1820.678643 VESTS |
| Transaction Info | Block #58501408/Trx ee9b6201df86e50585e072bef9da0be7dad74667 |
View Raw JSON Data
{
"trx_id": "ee9b6201df86e50585e072bef9da0be7dad74667",
"block": 58501408,
"trx_in_block": 7,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2021-10-28T10:47:57",
"op": [
"claim_reward_balance",
{
"account": "querystorm",
"reward_steem": "0.254 STEEM",
"reward_sbd": "1.217 SBD",
"reward_vests": "1820.678643 VESTS"
}
]
}steemdelegated 5.128 SP to @querystorm2021/06/14 05:25:12
steemdelegated 5.128 SP to @querystorm
2021/06/14 05:25:12
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 8333.787776 VESTS |
| Transaction Info | Block #54613212/Trx 53e037fdcaf507a777ff391a69458c9bc8656d40 |
View Raw JSON Data
{
"trx_id": "53e037fdcaf507a777ff391a69458c9bc8656d40",
"block": 54613212,
"trx_in_block": 13,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2021-06-14T05:25:12",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "8333.787776 VESTS"
}
]
}steemdelegated 5.243 SP to @querystorm2020/12/11 15:38:15
steemdelegated 5.243 SP to @querystorm
2020/12/11 15:38:15
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 8521.209750 VESTS |
| Transaction Info | Block #49360501/Trx 51bc860a5e40644556a6d55885709c3d4289a3a3 |
View Raw JSON Data
{
"trx_id": "51bc860a5e40644556a6d55885709c3d4289a3a3",
"block": 49360501,
"trx_in_block": 0,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2020-12-11T15:38:15",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "8521.209750 VESTS"
}
]
}steemdelegated 1.177 SP to @querystorm2020/12/06 09:14:18
steemdelegated 1.177 SP to @querystorm
2020/12/06 09:14:18
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 1912.543513 VESTS |
| Transaction Info | Block #49212029/Trx 64f8f6f184d7c0192f9e52071c32f03d183af206 |
View Raw JSON Data
{
"trx_id": "64f8f6f184d7c0192f9e52071c32f03d183af206",
"block": 49212029,
"trx_in_block": 1,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2020-12-06T09:14:18",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "1912.543513 VESTS"
}
]
}steemdelegated 5.247 SP to @querystorm2020/12/05 19:16:09
steemdelegated 5.247 SP to @querystorm
2020/12/05 19:16:09
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 8527.417604 VESTS |
| Transaction Info | Block #49195585/Trx 2aa6eb2d7db1679636a5d25edb49f63defa62c1c |
View Raw JSON Data
{
"trx_id": "2aa6eb2d7db1679636a5d25edb49f63defa62c1c",
"block": 49195585,
"trx_in_block": 7,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2020-12-05T19:16:09",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "8527.417604 VESTS"
}
]
}steemdelegated 1.181 SP to @querystorm2020/11/03 00:58:57
steemdelegated 1.181 SP to @querystorm
2020/11/03 00:58:57
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 1920.017158 VESTS |
| Transaction Info | Block #48268804/Trx 3580a50fa1f8200424a30631b86a3776b2676361 |
View Raw JSON Data
{
"trx_id": "3580a50fa1f8200424a30631b86a3776b2676361",
"block": 48268804,
"trx_in_block": 3,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2020-11-03T00:58:57",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "1920.017158 VESTS"
}
]
}steemdelegated 5.372 SP to @querystorm2020/05/09 10:16:30
steemdelegated 5.372 SP to @querystorm
2020/05/09 10:16:30
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 8730.222963 VESTS |
| Transaction Info | Block #43222348/Trx 8ee059eb4d338560453f176d6310df2403210223 |
View Raw JSON Data
{
"trx_id": "8ee059eb4d338560453f176d6310df2403210223",
"block": 43222348,
"trx_in_block": 11,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2020-05-09T10:16:30",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "8730.222963 VESTS"
}
]
}steemdelegated 1.202 SP to @querystorm2020/05/08 14:33:24
steemdelegated 1.202 SP to @querystorm
2020/05/08 14:33:24
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 1953.311140 VESTS |
| Transaction Info | Block #43199245/Trx 0dd65240fc76c0f76c89f84c6a72094ad78cfe1f |
View Raw JSON Data
{
"trx_id": "0dd65240fc76c0f76c89f84c6a72094ad78cfe1f",
"block": 43199245,
"trx_in_block": 15,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2020-05-08T14:33:24",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "1953.311140 VESTS"
}
]
}2020/02/28 13:04:51
2020/02/28 13:04:51
| parent author | querystorm |
| parent permlink | i-wandered-off-and-built-an-ide |
| author | steemitboard |
| permlink | steemitboard-notify-querystorm-20200228t130450000z |
| title | |
| body | Congratulations @querystorm! You received a personal award! <table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@querystorm/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table> <sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@querystorm) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=querystorm)_</sub> ###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes! |
| json metadata | {"image":["https://steemitboard.com/img/notify.png"]} |
| Transaction Info | Block #41214915/Trx 5b29dcbd2da33a60fb52ec9ed4e1bf0e84e9196c |
View Raw JSON Data
{
"trx_id": "5b29dcbd2da33a60fb52ec9ed4e1bf0e84e9196c",
"block": 41214915,
"trx_in_block": 10,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2020-02-28T13:04:51",
"op": [
"comment",
{
"parent_author": "querystorm",
"parent_permlink": "i-wandered-off-and-built-an-ide",
"author": "steemitboard",
"permlink": "steemitboard-notify-querystorm-20200228t130450000z",
"title": "",
"body": "Congratulations @querystorm! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@querystorm/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@querystorm) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=querystorm)_</sub>\n\n\n###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!",
"json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}"
}
]
}steemdelegated 5.464 SP to @querystorm2019/08/19 14:59:42
steemdelegated 5.464 SP to @querystorm
2019/08/19 14:59:42
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 8880.335443 VESTS |
| Transaction Info | Block #35691746/Trx a0cb24e0b7413f49823cda520e845f3fa0a3600e |
View Raw JSON Data
{
"trx_id": "a0cb24e0b7413f49823cda520e845f3fa0a3600e",
"block": 35691746,
"trx_in_block": 30,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2019-08-19T14:59:42",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "8880.335443 VESTS"
}
]
}2019/02/28 14:23:57
2019/02/28 14:23:57
| parent author | querystorm |
| parent permlink | i-wandered-off-and-built-an-ide |
| author | steemitboard |
| permlink | steemitboard-notify-querystorm-20190228t142356000z |
| title | |
| body | Congratulations @querystorm! You received a personal award! <table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@querystorm/birthday1.png</td><td>Happy Birthday! - You are on the Steem blockchain for 1 year!</td></tr></table> <sub>_[Click here to view your Board](https://steemitboard.com/@querystorm)_</sub> **Do not miss the last post from @steemitboard:** <table><tr><td><a href="https://steemit.com/carnival/@steemitboard/carnival-2019"><img src="https://steemitimages.com/64x128/http://i.cubeupload.com/rltzHT.png"></a></td><td><a href="https://steemit.com/carnival/@steemitboard/carnival-2019">Carnival Challenge - Collect badge and win 5 STEEM</a></td></tr></table> ###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) and get one more award and increased upvotes! |
| json metadata | {"image":["https://steemitboard.com/img/notify.png"]} |
| Transaction Info | Block #30745345/Trx 825d581833c87357dea2bdc07a272df4d567470e |
View Raw JSON Data
{
"trx_id": "825d581833c87357dea2bdc07a272df4d567470e",
"block": 30745345,
"trx_in_block": 8,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2019-02-28T14:23:57",
"op": [
"comment",
{
"parent_author": "querystorm",
"parent_permlink": "i-wandered-off-and-built-an-ide",
"author": "steemitboard",
"permlink": "steemitboard-notify-querystorm-20190228t142356000z",
"title": "",
"body": "Congratulations @querystorm! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@querystorm/birthday1.png</td><td>Happy Birthday! - You are on the Steem blockchain for 1 year!</td></tr></table>\n\n<sub>_[Click here to view your Board](https://steemitboard.com/@querystorm)_</sub>\n\n\n**Do not miss the last post from @steemitboard:**\n<table><tr><td><a href=\"https://steemit.com/carnival/@steemitboard/carnival-2019\"><img src=\"https://steemitimages.com/64x128/http://i.cubeupload.com/rltzHT.png\"></a></td><td><a href=\"https://steemit.com/carnival/@steemitboard/carnival-2019\">Carnival Challenge - Collect badge and win 5 STEEM</a></td></tr></table>\n\n###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) and get one more award and increased upvotes!",
"json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}"
}
]
}steemdelegated 5.586 SP to @querystorm2018/09/05 07:23:57
steemdelegated 5.586 SP to @querystorm
2018/09/05 07:23:57
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 9078.695083 VESTS |
| Transaction Info | Block #25687488/Trx 6e6966f1ffe1f145bd00d3fe169dae9d3493babd |
View Raw JSON Data
{
"trx_id": "6e6966f1ffe1f145bd00d3fe169dae9d3493babd",
"block": 25687488,
"trx_in_block": 16,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-09-05T07:23:57",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "9078.695083 VESTS"
}
]
}marcin648upvoted (100.00%) @querystorm / i-wandered-off-and-built-an-ide2018/06/13 11:05:57
marcin648upvoted (100.00%) @querystorm / i-wandered-off-and-built-an-ide
2018/06/13 11:05:57
| voter | marcin648 |
| author | querystorm |
| permlink | i-wandered-off-and-built-an-ide |
| weight | 10000 (100.00%) |
| Transaction Info | Block #23284093/Trx ce059b1590945bcf481509484907f821fb0f5209 |
View Raw JSON Data
{
"trx_id": "ce059b1590945bcf481509484907f821fb0f5209",
"block": 23284093,
"trx_in_block": 28,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-13T11:05:57",
"op": [
"vote",
{
"voter": "marcin648",
"author": "querystorm",
"permlink": "i-wandered-off-and-built-an-ide",
"weight": 10000
}
]
}querystormreceived 0.254 STEEM, 1.217 SBD, 1.120 SP author reward for @querystorm / i-wandered-off-and-built-an-ide2018/06/12 16:57:57
querystormreceived 0.254 STEEM, 1.217 SBD, 1.120 SP author reward for @querystorm / i-wandered-off-and-built-an-ide
2018/06/12 16:57:57
| author | querystorm |
| permlink | i-wandered-off-and-built-an-ide |
| sbd payout | 1.217 SBD |
| steem payout | 0.254 STEEM |
| vesting payout | 1820.678643 VESTS |
| Transaction Info | Block #23262335/Virtual Operation #35 |
View Raw JSON Data
{
"trx_id": "0000000000000000000000000000000000000000",
"block": 23262335,
"trx_in_block": 4294967295,
"op_in_trx": 0,
"virtual_op": 35,
"timestamp": "2018-06-12T16:57:57",
"op": [
"author_reward",
{
"author": "querystorm",
"permlink": "i-wandered-off-and-built-an-ide",
"sbd_payout": "1.217 SBD",
"steem_payout": "0.254 STEEM",
"vesting_payout": "1820.678643 VESTS"
}
]
}2018/06/06 17:43:54
2018/06/06 17:43:54
| parent author | querystorm |
| parent permlink | i-wandered-off-and-built-an-ide |
| author | steemitboard |
| permlink | steemitboard-notify-querystorm-20180606t174356000z |
| title | |
| body | Congratulations @querystorm! You have completed some achievement on Steemit and have been rewarded with new badge(s) : [](http://steemitboard.com/@querystorm) You published your First Post [](http://steemitboard.com/@querystorm) You made your First Comment [](http://steemitboard.com/@querystorm) You got a First Vote <sub>_Click on the badge to view your Board of Honor._</sub> <sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub> > Do you like [SteemitBoard's project](https://steemit.com/@steemitboard)? Then **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**! |
| json metadata | {"image":["https://steemitboard.com/img/notify.png"]} |
| Transaction Info | Block #23091069/Trx 736d233e95e167a854789ab679ed6f09a2d7bdc9 |
View Raw JSON Data
{
"trx_id": "736d233e95e167a854789ab679ed6f09a2d7bdc9",
"block": 23091069,
"trx_in_block": 54,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-06T17:43:54",
"op": [
"comment",
{
"parent_author": "querystorm",
"parent_permlink": "i-wandered-off-and-built-an-ide",
"author": "steemitboard",
"permlink": "steemitboard-notify-querystorm-20180606t174356000z",
"title": "",
"body": "Congratulations @querystorm! You have completed some achievement on Steemit and have been rewarded with new badge(s) :\n\n[](http://steemitboard.com/@querystorm) You published your First Post\n[](http://steemitboard.com/@querystorm) You made your First Comment\n[](http://steemitboard.com/@querystorm) You got a First Vote\n\n<sub>_Click on the badge to view your Board of Honor._</sub>\n<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>\n\n\n\n> Do you like [SteemitBoard's project](https://steemit.com/@steemitboard)? Then **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!",
"json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}"
}
]
}querystormclaimed reward balance: 0.009 SP2018/06/06 07:09:00
querystormclaimed reward balance: 0.009 SP
2018/06/06 07:09:00
| account | querystorm |
| reward steem | 0.000 STEEM |
| reward sbd | 0.000 SBD |
| reward vests | 14.276925 VESTS |
| Transaction Info | Block #23078373/Trx 8f0267e546a2706a3a38633fb4fa0cf886a60e88 |
View Raw JSON Data
{
"trx_id": "8f0267e546a2706a3a38633fb4fa0cf886a60e88",
"block": 23078373,
"trx_in_block": 54,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-06T07:09:00",
"op": [
"claim_reward_balance",
{
"account": "querystorm",
"reward_steem": "0.000 STEEM",
"reward_sbd": "0.000 SBD",
"reward_vests": "14.276925 VESTS"
}
]
}sensationupvoted (100.00%) @querystorm / i-wandered-off-and-built-an-ide2018/06/05 17:54:15
sensationupvoted (100.00%) @querystorm / i-wandered-off-and-built-an-ide
2018/06/05 17:54:15
| voter | sensation |
| author | querystorm |
| permlink | i-wandered-off-and-built-an-ide |
| weight | 10000 (100.00%) |
| Transaction Info | Block #23062482/Trx 9296a7b95aa559eae03ff049260c8023e5d833aa |
View Raw JSON Data
{
"trx_id": "9296a7b95aa559eae03ff049260c8023e5d833aa",
"block": 23062482,
"trx_in_block": 48,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-05T17:54:15",
"op": [
"vote",
{
"voter": "sensation",
"author": "querystorm",
"permlink": "i-wandered-off-and-built-an-ide",
"weight": 10000
}
]
}2018/06/05 17:40:21
2018/06/05 17:40:21
| voter | ben-jamin |
| author | querystorm |
| permlink | re-querystorm-i-wandered-off-and-built-an-ide-20180605t171443128z |
| weight | 10000 (100.00%) |
| Transaction Info | Block #23062204/Trx 93e290b261aee9264bc029bdc69c704afe165d8f |
View Raw JSON Data
{
"trx_id": "93e290b261aee9264bc029bdc69c704afe165d8f",
"block": 23062204,
"trx_in_block": 25,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-05T17:40:21",
"op": [
"vote",
{
"voter": "ben-jamin",
"author": "querystorm",
"permlink": "re-querystorm-i-wandered-off-and-built-an-ide-20180605t171443128z",
"weight": 10000
}
]
}ben-jaminupvoted (100.00%) @querystorm / i-wandered-off-and-built-an-ide2018/06/05 17:39:54
ben-jaminupvoted (100.00%) @querystorm / i-wandered-off-and-built-an-ide
2018/06/05 17:39:54
| voter | ben-jamin |
| author | querystorm |
| permlink | i-wandered-off-and-built-an-ide |
| weight | 10000 (100.00%) |
| Transaction Info | Block #23062195/Trx c9b8f4082fa9eff7d9cc05a90d8cec3ab1593549 |
View Raw JSON Data
{
"trx_id": "c9b8f4082fa9eff7d9cc05a90d8cec3ab1593549",
"block": 23062195,
"trx_in_block": 6,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-05T17:39:54",
"op": [
"vote",
{
"voter": "ben-jamin",
"author": "querystorm",
"permlink": "i-wandered-off-and-built-an-ide",
"weight": 10000
}
]
}querystormfollowed @introduce.bot2018/06/05 17:30:48
querystormfollowed @introduce.bot
2018/06/05 17:30:48
| required auths | [] |
| required posting auths | ["querystorm"] |
| id | follow |
| json | ["follow",{"follower":"querystorm","following":"introduce.bot","what":["blog"]}] |
| Transaction Info | Block #23062013/Trx ebbf30a8bfdc0e7e9fa6ec5123cc8406ed40f51c |
View Raw JSON Data
{
"trx_id": "ebbf30a8bfdc0e7e9fa6ec5123cc8406ed40f51c",
"block": 23062013,
"trx_in_block": 25,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-05T17:30:48",
"op": [
"custom_json",
{
"required_auths": [],
"required_posting_auths": [
"querystorm"
],
"id": "follow",
"json": "[\"follow\",{\"follower\":\"querystorm\",\"following\":\"introduce.bot\",\"what\":[\"blog\"]}]"
}
]
}noisyupvoted (100.00%) @querystorm / i-wandered-off-and-built-an-ide2018/06/05 17:28:57
noisyupvoted (100.00%) @querystorm / i-wandered-off-and-built-an-ide
2018/06/05 17:28:57
| voter | noisy |
| author | querystorm |
| permlink | i-wandered-off-and-built-an-ide |
| weight | 10000 (100.00%) |
| Transaction Info | Block #23061976/Trx 28f8149f142e5e24d923f32e03535c2211fa5745 |
View Raw JSON Data
{
"trx_id": "28f8149f142e5e24d923f32e03535c2211fa5745",
"block": 23061976,
"trx_in_block": 14,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-05T17:28:57",
"op": [
"vote",
{
"voter": "noisy",
"author": "querystorm",
"permlink": "i-wandered-off-and-built-an-ide",
"weight": 10000
}
]
}2018/06/05 17:28:18
2018/06/05 17:28:18
| parent author | querystorm |
| parent permlink | i-wandered-off-and-built-an-ide |
| author | introduce.bot |
| permlink | introduce-bot-re-querystormi-wandered-off-and-built-an-ide |
| title | |
| body | ✅ @querystorm, I gave you an upvote on your first post! **Please give me a follow** and I will give you a follow in return!<br><br>Please also take a moment to read [this post](https://steemit.com/spam/@pleasestop/introducing-pleasestop-here-to-reduce-comment-spam) regarding bad behavior on Steemit. |
| json metadata | |
| Transaction Info | Block #23061963/Trx 981818aec275dbee38a8d5fea561cfb158701c62 |
View Raw JSON Data
{
"trx_id": "981818aec275dbee38a8d5fea561cfb158701c62",
"block": 23061963,
"trx_in_block": 3,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-05T17:28:18",
"op": [
"comment",
{
"parent_author": "querystorm",
"parent_permlink": "i-wandered-off-and-built-an-ide",
"author": "introduce.bot",
"permlink": "introduce-bot-re-querystormi-wandered-off-and-built-an-ide",
"title": "",
"body": "✅ @querystorm, I gave you an upvote on your first post! **Please give me a follow** and I will give you a follow in return!<br><br>Please also take a moment to read [this post](https://steemit.com/spam/@pleasestop/introducing-pleasestop-here-to-reduce-comment-spam) regarding bad behavior on Steemit.",
"json_metadata": ""
}
]
}introduce.botupvoted (1.69%) @querystorm / i-wandered-off-and-built-an-ide2018/06/05 17:28:15
introduce.botupvoted (1.69%) @querystorm / i-wandered-off-and-built-an-ide
2018/06/05 17:28:15
| voter | introduce.bot |
| author | querystorm |
| permlink | i-wandered-off-and-built-an-ide |
| weight | 169 (1.69%) |
| Transaction Info | Block #23061962/Trx af4a575c1254d08c75928fb3c8ba110bca830ff1 |
View Raw JSON Data
{
"trx_id": "af4a575c1254d08c75928fb3c8ba110bca830ff1",
"block": 23061962,
"trx_in_block": 31,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-05T17:28:15",
"op": [
"vote",
{
"voter": "introduce.bot",
"author": "querystorm",
"permlink": "i-wandered-off-and-built-an-ide",
"weight": 169
}
]
}2018/06/05 17:14:45
2018/06/05 17:14:45
| parent author | querystorm |
| parent permlink | i-wandered-off-and-built-an-ide |
| author | querystorm |
| permlink | re-querystorm-i-wandered-off-and-built-an-ide-20180605t171443128z |
| title | |
| body | Posted this on reddit and hn a little while ago. Figured it might make for a good first steemit post too. |
| json metadata | {"tags":["ide"],"app":"steemit/0.1"} |
| Transaction Info | Block #23061692/Trx 3aa2fd3b1ab88334f22f8d3f48bfceb76737211b |
View Raw JSON Data
{
"trx_id": "3aa2fd3b1ab88334f22f8d3f48bfceb76737211b",
"block": 23061692,
"trx_in_block": 34,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-05T17:14:45",
"op": [
"comment",
{
"parent_author": "querystorm",
"parent_permlink": "i-wandered-off-and-built-an-ide",
"author": "querystorm",
"permlink": "re-querystorm-i-wandered-off-and-built-an-ide-20180605t171443128z",
"title": "",
"body": "Posted this on reddit and hn a little while ago. Figured it might make for a good first steemit post too.",
"json_metadata": "{\"tags\":[\"ide\"],\"app\":\"steemit/0.1\"}"
}
]
}ax3upvoted (1.00%) @querystorm / i-wandered-off-and-built-an-ide2018/06/05 16:58:12
ax3upvoted (1.00%) @querystorm / i-wandered-off-and-built-an-ide
2018/06/05 16:58:12
| voter | ax3 |
| author | querystorm |
| permlink | i-wandered-off-and-built-an-ide |
| weight | 100 (1.00%) |
| Transaction Info | Block #23061361/Trx a0e8d6027e70e15c3784b15c7dd31e9b60eb58f7 |
View Raw JSON Data
{
"trx_id": "a0e8d6027e70e15c3784b15c7dd31e9b60eb58f7",
"block": 23061361,
"trx_in_block": 9,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-05T16:58:12",
"op": [
"vote",
{
"voter": "ax3",
"author": "querystorm",
"permlink": "i-wandered-off-and-built-an-ide",
"weight": 100
}
]
}querystormpublished a new post: i-wandered-off-and-built-an-ide2018/06/05 16:57:57
querystormpublished a new post: i-wandered-off-and-built-an-ide
2018/06/05 16:57:57
| parent author | |
| parent permlink | ide |
| author | querystorm |
| permlink | i-wandered-off-and-built-an-ide |
| title | I wandered off and built an IDE |
| body | A few years ago, I set out to build a small Excel plugin to help out my girlfriend at the time. I ended up building a full-blown IDE over the course of four years and spent the winter in Poland in a startup accelerator.  How did this happen? As with many great endeavors of man, this one also started in order to impress a girl. Back in 2014, my girlfriend, let’s call her Anna, was having a hard time dealing with data in Excel files. Anna worked in quality control in a large pharma company. Every month or two, she’d start bringing home this soul-crushing pile of Excel files to work on, often over evenings and weekends. I wasn’t too happy about this since I had other plans for our evenings and weekends, but it did give me a chance to show off my superior tech skills so I wasn’t too sad about it. You might be surprised to learn that in a developer’s life, there aren’t all that many chances to impress girls with your coding skills. Anyway, I took a look at the Excel files she was bringing home and they were basically huge tables of data exported from various systems. She had to alchemy this data into several reports and the way to do it was to carefully follow the several dozen manual steps that were laid out in an arcane word document prepared by God-only-knows-who some years before. I looked at it carefully, and it turned out that what she needed to do would have been a few 10-line queries in SQL. In Excel, though, it was several days worth of vlookup-index-match-temporarycolumn-pivottable-copypaste-HELL. My first thought was importing the data into a database, processing it there and exporting it back. But this task was something she needed to do often and she didn’t have any database experience so this wasn’t an option. So anyway, I had built some plugins for Excel before, and I figured I could probably build something that would automate at least a part of her task, after which I would be seen and admired by her as the hero that I was. The first thing I wanted to implement was joining tables. So, I rolled up my sleeves and eagerly set out to reinvent the wheel. It took about an hour for me to realize that there already existed these mysterious softwares that have the ability to join tables of data. The idea struck me like a lightning bolt: I could put a small database engine (SQLite) into my plugin, load Excel data into it and query the crap out of it six ways from Sunday. In the UI of my plugin, I’d give the handsome user (myself) a textbox for writing the queries and a grid for displaying results. This was going to be great! It took a few days to build the first version. It was butt-ugly and looked like it was designed according to whatever the opposite to Feng Shui is, but it worked nicely. I could load data from Excel with the click of a button, type my SQL query into the textbox and run it by pressing “Button2”. Once the plugin was ready, I sat down with a somewhat skeptical Anna and we prepared the queries for her use cases. I was seriously looking forward to the next time Anna would bring home the pile of Excel files. And bring them she did. And work spectacularly it did! Not to brag, but instead of several days, we were done with her reports in about an hour! There was still some manual copy-paste work to do (hence the hour), but the bulk of the work was done by the queries and SQLite. “I had done it”… I remember thinking… “I had stared the into the eyes of the Gods of the spreadsheet underworld, and the bastards flinched!”. Anna was impressed (ever so slightly and not nearly enough). Not only did I win Anna’s underwhelming admiration, but this was a general purpose solution that I could sell to other people! It was obvious there was only one way this could go, and only one question to answer: what color mansion would I like? So I posted about my plugin on Reddit/r/excel. The [response](https://www.reddit.com/r/excel/comments/2wv52m/ive_built_an_excel_plugin_for_using_sql_in_excel/) was very enthusiastic, people loved it! Close to 100 upvote’s worth of love. Encouraged, I continued working on it much to Anna’s annoyance, because now, instead of her spending time in Excel, I was. At one point she got so annoyed that she gave me an ultimatum: either her or the project. Anyway, the Reddit reception was encouraging but for some strange reason, I did not have thousands of people beating a path to my door to buy some licenses the next morning. It was quite obvious that there was something wrong with all these people who weren’t lining up to buy. After all, my ex-girlfriend Anna saves several days each month with it, and she can’t be the only one who could make good use of it. Perhaps the problem is auto-complete. Any serious tool needs autocomplete these days… What was I to do, my turquoise mansion was waiting for me just one auto-complete feature away. So, I dusted off my compiler theory books from college, picked up Antlr and built a parser for SQLite (with the help of a [SQLite grammar](https://github.com/antlr/grammars-v4/blob/master/sqlite/SQLite.g4) I found on GitHub). This was my favorite feature to build. With the parser in place, one by one I added all the cool features: auto-complete, error highlighting, symbol tooltips, bracket-matching, code formatting, function insights and star expansion. Then I added the ability to use external databases instead of SQLite, which made it possible to process Excel data with an external database but also to easily move data between Excel and databases. This was great: posts on Reddit, posts on HackerNews, money rolling in, licenses being bought. Still, it was only a few hundred – maybe up to a few thousand dollars per month. Careful calculations conclusively showed it wasn’t enough for a mansion. But, it was fun, and my corporate job wasn’t. I decided to quit and devote my time to a worthy project: my Excel plugin. Being a techy person, I wasn’t very keen to do any marketing and sales, though. I didn’t need those. So, fast forward to today, I completely ignored the business side of it and continued developing what I felt like developing. Inevitably, after a while, I was slowly starting to go broke, but I had a lot of fun developing features, yay! For example, I took Roslyn and used it to add C# support, intellisense and all. LINQ queries on Excel tables, for God’s sake, you can’t tell me that doesn’t make your heart beat just a little bit faster. At this point, a reasonable question to ask might be: “Why in God’s name would you build an IDE in Excel, I thought developers hate Excel?!”. And you’d be right, most developers don’t care much for Excel, but that’s only because it doesn’t actually have support for tech skills. But not everyone is technical, and spreadsheets are almost everywhere, especially in companies, so whether we want to or not, we have to deal with data in spreadsheets. Some good tech tools can come in quite handy there. Also, with C# for logic and the spreadsheet for presentation and storage, you can build some really smart documents really fast. Excel might not seem fashionable, but it’s really useful and in business, you can pretty much count on most people having it on their machines. So here are some of the interesting things you can do with QueryStorm: – [Using C# in Excel](https://www.querystorm.com/docs/csharp) – [Cross-database queries from SQLite](http://blog.querystorm.com/index.php/2018/04/02/querying-other-databases-from-sqlite/) – [C# user-defined functions for SQLite (in Excel)](http://blog.querystorm.com/index.php/2018/03/31/sqlite-with-c-sprinkles-on-top/) – [Prototyping with C# and Excel](http://blog.querystorm.com/index.php/2018/03/30/c-programming-in-excel/) – [Regex galore in Excel](http://blog.querystorm.com/index.php/2018/03/26/regex-magic-in-excel/) Anyway, a few months ago, by chance, a guy I know asked me if I wanted to apply to this Polish accelerator. I said, “Yeah, sure, sounds good”. He saw right through my cunning attempt at blowing him off and said “no yeah sure… APPLY, NOW MOT*******ER!”. Well, apply I did, and it was fantastic. I spent four months in Warsaw, met a bunch of really cool people, got some new friends, got financing and some useful new skills like presenting. Could have been worse, all in all. I’m really grateful both to Luka (the dude who made me apply) as well as to the [HugeThing](http://hugething.vc/) team. If QueryStorm succeeds on the market, it will be in no small part thanks to these amazing gentlefolk! So anyway, I have this IDE… [wanna check it out](https://www.querystorm.com/)? |
| json metadata | {"tags":["ide","csharp","sql","excel","entrepreneurship"],"image":["https://www.querystorm.com/images/Untitled-Project.gif"],"links":["https://www.reddit.com/r/excel/comments/2wv52m/ive_built_an_excel_plugin_for_using_sql_in_excel/","https://github.com/antlr/grammars-v4/blob/master/sqlite/SQLite.g4","https://www.querystorm.com/docs/csharp","http://blog.querystorm.com/index.php/2018/04/02/querying-other-databases-from-sqlite/","http://blog.querystorm.com/index.php/2018/03/31/sqlite-with-c-sprinkles-on-top/","http://blog.querystorm.com/index.php/2018/03/30/c-programming-in-excel/","http://blog.querystorm.com/index.php/2018/03/26/regex-magic-in-excel/","http://hugething.vc/","https://www.querystorm.com/"],"app":"steemit/0.1","format":"markdown"} |
| Transaction Info | Block #23061356/Trx 37195814e7087fe2e8e55779c63d922098a9bab1 |
View Raw JSON Data
{
"trx_id": "37195814e7087fe2e8e55779c63d922098a9bab1",
"block": 23061356,
"trx_in_block": 63,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-05T16:57:57",
"op": [
"comment",
{
"parent_author": "",
"parent_permlink": "ide",
"author": "querystorm",
"permlink": "i-wandered-off-and-built-an-ide",
"title": "I wandered off and built an IDE",
"body": "A few years ago, I set out to build a small Excel plugin to help out my girlfriend at the time. I ended up building a full-blown IDE over the course of four years and spent the winter in Poland in a startup accelerator.\n\n\n\nHow did this happen? As with many great endeavors of man, this one also started in order to impress a girl.\n\nBack in 2014, my girlfriend, let’s call her Anna, was having a hard time dealing with data in Excel files. Anna worked in quality control in a large pharma company. Every month or two, she’d start bringing home this soul-crushing pile of Excel files to work on, often over evenings and weekends. I wasn’t too happy about this since I had other plans for our evenings and weekends, but it did give me a chance to show off my superior tech skills so I wasn’t too sad about it. You might be surprised to learn that in a developer’s life, there aren’t all that many chances to impress girls with your coding skills.\n\nAnyway, I took a look at the Excel files she was bringing home and they were basically huge tables of data exported from various systems. She had to alchemy this data into several reports and the way to do it was to carefully follow the several dozen manual steps that were laid out in an arcane word document prepared by God-only-knows-who some years before. I looked at it carefully, and it turned out that what she needed to do would have been a few 10-line queries in SQL. In Excel, though, it was several days worth of vlookup-index-match-temporarycolumn-pivottable-copypaste-HELL. My first thought was importing the data into a database, processing it there and exporting it back. But this task was something she needed to do often and she didn’t have any database experience so this wasn’t an option.\n\nSo anyway, I had built some plugins for Excel before, and I figured I could probably build something that would automate at least a part of her task, after which I would be seen and admired by her as the hero that I was. The first thing I wanted to implement was joining tables. So, I rolled up my sleeves and eagerly set out to reinvent the wheel. It took about an hour for me to realize that there already existed these mysterious softwares that have the ability to join tables of data. The idea struck me like a lightning bolt: I could put a small database engine (SQLite) into my plugin, load Excel data into it and query the crap out of it six ways from Sunday. In the UI of my plugin, I’d give the handsome user (myself) a textbox for writing the queries and a grid for displaying results. This was going to be great!\n\nIt took a few days to build the first version. It was butt-ugly and looked like it was designed according to whatever the opposite to Feng Shui is, but it worked nicely. I could load data from Excel with the click of a button, type my SQL query into the textbox and run it by pressing “Button2”. Once the plugin was ready, I sat down with a somewhat skeptical Anna and we prepared the queries for her use cases. I was seriously looking forward to the next time Anna would bring home the pile of Excel files. And bring them she did. And work spectacularly it did! Not to brag, but instead of several days, we were done with her reports in about an hour! There was still some manual copy-paste work to do (hence the hour), but the bulk of the work was done by the queries and SQLite.\n\n“I had done it”… I remember thinking… “I had stared the into the eyes of the Gods of the spreadsheet underworld, and the bastards flinched!”. Anna was impressed (ever so slightly and not nearly enough). Not only did I win Anna’s underwhelming admiration, but this was a general purpose solution that I could sell to other people! It was obvious there was only one way this could go, and only one question to answer: what color mansion would I like?\n\nSo I posted about my plugin on Reddit/r/excel. The [response](https://www.reddit.com/r/excel/comments/2wv52m/ive_built_an_excel_plugin_for_using_sql_in_excel/) was very enthusiastic, people loved it! Close to 100 upvote’s worth of love. Encouraged, I continued working on it much to Anna’s annoyance, because now, instead of her spending time in Excel, I was. At one point she got so annoyed that she gave me an ultimatum: either her or the project.\n\nAnyway, the Reddit reception was encouraging but for some strange reason, I did not have thousands of people beating a path to my door to buy some licenses the next morning. It was quite obvious that there was something wrong with all these people who weren’t lining up to buy. After all, my ex-girlfriend Anna saves several days each month with it, and she can’t be the only one who could make good use of it. Perhaps the problem is auto-complete. Any serious tool needs autocomplete these days…\n\nWhat was I to do, my turquoise mansion was waiting for me just one auto-complete feature away. So, I dusted off my compiler theory books from college, picked up Antlr and built a parser for SQLite (with the help of a [SQLite grammar](https://github.com/antlr/grammars-v4/blob/master/sqlite/SQLite.g4) I found on GitHub). This was my favorite feature to build. With the parser in place, one by one I added all the cool features: auto-complete, error highlighting, symbol tooltips, bracket-matching, code formatting, function insights and star expansion. Then I added the ability to use external databases instead of SQLite, which made it possible to process Excel data with an external database but also to easily move data between Excel and databases. This was great: posts on Reddit, posts on HackerNews, money rolling in, licenses being bought. Still, it was only a few hundred – maybe up to a few thousand dollars per month. Careful calculations conclusively showed it wasn’t enough for a mansion.\n\nBut, it was fun, and my corporate job wasn’t. I decided to quit and devote my time to a worthy project: my Excel plugin. Being a techy person, I wasn’t very keen to do any marketing and sales, though. I didn’t need those. So, fast forward to today, I completely ignored the business side of it and continued developing what I felt like developing. Inevitably, after a while, I was slowly starting to go broke, but I had a lot of fun developing features, yay! For example, I took Roslyn and used it to add C# support, intellisense and all. LINQ queries on Excel tables, for God’s sake, you can’t tell me that doesn’t make your heart beat just a little bit faster.\n\nAt this point, a reasonable question to ask might be: “Why in God’s name would you build an IDE in Excel, I thought developers hate Excel?!”. And you’d be right, most developers don’t care much for Excel, but that’s only because it doesn’t actually have support for tech skills. But not everyone is technical, and spreadsheets are almost everywhere, especially in companies, so whether we want to or not, we have to deal with data in spreadsheets. Some good tech tools can come in quite handy there. Also, with C# for logic and the spreadsheet for presentation and storage, you can build some really smart documents really fast. Excel might not seem fashionable, but it’s really useful and in business, you can pretty much count on most people having it on their machines.\n\nSo here are some of the interesting things you can do with QueryStorm:\n– [Using C# in Excel](https://www.querystorm.com/docs/csharp)\n– [Cross-database queries from SQLite](http://blog.querystorm.com/index.php/2018/04/02/querying-other-databases-from-sqlite/)\n– [C# user-defined functions for SQLite (in Excel)](http://blog.querystorm.com/index.php/2018/03/31/sqlite-with-c-sprinkles-on-top/)\n– [Prototyping with C# and Excel](http://blog.querystorm.com/index.php/2018/03/30/c-programming-in-excel/)\n– [Regex galore in Excel](http://blog.querystorm.com/index.php/2018/03/26/regex-magic-in-excel/)\n\nAnyway, a few months ago, by chance, a guy I know asked me if I wanted to apply to this Polish accelerator. I said, “Yeah, sure, sounds good”. He saw right through my cunning attempt at blowing him off and said “no yeah sure… APPLY, NOW MOT*******ER!”. Well, apply I did, and it was fantastic. I spent four months in Warsaw, met a bunch of really cool people, got some new friends, got financing and some useful new skills like presenting. Could have been worse, all in all. I’m really grateful both to Luka (the dude who made me apply) as well as to the [HugeThing](http://hugething.vc/) team. If QueryStorm succeeds on the market, it will be in no small part thanks to these amazing gentlefolk!\n\nSo anyway, I have this IDE… [wanna check it out](https://www.querystorm.com/)?",
"json_metadata": "{\"tags\":[\"ide\",\"csharp\",\"sql\",\"excel\",\"entrepreneurship\"],\"image\":[\"https://www.querystorm.com/images/Untitled-Project.gif\"],\"links\":[\"https://www.reddit.com/r/excel/comments/2wv52m/ive_built_an_excel_plugin_for_using_sql_in_excel/\",\"https://github.com/antlr/grammars-v4/blob/master/sqlite/SQLite.g4\",\"https://www.querystorm.com/docs/csharp\",\"http://blog.querystorm.com/index.php/2018/04/02/querying-other-databases-from-sqlite/\",\"http://blog.querystorm.com/index.php/2018/03/31/sqlite-with-c-sprinkles-on-top/\",\"http://blog.querystorm.com/index.php/2018/03/30/c-programming-in-excel/\",\"http://blog.querystorm.com/index.php/2018/03/26/regex-magic-in-excel/\",\"http://hugething.vc/\",\"https://www.querystorm.com/\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}"
}
]
}id1sent 0.001 SBD to @querystorm- "☆ Hi! We are creating one of the first Multichain tokens ever working on ETH, EOS and NEO: 3 in 1. Please check out our project 🔥Ducatur.net🔥 •MVP is ready •3 Hackathons won •Softcap Reached 📬 A..."2018/06/02 10:36:18
id1sent 0.001 SBD to @querystorm- "☆ Hi! We are creating one of the first Multichain tokens ever working on ETH, EOS and NEO: 3 in 1. Please check out our project 🔥Ducatur.net🔥 •MVP is ready •3 Hackathons won •Softcap Reached 📬 A..."
2018/06/02 10:36:18
| from | id1 |
| to | querystorm |
| amount | 0.001 SBD |
| memo | ☆ Hi! We are creating one of the first Multichain tokens ever working on ETH, EOS and NEO: 3 in 1. Please check out our project 🔥Ducatur.net🔥 •MVP is ready •3 Hackathons won •Softcap Reached 📬 Any questions please feel free to contact me [email protected] ☆ |
| Transaction Info | Block #22967357/Trx ebe59f9d5493eb30be316b9509bca2f3df7a31b0 |
View Raw JSON Data
{
"trx_id": "ebe59f9d5493eb30be316b9509bca2f3df7a31b0",
"block": 22967357,
"trx_in_block": 6,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-06-02T10:36:18",
"op": [
"transfer",
{
"from": "id1",
"to": "querystorm",
"amount": "0.001 SBD",
"memo": "☆ Hi! We are creating one of the first Multichain tokens ever working on ETH, EOS and NEO: 3 in 1. Please check out our project 🔥Ducatur.net🔥 •MVP is ready •3 Hackathons won •Softcap Reached 📬 Any questions please feel free to contact me [email protected] ☆"
}
]
}steemdelegated 18.149 SP to @querystorm2018/05/19 18:01:09
steemdelegated 18.149 SP to @querystorm
2018/05/19 18:01:09
| delegator | steem |
| delegatee | querystorm |
| vesting shares | 29496.507372 VESTS |
| Transaction Info | Block #22573508/Trx e564d3e9d66d7f9ae80c15a2ba0e0418bb583402 |
View Raw JSON Data
{
"trx_id": "e564d3e9d66d7f9ae80c15a2ba0e0418bb583402",
"block": 22573508,
"trx_in_block": 70,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-05-19T18:01:09",
"op": [
"delegate_vesting_shares",
{
"delegator": "steem",
"delegatee": "querystorm",
"vesting_shares": "29496.507372 VESTS"
}
]
}querystormreceived 0.009 SP curation reward for @ivoras / the-crash-and-burn-of-the-cryptohunt-game2018/04/02 12:07:15
querystormreceived 0.009 SP curation reward for @ivoras / the-crash-and-burn-of-the-cryptohunt-game
2018/04/02 12:07:15
| curator | querystorm |
| reward | 14.276925 VESTS |
| comment author | ivoras |
| comment permlink | the-crash-and-burn-of-the-cryptohunt-game |
| Transaction Info | Block #21213713/Virtual Operation #9 |
View Raw JSON Data
{
"trx_id": "0000000000000000000000000000000000000000",
"block": 21213713,
"trx_in_block": 4294967295,
"op_in_trx": 0,
"virtual_op": 9,
"timestamp": "2018-04-02T12:07:15",
"op": [
"curation_reward",
{
"curator": "querystorm",
"reward": "14.276925 VESTS",
"comment_author": "ivoras",
"comment_permlink": "the-crash-and-burn-of-the-cryptohunt-game"
}
]
}noisysent 95.921 STEEM to @querystorm- "rewards from https://steemit.com/programming/@noisy/yksiddpc"2018/03/28 17:21:15
noisysent 95.921 STEEM to @querystorm- "rewards from https://steemit.com/programming/@noisy/yksiddpc"
2018/03/28 17:21:15
| from | noisy |
| to | querystorm |
| amount | 95.921 STEEM |
| memo | rewards from https://steemit.com/programming/@noisy/yksiddpc |
| Transaction Info | Block #21076039/Trx cb0639bc33ac70713c03db3770f43c87ba4d0e54 |
View Raw JSON Data
{
"trx_id": "cb0639bc33ac70713c03db3770f43c87ba4d0e54",
"block": 21076039,
"trx_in_block": 15,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-03-28T17:21:15",
"op": [
"transfer",
{
"from": "noisy",
"to": "querystorm",
"amount": "95.921 STEEM",
"memo": "rewards from https://steemit.com/programming/@noisy/yksiddpc"
}
]
}querystormupvoted (100.00%) @ivoras / the-crash-and-burn-of-the-cryptohunt-game2018/03/26 12:59:00
querystormupvoted (100.00%) @ivoras / the-crash-and-burn-of-the-cryptohunt-game
2018/03/26 12:59:00
| voter | querystorm |
| author | ivoras |
| permlink | the-crash-and-burn-of-the-cryptohunt-game |
| weight | 10000 (100.00%) |
| Transaction Info | Block #21013209/Trx 2e9239ecb4b993ee6fb7fc5365669b9706679feb |
View Raw JSON Data
{
"trx_id": "2e9239ecb4b993ee6fb7fc5365669b9706679feb",
"block": 21013209,
"trx_in_block": 27,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-03-26T12:59:00",
"op": [
"vote",
{
"voter": "querystorm",
"author": "ivoras",
"permlink": "the-crash-and-burn-of-the-cryptohunt-game",
"weight": 10000
}
]
}steemcreated a new account: @querystorm2018/02/28 12:35:36
steemcreated a new account: @querystorm
2018/02/28 12:35:36
| fee | 0.500 STEEM |
| delegation | 29700.000000 VESTS |
| creator | steem |
| new account name | querystorm |
| owner | {"weight_threshold":1,"account_auths":[],"key_auths":[["STM6tkLFx4YpwMWXR5YhEC77WB4nHhZmPjjv1MVoLz27xWwk8AfLn",1]]} |
| active | {"weight_threshold":1,"account_auths":[],"key_auths":[["STM4z5MxGHgWgmph6F891hu7dDCoMN8XBZAxEPYjbBDyQthSYQYqG",1]]} |
| posting | {"weight_threshold":1,"account_auths":[],"key_auths":[["STM7bC8hdhFoCyJ2WR4yaLwswkzmY4fd6b6WUrNuQ9NMHmKmAXKAU",1]]} |
| memo key | STM7A4d99DUwcLkuCyC9pD25qKqWSUWnnKL2WXnT3iPRjjmRA2Csd |
| json metadata | |
| extensions | [] |
| Transaction Info | Block #20265350/Trx 411f5c8355beb6ef5462d7f4295065820cad0116 |
View Raw JSON Data
{
"trx_id": "411f5c8355beb6ef5462d7f4295065820cad0116",
"block": 20265350,
"trx_in_block": 22,
"op_in_trx": 0,
"virtual_op": 0,
"timestamp": "2018-02-28T12:35:36",
"op": [
"account_create_with_delegation",
{
"fee": "0.500 STEEM",
"delegation": "29700.000000 VESTS",
"creator": "steem",
"new_account_name": "querystorm",
"owner": {
"weight_threshold": 1,
"account_auths": [],
"key_auths": [
[
"STM6tkLFx4YpwMWXR5YhEC77WB4nHhZmPjjv1MVoLz27xWwk8AfLn",
1
]
]
},
"active": {
"weight_threshold": 1,
"account_auths": [],
"key_auths": [
[
"STM4z5MxGHgWgmph6F891hu7dDCoMN8XBZAxEPYjbBDyQthSYQYqG",
1
]
]
},
"posting": {
"weight_threshold": 1,
"account_auths": [],
"key_auths": [
[
"STM7bC8hdhFoCyJ2WR4yaLwswkzmY4fd6b6WUrNuQ9NMHmKmAXKAU",
1
]
]
},
"memo_key": "STM7A4d99DUwcLkuCyC9pD25qKqWSUWnnKL2WXnT3iPRjjmRA2Csd",
"json_metadata": "",
"extensions": []
}
]
}Manabar
Voting Power100.00%
Downvote Power100.00%
Resource Credits100.00%
Reputation Progress33.84%
{
"voting_manabar": {
"current_mana": "8143659806",
"last_update_time": 1779081735
},
"downvote_manabar": {
"current_mana": 2035914951,
"last_update_time": 1779081735
},
"rc_account": {
"account": "querystorm",
"rc_manabar": {
"current_mana": "10164408779",
"last_update_time": 1779081735
},
"max_rc_creation_adjustment": {
"amount": "2020748973",
"precision": 6,
"nai": "@@000000037"
},
"max_rc": "10164408779"
}
}Account Metadata
| POSTING JSON METADATA | |
| None | |
| JSON METADATA | |
| None |
{
"posting_json_metadata": {},
"json_metadata": {}
}Auth Keys
Owner
Single Signature
Public Keys
STM6tkLFx4YpwMWXR5YhEC77WB4nHhZmPjjv1MVoLz27xWwk8AfLn1/1
Active
Single Signature
Public Keys
STM4z5MxGHgWgmph6F891hu7dDCoMN8XBZAxEPYjbBDyQthSYQYqG1/1
Posting
Single Signature
Public Keys
STM7bC8hdhFoCyJ2WR4yaLwswkzmY4fd6b6WUrNuQ9NMHmKmAXKAU1/1
Memo
STM7A4d99DUwcLkuCyC9pD25qKqWSUWnnKL2WXnT3iPRjjmRA2Csd
{
"owner": {
"weight_threshold": 1,
"account_auths": [],
"key_auths": [
[
"STM6tkLFx4YpwMWXR5YhEC77WB4nHhZmPjjv1MVoLz27xWwk8AfLn",
1
]
]
},
"active": {
"weight_threshold": 1,
"account_auths": [],
"key_auths": [
[
"STM4z5MxGHgWgmph6F891hu7dDCoMN8XBZAxEPYjbBDyQthSYQYqG",
1
]
]
},
"posting": {
"weight_threshold": 1,
"account_auths": [],
"key_auths": [
[
"STM7bC8hdhFoCyJ2WR4yaLwswkzmY4fd6b6WUrNuQ9NMHmKmAXKAU",
1
]
]
},
"memo": "STM7A4d99DUwcLkuCyC9pD25qKqWSUWnnKL2WXnT3iPRjjmRA2Csd"
}Witness Votes
0 / 30
No active witness votes.
[]