Grant Proposal: Funding for TrackTerra

Papi · February 9, 2022, 4:04am

So we will not be maintaining a historic price feed. But we will be implementing a feature that tracks USD value of trades when one asset in the trade is UST. This will also work for LP transactions to track cost baises of the LP . This will help in most cases .

Papi · March 13, 2022, 8:32pm

Update:

We’ve have been working tirelessly to improve our parser support. In addition to what has been outlined in our milestones we have added support for prism,mars, fields of mars , edge protocol, glow, loterra, anchor liquidation queues, as well as minimal support for NFT marketplaces and other protocols such as starterra, luart and kujira .

We’ve had a minor deviation from our original milestone and will not be developing a UI for protocol support , due to multiple reasons around portability and due to the deep complexity and lack of standardization in some protocols. Protocol classier support is done via yaml files and is quite intuitive you can see our current classifiers here trackterra-api/protocols at main · trackterraorg/trackterra-api · GitHub and parsers can be found here trackterra-api/libs/parser/src/parser/processers at main · trackterraorg/trackterra-api · GitHub

We are currently focused on wrapping up our milestones and will be releasing documentation that covers protocol support as well as deployment. We will also be releasing a docker container that eases the deployment process of trackterra for parties who are interested in self hosting.

We are currently in talks with two crypto tax software providers in regards to an api integration and will support them in deploying their own self hosted trackterra instances.

As of right now we are focused on wrapping current milestones and will not be adding to our scope in the immediate term . However we do plan to build out additional features /export support in the future.

I should also add our code is quite portable and if anyone has a need/interest for a terra transaction parser i’d recommend checking out our public repos.

We will provide another update once our documentation is live.

Papi · March 19, 2022, 9:24pm

Another update – We are wrapping up the outlined TrackTerra milestones and are now withdrawing from our multisig wallet to compensate our developer and expense and allocate funds towards our hosting costs.

As our grant has appreciated due to funds being held in luna we will be compensating our dev 10,000$ in addition to milestone payments due to the amount of work he put in to the project working on functionality and features that weren’t outlined in the original proposal.

As I am a relatively neutral party and not accepting any sort compensation for my time or involvement in this project I think am in a position to make this judgment fairly. I have personally worked with Rebaz almost daily for two months and can attest to his hard work and that he has put way more hours/days than outlined in our original milestones and this shows in the functionality that we have delivered.

This includes additional protocol parser support, a streamlined deployment process , and various ui and backend features that make trackterra more usable for our users.

We will also be using these funds to secure hosting for two years including a dedicated LCD and FCD node.

Outline of hosting costs :

We are hosting 3 bare metal servers with hetzner – 2 of these servers are in production 1 of these servers is being built to resync fcd against col-4 to resolve a long standing issue with FCD where some col-4 data is missing , we will also temporarily have a 4th server to host the col-4 node . As our in production FCD is built using a database backup from TFL it is affected by this issue. This impacts some wallets in the march -april 2021 timeframe. When all is said and done we will be running 2 FCDs and one LCD.

These 3 servers come out to 220.30 USD per month

We also paid 129$ in setup costs

Our frontend is hosted on digitalocean and that costs us 58$ per month.

In total I’ve spent out of pocket 586.74$ USD on infrastructure on hetzner since January and about 58$ on digitalocean .

In order to secure hosting for 2 years and to cover our current out of pocket expenses(644.74$) and our future expected costs to temporarily run a col-4 node(400$) in total we are allocating $7716.74 to secure hosting (frontend + lcd +fcdx2) for two years.

Developer costs

We will be releasing 38,800 $ to our developer to pay him for milestone 1 , 2, 3 deliverables + 10,000$ to cover the additional work that has gone in to polishing our released product.

To conclude our current milestones and secure funding for hosting we have made two transactions against our multisig wallet.These transactions can be viewed here and have been converted from luna to USD at the time the transfer was made.

38,800 (418 luna)
https://legacy.extraterrestrial.money/mainnet/tx/823e403a89e184f7da2a78b533fe1146be17c531eb18290704e9b8e3632ba1ef

$7716.74 (83.5 luna)
https://legacy.extraterrestrial.money/mainnet/tx/94f294c59ae145b22290d056276079e642d10977775d5eb99f452f3e224b94f3

Our multisig holds remaining fund of 539.5 luna and over the coming weeks we will outline additional milestones to further expand our functionality that will be billed against our multisig.

As our team has been putting 10+ hour days most days this month, we’re going to take a couple weeks off and will back in early April with a follow up milestones to add additional CSV formats , address any outstanding bugs , and add support additional protocols where needed.

For interested parties in building or running trackterra. Please view our updated readme and deployment documentation

github.com

trackterraorg/trackterra-api/blob/main/Deployment.md

<h2>  
Deployment
</h2>
<p> 
  The app can be deployed with/out docker. But it is highly recommend that docker is used due to complexity of the deployment process
</p>  
<p align="center"></p> 

## Prerequisits
- Install jq
```bash
apt install jq
```

- Install yq 4.18.1
```bash
sudo wget -qO /usr/local/bin/yq https://github.com/mikefarah/yq/releases/download/v4.18.1/yq_linux_amd64
sudo chmod a+x /usr/local/bin/yq
```

This file has been truncated. show original

somethingelse · March 25, 2022, 2:36am

Hey @Papi

I just want to say thank you for your time and dedication to delivering the product you promised to the Terra community in a fair and transparent way. I really appreciate the very detailed outline of future costs as well as the accounting of the depletion of the funds you took in. I’m very much appreciative of you considering how dismal some of the other projects funded by the community pool have been in their responsiveness and production of what was paid for.

At this point I consider TrackTerra a total community funded success! Congratulations! Thank you TrackTerra team so much!

This is a huge value add to the community, these parsers will really help others get started building out more advanced indexing. I also hope it spurs a conversation on how to standardize smart contract outputs.

Papi · April 8, 2022, 1:46am

Update: We are moving forward with another sprint to support 4 new export formats and spend time addressing a few bugs that were recently reported.

Time will be billed at hourly rate and we will revise spend before issuing funds from our multisig. Proposal considers worst case scenario for development effort.

We’re also increasing the pay of our developer to 100 per hour to account for the skill level and lack of full time work moving forward.

See below :

github.com

rebaz88/TrackTerra-v2/blob/proposal/update_1.md

# Update-1

This update includes adding support for 4 tax softwares as well as couple bug fixes

### Overview

- **Total Estimated Duration:** 8 working days
- **Full-Time Equivalent (FTE):** 1 FTE
- **Total Costs:** 4,480 USD

### Milestone 1  — **Add support for tax software**

- **Estimated Duration:** 3 working days
- **FTE:** 1
- **Costs:** 1,680 USD

| Number   | Deliverable | Specification      |
| :---------- | :------------ | :------------|
| 1           | Export data to a format readable by CoinLedger, CryptoTaxCalculator       |  - Users will be able to export the data to to the format supported by the mentioned taxing softwares.|

This file has been truncated. show original

Papi · April 14, 2022, 1:08am

This milestone is complete . We went a bit over the on inital estimated time here as we spent additional hours on bug fixes but will be paying out funds based on initial estimates. You can view our recent commits here Commits · trackterraorg/trackterra-api · GitHub these changes are now live in the app.

50.32 luna will be dispersed from the multisig.

somethingelse · April 14, 2022, 6:36pm

Amazing, thank you for the update.

Papi · April 16, 2022, 10:48am

We are moving forward with another update - in this update we will be refactoring and updating the design of trackterra to make it easier to contribute and self deploy (without docker) . See below.

github.com

rebaz88/TrackTerra-v2/blob/proposal/update_2.md

# Update-2 - Design update to simplify development and deployment

We have created the current version of TT based on microservices architure. This approach makes the application quite scalable both horizontally and vertically. However, it comes at a cost of adding commplexity to the system. This includes lots of tools and techniques which makes it difficult to contribute & deploy. While we can make the deployment process much easier, unfortunately we are unable to make development easier as it requires background and expierence with microservices.

In order to better enable and support future TT contributors we have decided to migrate major parts of the application to a new much more simpler development architecture. This update aims at making both the deployment and contribution much easier.

We will migrate the current main branch to a new branch, however we will not maintain it. It will be available if anyone wants to continue working on using and developing the microservices branch. We will maintain the only version hosted on trackterra.org .

### Overview

- **Total Estimated Duration:** 40 working hours
- **Full-Time Equivalent (FTE):** 1 FTE
- **Total Costs:** 4,000 USD

### Milestone 1  — ** Migrate system to a three-tier application **

- **Estimated Duration:** 40 working hours
- **FTE:** 1
- **Costs:** 4,000 USD

This file has been truncated. show original

Papi · May 1, 2022, 5:41am

This update is now live. Github docs have been updated to reflect the new deployment process. You can view the changes here GitHub - trackterraorg/trackterra-api

Funds will shortly be dispersed from multisig.

Topic		Replies	Views
Trackterra V2- Request for Feedback Blockchain	29	2365	October 13, 2021
Grant Proposal: Funding for Trustee Wallet Governance & Proposals	11	899	February 2, 2022
Separation of Rebel Station from TFL infrastructure Governance & Proposals	374	19443	April 5, 2023
Proposal to Reduce the Terra Tax Rate to Zero Stability	29	8545	May 14, 2022
Terra Station for Everybody Governance & Proposals	39	1282	May 10, 2023

Related topics