Before 2017 ends, I would share a quick post to show some statisctics about my posts in the past 2 weeks. After 2 weeks on steemit, I feel very grateful and wanted to thank everyone of you that support me through this, especially from #teammalaysia. Without them, I would not have the motive to keep posting new contents, they also teach me tips and tricks with steem.

Since I had join steemit, I had receive close to 700 upvotes! (Details at the last sections) Which is a big achievement for me because in the past, my blog was not even viewed more than 10 people.

What I have learn since I join Steemit

• CryptoCurrency
  I learn how the crypto transactions works, buying and selling of crypto, and invest based on market cap instead of the change in price.
• Transactions with CryptoCurrency
  I manage to cash out cryptocurrency into fiat money.
• Investment with CryptoCurrency
  I learn about ICO and forking in CryptoCurrency. And best part of it, I haven't spend a single cents on investment in cryptocurrency.
• Making Discord Bot
  This morning, I manage to build a bot that will tell me wether that certain tag suitable for my post or not.
• MSSQL
  I learn to use Microsoft Server SQL, with their style of sql and making some analysis out from there.
• Making API with MSSQL using Node
  I also learn to use MSSQL along side with Node.js by making this website

Some statistics

Total Post

SELECT
 SUM(net_votes) as Votes,
 SUM(children) as Comments,
 COUNT(*) as Posts
FROM
 Comments (NOLOCK)
WHERE
 author = 'superoo7' and
 dirty = 'False' and
 parent_author = ''

Detail Post

This query extract out the post details.

SELECT
 title as Title,
 net_votes as '👍',
 children as '💭',
 JSON_QUERY(json_metadata, '$.tags') AS meta
FROM
 Comments (NOLOCK)
WHERE
 author = 'superoo7' and
 dirty = 'False' and
 parent_author = ''

All the post that I had done

Title	👍	💭	meta
Add to homescreen icon not properly shown	6	1	["utopian-io","steemit","steemit-issues","steem","teammalaysia"]
A Demo on collection of Progressive Web App features	8	8	["utopian-io","web","opensource","javascript","teammalaysia"]
Advent Of Code	11	3	["programming","teammalaysia","malaysia","elixir","opensource"]
A High Level View of Progressive Web App	14	2	["web","opensource","teammalaysia","malaysia","technology"]
Automatically post on twitter on new steemit post	9	9	["utopian-io","steemeducation","education","teammalaysia","twitter"]
Back to Analogue Gaming	4	3	["life","games","game","teammalaysia","malaysia"]
Better Software Development in Team with JavaScript Part 1	41	2	["javascript","web","software","programming","teammalaysia"]
Better Software Development in Team with JavaScript Part 2 with Docker	15	3	["javascript","web","software","programming","teammalaysia"]
Better Software Development in Team with JavaScript Part 3 with Docker	4	3	["javascript","web","software","programming","teammalaysia"]
Better Software Development in Team with JavaScript Part 4 (Final)	43	0	["javascript","web","programming","busy","teammalaysia"]
Cash out my first SBD to RM	15	10	["teammalaysia","malaysia","steemit","life"]
Contribution to open Dota Website	15	4	["utopian-io","programming","opensource","react","teammalaysia"]
Cookies VS Token based authentication	4	2	["web","software","programming","teammalaysia","steemeducation"]
Demo and High Level View of Progressive Web App	16	3	["utopian-io","opensource","teammalaysia","web","software"]
My free tutorial on Progressive Web App	25	7	["utopian-io","opensource","steemeducation","teammalaysia","programming"]
Getting Started with TypeScript	6	2	["utopian-io","javascript","software","web","teammalaysia"]
Getting started with CasperJS	12	10	["utopian-io","javascript","web","opensource","teammalaysia"]
Gift from Digital Ocean	32	1	["opensource","software","teammalaysia","technology","life"]
Javascript let, const and var	57	3	["utopian-io","javascript","web","software","teammalaysia"]
JWT Token Introduction	47	2	["web","teammalaysia","malaysia","opensource","programming"]
Making my first Discord Bot	11	0	["teammalaysia","bot","discord","javascript","steemit"]
Making Open Dota into Progressive Web App	7	2	["utopian-io","dota2","games","opensource","teammalaysia"]
Making print and play games	12	2	["games","game","teammalaysia","life","malaysia"]
Pull Request into Solution of AdventOfCode	15	6	["utopian-io","web","programming","technology","teammalaysia"]
Push Notification	5	2	["teammalaysia","technology","malaysia","programming","web"]
Selling your used car in Malaysia	60	3	["teammalaysia","malaysia","money","cars","automotive"]
Solution for a good tag for your post	61	1	["teammalaysia","steemeducation","developer","sql","javascript"]
Starting as a volunteer at DevCon Community	49	5	["life","teammalaysia","malaysia","blog","community"]
SteemSQL Tables and Columns	7	3	["steemit","teammalaysia","steemeducation","database","sql"]
Thoughts of making some cool things with SteemSQL	35	1	["teammalaysia","thoughts","database","sql","javascript"]
Tutor for Computing Application for Engineers	45	4	["utopian-io","engineering","teammalaysia","opensource","programming"]
Working on new project and chilling	5	0	[ "life", "photography", "steemit", "teammalaysia", "work", "steepshot" ]

About Me

I am Lai Weng Han (Johnson), you can find me on Twitter.