{
  "block": 106143042,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "5972.527241 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-05-17T23:54:48",
  "trx_id": "b4f98b2d96652e2a01a4ceb2688129895802ae3a",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 105974033,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "3260.316836 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-05-12T02:26:30",
  "trx_id": "5879ab28fa8fa3f18100ee74a51d574e2c04043a",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 105510702,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "5985.042997 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-04-25T23:16:12",
  "trx_id": "42cf2f83cbf24e15bf03605443d88e49f1e90859",
  "trx_in_block": 4,
  "virtual_op": 0
}

{
  "block": 102850698,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "3301.863655 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-01-23T06:52:30",
  "trx_id": "9f055ecae56e820c80304f7df12f96fafde8dce3",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 91297118,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "3466.082852 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2024-12-17T02:12:00",
  "trx_id": "75d85aeb4148214dbb063b84d769c1a298d888e9",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 79851318,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "3635.216384 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2023-11-13T17:54:42",
  "trx_id": "e0da6eeae7a8818b87c5951914fc10a91e043810",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 78347339,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "6572.495170 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2023-09-21T21:25:21",
  "trx_id": "def37f3d80fc91f4ae16c2562932d0578fec976a",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 69112750,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "6794.176608 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-11-03T11:16:30",
  "trx_id": "f86b35e25b0f9d4358185cb5aaa00d515ad829c7",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 60808955,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "7014.709839 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-01-17T10:34:27",
  "trx_id": "0a4571cd4e5ab5fb8910b837f13badd41296d9c9",
  "trx_in_block": 14,
  "virtual_op": 0
}

{
  "block": 54607365,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "7198.478497 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-06-14T00:30:42",
  "trx_id": "711469c340748553bc4e785f86b3ae7ca5c8ac34",
  "trx_in_block": 7,
  "virtual_op": 0
}

{
  "block": 49354838,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "7385.900471 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-11T10:50:12",
  "trx_id": "ea283f0290d8b81f3704637b964900fdc34efd0a",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 49206407,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "1912.543513 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-06T04:27:30",
  "trx_id": "35301ae2ea20b772ea49536b840be7896fce510f",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 49189940,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "7392.108325 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-05T14:28:27",
  "trx_id": "7aa7e55c8d3f545e688fee026780ce9902c8062f",
  "trx_in_block": 4,
  "virtual_op": 0
}

{
  "block": 48256972,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "1920.017158 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-11-02T14:56:18",
  "trx_id": "0eba6149d52033eb9156dd64adb7909b15413be7",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 43216646,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "7594.913684 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-05-09T05:24:27",
  "trx_id": "3027fcdf35d190ada2649ae42cfb6f182df877a0",
  "trx_in_block": 6,
  "virtual_op": 0
}

{
  "block": 43192685,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "1953.311140 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-05-08T08:57:27",
  "trx_id": "10a2c421f750e4524bb72e52ebe71201cf9b627a",
  "trx_in_block": 11,
  "virtual_op": 0
}

{
  "block": 39312903,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @elingmeyatmaja! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@elingmeyatmaja/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@elingmeyatmaja) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=elingmeyatmaja)_</sub>\n\n\n###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "elingmeyatmaja",
      "parent_permlink": "building-restful-apis-with-the-gin-framework",
      "permlink": "steemitboard-notify-elingmeyatmaja-20191224t084933000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-12-24T08:49:33",
  "trx_id": "8bdae816f9ff295ceb4c4321d96207828036720f",
  "trx_in_block": 4,
  "virtual_op": 0
}

{
  "block": 38790474,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "7680.715258 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-12-06T04:39:42",
  "trx_id": "e84d096a28b13c31bafa9e92c2edd5556eade925",
  "trx_in_block": 17,
  "virtual_op": 0
}

{
  "block": 29123130,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "7877.774968 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-01-03T05:20:54",
  "trx_id": "534f647d29fbb4de8adba98c09d945bac76b993b",
  "trx_in_block": 11,
  "virtual_op": 0
}

{
  "block": 28842114,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @elingmeyatmaja! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@elingmeyatmaja/birthday1.png</td><td>1 Year on Steemit</td></tr></table>\n\n<sub>_[Click here to view your Board](https://steemitboard.com/@elingmeyatmaja)_</sub>\n\n\n**Do not miss the last post from @steemitboard:**\n<table><tr><td><a href=\"https://steemit.com/christmas/@steemitboard/christmas-challenge-send-a-gift-to-to-your-friends\"><img src=\"https://steemitimages.com/64x128/http://i.cubeupload.com/kf4SJb.png\"></a></td><td><a href=\"https://steemit.com/christmas/@steemitboard/christmas-challenge-send-a-gift-to-to-your-friends\">Christmas Challenge - Send a gift to to your friends</a></td></tr></table>\n\n> Support [SteemitBoard's project](https://steemit.com/@steemitboard)! **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "elingmeyatmaja",
      "parent_permlink": "building-restful-apis-with-the-gin-framework",
      "permlink": "steemitboard-notify-elingmeyatmaja-20181224t110102000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-12-24T11:01:03",
  "trx_id": "6a46183a29d6ba04c18267360890be01d88c30cb",
  "trx_in_block": 4,
  "virtual_op": 0
}

{
  "block": 26737502,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "28112.898180 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-12T08:03:06",
  "trx_id": "c59ac6c78fc84b287c302fd022c8e171ec12d4e6",
  "trx_in_block": 11,
  "virtual_op": 0
}

{
  "block": 26737389,
  "op": [
    "claim_reward_balance",
    {
      "account": "elingmeyatmaja",
      "reward_sbd": "0.375 SBD",
      "reward_steem": "0.000 STEEM",
      "reward_vests": "908.615652 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-12T07:57:27",
  "trx_id": "04ce7eb8292b3af069b4359263ab5c18c709a9c9",
  "trx_in_block": 15,
  "virtual_op": 0
}

{
  "block": 26700750,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @elingmeyatmaja! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :\n\n[![](https://steemitimages.com/70x70/http://steemitboard.com/notifications/firstpayout.png)](http://steemitboard.com/@elingmeyatmaja) You got your First payout\n\n<sub>_Click on the badge to view your Board of Honor._</sub>\n<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>\n\n\n\n**Do not miss the last post from @steemitboard:**\n<table><tr><td><a href=\"https://steemit.com/spanish/@steemitboard/presentamos-el-ranking-de-steemitboard\"><img src=\"https://steemitimages.com/64x128/https://cdn.steemitimages.com/DQmfRVpHQhLDhnjDtqck8GPv9NPvNKPfMsDaAFDE1D9Er2Z/header_ranking.png\"></a></td><td><a href=\"https://steemit.com/spanish/@steemitboard/presentamos-el-ranking-de-steemitboard\">Presentamos el Ranking de SteemitBoard</a></td></tr></table>\n\n> Support [SteemitBoard's project](https://steemit.com/@steemitboard)! **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "elingmeyatmaja",
      "parent_permlink": "building-restful-apis-with-the-gin-framework",
      "permlink": "steemitboard-notify-elingmeyatmaja-20181011t012314000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-11T01:23:12",
  "trx_id": "d73ce6691e3b5e00d12fe8df07f7a0b0540c255b",
  "trx_in_block": 14,
  "virtual_op": 0
}

{
  "block": 26688019,
  "op": [
    "author_reward",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "sbd_payout": "0.375 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "908.615652 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-10T14:46:00",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 19
}

{
  "block": 26520199,
  "op": [
    "comment",
    {
      "author": "portugalcoin",
      "body": "Comment deleted\n\n---- \nNeed help? Write a ticket on https://support.utopian.io/. \nChat with us on [Discord](https://discord.gg/uTyJkNm). \n[[utopian-moderator]](https://join.utopian.io/)",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"links\":[\"https://support.utopian.io/\",\"https://discord.gg/uTyJkNm\",\"https://join.utopian.io/\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "elingmeyatmaja",
      "parent_permlink": "building-restful-apis-with-the-gin-framework",
      "permlink": "re-elingmeyatmaja-building-restful-apis-with-the-gin-framework-20181003t230302307z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-04T18:49:48",
  "trx_id": "c91b41cea3509195e6ea5f35d2b985915f30a4df",
  "trx_in_block": 11,
  "virtual_op": 0
}

{
  "block": 26508248,
  "op": [
    "comment",
    {
      "author": "mcfarhat",
      "body": "Your contribution has been found to be a copy of https://blog.narenarya.in/build-rest-api-go-mysql.html\nThis is considered plagiarism. Plagiarism is a serious offense, and hence your account has been banned for 30 days from receiving Utopian reviews.\nFuture plagiarism can lead to permanent ban of your account\n\n\n---- \nNeed help? Write a ticket on https://support.utopian.io/. \nChat with us on [Discord](https://discord.gg/uTyJkNm). \n[[utopian-moderator]](https://join.utopian.io/)",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"links\":[\"https://blog.narenarya.in/build-rest-api-go-mysql.html\",\"https://support.utopian.io/\",\"https://discord.gg/uTyJkNm\",\"https://join.utopian.io/\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "elingmeyatmaja",
      "parent_permlink": "building-restful-apis-with-the-gin-framework",
      "permlink": "re-elingmeyatmaja-building-restful-apis-with-the-gin-framework-20181004t085126878z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-04T08:51:57",
  "trx_id": "5dfaa70e08a48907f64bc0af23e656760a245c78",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 26502701,
  "op": [
    "comment",
    {
      "author": "elingmeyatmaja",
      "body": "Thank you for your moderation, I've updated my tittle too.",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "portugalcoin",
      "parent_permlink": "re-elingmeyatmaja-building-restful-apis-with-the-gin-framework-20181003t230302307z",
      "permlink": "re-portugalcoin-re-elingmeyatmaja-building-restful-apis-with-the-gin-framework-20181004t041429634z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-04T04:14:30",
  "trx_id": "3b8eb5eb7439d53eebad963e4f304681c90d825f",
  "trx_in_block": 16,
  "virtual_op": 0
}

{
  "block": 26502547,
  "op": [
    "comment",
    {
      "author": "elingmeyatmaja",
      "body": "![goalng.png](https://cdn.steemitimages.com/DQmecweo98CY8AM1phvmEZ5SZ1oCJtwmbVUEtUmqkgx3xqS/goalng.png)\n\n# Repository <h1>\nhttps://github.com/gin-gonic/gin\n# What Will I Learn?<h1> \n- Creating a REST API with the go-restful package\n- Creating a connection to MySql database\n- Introducing the Gin framework for creating a REST API\n- Testing the RESTful API with this GUI tool\n\n# Requirements<h1> \nState the requirements the user needs in order to follow this tutorial.\n- Localhost xampp\n- Basic GoLang\n- Basic Gin Golang \n- Basic Database MySQL\n\n# Difficulty<h1> \nIntermediate\n# Tutorial Contents<h1> \nIn this chapter, we are going to use a framework for simplifying building REST services. First, we will take a quick look at gin. Gin-gonic is a framework based on the httprouter. In this section I will show you how build REST service gin connect to mysql.\n\nPrepare your databases \nhttps://cdn.steemitimages.com/DQmdbTKeCA9SNHXD8QxcH6Rt9x8rrMdsyx4YSFufwKN7xof/Untitled.jpg\n\nTo install Gin package, you need to install Go and set your Go workspace first. GOPATH is nothing but the current appointed workspace on your machine. It is an\nenvironment variable that tells the Go compiler about where your source code, binaries,\nand packages are placed. While developing, set the GOPATH to one\nof your projects. The Go compiler now activates that project.\n1. Download and install it:\n$ go get -u github.com/gin-gonic/gin\nSimple install the package to your $GOPATH with the go tool from shell:\n$ go get -u github.com/go-sql-driver/mysql\nMake sure Git is installed on your machine and in your system's PATH.\n\n2. REST uses the URI to decode its resource to be handled. There are quite a few REST verbs available, but six of them are used frequently. They are as follows:\n- GET\n- POST\n- PUT\n- PATCH\n- DELETE\n\nBreakdown code\n\n```\npackage main\n\nimport (\n    \"bytes\"\n    \"database/sql\"\n    \"fmt\"\n    \"net/http\"\n\n    \"github.com/gin-gonic/gin\"\n    _ \"github.com/go-sql-driver/mysql\"\n)\n\n```\n- Package bytes implements functions for the manipulation of byte slices. It is analogous to the facilities of the strings package.\n- Package sql provides a generic interface around SQL (or SQL-like) databases. \n- Package fmt implements formatted I/O with functions\n- Imported a few packages. github.com/gin-gonic/gin, github.com/go-sql-driver/mysql is the  data service we created   before.\n- net/http is the core package we used to handle an HTTP request through its HandleFunc function. That function's arguments are http.Request and http.ResponseWriter. Those two deal with the request and response of an HTTP request.\n\n```\npackage main\n\t\n\timport (\n\t\t\"bytes\"\n\t\t\"database/sql\"\n\t\t\"fmt\"\n\t\t\"net/http\"\n\t\n\t\t\"github.com/gin-gonic/gin\"\n\t\t_ \"github.com/go-sql-driver/mysql\"\n\t)\n\t\n\tfunc main() {\n\t\tdb, err := sql.Open(\"mysql\", \"root:passapp@tcp(127.0.0.1:3306)/gotest\")\n\t\tif err != nil {\n\t\t\tfmt.Print(err.Error())\n\t\t}\n\t\tdefer db.Close()\n\t\t// make sure connection is available\n\t\terr = db.Ping()\n\t\tif err != nil {\n\t\t\tfmt.Print(err.Error())\n\t\t}\n\t\ttype Person struct {\n\t\t\tId         int\n\t\t\tFirst_Name string\n\t\t\tLast_Name  string\n\t\t}\n\t\trouter := gin.Default()\n\t\t// Add API handlers here\n\t\trouter.Run(\":3000\")\n\t}\n\n```\n\n- In every gin app, we should create a Default or New gin router\n- We can specify :port on which our Gin applications run using port 3000\n- We will keep the article structure simple with just three fields - Id, First_Name and Last_Name. This can be represented with a struct as follows:\n- The Data Source Name has a common format, but without type-prefix (optional parts marked by squared brackets):\n        - example : [username[:password]@][protocol[(address)]]/dbname[?param1=value1&...&paramN=valueN]\n\n```\n// GET a person detail\n    router.GET(\"/person/:id\", func(c *gin.Context) {\n        var (\n            person Person\n            result gin.H\n        )\n        id := c.Param(\"id\")\n        row := db.QueryRow(\"select id, first_name, last_name from person where id = ?;\", id)\n        err = row.Scan(&person.Id, &person.First_Name, &person.Last_Name)\n        if err != nil {\n            // If no results send null\n            result = gin.H{\n                \"result\": nil,\n                \"count\":  0,\n            }\n        } else {\n            result = gin.H{\n                \"result\": person,\n                \"count\":  1,\n            }\n        }\n        c.JSON(http.StatusOK, result)\n    })\n\n```\n- Routing is one of the core features that all modern frameworks provide. Any web page or an API end point is accessed by a URL. Frameworks use routes to handle requests to these URLs. \n- Gin offers a fast router that's easy to configure and use. Apart from handling specified URLs, Gin routers can also handle patterns and grouped URLs.\n- A GET method fetches the given resource from the server. To specify a resource, GET uses a few types of URI queries:\n\t- Query parameters\n\t- Path-based parameters\n- We use http.StatusOK to set the status code of the response header. The WriteHeader and Write functions are available on the response object for writing the header and body, respectively.\n\n```\n/// GET all persons\n    router.GET(\"/persons\", func(c *gin.Context) {\n        var (\n            person  Person\n            persons []Person\n        )\n        rows, err := db.Query(\"select id, first_name, last_name from person;\")\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n        for rows.Next() {\n            err = rows.Scan(&person.Id, &person.First_Name, &person.Last_Name)\n            persons = append(persons, person)\n            if err != nil {\n                fmt.Print(err.Error())\n            }\n        }\n        defer rows.Close()\n        c.JSON(http.StatusOK, gin.H{\n            \"result\": persons,\n            \"count\":  len(persons),\n        })\n    })\n\n```\nHere, the resource query is with the path parameter. Query parameters are intended to add detailed information to identify a resource from the server. For example, take this sample fictitious API. Let us assume this API is created for fetching, creating, and updating \n\n```\n// POST new person details\n    router.POST(\"/person\", func(c *gin.Context) {\n        var buffer bytes.Buffer\n        first_name := c.PostForm(\"first_name\")\n        last_name := c.PostForm(\"last_name\")\n        stmt, err := db.Prepare(\"insert into person (first_name, last_name) values(?,?);\")\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n        _, err = stmt.Exec(first_name, last_name)\n\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n\n        // Fastest way to append strings\n        buffer.WriteString(first_name)\n        buffer.WriteString(\" \")\n        buffer.WriteString(last_name)\n        defer stmt.Close()\n        name := buffer.String()\n        c.JSON(http.StatusOK, gin.H{\n            \"message\": fmt.Sprintf(\" %s successfully created\", name),\n        })\n    })\n\n```\nThe POST method  is used to create a resource on the server. A successful POST operation returns a 201 status code.\n```\n// PUT - update a person details\n    router.PUT(\"/person\", func(c *gin.Context) {\n        var buffer bytes.Buffer\n        id := c.Query(\"id\")\n        first_name := c.PostForm(\"first_name\")\n        last_name := c.PostForm(\"last_name\")\n        stmt, err := db.Prepare(\"update person set first_name= ?, last_name= ? where id= ?;\")\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n        _, err = stmt.Exec(first_name, last_name, id)\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n\n        // Fastest way to append strings\n        buffer.WriteString(first_name)\n        buffer.WriteString(\" \")\n        buffer.WriteString(last_name)\n        defer stmt.Close()\n        name := buffer.String()\n        c.JSON(http.StatusOK, gin.H{\n            \"message\": fmt.Sprintf(\"Successfully updated to %s\", name),\n        })\n    })\n```\n- In this part, create and initialize a new Buffer using string as its initial contents. It is intended to prepare a buffer to read an existing string.\n- The PUT method is similar to POST. It is used to replace the resource that already exists. The main difference is that PUT is idempotent. A POST call creates two instances with the same data. But PUT updates a single resource that already exists.\n```\n// Delete resources\n    router.DELETE(\"/person\", func(c *gin.Context) {\n        id := c.Query(\"id\")\n        stmt, err := db.Prepare(\"delete from person where id= ?;\")\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n        _, err = stmt.Exec(id)\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n        c.JSON(http.StatusOK, gin.H{\n            \"message\": fmt.Sprintf(\"Successfully deleted user: %s\", id),\n        })\n    })\n\n```\n\nThe DELETE API method is used to delete a resource from the database. It is similar to PUT but without any body. It just needs an ID of the resource to be deleted. Once a resource gets deleted, subsequent GET requests return a 404 not found status.\n\nIf we run this program:\nrun main.go\n\n![gin.png](https://cdn.steemitimages.com/DQmf8GhP13e8AWGbuvQNedn3GsAsrmQFSSrK9cH9ge5s31s/gin.png)\n\nThe following screenshot shows the JSON response body in Postman for the HTTP GET\nrequest:\n\n![postman.png](https://cdn.steemitimages.com/DQmayjxBvXCSBFEgQZQdDXGEU4e2JL7pk5RipmzW3UQ7HAd/postman.png)\n# Proof of Work Done<h1> \nhttps://github.com/elingmeyatmaja/RESTful-APIs-Gin-",
      "json_metadata": "{\"tags\":[\"utopian-io\",\"tutorials\",\"webservice\",\"restful\",\"golang\"],\"image\":[\"https://cdn.steemitimages.com/DQmecweo98CY8AM1phvmEZ5SZ1oCJtwmbVUEtUmqkgx3xqS/goalng.png\",\"https://cdn.steemitimages.com/DQmdbTKeCA9SNHXD8QxcH6Rt9x8rrMdsyx4YSFufwKN7xof/Untitled.jpg\",\"https://cdn.steemitimages.com/DQmf8GhP13e8AWGbuvQNedn3GsAsrmQFSSrK9cH9ge5s31s/gin.png\",\"https://cdn.steemitimages.com/DQmayjxBvXCSBFEgQZQdDXGEU4e2JL7pk5RipmzW3UQ7HAd/postman.png\"],\"links\":[\"https://github.com/gin-gonic/gin\",\"https://github.com/elingmeyatmaja/RESTful-APIs-Gin-\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "title": "MySql tutorial : Building RESTful APIs with the Gin framework"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-04T04:06:48",
  "trx_id": "8c6f11bf0a3d2721e5d0476d33f77044b2793546",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 26497750,
  "op": [
    "comment",
    {
      "author": "steem-ua",
      "body": "#### Hi @elingmeyatmaja!\n\nYour post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!\nYour post is eligible for our upvote, thanks to our collaboration with @utopian-io!\n**Feel free to join our [@steem-ua Discord server](https://discord.gg/KpBNYGz)**",
      "json_metadata": "{\"app\": \"beem/0.20.5\"}",
      "parent_author": "elingmeyatmaja",
      "parent_permlink": "building-restful-apis-with-the-gin-framework",
      "permlink": "re-building-restful-apis-with-the-gin-framework-20181004t000650z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-04T00:06:51",
  "trx_id": "22f84e1cd99105048a5b83e572704cfac807e2fd",
  "trx_in_block": 10,
  "virtual_op": 0
}

{
  "block": 26497746,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "steem-ua",
      "weight": 133
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-04T00:06:39",
  "trx_id": "2ae66b7be9bf8bfde05626c96176c65a802566ba",
  "trx_in_block": 25,
  "virtual_op": 0
}

{
  "block": 26496613,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "bullinachinashop",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T23:10:00",
  "trx_id": "71a3d9742f1f639f6b7dca4fc07f0c24bac7fa0c",
  "trx_in_block": 12,
  "virtual_op": 0
}

{
  "block": 26496613,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "mightypanda",
      "weight": 4500
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T23:10:00",
  "trx_id": "4a170723e81c0c605f4ea9b5b5d9f6988053096a",
  "trx_in_block": 11,
  "virtual_op": 0
}

{
  "block": 26496476,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "portugalcoin",
      "weight": 2800
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T23:03:09",
  "trx_id": "7a511483a9959d3bfc0343b97dd609dd1c8f9987",
  "trx_in_block": 9,
  "virtual_op": 0
}

{
  "block": 26496474,
  "op": [
    "comment",
    {
      "author": "portugalcoin",
      "body": "Thank you for your contribution @elingmeyatmaja.\nWe have been analyzing your tutorial and we suggest the following points:\n\n- We suggest that you enter as a keyword in the title of your MySql tutorial.\n\nYour tutorial is very intuitive. However we have seen a tutorial that complements yours <a href=\"https://medium.com/@thedevsaddam/build-restful-api-service-in-golang-using-gin-gonic-framework-85b1a6e176f3\">link</a>.\n\nGood work and we look forward to more tutorials from you.\n\nYour contribution has been evaluated according to [Utopian policies and guidelines](https://join.utopian.io/guidelines), as well as a predefined set of questions pertaining to the category.\n\nTo view those questions and the relevant answers related to your post, [click here](https://review.utopian.io/result/8/21313323).\n\n---- \nNeed help? Write a ticket on https://support.utopian.io/. \nChat with us on [Discord](https://discord.gg/uTyJkNm). \n[[utopian-moderator]](https://join.utopian.io/)",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"users\":[\"elingmeyatmaja\"],\"links\":[\"https://medium.com/@thedevsaddam/build-restful-api-service-in-golang-using-gin-gonic-framework-85b1a6e176f3\",\"https://join.utopian.io/guidelines\",\"https://review.utopian.io/result/8/21313323\",\"https://support.utopian.io/\",\"https://discord.gg/uTyJkNm\",\"https://join.utopian.io/\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "elingmeyatmaja",
      "parent_permlink": "building-restful-apis-with-the-gin-framework",
      "permlink": "re-elingmeyatmaja-building-restful-apis-with-the-gin-framework-20181003t230302307z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T23:03:03",
  "trx_id": "00f2c73c4ada1fc2e4bcef811330c8dad67b43a7",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 26495582,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "holger80",
      "weight": 7500
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T22:18:15",
  "trx_id": "383a0cedb1086ba0ade552fe3fb699969a05e49a",
  "trx_in_block": 14,
  "virtual_op": 0
}

{
  "block": 26489079,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "amosbastian",
      "weight": 500
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T16:52:57",
  "trx_id": "cc45a30d10ccf1c74b383cb5f79af27e7e2f9e26",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 26488116,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "codingdefined",
      "weight": 1000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T16:04:48",
  "trx_id": "b4e2edc208edffaf27fd1e19f134794f845defa8",
  "trx_in_block": 15,
  "virtual_op": 0
}

{
  "block": 26487975,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "remlaps2",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:57:45",
  "trx_id": "f4ec8b269fe3bac1076252fbf9772d9b4ea59c54",
  "trx_in_block": 24,
  "virtual_op": 0
}

{
  "block": 26487975,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "cub2",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:57:45",
  "trx_id": "0e5213c0bff41d8b88cd05f4a83f6c033cea41c9",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 26487974,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "remlaps-lite",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:57:42",
  "trx_id": "9ca64771e7ca279f859a6d4e6aaded59bd4cb9b7",
  "trx_in_block": 9,
  "virtual_op": 0
}

{
  "block": 26487973,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "cmp2020-lite",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:57:39",
  "trx_id": "7fcca0d8012684ddfe726d636bd37e031ad38f09",
  "trx_in_block": 15,
  "virtual_op": 0
}

{
  "block": 26487973,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "rgkmb-unofficial",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:57:39",
  "trx_id": "3ff67f5ec8eafbaef6d8a3bad803d5363d7f2da8",
  "trx_in_block": 9,
  "virtual_op": 0
}

{
  "block": 26487972,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "rgkmb",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:57:36",
  "trx_id": "8d092f611c18513fb5ebfb2b0d6356e8b0225142",
  "trx_in_block": 16,
  "virtual_op": 0
}

{
  "block": 26487972,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "astronomyizfun",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:57:36",
  "trx_id": "c284a92fe8156f11fb9db307ae72bf112a123e40",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 26487958,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "cub1",
      "weight": 2200
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:56:54",
  "trx_id": "c32d08279e56b2574cb071ad294d1d7a8b7a7d42",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 26487957,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "cmp2020",
      "weight": 2200
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:56:51",
  "trx_id": "f4c833634db3f960a4e7fca94f2d071470b555e9",
  "trx_in_block": 14,
  "virtual_op": 0
}

{
  "block": 26487824,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "svemirac",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:50:12",
  "trx_id": "768c9b4ef389c3e63d634bead58a07243c3d3ca9",
  "trx_in_block": 7,
  "virtual_op": 0
}

{
  "block": 26486924,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "andeladenaro",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:05:12",
  "trx_id": "004d1c647e46d8bf8567491982bacc80d95eacda",
  "trx_in_block": 8,
  "virtual_op": 0
}

{
  "block": 26486873,
  "op": [
    "comment",
    {
      "author": "pinoy",
      "body": "I upvoted your post.\r\n\r\nCheers to you.\r\n@Pinoy\r\n\r\nPosted using https://Steeming.com condenser site.",
      "json_metadata": "{}",
      "parent_author": "elingmeyatmaja",
      "parent_permlink": "building-restful-apis-with-the-gin-framework",
      "permlink": "re-elingmeyatmaja-building-restful-apis-with-the-gin-framework-20181003t150237956z",
      "title": "fossbot voter comment"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:02:39",
  "trx_id": "1e2fef6441a78c8e2192451fcd4ff756e402b7fc",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 26486870,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "pinoy",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:02:30",
  "trx_id": "5ad4f6064b7bf90cd5411db80c8158dc70fc368a",
  "trx_in_block": 21,
  "virtual_op": 0
}

{
  "block": 26486855,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "alphabot",
      "weight": 100
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:01:45",
  "trx_id": "1fc209cc4227779f100a8cb572a8c4666599c4a1",
  "trx_in_block": 28,
  "virtual_op": 0
}

{
  "block": 26486852,
  "op": [
    "comment",
    {
      "author": "elingmeyatmaja",
      "body": "@@ -1,12 +1,117 @@\n+!%5Bgoalng.png%5D(https://cdn.steemitimages.com/DQmecweo98CY8AM1phvmEZ5SZ1oCJtwmbVUEtUmqkgx3xqS/goalng.png)%0A%0A\n # Repository\n",
      "json_metadata": "{\"tags\":[\"utopian-io\",\"tutorials\",\"webservice\",\"restful\",\"golang\"],\"image\":[\"https://cdn.steemitimages.com/DQmecweo98CY8AM1phvmEZ5SZ1oCJtwmbVUEtUmqkgx3xqS/goalng.png\",\"https://cdn.steemitimages.com/DQmdbTKeCA9SNHXD8QxcH6Rt9x8rrMdsyx4YSFufwKN7xof/Untitled.jpg\",\"https://cdn.steemitimages.com/DQmf8GhP13e8AWGbuvQNedn3GsAsrmQFSSrK9cH9ge5s31s/gin.png\",\"https://cdn.steemitimages.com/DQmayjxBvXCSBFEgQZQdDXGEU4e2JL7pk5RipmzW3UQ7HAd/postman.png\"],\"links\":[\"https://github.com/gin-gonic/gin\",\"https://github.com/elingmeyatmaja/RESTful-APIs-Gin-\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "title": "Building RESTful APIs with the Gin framework"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T15:01:36",
  "trx_id": "ea4d34bed7fe26a180d7f4476824f4a75482e113",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 26486648,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "curbot",
      "weight": 1000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T14:51:24",
  "trx_id": "628d20b19aaf2535e99818a8b5b01d3cc5c56012",
  "trx_in_block": 33,
  "virtual_op": 0
}

{
  "block": 26486543,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "voter": "fastresteem",
      "weight": 100
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T14:46:09",
  "trx_id": "21fd68be8a32488d44b4c93891ddca51e25ccd70",
  "trx_in_block": 14,
  "virtual_op": 0
}

{
  "block": 26486540,
  "op": [
    "comment",
    {
      "author": "elingmeyatmaja",
      "body": "# Repository <h1>\nhttps://github.com/gin-gonic/gin\n# What Will I Learn?<h1> \n- Creating a REST API with the go-restful package\n- Creating a connection to MySql database\n- Introducing the Gin framework for creating a REST API\n- Testing the RESTful API with this GUI tool\n\n# Requirements<h1> \nState the requirements the user needs in order to follow this tutorial.\n- Localhost xampp\n- Basic GoLang\n- Basic Gin Golang \n- Basic Database MySQL\n\n# Difficulty<h1> \nIntermediate\n# Tutorial Contents<h1> \nIn this chapter, we are going to use a framework for simplifying building REST services. First, we will take a quick look at gin. Gin-gonic is a framework based on the httprouter. In this section I will show you how build REST service gin connect to mysql.\n\nPrepare your databases \nhttps://cdn.steemitimages.com/DQmdbTKeCA9SNHXD8QxcH6Rt9x8rrMdsyx4YSFufwKN7xof/Untitled.jpg\n\nTo install Gin package, you need to install Go and set your Go workspace first. GOPATH is nothing but the current appointed workspace on your machine. It is an\nenvironment variable that tells the Go compiler about where your source code, binaries,\nand packages are placed. While developing, set the GOPATH to one\nof your projects. The Go compiler now activates that project.\n1. Download and install it:\n$ go get -u github.com/gin-gonic/gin\nSimple install the package to your $GOPATH with the go tool from shell:\n$ go get -u github.com/go-sql-driver/mysql\nMake sure Git is installed on your machine and in your system's PATH.\n\n2. REST uses the URI to decode its resource to be handled. There are quite a few REST verbs available, but six of them are used frequently. They are as follows:\n- GET\n- POST\n- PUT\n- PATCH\n- DELETE\n\nBreakdown code\n\n```\npackage main\n\nimport (\n    \"bytes\"\n    \"database/sql\"\n    \"fmt\"\n    \"net/http\"\n\n    \"github.com/gin-gonic/gin\"\n    _ \"github.com/go-sql-driver/mysql\"\n)\n\n```\n- Package bytes implements functions for the manipulation of byte slices. It is analogous to the facilities of the strings package.\n- Package sql provides a generic interface around SQL (or SQL-like) databases. \n- Package fmt implements formatted I/O with functions\n- Imported a few packages. github.com/gin-gonic/gin, github.com/go-sql-driver/mysql is the  data service we created   before.\n- net/http is the core package we used to handle an HTTP request through its HandleFunc function. That function's arguments are http.Request and http.ResponseWriter. Those two deal with the request and response of an HTTP request.\n\n```\npackage main\n\t\n\timport (\n\t\t\"bytes\"\n\t\t\"database/sql\"\n\t\t\"fmt\"\n\t\t\"net/http\"\n\t\n\t\t\"github.com/gin-gonic/gin\"\n\t\t_ \"github.com/go-sql-driver/mysql\"\n\t)\n\t\n\tfunc main() {\n\t\tdb, err := sql.Open(\"mysql\", \"root:passapp@tcp(127.0.0.1:3306)/gotest\")\n\t\tif err != nil {\n\t\t\tfmt.Print(err.Error())\n\t\t}\n\t\tdefer db.Close()\n\t\t// make sure connection is available\n\t\terr = db.Ping()\n\t\tif err != nil {\n\t\t\tfmt.Print(err.Error())\n\t\t}\n\t\ttype Person struct {\n\t\t\tId         int\n\t\t\tFirst_Name string\n\t\t\tLast_Name  string\n\t\t}\n\t\trouter := gin.Default()\n\t\t// Add API handlers here\n\t\trouter.Run(\":3000\")\n\t}\n\n```\n\n- In every gin app, we should create a Default or New gin router\n- We can specify :port on which our Gin applications run using port 3000\n- We will keep the article structure simple with just three fields - Id, First_Name and Last_Name. This can be represented with a struct as follows:\n- The Data Source Name has a common format, but without type-prefix (optional parts marked by squared brackets):\n        - example : [username[:password]@][protocol[(address)]]/dbname[?param1=value1&...&paramN=valueN]\n\n```\n// GET a person detail\n    router.GET(\"/person/:id\", func(c *gin.Context) {\n        var (\n            person Person\n            result gin.H\n        )\n        id := c.Param(\"id\")\n        row := db.QueryRow(\"select id, first_name, last_name from person where id = ?;\", id)\n        err = row.Scan(&person.Id, &person.First_Name, &person.Last_Name)\n        if err != nil {\n            // If no results send null\n            result = gin.H{\n                \"result\": nil,\n                \"count\":  0,\n            }\n        } else {\n            result = gin.H{\n                \"result\": person,\n                \"count\":  1,\n            }\n        }\n        c.JSON(http.StatusOK, result)\n    })\n\n```\n- Routing is one of the core features that all modern frameworks provide. Any web page or an API end point is accessed by a URL. Frameworks use routes to handle requests to these URLs. \n- Gin offers a fast router that's easy to configure and use. Apart from handling specified URLs, Gin routers can also handle patterns and grouped URLs.\n- A GET method fetches the given resource from the server. To specify a resource, GET uses a few types of URI queries:\n\t- Query parameters\n\t- Path-based parameters\n- We use http.StatusOK to set the status code of the response header. The WriteHeader and Write functions are available on the response object for writing the header and body, respectively.\n\n```\n/// GET all persons\n    router.GET(\"/persons\", func(c *gin.Context) {\n        var (\n            person  Person\n            persons []Person\n        )\n        rows, err := db.Query(\"select id, first_name, last_name from person;\")\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n        for rows.Next() {\n            err = rows.Scan(&person.Id, &person.First_Name, &person.Last_Name)\n            persons = append(persons, person)\n            if err != nil {\n                fmt.Print(err.Error())\n            }\n        }\n        defer rows.Close()\n        c.JSON(http.StatusOK, gin.H{\n            \"result\": persons,\n            \"count\":  len(persons),\n        })\n    })\n\n```\nHere, the resource query is with the path parameter. Query parameters are intended to add detailed information to identify a resource from the server. For example, take this sample fictitious API. Let us assume this API is created for fetching, creating, and updating \n\n```\n// POST new person details\n    router.POST(\"/person\", func(c *gin.Context) {\n        var buffer bytes.Buffer\n        first_name := c.PostForm(\"first_name\")\n        last_name := c.PostForm(\"last_name\")\n        stmt, err := db.Prepare(\"insert into person (first_name, last_name) values(?,?);\")\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n        _, err = stmt.Exec(first_name, last_name)\n\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n\n        // Fastest way to append strings\n        buffer.WriteString(first_name)\n        buffer.WriteString(\" \")\n        buffer.WriteString(last_name)\n        defer stmt.Close()\n        name := buffer.String()\n        c.JSON(http.StatusOK, gin.H{\n            \"message\": fmt.Sprintf(\" %s successfully created\", name),\n        })\n    })\n\n```\nThe POST method  is used to create a resource on the server. A successful POST operation returns a 201 status code.\n```\n// PUT - update a person details\n    router.PUT(\"/person\", func(c *gin.Context) {\n        var buffer bytes.Buffer\n        id := c.Query(\"id\")\n        first_name := c.PostForm(\"first_name\")\n        last_name := c.PostForm(\"last_name\")\n        stmt, err := db.Prepare(\"update person set first_name= ?, last_name= ? where id= ?;\")\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n        _, err = stmt.Exec(first_name, last_name, id)\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n\n        // Fastest way to append strings\n        buffer.WriteString(first_name)\n        buffer.WriteString(\" \")\n        buffer.WriteString(last_name)\n        defer stmt.Close()\n        name := buffer.String()\n        c.JSON(http.StatusOK, gin.H{\n            \"message\": fmt.Sprintf(\"Successfully updated to %s\", name),\n        })\n    })\n```\n- In this part, create and initialize a new Buffer using string as its initial contents. It is intended to prepare a buffer to read an existing string.\n- The PUT method is similar to POST. It is used to replace the resource that already exists. The main difference is that PUT is idempotent. A POST call creates two instances with the same data. But PUT updates a single resource that already exists.\n```\n// Delete resources\n    router.DELETE(\"/person\", func(c *gin.Context) {\n        id := c.Query(\"id\")\n        stmt, err := db.Prepare(\"delete from person where id= ?;\")\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n        _, err = stmt.Exec(id)\n        if err != nil {\n            fmt.Print(err.Error())\n        }\n        c.JSON(http.StatusOK, gin.H{\n            \"message\": fmt.Sprintf(\"Successfully deleted user: %s\", id),\n        })\n    })\n\n```\n\nThe DELETE API method is used to delete a resource from the database. It is similar to PUT but without any body. It just needs an ID of the resource to be deleted. Once a resource gets deleted, subsequent GET requests return a 404 not found status.\n\nIf we run this program:\nrun main.go\n\n![gin.png](https://cdn.steemitimages.com/DQmf8GhP13e8AWGbuvQNedn3GsAsrmQFSSrK9cH9ge5s31s/gin.png)\n\nThe following screenshot shows the JSON response body in Postman for the HTTP GET\nrequest:\n\n![postman.png](https://cdn.steemitimages.com/DQmayjxBvXCSBFEgQZQdDXGEU4e2JL7pk5RipmzW3UQ7HAd/postman.png)\n# Proof of Work Done<h1> \nhttps://github.com/elingmeyatmaja/RESTful-APIs-Gin-",
      "json_metadata": "{\"tags\":[\"utopian-io\",\"tutorials\",\"webservice\",\"restful\",\"golang\"],\"image\":[\"https://cdn.steemitimages.com/DQmdbTKeCA9SNHXD8QxcH6Rt9x8rrMdsyx4YSFufwKN7xof/Untitled.jpg\",\"https://cdn.steemitimages.com/DQmf8GhP13e8AWGbuvQNedn3GsAsrmQFSSrK9cH9ge5s31s/gin.png\",\"https://cdn.steemitimages.com/DQmayjxBvXCSBFEgQZQdDXGEU4e2JL7pk5RipmzW3UQ7HAd/postman.png\"],\"links\":[\"https://github.com/gin-gonic/gin\",\"https://github.com/elingmeyatmaja/RESTful-APIs-Gin-\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "permlink": "building-restful-apis-with-the-gin-framework",
      "title": "Building RESTful APIs with the Gin framework"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-03T14:46:00",
  "trx_id": "0f6b11aaf862dbc511d7d0f36048322ade2b403c",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 26037583,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "29061.149834 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-09-17T11:14:39",
  "trx_id": "7776507a9f8c3a5195917ba22b73d5a9384fa8a3",
  "trx_in_block": 19,
  "virtual_op": 0
}

{
  "block": 26036798,
  "op": [
    "claim_reward_balance",
    {
      "account": "elingmeyatmaja",
      "reward_sbd": "0.000 SBD",
      "reward_steem": "0.000 STEEM",
      "reward_vests": "6.125922 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-09-17T10:35:24",
  "trx_id": "dc26c028334fe0a16dadd0da1415d7ce8bb0a0d0",
  "trx_in_block": 20,
  "virtual_op": 0
}

{
  "block": 23016939,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "8908.094679 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-06-04T03:56:03",
  "trx_id": "f22d42cb4d25414c273676ef554374b698dd4565",
  "trx_in_block": 43,
  "virtual_op": 0
}

{
  "block": 21707335,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "elingmeyatmaja",
      "delegator": "steem",
      "vesting_shares": "29309.302692 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-19T15:31:42",
  "trx_id": "ffe6e1359aee90dab0c5fa4218ad7febed706d7d",
  "trx_in_block": 31,
  "virtual_op": 0
}

{
  "block": 20567599,
  "op": [
    "curation_reward",
    {
      "comment_author": "aftaruannisa",
      "comment_permlink": "new-logo-for-freecad",
      "curator": "elingmeyatmaja",
      "reward": "6.125922 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-11T00:44:15",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 22
}

{
  "block": 20397903,
  "op": [
    "vote",
    {
      "author": "aftaruannisa",
      "permlink": "new-logo-for-freecad",
      "voter": "elingmeyatmaja",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-05T03:06:27",
  "trx_id": "19e9c1b2253b2919162c6722bea33af42ab7ac22",
  "trx_in_block": 34,
  "virtual_op": 0
}

{
  "block": 20002398,
  "op": [
    "vote",
    {
      "author": "vickysylvester",
      "permlink": "touring-bersama-byson-independent-siantar-6a44fceaef6f5",
      "voter": "elingmeyatmaja",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-02-19T09:16:45",
  "trx_id": "68ed79f50d20123f35762b3945b8e5ca87de1d70",
  "trx_in_block": 14,
  "virtual_op": 0
}

{
  "block": 19919606,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"elingmeyatmaja\",\"following\":\"nelvi-sari\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "elingmeyatmaja"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-02-16T12:15:48",
  "trx_id": "2e58cb6c6d6970a9c0130bf4140608a4fdb20bce",
  "trx_in_block": 17,
  "virtual_op": 0
}

{
  "block": 19850738,
  "op": [
    "claim_reward_balance",
    {
      "account": "elingmeyatmaja",
      "reward_sbd": "0.105 SBD",
      "reward_steem": "0.000 STEEM",
      "reward_vests": "45.009704 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-02-14T02:48:42",
  "trx_id": "89c07eb37bff60b5f27c66c8a10b863e1d1ab9ff",
  "trx_in_block": 36,
  "virtual_op": 0
}

{
  "block": 19712759,
  "op": [
    "vote",
    {
      "author": "danuega",
      "permlink": "new-logo-proposal-for-parkendd",
      "voter": "elingmeyatmaja",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-02-09T07:44:42",
  "trx_id": "19c2017d55f6b517abfac74a5f6e9b9a44ce7fbd",
  "trx_in_block": 43,
  "virtual_op": 0
}

{
  "block": 19524776,
  "op": [
    "author_reward",
    {
      "author": "elingmeyatmaja",
      "permlink": "wisata-kuliner-malam-di-tanjung-morawa",
      "sbd_payout": "0.093 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "38.871024 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-02-02T18:44:06",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 5
}

{
  "block": 19454680,
  "op": [
    "vote",
    {
      "author": "danuega",
      "permlink": "new-logo-proposal-for-taskbar",
      "voter": "elingmeyatmaja",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-31T08:14:03",
  "trx_id": "e538342a0966fd1eae8d60cc18d17ec595ea70ea",
  "trx_in_block": 22,
  "virtual_op": 0
}

{
  "block": 19454678,
  "op": [
    "vote",
    {
      "author": "danuega",
      "permlink": "new-logo-proposal-for-cache-cleaner",
      "voter": "elingmeyatmaja",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-31T08:13:57",
  "trx_id": "c0d78b5e5ba56977c158f2cf05219dae2237659c",
  "trx_in_block": 7,
  "virtual_op": 0
}

{
  "block": 19420356,
  "op": [
    "author_reward",
    {
      "author": "elingmeyatmaja",
      "permlink": "flask-login-implementation-with-sql-alchemy-and-postgresql",
      "sbd_payout": "0.012 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "6.138680 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-30T03:35:42",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 11
}

{
  "block": 19420356,
  "op": [
    "comment_benefactor_reward",
    {
      "author": "elingmeyatmaja",
      "benefactor": "utopian.pay",
      "permlink": "flask-login-implementation-with-sql-alchemy-and-postgresql",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "2.046226 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-30T03:35:42",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 10
}

{
  "block": 19395549,
  "op": [
    "vote",
    {
      "author": "riyo.s94",
      "permlink": "website-tour-using-trip-js",
      "voter": "elingmeyatmaja",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-29T06:54:30",
  "trx_id": "63fcedd42cd8df668ac926e5a443db9cdc9ddf98",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 19345467,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "wisata-kuliner-malam-di-tanjung-morawa",
      "voter": "andeladenaro",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-27T13:09:39",
  "trx_id": "94cd140819253774013a69fd0a285518167b63b9",
  "trx_in_block": 13,
  "virtual_op": 0
}

{
  "block": 19340815,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "wisata-kuliner-malam-di-tanjung-morawa",
      "voter": "nelvi-sari",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-27T09:16:48",
  "trx_id": "cc653eeff6edc4240fb786e5b0450e58b4077951",
  "trx_in_block": 62,
  "virtual_op": 0
}

{
  "block": 19337231,
  "op": [
    "vote",
    {
      "author": "elingmeyatmaja",
      "permlink": "wisata-kuliner-malam-di-tanjung-morawa",
      "voter": "calmunicorn",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-27T06:17:24",
  "trx_id": "f11eb34af86973ea68a26e57987d49c6db33e0c0",
  "trx_in_block": 10,
  "virtual_op": 0
}

{
  "block": 19334160,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"elingmeyatmaja\",\"following\":\"kakilasak\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "elingmeyatmaja"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-27T03:43:48",
  "trx_id": "55486c7d48243cd5827a806a4ea0294965f97c19",
  "trx_in_block": 51,
  "virtual_op": 0
}