---
# System prepended metadata

title: meeting 2021-June-03
tags: [meeting]

---

---
tags: meeting
---

# meeting 2021-June-03

## agenda

**NEAR in Minutes**


- [x] fetching data for community contributions
- [x] @ozanisgor recordings and Loom
- [x] @ozanisgor contribution flow
- [x] @hiba updates on near-in-minutes

**Other**

- [ ] @amgando indexer for explorer and queries

---

**fetching data for community contributions**

- today this is in a local JSON file
- **decision**: @hiba and @amgando will pair on this on Friday between 10a - 2p (all are welcome to join)
- the plan will be (for now) to: 
    - integrate Airtable as the backend
    - create form(s) and kanban board(s) for flow
    - create automation and metrics for reporting
    - surface some / all of this into the website


**recordings and Loom**

- business trial is done, now limited to 5 mins
- **decision**: please purchase a license and expense it --> $10/mo, billed monthly


**contribution flow**

- add instructions in the readme file
- **decision**: we will wait until next week to capture this process based on the new process design 


**updates on NEAR in Minutes**

- quick update recording here:
    - https://www.loom.com/share/92836ab1b9314edfb8d828316476f2f3
- @hiba will buy domain `near-in-minutes.com` and register with render.com

**indexer for explorer and queries**

- quick intro recording here
    - https://www.loom.com/share/d73d5b522768456cb191dc4804d928a3
- https://github.com/near/near-indexer-for-explorer
- https://eggerapps.at/postico/
- https://www.postgresql.org/docs/13/functions-datetime.html

```sql=
--select * from accounts where account_id LIKE '%sputnik%'
--select * from access_keys where account_id = 'sherif.testnet'
--select * from account_changes limit 10
--select * from action_receipt_actions limit 10
--select * from action_receipt_input_data limit 10 
--select * from action_receipt_output_data limit 10
--select * from action_receipts limit 10
--select * from blocks order by block_height desc limit 10
--select * from chunks limit 10
--select * from data_receipts limit 10
--select * from execution_outcome_receipts limit 10
--select * from execution_outcomes limit 10
--select * from receipts limit 10
--select * from transaction_actions limit 10
--select * from transactions limit 10

select 
	date_trunc('minute', to_timestamp(block_timestamp/1000/1000/1000)) as time, 
	action_kind as action, 
	args, 
	signer_account_id as signer, 
	receiver_account_id as receiver
from 
	transactions t, 
	transaction_actions ta 
where 
	signer_account_id = 'sherif.testnet' 
	and t.transaction_hash = ta.transaction_hash 
--limit 10
```


---

![](https://i.imgur.com/GpdzfBO.png)

![](https://i.imgur.com/TMrY2tQ.png)
