create account

支持HiveSQL提案 以及 安装LINQPad by oflyhigh

View this thread on: hive.blog |  peakd.com |  ecency.com
hive-105017 · @oflyhigh · (edited)
$39.58
支持HiveSQL提案 以及 安装LINQPad
你知道嘛？除了从链上直接获取HIVE的数据，还有个方法就是从数据库获取。而HiveSQL大概是HIVE区块链上最好用的数据库啦。

![image.png](https://images.hive.blog/DQmcd79eeSfH8YEXDwTfuj6tbKdrvatVWKDfMphPnuQKfSg/image.png)
(图源 ：[pixabay](https://pixabay.com/))

# 支持HiveSQL提案

HiveSQL由@arcange 开发并维护，曾经一度使用订阅模式，后来由DHF的资金资助后，对用户免费。

目前，之前一轮的HIVESQL提案已经接近尾期：
>![image.png](https://images.hive.blog/DQme4R9gRfcP9ZmZN4h9whWAwMV5Qbr353om8eszAG184p8/image.png)

也就是说到2022年12月31日，这期的HiveSQL提案，就不再给HiveSQL项目发放资金啦。 

但是HIVESQL的基础设施以及维护等，都是需要资金的，尤其是随着HIVE区块链上数据的不断增多，显然这些成本也会增加。

为了能覆盖这些成本，避免在回到订阅模式，@arcange发起了新一轮的[HiveSQL提案]()：
>![image.png](https://images.hive.blog/DQmdDEDg8v4SJ4WbZbFus5whzTn5tjYRbxa73kDTNNKomLx/image.png)

作为HIVESQL的忠实用户，当然要支持这个提案啦，命令行投票代码如下：
>`update_proposal_votes your_account [247] true true`

在区块链浏览器上看到的原始数据大致这个样子：
>![image.png](https://images.hive.blog/DQmRNRwn33UxwqnEAoNjpQVKjipsKu9eqXz1LbaotQwf4sb/image.png)

如果你也使用HiveSQL，或者觉得HiveSQL确实是HIVE生态中很重要的基础设施之一，那么不妨也投上HiveSQL新提案一票。

# 安装LINQPad

忘记是哪位大佬推荐的，但是LINQPad搭配HiveSQL使用简直是太方便了。

之前的电脑里我都装有LINQPad，但是这台不算太新的新电脑，因为一直没直接使用HiveSQL，所以一直懒得安装LINQPad。

今天给HiveSQL投票，顺便想起来，或许我应该在这台机器上也装个LINQPad呢。

LINQPad的下载地址为：
>https://www.linqpad.net/Download.aspx

里边有很多下载选项：
>![1670148412706.png](https://images.hive.blog/DQmU7hPgETaN53WYTiziYSeWoL1BLkqggrzrowCfXK4MrRt/1670148412706.png)

我选择了其中一个免安装版，下载后是一个zip文件，解压后包含这样一堆文件：
>![1670148487643(1).png](https://images.hive.blog/DQmPwagNxTe5M4go7BBKL6caRC68yxXK4oWF5SUjDMfCQMm/1670148487643(1).png)

执行和你系统对应的版本即可（64位系统选择LINQPad7-x64）。

如果你的系统没有安装对应.Net支持，那么会弹出个提示框让你安装.Net，并启动如下程序：
>![image.png](https://images.hive.blog/DQmcETAYjhQG7tAJhLQntkYQvmj7DSDBSui3ppA1NSpj3kd/image.png)

下载.Net 7.0：
>![image.png](https://images.hive.blog/DQmNpF2VbPZKWq7FPYhv9Bytrk4WrrSDD5MFu9S4cH6XEDd/image.png)

按提示安装.Net 7.0(x64)：
>![image.png](https://images.hive.blog/DQmWypK2LcCbt2ShzhXdQuoxwmTft524s6qVMJzkm6RRVcC/image.png)

然后就可以愉快地使用啦。(可惜我一时竟然忘记了咋用，尴尬，看来要保持拳不离手曲不离口啊）

# 相关链接
* https://hivesql.io/
* https://wallet.hive.blog/proposals
* [HiveSQL Services Proposal - Let's keep it free](https://hive.blog/hive-139531/@arcange/hivesql-proposal-2023-2024)
* https://www.linqpad.net/
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 120 others
properties (23)
authoroflyhigh
permlinkhivesql-linqpad
categoryhive-105017
json_metadata{"tags":["cn","life","blog","hivesql","linqpad"],"users":["arcange"],"image":["https://images.hive.blog/DQmcd79eeSfH8YEXDwTfuj6tbKdrvatVWKDfMphPnuQKfSg/image.png","https://images.hive.blog/DQme4R9gRfcP9ZmZN4h9whWAwMV5Qbr353om8eszAG184p8/image.png","https://images.hive.blog/DQmdDEDg8v4SJ4WbZbFus5whzTn5tjYRbxa73kDTNNKomLx/image.png","https://images.hive.blog/DQmRNRwn33UxwqnEAoNjpQVKjipsKu9eqXz1LbaotQwf4sb/image.png","https://images.hive.blog/DQmU7hPgETaN53WYTiziYSeWoL1BLkqggrzrowCfXK4MrRt/1670148412706.png","https://images.hive.blog/DQmPwagNxTe5M4go7BBKL6caRC68yxXK4oWF5SUjDMfCQMm/1670148487643(1).png","https://images.hive.blog/DQmcETAYjhQG7tAJhLQntkYQvmj7DSDBSui3ppA1NSpj3kd/image.png","https://images.hive.blog/DQmNpF2VbPZKWq7FPYhv9Bytrk4WrrSDD5MFu9S4cH6XEDd/image.png","https://images.hive.blog/DQmWypK2LcCbt2ShzhXdQuoxwmTft524s6qVMJzkm6RRVcC/image.png"],"links":["https://pixabay.com/"],"app":"hiveblog/0.1","format":"markdown"}
created2022-12-04 10:30:33
last_update2022-12-04 10:43:24
depth0
children18
last_payout2022-12-11 10:30:33
cashout_time1969-12-31 23:59:59
total_payout_value19.806 HBD
curator_payout_value19.776 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length2,113
author_reputation4,653,797,396,253,567
root_title"支持HiveSQL提案 以及 安装LINQPad"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id118,837,697
net_rshares84,468,947,070,509
author_curate_reward""
vote details (184)
@aellly · 
看懵了，完全看不懂。
告辞。😂😂😂😂
properties (22)
authoraellly
permlinkre-oflyhigh-2022124t195520280z
categoryhive-105017
json_metadata{"tags":["cn","life","blog","hivesql","linqpad"],"app":"ecency/3.0.29-vision","format":"markdown+html"}
created2022-12-04 11:55:18
last_update2022-12-04 11:55:18
depth1
children0
last_payout2022-12-11 11:55:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length18
author_reputation637,235,217,483,467
root_title"支持HiveSQL提案 以及 安装LINQPad"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id118,838,736
net_rshares0
@alpha-omega · 
HiveSQL是基于MySQL还是PostgreSQL?
properties (22)
authoralpha-omega
permlinkre-oflyhigh-2022124t195025165z
categoryhive-105017
json_metadata{"tags":["hive-105017","cn","life","blog","hivesql","linqpad"],"app":"ecency/3.0.19-mobile","format":"markdown+html"}
created2022-12-04 11:50:27
last_update2022-12-04 11:50:27
depth1
children1
last_payout2022-12-11 11:50:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length28
author_reputation293,918,827,004,111
root_title"支持HiveSQL提案 以及 安装LINQPad"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id118,838,666
net_rshares0
@oflyhigh · 
MS-SQL
properties (22)
authoroflyhigh
permlinkrmd81u
categoryhive-105017
json_metadata{"app":"hiveblog/0.1"}
created2022-12-04 12:01:06
last_update2022-12-04 12:01:06
depth2
children0
last_payout2022-12-11 12:01:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length6
author_reputation4,653,797,396,253,567
root_title"支持HiveSQL提案 以及 安装LINQPad"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id118,838,850
net_rshares0
@arcange · 
Thank you for the shout-out about HiveSQL and its proposal. Really appreciated!<div><a href="https://engage.hivechain.app">![](https://i.imgur.com/XsrNmcl.png)</a></div>
properties (22)
authorarcange
permlinkre-1670343961985
categoryhive-105017
json_metadata{"app":"engage"}
created2022-12-06 16:26:03
last_update2022-12-06 16:26:03
depth1
children0
last_payout2022-12-13 16:26:03
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length169
author_reputation1,065,065,779,136,773
root_title"支持HiveSQL提案 以及 安装LINQPad"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id118,899,602
net_rshares0
@lovelingling · 
SQL，额，我还记得这个英文缩写就是数据库。O哥，是不是我也可以投票？
properties (22)
authorlovelingling
permlinkre-oflyhigh-2022124t1942216z
categoryhive-105017
json_metadata{"tags":["hive-105017","cn","life","blog","hivesql","linqpad"],"app":"ecency/3.0.19-mobile","format":"markdown+html"}
created2022-12-04 11:04:00
last_update2022-12-04 11:04:00
depth1
children10
last_payout2022-12-11 11:04:00
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length35
author_reputation537,711,632,767,157
root_title"支持HiveSQL提案 以及 安装LINQPad"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id118,838,070
net_rshares0
@deanliu · (edited)
$0.48
當然啊，用peakd的話，可以到這裡去投: https://peakd.com/me/proposals/247 按下support後，確認同意投出即可喔... :)
👍  
properties (23)
authordeanliu
permlinkre-lovelingling-rmd6m3
categoryhive-105017
json_metadata{"tags":["hive-105017"],"app":"peakd/2022.11.2"}
created2022-12-04 11:29:57
last_update2022-12-04 11:30:54
depth2
children9
last_payout2022-12-11 11:29:57
cashout_time1969-12-31 23:59:59
total_payout_value0.238 HBD
curator_payout_value0.238 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length83
author_reputation2,735,287,367,516,496
root_title"支持HiveSQL提案 以及 安装LINQPad"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id118,838,430
net_rshares1,013,687,129,335
author_curate_reward""
vote details (1)
@lovelingling · 
好的，谢谢刘美女😂
properties (22)
authorlovelingling
permlinkre-deanliu-2022124t203520263z
categoryhive-105017
json_metadata{"tags":["hive-105017"],"app":"ecency/3.0.19-mobile","format":"markdown+html"}
created2022-12-04 12:35:18
last_update2022-12-04 12:35:18
depth3
children2
last_payout2022-12-11 12:35:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length9
author_reputation537,711,632,767,157
root_title"支持HiveSQL提案 以及 安装LINQPad"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id118,839,429
net_rshares0
@lovelingling · 
![](https://images.ecency.com/DQmTDQhfhTZqHkkUptsZ6ppgSyK1UDP4mVPNHrSCBCggT6Z/_20221205095051.png)
搞定
properties (22)
authorlovelingling
permlinkre-deanliu-2022125t95138258z
categoryhive-105017
json_metadata{"tags":["hive-105017"],"app":"ecency/3.0.29-vision","format":"markdown+html"}
created2022-12-05 01:51:48
last_update2022-12-05 01:51:48
depth3
children0
last_payout2022-12-12 01:51:48
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length101
author_reputation537,711,632,767,157
root_title"支持HiveSQL提案 以及 安装LINQPad"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id118,856,052
net_rshares0
@oflyhigh · 
感谢O哥答复
properties (22)
authoroflyhigh
permlinkrmd82n
categoryhive-105017
json_metadata{"app":"hiveblog/0.1"}
created2022-12-04 12:01:36
last_update2022-12-04 12:01:36
depth3
children4
last_payout2022-12-11 12:01:36
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length6
author_reputation4,653,797,396,253,567
root_title"支持HiveSQL提案 以及 安装LINQPad"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id118,838,860
net_rshares0
@marygong77777 · 
👍👍
properties (22)
authormarygong77777
permlinkre-oflyhigh-2022124t223938844z
categoryhive-105017
json_metadata{"tags":["hive-105017","cn","life","blog","hivesql","linqpad"],"app":"ecency/3.0.34-mobile","format":"markdown+html"}
created2022-12-04 14:39:39
last_update2022-12-04 14:39:39
depth1
children0
last_payout2022-12-11 14:39:39
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length2
author_reputation205,731,275,373,699
root_title"支持HiveSQL提案 以及 安装LINQPad"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id118,841,820
net_rshares0
@swkailing · 
感谢O哥的分享，很详细👍👍😁
properties (22)
authorswkailing
permlinkre-oflyhigh-2022124t185057344z
categoryhive-105017
json_metadata{"tags":["hive-105017","cn","life","blog","hivesql","linqpad"],"app":"ecency/3.0.25-mobile","format":"markdown+html"}
created2022-12-04 10:50:57
last_update2022-12-04 10:50:57
depth1
children0
last_payout2022-12-11 10:50:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length14
author_reputation42,649,547,293,068
root_title"支持HiveSQL提案 以及 安装LINQPad"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id118,837,891
net_rshares0
@xiaoyaodidi · 
已添加书签
properties (22)
authorxiaoyaodidi
permlinkre-oflyhigh-2022124t185943580z
categoryhive-105017
json_metadata{"tags":["hive-105017","cn","life","blog","hivesql","linqpad"],"app":"ecency/3.0.35-mobile","format":"markdown+html"}
created2022-12-04 10:59:42
last_update2022-12-04 10:59:42
depth1
children0
last_payout2022-12-11 10:59:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length5
author_reputation329,404,560,486,956
root_title"支持HiveSQL提案 以及 安装LINQPad"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id118,837,992
net_rshares0
Help/Feedback