A few days back, a twitter user by the handle of @WilMetcalfe started a Q&A tweet regarding Blurt.

As I've mentioned in the Witness Projects section of my previous post, the migration of the Blurtopian BI (Business Intelligence) data from a cloud-based mongo DB to a locally hosted one was pending. This tweet prompted me to put the task on high priority.

At the onset, I would like to credit @saboin for his tremendous help for guiding me to setup a local Blurt node on my VPS machine. Being my first time to setup one, it took a lot of troubleshooting to make it to work. Prior to the local node setup, I was expecting the data extraction to take more than a month, it now only took me around four days to traverse all 1.4M blocks.

I now understand why he said that it sped up data extraction by a lot!

Anyways, here are the updates to each page of the site.

1. History

For easier reference, here are the introductory posts of this project.

1. #Blurtopian Analysis: Where is Blurt Now? A Blurt Blockchain Analysis
2. #Blurtopian Development: Introducing bi.blurt-now.com (Blurt Business Intelligence)

These two posts tackled what the project is about and how it started.

2. Migration Updates

In order to accomplish the migration, there were two parts of the solution.

1. Setting up a local node
   • I basically followed (it took a couple of re-runs) the steps shared by @saboin
2. Updating the streaming code/project
   • I had to use a modified version of Blurt's notification project which extracted the data and save them to a mongo DB

With these two in place, it was just a matter of running the project and wait for the script to traverse all blocks.

3. Site Updates (Blurt Analysis)

Here are the main sections or pages of the site.

3.1. Blurt Posts & Comments Count

As expected, there's currently an uptrend in the number of Blurt post and comments. I still have to add a moving average for this, but thi image should give us a ballpark figure on the average number of posts and comments (posts are green, comments are blue).

^{NOTE: Posts and comments from July 4 to July 9, 2020 were filtered out from the chart above because they skewed the graph due to the spam attack which against the chain with a peak of 28,000 posts+comments.}

3.2. Upvote Count

This is the second major page of the site. The number of upvotes done on the chain. Same as the posts and comments section/page, the upvotes are also on an uptrend.

3.3. Blurt Accounts Created

And lastly the number of accounts created. On October 31, there was sudden spike of 34 accounts created with 21 accounts created by @ obikay.

4. Next

I plan to create a new execute summary page. I just have to figure out the data that needs to be displayed on this page.

---

@eastmael's Witness Projects

• https://blurt-now.com/ to monitor your Blurt account
• @brunobot a Blurt Discord Bot notification service
• https://dtube.blurtopian.com/ - Blurt + Dtube Integration to simultaneously post your video on DTube and Blurt
• Blurt Richlist API in coordination with @ecosynthesizer's Blurt Richlist UI
• https://bi.blurt-now.com/ for your Blurt Business Intelligence data needs
• https://blurtopian.com @blurtopian #blurtopian Blurt contribution curation initiative

---

Find my contributions valuable? Please consider voting for my witness:

https://blurtwallet.com/~witnesses?highlight=eastmael