Ecoer Logo
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 Deleg
+3.253SP

Detailed Balance

STEEM
balance
96.175STEEM
market_balance
0.000STEEM
savings_balance
0.000STEEM
reward_steem_balance
0.000STEEM
STEEM POWER
Own SP
1.758SP
Delegated Out
0.000SP
Delegation In
3.253SP
Effective Power
5.011SP
Reward SP (pending)
0.002SP
SBD
sbd_balance
1.218SBD
sbd_conversions
0.000SBD
sbd_market_balance
0.000SBD
savings_sbd_balance
0.000SBD
reward_sbd_balance
0.000SBD
{
  "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

namequerystorm
id776688
rank542,848
reputation23492443601
created2018-02-28T12:35:36
recovery_accountsteem
proxyNone
post_count2
comment_count0
lifetime_vote_count0
witnesses_voted_for0
last_post2018-06-05T17:14:45
last_root_post2018-06-05T16:57:57
last_vote_time2018-03-26T12:59:00
proxied_vsf_votes0, 0, 0, 0
can_vote1
voting_power0
delayed_votes0
balance96.175 STEEM
savings_balance0.000 STEEM
sbd_balance1.218 SBD
savings_sbd_balance0.000 SBD
vesting_shares2856.501929 VESTS
delegated_vesting_shares0.000000 VESTS
received_vesting_shares5287.157877 VESTS
reward_vesting_balance3.698588 VESTS
vesting_balance0.000 STEEM
vesting_withdraw_rate0.000000 VESTS
next_vesting_withdrawal1969-12-31T23:59:59
withdrawn0
to_withdraw0
withdraw_routes0
savings_withdraw_requests0
last_account_recovery1970-01-01T00:00:00
reset_accountnull
last_owner_update1970-01-01T00:00:00
last_account_update1970-01-01T00:00:00
minedNo
sbd_seconds0
sbd_last_interest_payment2021-10-28T10:47:57
savings_sbd_last_interest_payment1970-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

IncomingOutgoing
Empty
Empty
{
  "incoming": [],
  "outgoing": []
}
From Date
To Date
steemdelegated 3.253 SP to @querystorm
2026/05/18 05:22:15
delegatorsteem
delegateequerystorm
vesting shares5287.157877 VESTS
Transaction InfoBlock #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 @querystorm
2026/05/13 00:37:18
delegatorsteem
delegateequerystorm
vesting shares2574.947472 VESTS
Transaction InfoBlock #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 @querystorm
2026/04/26 04:35:27
delegatorsteem
delegateequerystorm
vesting shares5299.673633 VESTS
Transaction InfoBlock #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 @querystorm
2026/01/23 21:33:36
delegatorsteem
delegateequerystorm
vesting shares2616.494291 VESTS
Transaction InfoBlock #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 @querystorm
2024/12/17 16:44:27
delegatorsteem
delegateequerystorm
vesting shares2780.713488 VESTS
Transaction InfoBlock #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 @querystorm
2023/11/14 08:25:51
delegatorsteem
delegateequerystorm
vesting shares2949.847020 VESTS
Transaction InfoBlock #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 @querystorm
2023/09/22 09:18:06
delegatorsteem
delegateequerystorm
vesting shares5886.755806 VESTS
Transaction InfoBlock #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 @querystorm
2022/06/17 22:24:03
delegatorsteem
delegateequerystorm
vesting shares6212.478187 VESTS
Transaction InfoBlock #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 @abandi
2021/11/04 10:52:45
benefactorquerystorm
authorabandi
permlinkare-great-profits-on-the-steem-blockchain-achievable-20211028t105245
sbd payout0.000 SBD
steem payout0.000 STEEM
vesting payout3.698588 VESTS
Transaction InfoBlock #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 @querystorm
2021/10/28 11:06:03
delegatorsteem
delegateequerystorm
vesting shares6394.261006 VESTS
Transaction InfoBlock #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 SP
2021/10/28 10:47:57
accountquerystorm
reward steem0.254 STEEM
reward sbd1.217 SBD
reward vests1820.678643 VESTS
Transaction InfoBlock #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 @querystorm
2021/06/14 05:25:12
delegatorsteem
delegateequerystorm
vesting shares8333.787776 VESTS
Transaction InfoBlock #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 @querystorm
2020/12/11 15:38:15
delegatorsteem
delegateequerystorm
vesting shares8521.209750 VESTS
Transaction InfoBlock #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 @querystorm
2020/12/06 09:14:18
delegatorsteem
delegateequerystorm
vesting shares1912.543513 VESTS
Transaction InfoBlock #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 @querystorm
2020/12/05 19:16:09
delegatorsteem
delegateequerystorm
vesting shares8527.417604 VESTS
Transaction InfoBlock #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 @querystorm
2020/11/03 00:58:57
delegatorsteem
delegateequerystorm
vesting shares1920.017158 VESTS
Transaction InfoBlock #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 @querystorm
2020/05/09 10:16:30
delegatorsteem
delegateequerystorm
vesting shares8730.222963 VESTS
Transaction InfoBlock #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 @querystorm
2020/05/08 14:33:24
delegatorsteem
delegateequerystorm
vesting shares1953.311140 VESTS
Transaction InfoBlock #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
parent authorquerystorm
parent permlinki-wandered-off-and-built-an-ide
authorsteemitboard
permlinksteemitboard-notify-querystorm-20200228t130450000z
title
bodyCongratulations @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 InfoBlock #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 @querystorm
2019/08/19 14:59:42
delegatorsteem
delegateequerystorm
vesting shares8880.335443 VESTS
Transaction InfoBlock #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
parent authorquerystorm
parent permlinki-wandered-off-and-built-an-ide
authorsteemitboard
permlinksteemitboard-notify-querystorm-20190228t142356000z
title
bodyCongratulations @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 InfoBlock #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 @querystorm
2018/09/05 07:23:57
delegatorsteem
delegateequerystorm
vesting shares9078.695083 VESTS
Transaction InfoBlock #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"
    }
  ]
}
2018/06/13 11:05:57
votermarcin648
authorquerystorm
permlinki-wandered-off-and-built-an-ide
weight10000 (100.00%)
Transaction InfoBlock #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-ide
2018/06/12 16:57:57
authorquerystorm
permlinki-wandered-off-and-built-an-ide
sbd payout1.217 SBD
steem payout0.254 STEEM
vesting payout1820.678643 VESTS
Transaction InfoBlock #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
parent authorquerystorm
parent permlinki-wandered-off-and-built-an-ide
authorsteemitboard
permlinksteemitboard-notify-querystorm-20180606t174356000z
title
bodyCongratulations @querystorm! You have completed some achievement on Steemit and have been rewarded with new badge(s) : [![](https://steemitimages.com/70x70/http://steemitboard.com/notifications/firstpost.png)](http://steemitboard.com/@querystorm) You published your First Post [![](https://steemitimages.com/70x70/http://steemitboard.com/notifications/firstcomment.png)](http://steemitboard.com/@querystorm) You made your First Comment [![](https://steemitimages.com/70x70/http://steemitboard.com/notifications/firstvoted.png)](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 InfoBlock #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[![](https://steemitimages.com/70x70/http://steemitboard.com/notifications/firstpost.png)](http://steemitboard.com/@querystorm) You published your First Post\n[![](https://steemitimages.com/70x70/http://steemitboard.com/notifications/firstcomment.png)](http://steemitboard.com/@querystorm) You made your First Comment\n[![](https://steemitimages.com/70x70/http://steemitboard.com/notifications/firstvoted.png)](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 SP
2018/06/06 07:09:00
accountquerystorm
reward steem0.000 STEEM
reward sbd0.000 SBD
reward vests14.276925 VESTS
Transaction InfoBlock #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"
    }
  ]
}
2018/06/05 17:54:15
votersensation
authorquerystorm
permlinki-wandered-off-and-built-an-ide
weight10000 (100.00%)
Transaction InfoBlock #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
voterben-jamin
authorquerystorm
permlinkre-querystorm-i-wandered-off-and-built-an-ide-20180605t171443128z
weight10000 (100.00%)
Transaction InfoBlock #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
    }
  ]
}
2018/06/05 17:39:54
voterben-jamin
authorquerystorm
permlinki-wandered-off-and-built-an-ide
weight10000 (100.00%)
Transaction InfoBlock #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
    }
  ]
}
2018/06/05 17:30:48
required auths[]
required posting auths["querystorm"]
idfollow
json["follow",{"follower":"querystorm","following":"introduce.bot","what":["blog"]}]
Transaction InfoBlock #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\"]}]"
    }
  ]
}
2018/06/05 17:28:57
voternoisy
authorquerystorm
permlinki-wandered-off-and-built-an-ide
weight10000 (100.00%)
Transaction InfoBlock #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
parent authorquerystorm
parent permlinki-wandered-off-and-built-an-ide
authorintroduce.bot
permlinkintroduce-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 InfoBlock #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": ""
    }
  ]
}
2018/06/05 17:28:15
voterintroduce.bot
authorquerystorm
permlinki-wandered-off-and-built-an-ide
weight169 (1.69%)
Transaction InfoBlock #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
parent authorquerystorm
parent permlinki-wandered-off-and-built-an-ide
authorquerystorm
permlinkre-querystorm-i-wandered-off-and-built-an-ide-20180605t171443128z
title
bodyPosted 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 InfoBlock #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\"}"
    }
  ]
}
2018/06/05 16:58:12
voterax3
authorquerystorm
permlinki-wandered-off-and-built-an-ide
weight100 (1.00%)
Transaction InfoBlock #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
    }
  ]
}
2018/06/05 16:57:57
parent author
parent permlinkide
authorquerystorm
permlinki-wandered-off-and-built-an-ide
titleI wandered off and built an IDE
bodyA 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. ![QueryStorm](https://www.querystorm.com/images/Untitled-Project.gif) 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 InfoBlock #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![QueryStorm](https://www.querystorm.com/images/Untitled-Project.gif)\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
fromid1
toquerystorm
amount0.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 InfoBlock #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 @querystorm
2018/05/19 18:01:09
delegatorsteem
delegateequerystorm
vesting shares29496.507372 VESTS
Transaction InfoBlock #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-game
2018/04/02 12:07:15
curatorquerystorm
reward14.276925 VESTS
comment authorivoras
comment permlinkthe-crash-and-burn-of-the-cryptohunt-game
Transaction InfoBlock #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
fromnoisy
toquerystorm
amount95.921 STEEM
memorewards from https://steemit.com/programming/@noisy/yksiddpc
Transaction InfoBlock #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"
    }
  ]
}
2018/03/26 12:59:00
voterquerystorm
authorivoras
permlinkthe-crash-and-burn-of-the-cryptohunt-game
weight10000 (100.00%)
Transaction InfoBlock #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: @querystorm
2018/02/28 12:35:36
fee0.500 STEEM
delegation29700.000000 VESTS
creatorsteem
new account namequerystorm
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 keySTM7A4d99DUwcLkuCyC9pD25qKqWSUWnnKL2WXnT3iPRjjmRA2Csd
json metadata
extensions[]
Transaction InfoBlock #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": []
    }
  ]
}

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.
[]