28:null 29:["$","title",null,{"children":"Ports | Roland Crosby | Observable"}] 2e:[{"id":"d7bc4080d15c87944fcfb4df640ee10c9beb2a56fb0d39d08b9cfd79ac55c10189b2f67be7c2aa45a2ea6b05e5089d953dde08ebce574387f4afcf3f9ca96996","href":"https://static.observableusercontent.com/files/d7bc4080d15c87944fcfb4df640ee10c9beb2a56fb0d39d08b9cfd79ac55c10189b2f67be7c2aa45a2ea6b05e5089d953dde08ebce574387f4afcf3f9ca96996","name":"iana-ports.json","type":"application/json","lastModified":1588092121393.269,"size":699149},{"id":"fc24e310a54adb0a035eee688a807702cd6c721247a6d21b3a41fcae5151836cd778861572fdf544db17cfb7132d6e7706447a0cb81098d135de0953d4868ec6","href":"https://static.observableusercontent.com/files/fc24e310a54adb0a035eee688a807702cd6c721247a6d21b3a41fcae5151836cd778861572fdf544db17cfb7132d6e7706447a0cb81098d135de0953d4868ec6","name":"ports@6.csv","type":"text/csv","lastModified":1588180116589.07,"size":123059},{"id":"e29fe83eeb6d95fdc2359c5690443f46f317a18054badf4c29af849984e748db26341f976598b8c6177993958b82ad755c882d92716c708a6df16f26f9d0f761","href":"https://static.observableusercontent.com/files/e29fe83eeb6d95fdc2359c5690443f46f317a18054badf4c29af849984e748db26341f976598b8c6177993958b82ad755c882d92716c708a6df16f26f9d0f761","name":"ports@10.csv","type":"text/csv","lastModified":1588520906668.058,"size":563373},{"id":"34be670606fa2e87806800dd289684228f40ce630048383ba6de131698b19f8ab2f48cf41cf0b7931e173be75cf9dd00e605ead07b74b529f6056000bf16ecee","href":"https://static.observableusercontent.com/files/34be670606fa2e87806800dd289684228f40ce630048383ba6de131698b19f8ab2f48cf41cf0b7931e173be75cf9dd00e605ead07b74b529f6056000bf16ecee","name":"ports.csv","type":"text/csv","lastModified":1588093337094.635,"size":39540},{"id":"88072156925d1f8625cd154e089c855f671035093e6129964fb288a629fc1f84bba8a230cf20e7e2d78c0d08c61c860323b5cadb9fac3727f5d103931c0a4362","href":"https://static.observableusercontent.com/files/88072156925d1f8625cd154e089c855f671035093e6129964fb288a629fc1f84bba8a230cf20e7e2d78c0d08c61c860323b5cadb9fac3727f5d103931c0a4362","name":"ports@1.csv","type":"text/csv","lastModified":1588099589142.411,"size":46045},{"id":"4f6d08650693e1830a2536a41918c523ad814b76f9cc8b77e27ffb6ebe82c3f1853503ba30789a90ed9186a44c9a9076bd057306c07dc4211838a7b661fd69a7","href":"https://static.observableusercontent.com/files/4f6d08650693e1830a2536a41918c523ad814b76f9cc8b77e27ffb6ebe82c3f1853503ba30789a90ed9186a44c9a9076bd057306c07dc4211838a7b661fd69a7","name":"ports@7.csv","type":"text/csv","lastModified":1588259068547.819,"size":225353},{"id":"dd8ee1f9ead0e3664c7d277076fbfaecb35fae987bd7ffa1d1309f1ba6462b5f8207317c542ffc1ae615dc081be359d632cc50defa346de4a35dc99322bf7012","href":"https://static.observableusercontent.com/files/dd8ee1f9ead0e3664c7d277076fbfaecb35fae987bd7ffa1d1309f1ba6462b5f8207317c542ffc1ae615dc081be359d632cc50defa346de4a35dc99322bf7012","name":"ports@3.csv","type":"text/csv","lastModified":1588122643745.486,"size":60176},{"id":"6eb10f9a61ba6dab73fc29544824fd76c9b5711b4d43164fb5ba171bd3ca5ea697702159649cba22e16f706bd21839761d3bf3d04fc0f75e55f51c6a4bfafcb9","href":"https://static.observableusercontent.com/files/6eb10f9a61ba6dab73fc29544824fd76c9b5711b4d43164fb5ba171bd3ca5ea697702159649cba22e16f706bd21839761d3bf3d04fc0f75e55f51c6a4bfafcb9","name":"ports@4.csv","type":"text/csv","lastModified":1588127526145.689,"size":61855},{"id":"65ee28190766fddc1ea98a8f9e00571616a1addd3e9827a5697f679cba110cb0a852b098adc50dcaf64eb50bafe262519d8a33e99a740d5046c2b7c3de3237a5","href":"https://static.observableusercontent.com/files/65ee28190766fddc1ea98a8f9e00571616a1addd3e9827a5697f679cba110cb0a852b098adc50dcaf64eb50bafe262519d8a33e99a740d5046c2b7c3de3237a5","name":"ports@8.csv","type":"text/csv","lastModified":1588352142357.819,"size":347610},{"id":"300811c7b2b58108b0800ff237d22271d0f61364694ec911da29dd5e358413701c32b9e3936a2ce52c45847b1c124ffa6534377889aecae5e20e42eb61bbecca","href":"https://static.observableusercontent.com/files/300811c7b2b58108b0800ff237d22271d0f61364694ec911da29dd5e358413701c32b9e3936a2ce52c45847b1c124ffa6534377889aecae5e20e42eb61bbecca","name":"ports@5.csv","type":"text/csv","lastModified":1588168414968.879,"size":109880},{"id":"e7a824a3fec3f6cf31cd88f3482531064a6bcb60cb4f2f557ecf039106f13b7bcdfaa446af2a657087b3774475fe60ff351d71adb97bc1b091b2d1fa0be49ba6","href":"https://static.observableusercontent.com/files/e7a824a3fec3f6cf31cd88f3482531064a6bcb60cb4f2f557ecf039106f13b7bcdfaa446af2a657087b3774475fe60ff351d71adb97bc1b091b2d1fa0be49ba6","name":"ports@13.csv","type":"text/csv","lastModified":1588634848456.983,"size":563427}] 2c:{"id":"9c2950d9b55ea51a","slug":"ports","title":"Ports","thumbnail":"d9a997284ba63429ee21b9116ca65413566ec9a93992cd3e6bcdf603c8c5b6cf","access_level":"public","create_time":"$D2020-04-28T16:41:47.744Z","update_time":"$D2020-05-04T23:27:40.040Z","view_time":null,"first_public_time":"$D2020-04-28T17:32:21.683Z","has_unpublished_edits":null,"fork":false,"stars":7,"starred":false,"owner":{"type":"team","id":"5b00e65b26962af6","login":"rolandcrosby","name":"Roland Crosby","avatar_url":"https://avatars-next.observableusercontent.com/4076d34c3c02cdcf4fc53a463d3d774548ba0c2959cd54f9c19441402f810fd8","tier":"starter_2024"},"version":442,"publish_version":442,"role":null,"authored":false,"authors":[{"type":"individual","id":"0b47dde7f0e387e2","login":"rolandcrosby","name":"Roland Crosby","avatar_url":"https://avatars-next.observableusercontent.com/4076d34c3c02cdcf4fc53a463d3d774548ba0c2959cd54f9c19441402f810fd8","tier":null}],"members":[{"type":"individual","id":"0b47dde7f0e387e2","login":"rolandcrosby","name":"Roland Crosby","avatar_url":"https://avatars-next.observableusercontent.com/4076d34c3c02cdcf4fc53a463d3d774548ba0c2959cd54f9c19441402f810fd8","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Ports","cells":[{"id":0,"value":"md`# Ports\n\nFrequency of references to \\`\"localhost:n\"\\` in GitHub code search ([e.g.](https://github.com/search?q=%22localhost%3A3306%22&type=Code)). Data collected from the GitHub API in early May 2020. See slightly more extensive explanation [here](https://notes.rolandcrosby.com/posts/github-ports/).\n\nData is definitely not perfect - the popularity of \\`127\\` and \\`192\\`, for example, are probably due to the above search query matching strings like \\`localhost 127.0.0.1\\` or \\`localhost 192.168.0.50\\`. But the overall patterns are still kind of cool.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"viewof selectedPort = {\n const gridWidth = width > 620 ? width - 80 : width;\n const scale = Math.max(1, Math.floor(gridWidth / cols));\n const innerEl = svg``;\n const tbl = d3.select(innerEl);\n tbl.attr('style', `transform: scale(${scale}); transform-origin: top left;`);\n const rows = tbl\n .selectAll('g.row')\n .data(ports)\n .enter()\n .append('g')\n .attr('class', 'row')\n .attr('style', (d, i) => `transform: translate(0, ${i}px)`);\n const cells = rows\n .selectAll('rect')\n .data(d => d)\n .enter()\n .append('rect')\n .attr('width', 1)\n .attr('height', 1)\n .attr('x', (d, i) => i)\n .attr('style', d => `fill: ${colorScale(d.hits)}`);\n const el = html`

${innerEl}

`;\n el.addEventListener('mousemove', e => {\n el.value = d3.select(e.target).data()[0];\n el.dispatchEvent(new CustomEvent(\"input\"));\n });\n return el;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":164,"value":"details = {\n if (selectedPort) {\n let iana = \"\";\n if (selectedPort.iana) {\n iana = \"\\nIANA service names: \";\n let services = new Set(selectedPort.iana.map(i => i[1]));\n iana += Array.from(services).join(\", \");\n }\n let m = md`## \\`Port ${selectedPort.port}\\``;\n if (selectedPort.hits !== null) {\n m = md`${m}\\n${fmt(\n selectedPort.hits\n )} GitHub code search results (${numeral(\n percentile(selectedPort.hits)\n ).format('0o')} percentile) for \\`\"localhost:${selectedPort.port}\"\\``;\n }\n return md`${m}\\n${iana}`;\n } else {\n return html`

`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":353,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":356,"value":"topPorts = {\n const n = 100;\n const el = d3.select(html`

`);\n const header = el.append('thead').append('tr');\n let topPorts = Object.entries(githubPorts)\n .sort((a, b) => b[1] - a[1])\n .slice(0, n)\n .map(a => ({ port: a[0], hits: a[1], iana: ianaPorts[a[0]] || [] }));\n header.append('th').text('Port');\n header.append('th').text('Search Results');\n header.append('th').text('IANA Assignments');\n const rows = el\n .append('tbody')\n .selectAll('tr')\n .data(topPorts)\n .enter()\n .append('tr');\n rows.append('td').text(d => d.port.toString());\n rows.append('td').text(d => fmt(d.hits));\n rows\n .append('td')\n .text(d => Array.from(new Set((d.iana || []).map(i => i[1]))).join(\", \"));\n return html`

`Top ${n} Ports`

${el.node()}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":345,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"viewof cols = slider({\n value: 100,\n min: 100,\n max: 1000,\n step: 50,\n title: \"Ports per line\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"colorScale = {\n // const scale = d3.scaleSequentialQuantile(\n // [...Object.values(githubPorts)],\n // d3.interpolateOrRd\n // );\n const logScale = d3\n .scaleLog()\n .domain([1, Math.max(...Object.values(githubPorts))])\n .clamp(1);\n const scale = d => d3.interpolateOrRd(logScale(d));\n return function(d) {\n if (d == null) {\n return \"transparent\";\n }\n return scale(d);\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":312,"value":"percentile = d3\n .scaleQuantile()\n .domain(Object.values(githubPorts))\n .range(d3.range(1, 100))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":177,"value":"fmt = d3.format(',')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"ports = {\n let out = [];\n for (let msb = 0; msb < 65535 / cols; msb++) {\n let row = [];\n for (let lsb = 0; lsb < cols; lsb++) {\n const p = msb * cols + lsb;\n const info = {\n port: p,\n iana: null,\n hits: null\n };\n if (ianaPorts.hasOwnProperty(p)) {\n info.iana = ianaPorts[p];\n }\n if (githubPorts.hasOwnProperty(p)) {\n info.hits = githubPorts[p];\n }\n if (p <= 65535) {\n row.push(info);\n }\n }\n out.push(row);\n }\n return out;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":420,"value":"ports[655]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"githubPorts = {\n const out = {};\n const ghPorts = await FileAttachment(\"ports@13.csv\").text();\n d3.csvParseRows(ghPorts).forEach(row => {\n if (row[0] >= 10) {\n out[row[0]] = parseInt(row[1], 10);\n }\n });\n return out;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"ianaPorts = FileAttachment(\"iana-ports.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":100,"value":"import { slider } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"d3 = require('d3@5')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":338,"value":"numeral = require('numeral')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2e","stdlib":"1","titling":"auto"}} 2d:"$2c:body"