## What's RC Angel? 

Last October, I set up my account to donate 10% of its Resource Credits (RC) to [RC-Angel](https://peakd.com/hive-139531/@deathwing/announcing-rc-angel-or-rc-pools-but-better). I have not changed the allocation since. RC angel is a service created by @deathwing that loans out RCs. For example, if a new user has difficulty broadcasting to the network because they've run out of RCs, the angel can step in and give them a resource boost. This service is also hooked up to @rishi556's GiftGiver.site where Hivers can request RC delegations for themselves or others. All of this was made possible by the new RC delegation feature in Hive Hardfork 26 (thanks, core devs!).

## Asking HiveSQL about RC Delegation History

This week I learned how to ask HiveSQL (by @arcange) about Hive custom_json ops. And an interesting question is: how many times has RC angel delegated RCs on my behalf since last October?

A quick query tells me that 412 delegations have been sent from my account.

```
SELECT COUNT(*)
FROM TxCustoms 
WHERE timestamp > DATEADD(MONTH, -6, GETDATE()) 
AND required_posting_auth = 'hivetrending'
AND tid = 'rc'

```

HiveSQL can also do neat tricks like partitioning data into days/months/years buckets. Like this:


```
SELECT DATEPART(month, timestamp) as month_bucket, COUNT(*) as num_rows
FROM TxCustoms 
WHERE timestamp > DATEADD(MONTH, -6, GETDATE()) 
AND required_posting_auth = 'hivetrending'
AND tid = 'rc'
GROUP BY DATEPART(month, timestamp)
ORDER BY month_bucket ASC

```

And then I can copy the data into Google Sheets to make nice charts like this. What happened in Feb?

![image.png](https://files.peakd.com/file/peakd-hive/hivetrending/23sxpXQpkcwzcaWVYdBa3mieX7ELzBKT88Jefz6tbJqeJJXqsjgDTNebYPpNavwnM4JXi.png)

### Calling HiveSQL from VSCode

In the past, I had dabbled with HiveSQL but struggled to find a reliable, free MSSQL client. Look no further! This [VSCode extension](https://learn.microsoft.com/en-us/sql/tools/visual-studio-code/sql-server-develop-use-vscode?view=sql-server-ver16) makes it possible to connect to HiveSQL and execute queries from a VSCode text editor. Awesome!


![image.png](https://files.peakd.com/file/peakd-hive/hivetrending/EoASUqbZkFrmBWVY6TheAQxrtREVfz3qC8KQ5uAEXeaKcqgc86MCpikcN8dVaosyjo6.png)

After installing the VSCode MSSQL extension, many new commands are added to the command palette. First, "MSSQL: Add Connection" and input the connection details provided when signing up for HiveSQL access. Then, create a new file, type an MSSQL query, and run the "MSSQL: Execute Query" command. A new pane will appear on the right with the status and results. 


![image.png](https://files.peakd.com/file/peakd-hive/hivetrending/Eo43mfN9WB3VbRVtP955cq1iY8kCG7DWgXqFEe3N8Qr5HKyEGqpLzvphcD2esU73ChD.png)

## That's it

I just wanted to share a few useful things I've learned this week. Enjoy SQL querying! Consider voting for the [HiveSQL DHF proposal](https://peakd.com/hive-139531/@arcange/hivesql-proposal-2023-2024) and Deathwing's proposal(s) to support their projects.

Signing off,
Hivetrending (pizza.witness team)