2a:null 2b:["$","title",null,{"children":"Search for Faucets with CLIP, API edition | Simon Willison | Observable"}] 30:[] 2e:{"id":"abcdf9f82db0fbf4","slug":"search-for-faucets-with-clip-api","title":"Search for Faucets with CLIP, API edition","thumbnail":"d8b527f2e8cb00721ec2728e29c15a1d10c0545405ad25553600affad7c2ffbc","access_level":"public","create_time":"$D2023-10-08T14:15:42.496Z","update_time":"$D2023-10-08T19:50:06.292Z","view_time":null,"first_public_time":"$D2023-10-08T14:15:42.496Z","has_unpublished_edits":null,"fork":{"id":"7412e6f6d7fe86bd","slug":"search-for-faucets-with-clip","title":"Search for Faucets with CLIP","owner":{"id":"3b974c2db4452cfc","login":"simonw","name":"Simon Willison"}},"stars":2,"starred":false,"owner":{"type":"team","id":"3b974c2db4452cfc","login":"simonw","name":"Simon Willison","avatar_url":"https://avatars-next.observableusercontent.com/78a40181b372a172b86abe69479cab717df036b9cdcbaab5a197e45a76ffb4f3","tier":"starter_2024"},"version":254,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"dc026342127b807b","login":"simonw","name":"Simon Willison","avatar_url":"https://avatars-next.observableusercontent.com/78a40181b372a172b86abe69479cab717df036b9cdcbaab5a197e45a76ffb4f3","tier":null}],"members":[{"type":"individual","id":"dc026342127b807b","login":"simonw","name":"Simon Willison","avatar_url":"https://avatars-next.observableusercontent.com/78a40181b372a172b86abe69479cab717df036b9cdcbaab5a197e45a76ffb4f3","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":4,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Search for Faucets with CLIP, API edition","cells":[{"id":0,"value":"# Search for Faucets with CLIP, API edition\n\nUses https://faucet-finder.fly.dev/\n\nTry `purple` or `gold` or `nintendo` or `terror` or `bird`","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":81,"value":"viewof input = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"html`

${faucets\n .reverse()\n .map(\n (img) =>\n `

${img[0]}
${img[1]}

`\n )\n .join(\"\")}

`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":222,"value":"text = debounce(viewof input)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":183,"value":"hex_embedding = {\n const controller = new AbortController();\n invalidation.then(() => controller.abort());\n try {\n return (\n await (\n await fetch(\n `https://clip-datasette-on-fly.fly.dev/_memory.json?sql=select+hex(llm_embed(%27clip%27%2C+%3Aq))+as+x&q=${encodeURIComponent(\n text\n )}&_shape=array`,\n { signal: controller.signal }\n )\n ).json()\n )[0].x;\n } catch {\n return \"\";\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"input_embedding = hexToFloatArray(hex_embedding)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":244,"value":"md`[View in Datasette](${faucets_url.replace(\".json\", \"\")})`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"sql = `\nselect value from json_each(faiss_search_with_scores('faucets', 'embeddings', faiss_encode(:data), 8))\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"faucets_url = `https://faucet-finder.fly.dev/faucets.json?sql=${encodeSQL(\n sql\n)}&data=${encodeURIComponent(\n JSON.stringify(input_embedding)\n)}&_shape=arrayfirst&_json=value`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":253,"value":"function encodeSQL(s) {\n return encodeURIComponent(s).replace(/\$/g, \"%28\").replace(/\$/g, \"%29\");\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"faucets = (\n await fetch(\n `https://faucet-finder.fly.dev/faucets.json?sql=select+value+from+json_each(faiss_search_with_scores(%27faucets%27%2C+%27embeddings%27%2C+faiss_encode(%3Adata)%2C+8))&data=${encodeURIComponent(\n JSON.stringify(input_embedding)\n )}&_shape=arrayfirst&_json=value`\n )\n).json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":198,"value":"function hexToFloatArray(hexString) {\n const buffer = new ArrayBuffer(hexString.length / 2);\n const view = new DataView(buffer);\n const floatArray = [];\n\n for (let i = 0; i < hexString.length; i += 2) {\n const byteValue = parseInt(hexString.substr(i, 2), 16);\n view.setUint8(i / 2, byteValue);\n }\n\n for (let i = 0; i < buffer.byteLength; i += 4) {\n const floatValue = view.getFloat32(i, true); // true for little-endian\n floatArray.push(floatValue);\n }\n\n return floatArray;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":220,"value":"function debounce(input, delay = 1000) {\n return Generators.observe((notify) => {\n let timer = null;\n let value;\n\n // On input, check if we recently reported a value.\n // If we did, do nothing and wait for a delay;\n // otherwise, report the current value and set a timeout.\n function inputted() {\n if (timer !== null) return;\n notify((value = input.value));\n timer = setTimeout(delayed, delay);\n }\n\n // After a delay, check if the last-reported value is the current value.\n // If it’s not, report the new value.\n function delayed() {\n timer = null;\n if (value === input.value) return;\n notify((value = input.value));\n }\n\n input.addEventListener(\"input\", inputted), inputted();\n return () => input.removeEventListener(\"input\", inputted);\n });\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W30","stdlib":"1"}} 2f:"$2e:body"