How to play Loopy Letters:

Use every letter on the donut to spell a word.
Letters in the word must be adjacent to each other on the donut.
\n You can go clockwise or counterclockwise.\n
When you find a word, the next word to find appears.
Go fast? Go slow? Enjoy!

\n \n

\n );\n}\n\nfunction GameOverModal({ elapsedTime, onPlayAgain }) {\n return (\n

Game Over!

Your time: {Math.round(elapsedTime)} seconds

\n \n

\n );\n}\n\nfunction App({ wordlist }) {\n const [currentWordIndex, setCurrentWordIndex] = useState(0);\n const [currentWord, setCurrentWord] = useState(wordlist[0]);\n const [displayWord, setDisplayWord] = useState(\"\");\n const [selectedWord, setSelectedWord] = useState(\"\");\n const [selection, setSelection] = useState([]);\n const [stars, setStars] = useState([]);\n const [foundWords, setFoundWords] = useState([]);\n const [wordCount, setWordCount] = useState(0);\n const [showInstructionsModal, setShowInstructionsModal] = useState(true);\n const [showGameOverModal, setShowGameOverModal] = useState(false);\n const [gameStarted, setGameStarted] = useState(false);\n const [elapsedTime, setElapsedTime] = useState(0);\n const svgRef = useRef(null);\n const timerRef = useRef(null);\n\n useEffect(() => {\n setDisplayWord(randomRotate(tryReverse(currentWord)));\n }, [currentWord]);\n\n useEffect(() => {\n const timeout = setTimeout(() => {\n setStars(prevStars => {\n const updatedStars = prevStars.map(star => ({\n ...star,\n fading: true,\n }));\n return updatedStars;\n });\n }, 300);\n\n const removeTimeout = setTimeout(() => {\n setStars(prevStars => prevStars.filter(star => !star.fading));\n }, 600);\n\n return () => {\n clearTimeout(timeout);\n clearTimeout(removeTimeout);\n };\n }, [stars]);\n\n useEffect(() => {\n if (gameStarted && currentWordIndex < wordlist.length) {\n timerRef.current = setInterval(() => {\n setElapsedTime(prev => prev + 1);\n }, 1000);\n\n return () => {\n if (timerRef.current) {\n clearInterval(timerRef.current);\n }\n };\n }\n }, [gameStarted, currentWordIndex, wordlist.length]);\n\n useEffect(() => {\n if (currentWordIndex === wordlist.length) {\n if (timerRef.current) {\n clearInterval(timerRef.current);\n }\n setShowGameOverModal(true);\n }\n }, [currentWordIndex, wordlist.length]);\n\n const isValid = (str) => str === currentWord;\n\n const handlePointerDown = (event) => {\n if (!gameStarted) return;\n const point = getRelativeCoordinates(event);\n const index = getLetterIndexFromPoint(point);\n if (index !== -1) {\n setSelectedWord(displayWord[index]);\n setSelection([index]);\n }\n };\n\n const handlePointerMove = (event) => {\n if (!gameStarted) return;\n if (selection.length === 0) return;\n const point = getRelativeCoordinates(event);\n const index = getLetterIndexFromPoint(point);\n if (index !== -1 && index !== selection[selection.length - 1] && !selection.includes(index)) {\n if (isAdjacent(index, selection[selection.length - 1])) {\n const newSelection = [...selection, index];\n setSelection(newSelection);\n setSelectedWord(newSelection.map(i => displayWord[i]).join(\"\"));\n }\n }\n };\n\n const handlePointerUp = () => {\n if (!gameStarted) return;\n if (selectedWord && isReverseSubstring(selectedWord, displayWord) && isValid(selectedWord)) {\n setStars(prevStars => [...prevStars, { x: CENTER.x, y: CENTER.y, key: Date.now(), fading: false }]);\n\n // Update found words (keep only the most recent word)\n setFoundWords([selectedWord]);\n\n // Increment word count\n setWordCount(prev => prev + 1);\n\n const nextIndex = currentWordIndex + 1;\n setCurrentWordIndex(nextIndex);\n if (nextIndex < wordlist.length) {\n setCurrentWord(wordlist[nextIndex]);\n }\n }\n setSelectedWord(\"\");\n setSelection([]);\n };\n\n const getRelativeCoordinates = (event) => {\n const svg = svgRef.current;\n const pt = svg.createSVGPoint();\n pt.x = event.clientX;\n pt.y = event.clientY;\n return pt.matrixTransform(svg.getScreenCTM().inverse());\n };\n\n const getLetterIndexFromPoint = (point) => {\n const dx = point.x - CENTER.x;\n const dy = point.y - CENTER.y;\n const distance = Math.sqrt(dx * dx + dy * dy);\n if (distance < INNER_RADIUS || distance > OUTER_RADIUS) return -1;\n\n let angle = Math.atan2(dy, dx);\n if (angle < 0) angle += 2 * Math.PI;\n const segmentAngle = (2 * Math.PI) / currentWord.length;\n return Math.floor(angle / segmentAngle) % currentWord.length;\n };\n\n const isAdjacent = (index1, index2) => {\n const diff = Math.abs(index1 - index2);\n return diff === 1 || diff === currentWord.length - 1;\n };\n\n const createDonutSegment = (startAngle, endAngle, index) => {\n const isSelected = selection.includes(index);\n const largeArcFlag = endAngle - startAngle <= Math.PI ? \"0\" : \"1\";\n\n const startOuterX = CENTER.x + OUTER_RADIUS * Math.cos(startAngle);\n const startOuterY = CENTER.y + OUTER_RADIUS * Math.sin(startAngle);\n const endOuterX = CENTER.x + OUTER_RADIUS * Math.cos(endAngle);\n const endOuterY = CENTER.y + OUTER_RADIUS * Math.sin(endAngle);\n\n const startInnerX = CENTER.x + INNER_RADIUS * Math.cos(endAngle);\n const startInnerY = CENTER.y + INNER_RADIUS * Math.sin(endAngle);\n const endInnerX = CENTER.x + INNER_RADIUS * Math.cos(startAngle);\n const endInnerY = CENTER.y + INNER_RADIUS * Math.sin(startAngle);\n\n const path = [\n `M ${startOuterX} ${startOuterY}`,\n `A ${OUTER_RADIUS} ${OUTER_RADIUS} 0 ${largeArcFlag} 1 ${endOuterX} ${endOuterY}`,\n `L ${startInnerX} ${startInnerY}`,\n `A ${INNER_RADIUS} ${INNER_RADIUS} 0 ${largeArcFlag} 0 ${endInnerX} ${endInnerY}`,\n \"Z\",\n ].join(\" \");\n\n return ;\n };\n\n const createStar = (cx, cy, spikes = 5, outerRadius = 20, innerRadius = 10, fading = false) => {\n let points = [];\n for (let i = 0; i < spikes * 2; i++) {\n const radius = i % 2 === 0 ? outerRadius : innerRadius;\n const angle = (Math.PI * i) / spikes;\n const x = cx + Math.cos(angle) * radius;\n const y = cy + Math.sin(angle) * radius;\n points.push(`${x},${y}`);\n }\n return ;\n };\n\n const startGame = () => {\n setShowInstructionsModal(false);\n setGameStarted(true);\n };\n\n const resetGame = () => {\n setCurrentWordIndex(0);\n setCurrentWord(wordlist[0]);\n setDisplayWord(\"\");\n setSelectedWord(\"\");\n setSelection([]);\n setStars([]);\n setFoundWords([]);\n setWordCount(0);\n setShowGameOverModal(false);\n setGameStarted(true);\n setElapsedTime(0);\n };\n\n return (\n

\n {showInstructionsModal && }\n {showGameOverModal && }\n

Loopy Letters

a word game by Alex Wein

Words Found: {wordCount}/{wordlist.length}

{Math.round(elapsedTime)} s

\n {foundWords.map((word, index) => {word})}\n

- {selectedWord} -

\n \n \n {displayWord.split(\"\").map((letter, index) => {\n const segmentAngle = (2 * Math.PI) / currentWord.length;\n const startAngle = index * segmentAngle;\n const endAngle = (index + 1) * segmentAngle;\n const midAngle = (startAngle + endAngle) / 2;\n const textRadius = (INNER_RADIUS + 1.1 * OUTER_RADIUS) / 2;\n const textX = CENTER.x + textRadius * Math.cos(midAngle);\n const textY = CENTER.y + textRadius * Math.sin(midAngle);\n\n return (\n \n {createDonutSegment(startAngle, endAngle, index)}\n \n {letter}\n \n \n );\n })}\n \n {stars.map((star) => createStar(star.x, star.y, 5, 15, 7.5, star.fading))}\n \n

\n );\n}\n\nfunction client(wordlist) {\n createRoot(document.getElementById(\"root\")).render();\n}\n\nif (typeof document !== \"undefined\") {\n const wordlist = JSON.parse(document.getElementById(\"wordlist\").textContent);\n client(wordlist);\n}\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n const randRowsQ = `\n select id, word\n from judgments\n where judgment is null\n order by random()\n limit 7\n `;\n\n try {\n const result = await sqlite.execute(randRowsQ);\n const wordlist = result.rows\n .map(row => row?.word ? row.word.toUpperCase() : null)\n .filter(word => word !== null);\n\n // Use fallback wordlist if no words are found\n const finalWordlist = wordlist.length > 0 ? wordlist : FALLBACK_WORDLIST;\n\n return new Response(\n `\n \n \n Loopy Letters\n \n \n \n \n

\n \n \n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n },\n );\n } catch (error) {\n console.error(\"Error fetching words:\", error);\n\n return new Response(\n `\n \n \n Loopy Letters\n \n \n \n \n

\n \n \n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n },\n );\n }\n}\n\nconst css = `\nbody, html {\n margin: 0;\n padding: 0;\n font-family: system-ui, sans-serif;\n height: 100%;\n overscroll-behavior: none;\n}\n\n#root {\n height: 100%;\n}\n\n.game-container {\n display: flex;\n flex-direction: column;\n align-items: center;\n width: 100%;\n max-width: 100%;\n padding: 10px;\n box-sizing: border-box;\n height: 100vh;\n max-height: 100vh;\n overflow: hidden;\n}\n\n.game-header {\n width: 100%;\n background-color: #333;\n color: white;\n text-align: center;\n padding: 10px 0;\n margin-bottom: 10px;\n flex-shrink: 0;\n}\n\n.game-header h1 {\n margin: 0;\n font-size: 24px;\n}\n\n.game-stats {\n display: flex;\n justify-content: space-between;\n width: 100%;\n padding: 0 20px;\n margin-bottom: 10px;\n flex-shrink: 0;\n}\n\n.word-count {\n font-weight: bold;\n}\n\n.timer {\n font-weight: bold;\n}\n\n.last-word {\n display: flex;\n gap: 10px;\n}\n\n.found-word {\n background-color: #e0e0e0;\n padding: 5px 10px;\n border-radius: 5px;\n}\n\n.svg-container {\n flex-grow: 1;\n display: flex;\n align-items: center;\n justify-content: center;\n width: 100%;\n max-height: 60vh;\n overflow: hidden;\n}\n\nsvg {\n width: 100%;\n max-width: 300px;\n max-height: 300px;\n touch-action: none;\n}\n\n.donut path {\n fill: #fff;\n stroke: #333;\n stroke-width: 2;\n}\n\n.donut path.selected {\n fill: #ffd700;\n}\n\ntext {\n font-size: 24px;\n user-select: none;\n}\n\n.word-display {\n text-align: center;\n height: 50px;\n flex-shrink: 0;\n}\n\n.star {\n fill: gold;\n stroke: goldenrod;\n stroke-width: 1;\n opacity: 1;\n transition: opacity 0.3s ease-out;\n}\n\n.star.fading {\n opacity: 0;\n}\n\n.modal-overlay {\n position: fixed;\n top: 0;\n left: 0;\n width: 100%;\n height: 100%;\n background-color: rgba(0, 0, 0, 0.5);\n display: flex;\n justify-content: center;\n align-items: center;\n z-index: 1000;\n}\n\n.modal-content {\n background-color: white;\n padding: 20px;\n border-radius: 10px;\n max-width: 90%;\n width: 400px;\n text-align: left;\n}\n\n.modal-content h2 {\n margin-top: 0;\n}\n\n.modal-content ol {\n padding-left: 20px;\n}\n\n.modal-content button {\n width: 100%;\n padding: 10px;\n background-color: #333;\n color: white;\n border: none;\n border-radius: 5px;\n margin-top: 20px;\n cursor: pointer;\n}\n\n@media (max-height: 600px) {\n .game-container {\n padding: 5px;\n }\n \n .svg-container {\n max-height: 50vh;\n }\n \n svg {\n max-width: 250px;\n max-height: 250px;\n }\n}\n`;","createdAt",["D",1739845121871],"version",52,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_130":131,"_132":133},"handle","alexwein","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycjh6emNHdk9mMnY5djU3OFZBbEdleGhQZFAifQ","forkedVal","interval","slug","alexwein/loopyLetters","description","[WIP] Loopy Letters, another little word game A word game with a small gameplay loop. Plays best on your phone. It uses random words from the Wordnik word game list, as shared on their Github page ,\nwhich has a lot of stuff on there I myself wouldn't really consider a word. Sorry about that. I probably spent as much time prompting the Townie LLM interface as I did in the code editor.\nSo if parts seem sloppy, it's because it is slop. Rules Use every letter on the donut to spell a word. Letters in the word must be adjacent to each other on the donut. You can go clockwise or counterclockwise . When you find a word. The next word to find appears. Go fast. Go slow. Enjoy. This revisits the gameplay from a 2002 Observable notebook I made called\n \"find a (big) word, rings\" .","versions",[142,145,149,153,157,161,165,169,173,177,181,185,189,193,197,201,205,209,213,217,221,225,229,233,237,241,245,249,253,257,261,265,269,273,277,281,285,289,293,297,301,305,309,313,317,321,325,329,333,337,341,344,347],{"_118":119,"_143":-5,"_116":144,"_113":111},"prId",["D",1739845121871],{"_118":146,"_143":-5,"_116":147,"_113":148},51,["D",1739845100444],"9f47f488-ed9e-11ef-8d92-e6cdfca9ef9f",{"_118":150,"_143":-5,"_116":151,"_113":152},50,["D",1739844755262],"d187b326-ed9d-11ef-8d64-e6cdfca9ef9f",{"_118":154,"_143":-5,"_116":155,"_113":156},49,["D",1739840198344],"356556ba-ed93-11ef-82a0-e6cdfca9ef9f",{"_118":158,"_143":-5,"_116":159,"_113":160},48,["D",1739832772675],"eb5a5eb4-ed81-11ef-a695-e6cdfca9ef9f",{"_118":162,"_143":-5,"_116":163,"_113":164},47,["D",1739831909801],"e909cf3e-ed7f-11ef-87bb-e6cdfca9ef9f",{"_118":166,"_143":-5,"_116":167,"_113":168},46,["D",1739831818722],"b2c27a98-ed7f-11ef-96c1-e6cdfca9ef9f",{"_118":170,"_143":-5,"_116":171,"_113":172},45,["D",1739831649412],"4dd57aa4-ed7f-11ef-bf05-e6cdfca9ef9f",{"_118":174,"_143":-5,"_116":175,"_113":176},44,["D",1739831619668],"3c1bfbbc-ed7f-11ef-bf05-e6cdfca9ef9f",{"_118":178,"_143":-5,"_116":179,"_113":180},43,["D",1739831588763],"29b002fc-ed7f-11ef-bef3-e6cdfca9ef9f",{"_118":182,"_143":-5,"_116":183,"_113":184},42,["D",1739831438597],"d02e27f4-ed7e-11ef-a544-e6cdfca9ef9f",{"_118":186,"_143":-5,"_116":187,"_113":188},41,["D",1739831307563],"82228f8c-ed7e-11ef-832d-e6cdfca9ef9f",{"_118":190,"_143":-5,"_116":191,"_113":192},40,["D",1739831168559],"2f391610-ed7e-11ef-bbea-e6cdfca9ef9f",{"_118":194,"_143":-5,"_116":195,"_113":196},39,["D",1739831129727],"18140bd4-ed7e-11ef-bbea-e6cdfca9ef9f",{"_118":198,"_143":-5,"_116":199,"_113":200},38,["D",1739831100568],"06b2ed42-ed7e-11ef-a2fb-e6cdfca9ef9f",{"_118":202,"_143":-5,"_116":203,"_113":204},37,["D",1739831023152],"d88e893a-ed7d-11ef-a856-e6cdfca9ef9f",{"_118":206,"_143":-5,"_116":207,"_113":208},36,["D",1739830961901],"b40c2fcc-ed7d-11ef-91ae-e6cdfca9ef9f",{"_118":210,"_143":-5,"_116":211,"_113":212},35,["D",1739830879839],"8322856e-ed7d-11ef-9790-e6cdfca9ef9f",{"_118":214,"_143":-5,"_116":215,"_113":216},34,["D",1739830774971],"44a15428-ed7d-11ef-9637-e6cdfca9ef9f",{"_118":218,"_143":-5,"_116":219,"_113":220},33,["D",1739830633793],"f07aa1d8-ed7c-11ef-896d-e6cdfca9ef9f",{"_118":222,"_143":-5,"_116":223,"_113":224},32,["D",1739830569941],"ca6c626a-ed7c-11ef-8a70-e6cdfca9ef9f",{"_118":226,"_143":-5,"_116":227,"_113":228},31,["D",1739830278078],"1c74f6b8-ed7c-11ef-b6f3-e6cdfca9ef9f",{"_118":230,"_143":-5,"_116":231,"_113":232},30,["D",1739829883964],"318cd864-ed7b-11ef-a7f6-e6cdfca9ef9f",{"_118":234,"_143":-5,"_116":235,"_113":236},29,["D",1739829260764],"be17442e-ed79-11ef-9b02-e6cdfca9ef9f",{"_118":238,"_143":-5,"_116":239,"_113":240},28,["D",1739829260288],"bdced0cc-ed79-11ef-80e7-e6cdfca9ef9f",{"_118":242,"_143":-5,"_116":243,"_113":244},27,["D",1739829172651],"89917c1a-ed79-11ef-97a1-e6cdfca9ef9f",{"_118":246,"_143":-5,"_116":247,"_113":248},26,["D",1739816564541],"2e8cecb8-ed5c-11ef-a977-e6cdfca9ef9f",{"_118":250,"_143":-5,"_116":251,"_113":252},25,["D",1739816523406],"16085d58-ed5c-11ef-a2f8-e6cdfca9ef9f",{"_118":254,"_143":-5,"_116":255,"_113":256},24,["D",1739816367861],"b953d498-ed5b-11ef-ab95-e6cdfca9ef9f",{"_118":258,"_143":-5,"_116":259,"_113":260},23,["D",1739816240683],"6d844c82-ed5b-11ef-8569-e6cdfca9ef9f",{"_118":262,"_143":-5,"_116":263,"_113":264},22,["D",1739815665282],"168d5460-ed5a-11ef-8109-e6cdfca9ef9f",{"_118":266,"_143":-5,"_116":267,"_113":268},21,["D",1739815576036],"e15e541a-ed59-11ef-9c3c-e6cdfca9ef9f",{"_118":270,"_143":-5,"_116":271,"_113":272},20,["D",1739815504743],"b6dcfc5a-ed59-11ef-8109-e6cdfca9ef9f",{"_118":274,"_143":-5,"_116":275,"_113":276},19,["D",1739815468520],"a1628a20-ed59-11ef-975e-e6cdfca9ef9f",{"_118":278,"_143":-5,"_116":279,"_113":280},18,["D",1739815372814],"683a0e9e-ed59-11ef-992d-e6cdfca9ef9f",{"_118":282,"_143":-5,"_116":283,"_113":284},17,["D",1739815349266],"5a305b8c-ed59-11ef-9728-e6cdfca9ef9f",{"_118":286,"_143":-5,"_116":287,"_113":288},16,["D",1739815320495],"490a76da-ed59-11ef-8c29-e6cdfca9ef9f",{"_118":290,"_143":-5,"_116":291,"_113":292},15,["D",1739815283195],"32cfff66-ed59-11ef-9728-e6cdfca9ef9f",{"_118":294,"_143":-5,"_116":295,"_113":296},14,["D",1739815257919],"23be8100-ed59-11ef-ab12-e6cdfca9ef9f",{"_118":298,"_143":-5,"_116":299,"_113":300},13,["D",1739815084218],"bc364ed2-ed58-11ef-81cb-e6cdfca9ef9f",{"_118":302,"_143":-5,"_116":303,"_113":304},12,["D",1739814746382],"f2d93220-ed57-11ef-8328-e6cdfca9ef9f",{"_118":306,"_143":-5,"_116":307,"_113":308},11,["D",1739814581561],"909b3d24-ed57-11ef-a88c-e6cdfca9ef9f",{"_118":310,"_143":-5,"_116":311,"_113":312},10,["D",1739744360668],"11b071ee-ecb4-11ef-ae25-e6cdfca9ef9f",{"_118":314,"_143":-5,"_116":315,"_113":316},9,["D",1739744037385],"50ff94d4-ecb3-11ef-96f7-e6cdfca9ef9f",{"_118":318,"_143":-5,"_116":319,"_113":320},8,["D",1739743944050],"195d9b02-ecb3-11ef-a29b-e6cdfca9ef9f",{"_118":322,"_143":-5,"_116":323,"_113":324},7,["D",1739743888089],"f8040176-ecb2-11ef-b6a2-e6cdfca9ef9f",{"_118":326,"_143":-5,"_116":327,"_113":328},6,["D",1739743651453],"6af72a24-ecb2-11ef-93c8-e6cdfca9ef9f",{"_118":330,"_143":-5,"_116":331,"_113":332},5,["D",1739743399450],"d4c257fe-ecb1-11ef-985b-e6cdfca9ef9f",{"_118":334,"_143":-5,"_116":335,"_113":336},4,["D",1739743368003],"c203e25e-ecb1-11ef-9fe7-e6cdfca9ef9f",{"_118":338,"_143":-5,"_116":339,"_113":340},3,["D",1739743191881],"5909cbb0-ecb1-11ef-b158-e6cdfca9ef9f",{"_118":90,"_143":-5,"_116":342,"_113":343},["D",1739743105985],"25d72f80-ecb1-11ef-a576-e6cdfca9ef9f",{"_118":125,"_143":-5,"_116":345,"_113":346},["D",1739743065331],"0d9ba6c6-ecb1-11ef-9b7b-e6cdfca9ef9f",{"_118":31,"_143":-5,"_116":348,"_113":349},["D",1739742840408],"878d2fc8-ecb0-11ef-ad33-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.dependencies",{"_357":358,"_414":125,"_415":137,"_416":31,"_94":417},"dependenciesList",[359],{"_100":360,"_361":362},"08f95904-3584-11ef-8995-0e10024e3b32","initialData",{"_98":363,"_95":364,"_100":360,"_102":365,"_103":-5,"_104":105,"_106":366,"_108":367,"_110":368,"_112":26,"_113":368,"_114":369,"_116":370,"_118":298,"_120":26,"_121":310,"_123":371,"_124":125,"_126":125,"_122":266,"_127":31,"_128":-5,"_20":372,"_134":375,"_135":-7,"_138":379,"_380":-5,"_136":381,"_140":382},"sqlite","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","76a8911e-393e-11ef-8e71-de64eea55b61","# LLM-Safe Fork of @std/sqlite\n\nWe found that LLMs have trouble with the inputs and outputs of our @std/sqlite method.\n\n1. It expects the input to be `(sql: string, args: any[])` but it's `{ sql: string, args: any[] }`\n2. It expects the output to be objects, but they are arrays\n\nInstead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. \n\nThis val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","script","5631f2d0-dcb9-11ef-80ec-e6cdfca9ef9f","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type ResultSet, type Row, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\n/**\n * Every Val Town account comes with its own private\n * [SQLite database](https://www.sqlite.org/) that\n * is accessible from any of your vals.\n * ([Docs ↗](https://docs.val.town/std/sqlite))\n */\nexport const sqlite = {\n /**\n * Executes a SQLite statement.\n *\n * @param {InStatement} statement - The SQLite statement to execute.\n * @example String query:\n * `sqlite.execute(\"SELECT 1;\")`\n * @example Query with arguments:\n * `sqlite.execute({sql: \"SELECT * from books WHERE year > ?;\", args: [2020]})`\n */\n execute,\n\n /**\n * Executes a batch of SQLite statements.\n *\n * @param {InStatement[]} statements - An array of SQLite statements to execute.\n * @param {TransactionMode} [mode] - The transaction mode for the batch execution.\n */\n batch,\n};\n\n// ------------\n// Functions\n// ------------\n\nasync function execute(statement: InStatement, args?: InArgs): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n },\n body: JSON.stringify({ statement: normalizeStatement(statement, args) }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSet = await res.json();\n return upgradeResultSet(resultSet);\n}\n\nasync function batch(statements: InStatement[], mode?: TransactionMode): Promise {\n if (mode && ![\"write\", \"read\", \"deferred\"].includes(mode)) {\n throw new Error(\"Invalid transaction mode provided to sqlite.batch. Must be 'write', 'read', or 'deferred.\");\n }\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n },\n body: JSON.stringify({ statements: statements.map(s => normalizeStatement(s)), mode }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSets = await res.json();\n return resultSets.map(upgradeResultSet);\n}\n\nfunction createResError(body: string) {\n try {\n const e = zLibsqlError.parse(JSON.parse(body));\n // e.message already contains the code, and LibsqlError adds the\n // code to the beginning, so we remove it here\n const msg = e.message.replace(e.code, \"\").replace(/^:\\s+/, \"\");\n return new LibsqlError(msg, e.code, e.rawCode);\n } catch (_) {\n // Failed to parse libsql error\n }\n return new Error(body);\n}\n\n/* Val Town's Turso Proxy returns rows as an array of values\n * Yet the LibSQL API has a Row type which behave as an array or object,\n * ie you can access it via numerical index or string\n */\ninterface ImpoverishedResultSet extends ResultSet {\n rows: any[];\n}\n\nfunction normalizeStatement(statement: InStatement, args?: InArgs) {\n if (Array.isArray(statement)) {\n // for the case of an array of arrays\n return normalizeStatement(statement[0], statement[1]);\n }\n if (typeof statement === \"string\") {\n if (args) {\n return { sql: statement, args };\n } else return statement;\n }\n else if (typeof statement === \"object\") {\n if (statement.args) {\n return statement;\n }\n if (args) {\n return { sql: statement.sql, args };\n }\n return statement.sql;\n }\n else throw new Error(\"Error normalizing sql input\");\n}\n\nfunction upgradeResultSet(results: ImpoverishedResultSet): ResultSet {\n return {\n ...results,\n rows: results.rows.map(row => rowFromSql(row, results.columns)),\n };\n}\n\n// adapted from\n// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2\nfunction rowFromSql(\n sqlRow: Array,\n columns: Array,\n): Row {\n const row = {};\n // make sure that the \"length\" property is not enumerable\n Object.defineProperty(row, \"length\", { value: sqlRow.length });\n for (let i = 0; i < sqlRow.length; ++i) {\n const value = sqlRow[i];\n Object.defineProperty(row, i, { value });\n\n const column = columns[i];\n if (!Object.hasOwn(row, column)) {\n Object.defineProperty(row, column, {\n value,\n enumerable: true,\n configurable: true,\n writable: true,\n });\n }\n }\n return row as Row;\n}\n\n// ------------\n// Helpers\n// ------------\n\nconst zLibsqlError = z.object({\n message: z.string(),\n code: z.string(),\n rawCode: z.number().optional(),\n});\n\n// We patch these types to only support JSON values\nexport type InValue = null | string | number | boolean;\nexport type InArgs = Array | Record;\nexport type InStatement = {\n /**\n * The SQL statement to execute.\n */\n sql: string;\n\n /**\n * The arguments to bind to the SQL statement.\n */\n args: InArgs;\n} | string;",["D",1737987404484],13371,{"_130":373,"_132":374},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_113":376,"_130":377,"_98":363,"_118":326,"_378":-5},"56c849ee-f1f8-11ee-9b87-cab58f78796a","std","prDisabledHint","LLM-Safe Fork of @std/sqlite We found that LLMs have trouble with the inputs and outputs of our @std/sqlite method. It expects the input to be (sql: string, args: any[]) but it's { sql: string, args: any[] } It expects the output to be objects, but they are arrays Instead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. This val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","latestEvaluation","stevekrouse/sqlite",[383,387,390,393,396,399,402,405,408,411],{"_116":384,"_118":298,"_385":386},["D",1737987404484],"n","1",{"_116":388,"_118":302,"_385":389},["D",1724087412304],"2",{"_116":391,"_118":306,"_385":392},["D",1724087404512],"3",{"_116":394,"_118":310,"_385":395},["D",1723494410142],"4",{"_116":397,"_118":314,"_385":398},["D",1723494389876],"5",{"_116":400,"_118":318,"_385":401},["D",1723494345363],"6",{"_116":403,"_118":322,"_385":404},["D",1723494323065],"7",{"_116":406,"_118":326,"_385":407},["D",1719604370206],"8",{"_116":409,"_118":330,"_385":410},["D",1719604260994],"9",{"_116":412,"_118":334,"_385":413},["D",1719604144103],"10","dependenciesCount","valname","page",{"_113":111,"_98":99,"_130":131,"_11":96,"_118":119,"_100":101,"_114":115,"_104":105,"_112":26,"_136":137},"routes/_app","actionData","errors"]