{"url":"https://api.github.com/gists/1468492","forks_url":"https://api.github.com/gists/1468492/forks","commits_url":"https://api.github.com/gists/1468492/commits","id":"1468492","node_id":"MDQ6R2lzdDE0Njg0OTI=","git_pull_url":"https://gist.github.com/1468492.git","git_push_url":"https://gist.github.com/1468492.git","html_url":"https://gist.github.com/mbostock/1468492","files":{"server.js":{"filename":"server.js","type":"text/javascript","language":"JavaScript","raw_url":"https://gist.githubusercontent.com/mbostock/1468492/raw/415cae52b70af9c2e68b42615c8cb16b68785ee1/server.js","size":958,"truncated":false,"content":"process.env.TZ = \"UTC\";\n\nvar util = require(\"util\"),\n    express = require(\"express\"),\n    gzip = require(\"connect-gzip\"),\n    mysql = require(\"mysql\");\n\nvar client = mysql.createClient({\n  host: /* mysql host, e.g., \"host.example.com\" */,\n  port: /* mysql port, e.g., 3306 */,\n  user: /* mysql user, e.g., \"username\" */,\n  password: /* mysql password, e.g., \"password\" */,\n  database: /* mysql database, e.g., \"database\" */\n});\n\nvar server = express.createServer();\nserver.use(gzip.gzip());\nserver.use(express.static(__dirname + \"/public\"));\n\nserver.get(\"/things/:id([0-9]+).json\", function(request, response, next) {\n  client.query(\"SELECT\"\n    + \" t.name,\"\n    + \" t.favorite_color,\"\n    + \" t.airspeed_velocity\"\n    + \" FROM things t\"\n    + \" WHERE t.id = ?\", [request.params.id], function(error, rows) {\n    if (error) return next(error);\n    response.json(rows);\n  });\n});\n\nserver.listen(/* http port, e.g., 8888 */, /* http host, e.g., \"0.0.0.0\" */);\n","encoding":"utf-8"}},"public":true,"created_at":"2011-12-12T18:38:46Z","updated_at":"2020-05-21T00:59:41Z","description":"Node + MySQL + JSON","comments":3,"user":null,"comments_enabled":true,"comments_url":"https://api.github.com/gists/1468492/comments","owner":{"login":"mbostock","id":230541,"node_id":"MDQ6VXNlcjIzMDU0MQ==","avatar_url":"https://avatars.githubusercontent.com/u/230541?v=4","gravatar_id":"","url":"https://api.github.com/users/mbostock","html_url":"https://github.com/mbostock","followers_url":"https://api.github.com/users/mbostock/followers","following_url":"https://api.github.com/users/mbostock/following{/other_user}","gists_url":"https://api.github.com/users/mbostock/gists{/gist_id}","starred_url":"https://api.github.com/users/mbostock/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbostock/subscriptions","organizations_url":"https://api.github.com/users/mbostock/orgs","repos_url":"https://api.github.com/users/mbostock/repos","events_url":"https://api.github.com/users/mbostock/events{/privacy}","received_events_url":"https://api.github.com/users/mbostock/received_events","type":"User","user_view_type":"public","site_admin":false},"forks":[],"history":[{"user":{"login":"mbostock","id":230541,"node_id":"MDQ6VXNlcjIzMDU0MQ==","avatar_url":"https://avatars.githubusercontent.com/u/230541?v=4","gravatar_id":"","url":"https://api.github.com/users/mbostock","html_url":"https://github.com/mbostock","followers_url":"https://api.github.com/users/mbostock/followers","following_url":"https://api.github.com/users/mbostock/following{/other_user}","gists_url":"https://api.github.com/users/mbostock/gists{/gist_id}","starred_url":"https://api.github.com/users/mbostock/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbostock/subscriptions","organizations_url":"https://api.github.com/users/mbostock/orgs","repos_url":"https://api.github.com/users/mbostock/repos","events_url":"https://api.github.com/users/mbostock/events{/privacy}","received_events_url":"https://api.github.com/users/mbostock/received_events","type":"User","user_view_type":"public","site_admin":false},"version":"63e03c29a2a8b1a2c0a10a4ef4f82995226948b7","committed_at":"2011-12-12T18:38:46Z","change_status":{"total":32,"additions":32,"deletions":0},"url":"https://api.github.com/gists/1468492/63e03c29a2a8b1a2c0a10a4ef4f82995226948b7"}],"truncated":false}