[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_208":209,"_210":211},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_107":89,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":58,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","index.ts","latestPath","fileId","264a239e-008f-11f1-b6b7-42dde27851f2","name","fileType","http","content","/**\n * Val.town Example: AI Chat History API with nano-supabase\n *\n * A local PostgreSQL-powered chat store with persistent storage.\n * Data survives cold starts using Val.town's blob storage.\n *\n * To use:\n * 1. Go to https://val.town and create a new val\n * 2. Copy this code into the editor\n * 3. Set the val type to HTTP\n * 4. Your API is instantly live!\n */\n\nimport { PGlite } from \"npm:@electric-sql/pglite@0.2.17\";\nimport { createSupabaseClient } from \"https://raw.githubusercontent.com/filipecabaco/nano-supabase/main/dist/index.js\";\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nconst BLOB_KEY = \"nano-supabase-chat-db\";\n\nlet db: PGlite | null = null;\nlet supabase: Awaited> | null = null;\nlet initialized = false;\n\nasync function saveDb() {\n if (!db) return;\n try {\n // Export all data as SQL statements\n const conversations = await db.query(\"SELECT * FROM conversations\");\n const messages = await db.query(\"SELECT * FROM messages\");\n await blob.setJSON(BLOB_KEY, {\n conversations: conversations.rows,\n messages: messages.rows,\n savedAt: new Date().toISOString(),\n });\n console.log(\"Saved database to blob storage\");\n } catch (e) {\n console.error(\"Failed to save:\", e);\n }\n}\n\nasync function restoreFromBlob(db: PGlite) {\n try {\n const saved = await blob.getJSON(BLOB_KEY) as {\n conversations: Array<{ id: string; title: string; created_at: string }>;\n messages: Array<{ id: string; conversation_id: string; role: string; content: string; tokens: number; created_at: string }>;\n } | null;\n\n if (saved?.conversations) {\n for (const conv of saved.conversations) {\n await db.query(\n `INSERT INTO conversations (id, title, created_at) VALUES ($1, $2, $3) ON CONFLICT (id) DO NOTHING`,\n [conv.id, conv.title, conv.created_at]\n );\n }\n }\n if (saved?.messages) {\n for (const msg of saved.messages) {\n await db.query(\n `INSERT INTO messages (id, conversation_id, role, content, tokens, created_at) VALUES ($1, $2, $3, $4, $5, $6) ON CONFLICT (id) DO NOTHING`,\n [msg.id, msg.conversation_id, msg.role, msg.content, msg.tokens, msg.created_at]\n );\n }\n }\n return saved !== null;\n } catch {\n return false;\n }\n}\n\nasync function initDb() {\n if (!db || !initialized) {\n db = new PGlite();\n\n // Create tables first\n await db.exec(`\n CREATE TABLE IF NOT EXISTS conversations (\n id TEXT PRIMARY KEY DEFAULT gen_random_uuid()::text,\n title TEXT,\n created_at TIMESTAMPTZ DEFAULT now()\n );\n\n CREATE TABLE IF NOT EXISTS messages (\n id TEXT PRIMARY KEY DEFAULT gen_random_uuid()::text,\n conversation_id TEXT REFERENCES conversations(id),\n role TEXT CHECK (role IN ('user', 'assistant', 'system')),\n content TEXT NOT NULL,\n tokens INTEGER,\n created_at TIMESTAMPTZ DEFAULT now()\n );\n\n CREATE INDEX IF NOT EXISTS idx_messages_conversation\n ON messages(conversation_id, created_at);\n `);\n\n // Then restore data from blob\n const restored = await restoreFromBlob(db);\n console.log(restored ? \"Restored from blob storage\" : \"Starting fresh\");\n\n supabase = await createSupabaseClient(db);\n initialized = true;\n }\n return { db, supabase: supabase! };\n}\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n\n const headers = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n };\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers });\n }\n\n try {\n const { db, supabase } = await initDb();\n\n // GET /conversations\n if (req.method === \"GET\" && path === \"/conversations\") {\n const { data, error } = await supabase\n .from(\"conversations\")\n .select(\"*\")\n .order(\"created_at\", { ascending: false });\n return Response.json({ data, error: error?.message }, { headers });\n }\n\n // POST /conversations\n if (req.method === \"POST\" && path === \"/conversations\") {\n const body = await req.json();\n const result = await db.query(\n `INSERT INTO conversations (title) VALUES ($1) RETURNING *`,\n [body.title || \"New Chat\"]\n );\n await saveDb();\n return Response.json({ data: result.rows[0] }, { headers });\n }\n\n // GET /messages?conversation_id=xxx\n if (req.method === \"GET\" && path === \"/messages\") {\n const conversationId = url.searchParams.get(\"conversation_id\");\n if (!conversationId) {\n return Response.json({ error: \"conversation_id required\" }, { status: 400, headers });\n }\n const { data, error } = await supabase\n .from(\"messages\")\n .select(\"*\")\n .eq(\"conversation_id\", conversationId)\n .order(\"created_at\", { ascending: true });\n return Response.json({ data, error: error?.message }, { headers });\n }\n\n // POST /messages\n if (req.method === \"POST\" && path === \"/messages\") {\n const body = await req.json();\n const result = await db.query(\n `INSERT INTO messages (conversation_id, role, content, tokens)\n VALUES ($1, $2, $3, $4) RETURNING *`,\n [body.conversation_id, body.role, body.content, body.tokens || null]\n );\n await saveDb();\n return Response.json({ data: result.rows[0] }, { headers });\n }\n\n // GET /stats\n if (req.method === \"GET\" && path === \"/stats\") {\n const result = await db.query(`\n SELECT COUNT(*) as total_messages,\n COALESCE(SUM(tokens), 0) as total_tokens,\n COUNT(DISTINCT conversation_id) as conversations\n FROM messages\n `);\n return Response.json({ data: result.rows[0] }, { headers });\n }\n\n return Response.json({\n message: \"nano-supabase Chat API (with persistence)\",\n github: \"https://github.com/filipecabaco/nano-supabase\",\n endpoints: [\n \"GET /conversations\",\n \"POST /conversations { title }\",\n \"GET /messages?conversation_id=xxx\",\n \"POST /messages { conversation_id, role, content, tokens? }\",\n \"GET /stats\",\n ],\n }, { headers });\n } catch (error) {\n return Response.json(\n { error: error instanceof Error ? error.message : \"Unknown error\" },\n { status: 500, headers }\n );\n }\n}\n","import { initDb, saveSnapshot } from \"./persistence.ts\";\n\nconst HEADERS = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, PATCH, DELETE, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n};\n\nfunction json(data: unknown, status = 200) {\n return Response.json(data, { status, headers: HEADERS });\n}\n\nfunction parseSegments(path: string) {\n return path.split(\"/\").filter(Boolean);\n}\n\nfunction hashString(str: string): number {\n let hash = 5381;\n for (let i = 0; i < str.length; i++) {\n hash = ((hash << 5) + hash + str.charCodeAt(i)) >>> 0;\n }\n return hash % 100;\n}\n\nasync function getFlag(supabase: any, name: string) {\n const { data, error } = await supabase\n .from(\"feature_flags\")\n .select(\"*\")\n .eq(\"name\", name)\n .single();\n\n if (error || !data) return null;\n return data;\n}\n\nasync function handleListFlags(supabase: any, url: URL) {\n let query = supabase\n .from(\"feature_flags\")\n .select(\"*\")\n .order(\"created_at\", { ascending: false });\n\n const enabled = url.searchParams.get(\"enabled\");\n if (enabled !== null) {\n query = query.is(\"enabled\", enabled === \"true\");\n }\n\n const app = url.searchParams.get(\"app\");\n if (app) {\n const { data: appFlags } = await supabase\n .from(\"flag_apps\")\n .select(\"*\")\n .eq(\"app_name\", app);\n\n if (appFlags?.length) {\n query = query.in(\"id\", appFlags.map((f: any) => f.flag_id));\n }\n }\n\n const environment = url.searchParams.get(\"environment\");\n if (environment) {\n const { data: envFlags } = await supabase\n .from(\"flag_environments\")\n .select(\"*\")\n .eq(\"environment\", environment);\n\n if (envFlags?.length) {\n query = query.in(\"id\", envFlags.map((f: any) => f.flag_id));\n }\n }\n\n const { data, error } = await query;\n return json({ data, error: error?.message });\n}\n\nasync function handleCreateFlag(supabase: any, req: Request) {\n const body = await req.json();\n const { data, error } = await supabase\n .from(\"feature_flags\")\n .insert({\n name: body.name,\n description: body.description ?? \"\",\n enabled: body.enabled ?? false,\n rollout_percentage: body.rollout_percentage ?? 100,\n })\n .select()\n .single();\n\n if (error) return json({ error: error.message }, 400);\n await saveSnapshot();\n return json({ data }, 201);\n}\n\nasync function handleGetFlag(supabase: any, name: string) {\n const flag = await getFlag(supabase, name);\n if (!flag) return json({ error: \"Flag not found\" }, 404);\n\n const { data: environments } = await supabase\n .from(\"flag_environments\")\n .select(\"*\")\n .eq(\"flag_id\", flag.id);\n\n const { data: apps } = await supabase\n .from(\"flag_apps\")\n .select(\"*\")\n .eq(\"flag_id\", flag.id);\n\n return json({ data: { ...flag, environments: environments ?? [], apps: apps ?? [] } });\n}\n\nasync function handleUpdateFlag(supabase: any, name: string, req: Request) {\n const body = await req.json();\n const updates: Record = { updated_at: new Date().toISOString() };\n if (body.description !== undefined) updates.description = body.description;\n if (body.enabled !== undefined) updates.enabled = body.enabled;\n if (body.rollout_percentage !== undefined) updates.rollout_percentage = body.rollout_percentage;\n\n const { data, error } = await supabase\n .from(\"feature_flags\")\n .update(updates)\n .eq(\"name\", name)\n .select()\n .single();\n\n if (error) return json({ error: error.message }, 400);\n await saveSnapshot();\n return json({ data });\n}\n\nasync function handleDeleteFlag(supabase: any, name: string) {\n const flag = await getFlag(supabase, name);\n if (!flag) return json({ error: \"Flag not found\" }, 404);\n\n const { error } = await supabase\n .from(\"feature_flags\")\n .delete()\n .eq(\"name\", name);\n\n if (error) return json({ error: error.message }, 400);\n await saveSnapshot();\n return json({ data: { deleted: true } });\n}\n\nasync function handleToggleFlag(supabase: any, name: string) {\n const flag = await getFlag(supabase, name);\n if (!flag) return json({ error: \"Flag not found\" }, 404);\n\n const { data, error } = await supabase\n .from(\"feature_flags\")\n .update({ enabled: !flag.enabled, updated_at: new Date().toISOString() })\n .eq(\"name\", name)\n .select()\n .single();\n\n if (error) return json({ error: error.message }, 400);\n await saveSnapshot();\n return json({ data });\n}\n\nasync function handleEvaluateFlag(supabase: any, name: string, url: URL) {\n const app = url.searchParams.get(\"app\");\n const environment = url.searchParams.get(\"environment\");\n if (!app || !environment) {\n return json({ error: \"app and environment query params required\" }, 400);\n }\n\n const flag = await getFlag(supabase, name);\n if (!flag) return json({ data: { flag_name: name, active: false, reason: \"flag_not_found\" } });\n\n const { data: scopedApps } = await supabase\n .from(\"flag_apps\")\n .select(\"*\")\n .eq(\"flag_id\", flag.id);\n\n if (scopedApps?.length) {\n const isScoped = scopedApps.some((a: any) => a.app_name === app);\n if (!isScoped) {\n return json({ data: { flag_name: name, active: false, reason: \"app_not_scoped\" } });\n }\n }\n\n let enabled = flag.enabled;\n\n const { data: envOverride } = await supabase\n .from(\"flag_environments\")\n .select(\"*\")\n .eq(\"flag_id\", flag.id)\n .eq(\"environment\", environment)\n .maybeSingle();\n\n if (envOverride) {\n enabled = envOverride.enabled;\n }\n\n if (!enabled) {\n return json({ data: { flag_name: name, active: false, reason: \"disabled\" } });\n }\n\n if (flag.rollout_percentage < 100) {\n const identifier = url.searchParams.get(\"identifier\");\n const roll = identifier ? hashString(identifier) : Math.floor(Math.random() * 100);\n if (roll >= flag.rollout_percentage) {\n return json({ data: { flag_name: name, active: false, reason: \"rollout_excluded\" } });\n }\n }\n\n return json({ data: { flag_name: name, active: true } });\n}\n\nasync function handleAddEnvironment(supabase: any, name: string, req: Request) {\n const flag = await getFlag(supabase, name);\n if (!flag) return json({ error: \"Flag not found\" }, 404);\n\n const body = await req.json();\n const { data, error } = await supabase\n .from(\"flag_environments\")\n .insert({ flag_id: flag.id, environment: body.environment, enabled: body.enabled ?? false })\n .select()\n .single();\n\n if (error) return json({ error: error.message }, 400);\n await saveSnapshot();\n return json({ data }, 201);\n}\n\nasync function handleAddApp(supabase: any, name: string, req: Request) {\n const flag = await getFlag(supabase, name);\n if (!flag) return json({ error: \"Flag not found\" }, 404);\n\n const body = await req.json();\n const { data, error } = await supabase\n .from(\"flag_apps\")\n .insert({ flag_id: flag.id, app_name: body.app_name })\n .select()\n .single();\n\n if (error) return json({ error: error.message }, 400);\n await saveSnapshot();\n return json({ data }, 201);\n}\n\nexport default async function handler(req: Request): Promise {\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: HEADERS });\n }\n\n try {\n const { supabase } = await initDb();\n const url = new URL(req.url);\n const segments = parseSegments(url.pathname);\n\n if (segments.length === 0) {\n return json({\n message: \"nano-supabase Feature Flag Service\",\n github: \"https://github.com/filipecabaco/nano-supabase\",\n endpoints: [\n \"GET /flags List flags (?enabled, ?app, ?environment)\",\n \"POST /flags Create flag { name, description?, enabled?, rollout_percentage? }\",\n \"GET /flags/:name Get flag details\",\n \"PATCH /flags/:name Update flag { description?, enabled?, rollout_percentage? }\",\n \"DELETE /flags/:name Delete flag\",\n \"POST /flags/:name/toggle Toggle flag on/off\",\n \"GET /flags/:name/evaluate Evaluate flag ?app=x&environment=y&identifier=z\",\n \"POST /flags/:name/environments Add env override { environment, enabled }\",\n \"POST /flags/:name/apps Add app scope { app_name }\",\n ],\n });\n }\n\n if (segments[0] !== \"flags\") {\n return json({ error: \"Not found\" }, 404);\n }\n\n if (segments.length === 1) {\n if (req.method === \"GET\") return handleListFlags(supabase, url);\n if (req.method === \"POST\") return handleCreateFlag(supabase, req);\n return json({ error: \"Method not allowed\" }, 405);\n }\n\n const flagName = decodeURIComponent(segments[1]);\n const action = segments[2];\n\n if (!action) {\n if (req.method === \"GET\") return handleGetFlag(supabase, flagName);\n if (req.method === \"PATCH\") return handleUpdateFlag(supabase, flagName, req);\n if (req.method === \"DELETE\") return handleDeleteFlag(supabase, flagName);\n return json({ error: \"Method not allowed\" }, 405);\n }\n\n if (action === \"toggle\" && req.method === \"POST\") return handleToggleFlag(supabase, flagName);\n if (action === \"evaluate\" && req.method === \"GET\") return handleEvaluateFlag(supabase, flagName, url);\n if (action === \"environments\" && req.method === \"POST\") return handleAddEnvironment(supabase, flagName, req);\n if (action === \"apps\" && req.method === \"POST\") return handleAddApp(supabase, flagName, req);\n\n return json({ error: \"Not found\" }, 404);\n } catch (error) {\n return json({ error: error instanceof Error ? error.message : \"Unknown error\" }, 500);\n }\n}\n","createdAt",["D",1770116660135],"branchVersion","branchId","25cbd9c6-008f-11f1-9237-42dde27851f2","id","25cb6d6a-008f-11f1-9237-42dde27851f2","nanosupabase-demo",["D",1770075023956],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Chat API with nano-supabase","imageUrl","019c2095-952a-746b-bfc7-55e9a9eb0683","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019c2095-952a-746b-bfc7-5bc887fa704c","tursoName","25cb6d6a008f11f1923742dde27851f2","tursoHostname","25cb6d6a008f11f1923742dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789470042795],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",17,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","filipecabaco","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOThNTVBUczFxSlc1VnlFM3JMc3h6TEVteUMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":203,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":204,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":205,"_83":206,"_85":207,"_87":25},"tree",[182,183,184,185,186],"files",[182,183,184,185,186],"counts",{"_171":62,"_172":173,"_174":62,"_175":176,"_177":178},"contents",[129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":163,"_32":164,"_30":165,"_137":-5,"_41":42,"_40":166,"_139":58,"_38":167,"_13":168,"_33":20,"_35":169,"_24":25,"_142":-5,"_27":170},{"_43":159,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":25,"_38":160,"_13":161,"_33":34,"_35":37,"_24":25,"_142":-5,"_27":162},{"_43":152,"_32":153,"_30":154,"_137":-5,"_41":42,"_40":155,"_139":25,"_38":156,"_13":62,"_33":149,"_35":157,"_24":25,"_142":-5,"_27":158},{"_43":144,"_32":145,"_30":146,"_137":-5,"_41":42,"_40":147,"_139":58,"_38":148,"_13":62,"_33":149,"_35":150,"_24":25,"_142":-5,"_27":151},{"_43":134,"_32":135,"_30":136,"_137":-5,"_41":42,"_40":138,"_139":58,"_38":140,"_13":62,"_33":20,"_35":141,"_24":25,"_142":-5,"_27":143},"16e6826a-00f0-11f1-b206-42dde27851f2","test.sh","16e6836e-00f0-11f1-b206-42dde27851f2","parentId",10,"latest",["D",1770116660133],"#!/bin/bash\nset -e\n\nif [ -z \"$1\" ]; then\n echo \"Error: BASE_URL is required\"\n echo \"\"\n echo \"Usage: ./test.sh \"\n echo \"Example: ./test.sh https://username-valname.web.val.run\"\n exit 1\nfi\n\nBASE=\"$1\"\nFMT=\"python3 -m json.tool 2>/dev/null\"\n\npp() { python3 -m json.tool 2>/dev/null || cat; }\n\necho \"=== nano-supabase Feature Flag Service Test ===\"\necho \"Base URL: $BASE\"\necho \"\"\n\necho \"1. API Info:\"\ncurl -s \"$BASE/\" | pp\necho \"\"\n\necho \"2. Creating feature flag 'dark-mode'...\"\nFLAG_RESPONSE=$(curl -s -X POST \"$BASE/flags\" \\\n -H \"Content-Type: application/json\" \\\n -d '{\"name\": \"dark-mode\", \"description\": \"Enable dark mode UI\", \"enabled\": false, \"rollout_percentage\": 50}')\necho \"$FLAG_RESPONSE\" | pp\necho \"\"\n\necho \"3. Creating feature flag 'new-checkout'...\"\ncurl -s -X POST \"$BASE/flags\" \\\n -H \"Content-Type: application/json\" \\\n -d '{\"name\": \"new-checkout\", \"description\": \"Redesigned checkout flow\", \"enabled\": true}' | pp\necho \"\"\n\necho \"4. Listing all flags...\"\ncurl -s \"$BASE/flags\" | pp\necho \"\"\n\necho \"5. Getting 'dark-mode' details...\"\ncurl -s \"$BASE/flags/dark-mode\" | pp\necho \"\"\n\necho \"6. Toggling 'dark-mode' on...\"\ncurl -s -X POST \"$BASE/flags/dark-mode/toggle\" | pp\necho \"\"\n\necho \"7. Adding environment override (production=disabled)...\"\ncurl -s -X POST \"$BASE/flags/dark-mode/environments\" \\\n -H \"Content-Type: application/json\" \\\n -d '{\"environment\": \"production\", \"enabled\": false}' | pp\necho \"\"\n\necho \"8. Adding environment override (staging=enabled)...\"\ncurl -s -X POST \"$BASE/flags/dark-mode/environments\" \\\n -H \"Content-Type: application/json\" \\\n -d '{\"environment\": \"staging\", \"enabled\": true}' | pp\necho \"\"\n\necho \"9. Scoping 'dark-mode' to app 'web-app'...\"\ncurl -s -X POST \"$BASE/flags/dark-mode/apps\" \\\n -H \"Content-Type: application/json\" \\\n -d '{\"app_name\": \"web-app\"}' | pp\necho \"\"\n\necho \"10. Evaluating 'dark-mode' for web-app/staging...\"\ncurl -s \"$BASE/flags/dark-mode/evaluate?app=web-app&environment=staging&identifier=user-123\" | pp\necho \"\"\n\necho \"11. Evaluating 'dark-mode' for web-app/production (should be disabled)...\"\ncurl -s \"$BASE/flags/dark-mode/evaluate?app=web-app&environment=production&identifier=user-123\" | pp\necho \"\"\n\necho \"12. Evaluating 'dark-mode' for mobile-app (not scoped, should fail)...\"\ncurl -s \"$BASE/flags/dark-mode/evaluate?app=mobile-app&environment=staging&identifier=user-456\" | pp\necho \"\"\n\necho \"13. Updating 'dark-mode' rollout to 100%...\"\ncurl -s -X PATCH \"$BASE/flags/dark-mode\" \\\n -H \"Content-Type: application/json\" \\\n -d '{\"rollout_percentage\": 100}' | pp\necho \"\"\n\necho \"14. Listing enabled flags only...\"\ncurl -s \"$BASE/flags?enabled=true\" | pp\necho \"\"\n\necho \"15. Getting full 'dark-mode' details (with environments and apps)...\"\ncurl -s \"$BASE/flags/dark-mode\" | pp\necho \"\"\n\necho \"16. Deleting 'new-checkout'...\"\ncurl -s -X DELETE \"$BASE/flags/new-checkout\" | pp\necho \"\"\n\necho \"17. Final flag list...\"\ncurl -s \"$BASE/flags\" | pp\necho \"\"\n\necho \"=== Test Complete ===\"\necho \"\"\necho \"To verify persistence, wait for a cold start and run:\"\necho \" curl $BASE/flags\"\n","label",[135],"16e382ea-00f0-11f1-baff-42dde27851f2","schema.ts","16e3838a-00f0-11f1-baff-42dde27851f2",9,["D",1770116660129],"script","import type { PGlite } from \"npm:@electric-sql/pglite@0.2.17\";\n\nexport async function createSchema(db: PGlite) {\n await db.exec(`\n CREATE TABLE IF NOT EXISTS feature_flags (\n id TEXT PRIMARY KEY DEFAULT gen_random_uuid()::text,\n name TEXT UNIQUE NOT NULL,\n description TEXT DEFAULT '',\n enabled BOOLEAN DEFAULT false,\n rollout_percentage INTEGER DEFAULT 100\n CHECK (rollout_percentage >= 0 AND rollout_percentage <= 100),\n created_at TIMESTAMPTZ DEFAULT now(),\n updated_at TIMESTAMPTZ DEFAULT now()\n );\n\n CREATE TABLE IF NOT EXISTS flag_environments (\n id TEXT PRIMARY KEY DEFAULT gen_random_uuid()::text,\n flag_id TEXT NOT NULL REFERENCES feature_flags(id) ON DELETE CASCADE,\n environment TEXT NOT NULL,\n enabled BOOLEAN DEFAULT false,\n UNIQUE(flag_id, environment)\n );\n\n CREATE TABLE IF NOT EXISTS flag_apps (\n id TEXT PRIMARY KEY DEFAULT gen_random_uuid()::text,\n flag_id TEXT NOT NULL REFERENCES feature_flags(id) ON DELETE CASCADE,\n app_name TEXT NOT NULL,\n UNIQUE(flag_id, app_name)\n );\n\n CREATE INDEX IF NOT EXISTS idx_flag_environments_flag_id ON flag_environments(flag_id);\n CREATE INDEX IF NOT EXISTS idx_flag_apps_flag_id ON flag_apps(flag_id);\n CREATE INDEX IF NOT EXISTS idx_feature_flags_name ON feature_flags(name);\n `);\n}\n",[145],"16ed5b58-00f0-11f1-92cc-42dde27851f2","persistence.ts","16ed5c3e-00f0-11f1-92cc-42dde27851f2",11,["D",1770116660108],"import { PGlite } from \"npm:@electric-sql/pglite@0.2.17\";\nimport { createSupabaseClient } from \"https://raw.githubusercontent.com/filipecabaco/nano-supabase/main/dist/index.js\";\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport { createSchema } from \"./schema.ts\";\n\nconst BLOB_KEY = \"nano-supabase-flags-db\";\n\nlet db: PGlite | null = null;\nlet supabase: Awaited> | null = null;\nlet initialized = false;\n\nasync function loadSnapshot(): Promise {\n const response = await blob.get(BLOB_KEY);\n if (!response) return null;\n const data = await response.arrayBuffer();\n if (data.byteLength === 0) return null;\n return new Blob([data]);\n}\n\nexport async function saveSnapshot() {\n if (!db) return;\n const backup = await db.dumpDataDir(\"gzip\");\n await blob.set(BLOB_KEY, backup);\n}\n\nexport async function initDb() {\n if (db && initialized) return { db, supabase: supabase! };\n\n const snapshot = await loadSnapshot();\n\n if (snapshot) {\n db = new PGlite({ loadDataDir: snapshot });\n } else {\n db = new PGlite();\n await createSchema(db);\n }\n\n supabase = await createSupabaseClient(db);\n initialized = true;\n return { db, supabase: supabase! };\n}\n",[153],"16fde50e-00f0-11f1-b743-42dde27851f2",["D",1770116660135],4,[28],"16e01c2c-00f0-11f1-928a-42dde27851f2","README.md","262d019c-008f-11f1-8893-42dde27851f2",8,["D",1770116660104],3,"# Val.town Example: Feature Flag Service\n\nDeploy a feature flag service on [Val.town](https://val.town) powered by nano-supabase with **persistent storage**.\n\n## Features\n\n- Full PostgreSQL database running in WebAssembly\n- Supabase-compatible query API\n- Per-environment overrides and app scoping\n- Percentage-based rollouts with deterministic hashing\n- **Persistent storage** via PGlite's `dumpDataDir`/`loadDataDir` (data survives cold starts)\n- CORS enabled for browser access\n\n## Quick Start (Web UI)\n\n1. Go to [val.town](https://val.town) and create a new val\n2. Copy the contents of all `.ts` files (`index.ts`, `persistence.ts`, `schema.ts`) into the editor\n3. **Important**: Set the val type to **HTTP** using the dropdown near the val name\n4. Your API is instantly live at `https://YOUR_USERNAME-YOUR_VAL_NAME.web.val.run`\n\n## Using the vt CLI\n\n```bash\nnpm install -g @valtown/vt\n\nvt login\n\ncd examples/valtown\nvt create my-flags . --no-editor-files --upload-if-exists --public\n\n# Set the val type to HTTP on the web page\nvt browse\n```\n\n## API Endpoints\n\n| Method | Path | Description |\n|--------|------|-------------|\n| GET | `/` | API info and available endpoints |\n| GET | `/flags` | List all flags (`?enabled`, `?app`, `?environment`) |\n| POST | `/flags` | Create flag `{ name, description?, enabled?, rollout_percentage? }` |\n| GET | `/flags/:name` | Get flag details with environments and apps |\n| PATCH | `/flags/:name` | Update flag `{ description?, enabled?, rollout_percentage? }` |\n| DELETE | `/flags/:name` | Delete flag (cascades to environments and apps) |\n| POST | `/flags/:name/toggle` | Toggle flag enabled/disabled |\n| GET | `/flags/:name/evaluate` | Evaluate flag `?app=x&environment=y&identifier=z` |\n| POST | `/flags/:name/environments` | Add environment override `{ environment, enabled }` |\n| POST | `/flags/:name/apps` | Add app scope `{ app_name }` |\n\n## Testing\n\n```bash\n./test.sh https://YOUR_USERNAME-YOUR_VAL_NAME.web.val.run\n```\n\nOr test manually:\n\n```bash\n# Create a flag with 50% rollout\ncurl -X POST https://YOUR_URL/flags \\\n -H \"Content-Type: application/json\" \\\n -d '{\"name\": \"dark-mode\", \"enabled\": true, \"rollout_percentage\": 50}'\n\n# Add a production override (disabled)\ncurl -X POST https://YOUR_URL/flags/dark-mode/environments \\\n -H \"Content-Type: application/json\" \\\n -d '{\"environment\": \"production\", \"enabled\": false}'\n\n# Scope to a specific app\ncurl -X POST https://YOUR_URL/flags/dark-mode/apps \\\n -H \"Content-Type: application/json\" \\\n -d '{\"app_name\": \"web-app\"}'\n\n# Evaluate: is this flag active for web-app in staging?\ncurl \"https://YOUR_URL/flags/dark-mode/evaluate?app=web-app&environment=staging&identifier=user-123\"\n\n# Toggle a flag\ncurl -X POST https://YOUR_URL/flags/dark-mode/toggle\n```\n\n## Evaluation Logic\n\nWhen evaluating a flag (`GET /flags/:name/evaluate?app=x&environment=y`):\n\n1. If the flag doesn't exist -> `active: false` (`flag_not_found`)\n2. If the flag has app scopes and the requested app isn't listed -> `active: false` (`app_not_scoped`)\n3. If an environment override exists, its `enabled` value takes precedence over the global flag `enabled`\n4. If resolved `enabled` is false -> `active: false` (`disabled`)\n5. If `rollout_percentage < 100`, a deterministic hash of the `identifier` param decides inclusion. Without an identifier, it uses random selection -> `active: false` (`rollout_excluded`)\n6. Otherwise -> `active: true`\n\n## Persistence\n\nThe database is persisted using PGlite's built-in `dumpDataDir`/`loadDataDir`. On each write operation, the entire database is serialized as a gzipped tarball and stored in Val.town's blob storage. On cold start, the snapshot is loaded back, restoring all tables, indexes, and data atomically.\n\nThe blob key is `nano-supabase-flags-db`.\n\n## File Structure\n\n- `index.ts` - HTTP handler with all feature flag endpoints\n- `persistence.ts` - Database initialization and snapshot persistence\n- `schema.ts` - Table definitions (feature_flags, flag_environments, flag_apps)\n\n## Troubleshooting\n\n**\"Not found\" response**: The val type isn't set to HTTP. Go to the val's page and change the type dropdown to \"HTTP\".\n\n**\"Invalid version provided\" error**: Try deleting the val and creating a new one with a different name, or clear Val.town's module cache by changing the import URL (add `?v=2`).\n\n**Import errors**: Make sure you're using the exact versions specified in the import statements.\n",[164],"pulls","branches",1,"forks","envVars",{"_179":62,"_181":62},"connections",{"_179":62,"_180":62},"count","unfilledCount","emptyCount",{"_43":163,"_32":164,"_30":165,"_137":-5,"_41":42,"_40":166,"_139":58,"_38":200,"_13":168,"_33":20,"_35":169,"_24":25,"_142":-5,"_188":201,"_27":202},{"_43":159,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":25,"_38":197,"_13":161,"_33":34,"_35":37,"_24":25,"_142":-5,"_188":198,"_27":199},{"_43":152,"_32":153,"_30":154,"_137":-5,"_41":42,"_40":155,"_139":25,"_38":194,"_13":62,"_33":149,"_35":157,"_24":25,"_142":-5,"_188":195,"_27":196},{"_43":144,"_32":145,"_30":146,"_137":-5,"_41":42,"_40":147,"_139":58,"_38":191,"_13":62,"_33":149,"_35":150,"_24":25,"_142":-5,"_188":192,"_27":193},{"_43":134,"_32":135,"_30":136,"_137":-5,"_41":42,"_40":138,"_139":58,"_38":187,"_13":62,"_33":20,"_35":141,"_24":25,"_142":-5,"_188":189,"_27":190},["D",1770116660133],"children",[],[135],["D",1770116660129],[],[145],["D",1770116660108],[],[153],["D",1770116660135],[],[28],["D",1770116660104],[],[164],["D",1770075023956],["D",1789470042795],{"_99":98,"_106":102},{"_99":98,"_100":-5,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_126":241,"_242":243,"_244":245,"_246":25,"_247":25,"_248":25,"_249":58,"_250":-5,"_251":-7,"_252":-7,"_253":62,"_254":25,"_255":25,"_256":-5,"_257":25,"_258":25,"_259":25,"_260":-5},"ENV",{"_212":213,"_214":215,"_216":89,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v12