[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_218":219,"_220":221},"routes/_app.x.$handle.$name",{"_98":97,"_31":43,"_106":88,"_26":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":24,"_121":122,"_123":57,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":24},"version",16,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","local-server.ts","latestPath","fileId","a7ae62f0-00fe-11f1-b8a6-42dde27851f2","name","fileType","script","content","import { PGlite } from \"@electric-sql/pglite\";\nimport { createSupabaseClient } from \"../../dist/index.js\";\n\nconst PORT = 3456;\n\nconst db = new PGlite();\n\nawait 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\nconst supabase = await createSupabaseClient(db);\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, PATCH, DELETE, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n },\n });\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\n// deno-lint-ignore no-explicit-any\nasync function getFlag(name: string): Promise {\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 handler(req: Request): Promise {\n if (req.method === \"OPTIONS\") return json(null, 204);\n\n try {\n const url = new URL(req.url);\n const segments = parseSegments(url.pathname);\n // deno-lint-ignore no-explicit-any\n let body: any;\n if ([\"POST\", \"PATCH\", \"PUT\"].includes(req.method)) {\n const text = await req.text();\n if (text) body = JSON.parse(text);\n }\n\n if (segments.length === 0) {\n return json({\n message: \"nano-supabase Feature Flag Service (local)\",\n endpoints: [\n \"GET /flags\",\n \"POST /flags\",\n \"GET /flags/:name\",\n \"PATCH /flags/:name\",\n \"DELETE /flags/:name\",\n \"POST /flags/:name/toggle\",\n \"GET /flags/:name/evaluate?app=x&environment=y&identifier=z\",\n \"POST /flags/:name/environments\",\n \"POST /flags/:name/apps\",\n ],\n });\n }\n\n if (segments[0] !== \"flags\") return json({ error: \"Not found\" }, 404);\n\n if (segments.length === 1) {\n if (req.method === \"GET\") {\n let query = supabase.from(\"feature_flags\").select(\"*\").order(\"created_at\", { ascending: false });\n const enabled = url.searchParams.get(\"enabled\");\n if (enabled !== null) query = query.is(\"enabled\", enabled === \"true\");\n\n const app = url.searchParams.get(\"app\");\n if (app) {\n const { data: appFlags } = await supabase.from(\"flag_apps\").select(\"*\").eq(\"app_name\", app);\n // deno-lint-ignore no-explicit-any\n if (appFlags?.length) query = query.in(\"id\", (appFlags as any[]).map((f) => f.flag_id));\n }\n\n const environment = url.searchParams.get(\"environment\");\n if (environment) {\n const { data: envFlags } = await supabase.from(\"flag_environments\").select(\"*\").eq(\"environment\", environment);\n // deno-lint-ignore no-explicit-any\n if (envFlags?.length) query = query.in(\"id\", (envFlags as any[]).map((f) => f.flag_id));\n }\n\n const { data, error } = await query;\n return json({ data, error: error?.message });\n }\n\n if (req.method === \"POST\") {\n const { error } = await supabase.from(\"feature_flags\").insert({\n name: body.name,\n description: body.description ?? \"\",\n enabled: body.enabled ?? false,\n rollout_percentage: body.rollout_percentage ?? 100,\n });\n if (error) return json({ error: error.message }, 400);\n const created = await getFlag(body.name);\n return json({ data: created }, 201);\n }\n\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\") {\n const flag = await getFlag(flagName);\n if (!flag) return json({ error: \"Flag not found\" }, 404);\n const { data: environments } = await supabase.from(\"flag_environments\").select(\"*\").eq(\"flag_id\", flag.id);\n const { data: apps } = await supabase.from(\"flag_apps\").select(\"*\").eq(\"flag_id\", flag.id);\n return json({ data: { ...flag, environments: environments ?? [], apps: apps ?? [] } });\n }\n\n if (req.method === \"PATCH\") {\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 const { error } = await supabase.from(\"feature_flags\").update(updates).eq(\"name\", flagName);\n if (error) return json({ error: error.message }, 400);\n const updated = await getFlag(flagName);\n return json({ data: updated });\n }\n\n if (req.method === \"DELETE\") {\n const flag = await getFlag(flagName);\n if (!flag) return json({ error: \"Flag not found\" }, 404);\n const { error } = await supabase.from(\"feature_flags\").delete().eq(\"name\", flagName);\n if (error) return json({ error: error.message }, 400);\n return json({ data: { deleted: true } });\n }\n\n return json({ error: \"Method not allowed\" }, 405);\n }\n\n if (action === \"toggle\" && req.method === \"POST\") {\n const flag = await getFlag(flagName);\n if (!flag) return json({ error: \"Flag not found\" }, 404);\n const { error } = await supabase.from(\"feature_flags\").update({ enabled: !flag.enabled, updated_at: new Date().toISOString() }).eq(\"name\", flagName);\n if (error) return json({ error: error.message }, 400);\n const toggled = await getFlag(flagName);\n return json({ data: toggled });\n }\n\n if (action === \"evaluate\" && req.method === \"GET\") {\n const app = url.searchParams.get(\"app\");\n const environment = url.searchParams.get(\"environment\");\n if (!app || !environment) return json({ error: \"app and environment query params required\" }, 400);\n\n const flag = await getFlag(flagName);\n if (!flag) return json({ data: { flag_name: flagName, active: false, reason: \"flag_not_found\" } });\n\n const { data: scopedApps } = await supabase.from(\"flag_apps\").select(\"*\").eq(\"flag_id\", flag.id);\n if (scopedApps?.length) {\n // deno-lint-ignore no-explicit-any\n const isScoped = (scopedApps as any[]).some((a) => a.app_name === app);\n if (!isScoped) return json({ data: { flag_name: flagName, active: false, reason: \"app_not_scoped\" } });\n }\n\n let enabled = flag.enabled;\n const { data: envOverride } = await supabase.from(\"flag_environments\").select(\"*\").eq(\"flag_id\", flag.id).eq(\"environment\", environment).maybeSingle();\n // deno-lint-ignore no-explicit-any\n if (envOverride) enabled = (envOverride as any).enabled;\n\n if (!enabled) return json({ data: { flag_name: flagName, active: false, reason: \"disabled\" } });\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) return json({ data: { flag_name: flagName, active: false, reason: \"rollout_excluded\" } });\n }\n\n return json({ data: { flag_name: flagName, active: true } });\n }\n\n if (action === \"environments\" && req.method === \"POST\") {\n const flag = await getFlag(flagName);\n if (!flag) return json({ error: \"Flag not found\" }, 404);\n const { error } = await supabase.from(\"flag_environments\").insert({ flag_id: flag.id, environment: body.environment, enabled: body.enabled ?? false });\n if (error) return json({ error: error.message }, 400);\n const { data: created } = await supabase.from(\"flag_environments\").select(\"*\").eq(\"flag_id\", flag.id).eq(\"environment\", body.environment).single();\n return json({ data: created }, 201);\n }\n\n if (action === \"apps\" && req.method === \"POST\") {\n const flag = await getFlag(flagName);\n if (!flag) return json({ error: \"Flag not found\" }, 404);\n const { error } = await supabase.from(\"flag_apps\").insert({ flag_id: flag.id, app_name: body.app_name });\n if (error) return json({ error: error.message }, 400);\n const { data: created } = await supabase.from(\"flag_apps\").select(\"*\").eq(\"flag_id\", flag.id).eq(\"app_name\", body.app_name).single();\n return json({ data: created }, 201);\n }\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\nDeno.serve({ port: PORT }, handler);\n","createdAt",["D",1770122916004],"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","264a239e-008f-11f1-b6b7-42dde27851f2","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",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":53,"_102":103,"_104":24},"branch",{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"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",{"_41":42,"_31":43,"_36":213,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":214,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":215,"_82":216,"_84":217,"_86":24},"tree",[188,189,190,191,192,193],"files",[188,189,190,191,192,193],"counts",{"_178":61,"_179":156,"_180":61,"_181":182,"_183":184},"contents",[128,129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":170,"_31":171,"_29":172,"_137":-5,"_39":40,"_38":173,"_139":57,"_36":174,"_13":175,"_32":20,"_34":176,"_23":24,"_142":-5,"_26":177},{"_41":162,"_31":163,"_29":55,"_137":-5,"_39":40,"_38":164,"_139":24,"_36":165,"_13":166,"_32":167,"_34":168,"_23":24,"_142":-5,"_26":169},{"_41":159,"_31":27,"_29":30,"_137":-5,"_39":40,"_38":14,"_139":57,"_36":160,"_13":61,"_32":33,"_34":35,"_23":24,"_142":-5,"_26":161},{"_41":151,"_31":152,"_29":153,"_137":-5,"_39":40,"_38":154,"_139":57,"_36":155,"_13":156,"_32":33,"_34":157,"_23":24,"_142":-5,"_26":158},{"_41":144,"_31":145,"_29":146,"_137":-5,"_39":40,"_38":147,"_139":57,"_36":148,"_13":61,"_32":33,"_34":149,"_23":24,"_142":-5,"_26":150},{"_41":134,"_31":135,"_29":136,"_137":-5,"_39":40,"_38":138,"_139":57,"_36":140,"_13":61,"_32":20,"_34":141,"_23":24,"_142":-5,"_26":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],"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],"b34a9f24-00f0-11f1-89a8-42dde27851f2","persistence.ts","16ed5c3e-00f0-11f1-92cc-42dde27851f2",14,["D",1770116922514],1,"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 try {\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 } catch {\n return null;\n }\n}\n\nexport async function saveSnapshot() {\n if (!db) return;\n try {\n const backup = await db.dumpDataDir(\"gzip\");\n await blob.set(BLOB_KEY, backup);\n } catch (e) {\n console.error(\"Failed to save snapshot:\", e);\n }\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",[152],"a7ae6232-00fe-11f1-b8a6-42dde27851f2",["D",1770122916004],[27],"898506d6-00fd-11f1-b9d6-42dde27851f2","index.ts",15,["D",1770122435900],6,"http","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 { 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\n if (error) return json({ error: error.message }, 400);\n await saveSnapshot();\n\n const created = await getFlag(supabase, body.name);\n return json({ data: created }, 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 { error } = await supabase\n .from(\"feature_flags\")\n .update(updates)\n .eq(\"name\", name);\n\n if (error) return json({ error: error.message }, 400);\n await saveSnapshot();\n\n const updated = await getFlag(supabase, name);\n return json({ data: updated });\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 { error } = await supabase\n .from(\"feature_flags\")\n .update({ enabled: !flag.enabled, updated_at: new Date().toISOString() })\n .eq(\"name\", name);\n\n if (error) return json({ error: error.message }, 400);\n await saveSnapshot();\n\n const toggled = await getFlag(supabase, name);\n return json({ data: toggled });\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 { error } = await supabase\n .from(\"flag_environments\")\n .insert({ flag_id: flag.id, environment: body.environment, enabled: body.enabled ?? false });\n\n if (error) return json({ error: error.message }, 400);\n await saveSnapshot();\n\n const { data: created } = await supabase\n .from(\"flag_environments\")\n .select(\"*\")\n .eq(\"flag_id\", flag.id)\n .eq(\"environment\", body.environment)\n .single();\n\n return json({ data: created }, 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 { error } = await supabase\n .from(\"flag_apps\")\n .insert({ flag_id: flag.id, app_name: body.app_name });\n\n if (error) return json({ error: error.message }, 400);\n await saveSnapshot();\n\n const { data: created } = await supabase\n .from(\"flag_apps\")\n .select(\"*\")\n .eq(\"flag_id\", flag.id)\n .eq(\"app_name\", body.app_name)\n .single();\n\n return json({ data: created }, 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 const msg = error instanceof Error ? error.message : String(error);\n return json({ error: msg || \"Unknown error\", stack: error instanceof Error ? error.stack : undefined }, 500);\n }\n}\n",[163],"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",[171],"pulls","branches","forks","envVars",{"_185":61,"_187":61},"connections",{"_185":61,"_186":61},"count","unfilledCount","emptyCount",{"_41":170,"_31":171,"_29":172,"_137":-5,"_39":40,"_38":173,"_139":57,"_36":210,"_13":175,"_32":20,"_34":176,"_23":24,"_142":-5,"_195":211,"_26":212},{"_41":162,"_31":163,"_29":55,"_137":-5,"_39":40,"_38":164,"_139":24,"_36":207,"_13":166,"_32":167,"_34":168,"_23":24,"_142":-5,"_195":208,"_26":209},{"_41":159,"_31":27,"_29":30,"_137":-5,"_39":40,"_38":14,"_139":57,"_36":204,"_13":61,"_32":33,"_34":35,"_23":24,"_142":-5,"_195":205,"_26":206},{"_41":151,"_31":152,"_29":153,"_137":-5,"_39":40,"_38":154,"_139":57,"_36":201,"_13":156,"_32":33,"_34":157,"_23":24,"_142":-5,"_195":202,"_26":203},{"_41":144,"_31":145,"_29":146,"_137":-5,"_39":40,"_38":147,"_139":57,"_36":198,"_13":61,"_32":33,"_34":149,"_23":24,"_142":-5,"_195":199,"_26":200},{"_41":134,"_31":135,"_29":136,"_137":-5,"_39":40,"_38":138,"_139":57,"_36":194,"_13":61,"_32":20,"_34":141,"_23":24,"_142":-5,"_195":196,"_26":197},["D",1770116660133],"children",[],[135],["D",1770116660129],[],[145],["D",1770116922514],[],[152],["D",1770122916004],[],[27],["D",1770122435900],[],[163],["D",1770116660104],[],[171],["D",1770075023956],["D",1789470042795],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":53,"_102":103,"_104":24},{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"ctx",{"_80":-5,"_125":251,"_252":253,"_254":255,"_256":24,"_257":24,"_258":24,"_259":57,"_260":-5,"_261":-7,"_262":-7,"_263":61,"_264":24,"_265":24,"_266":-5,"_267":24,"_268":24,"_269":24,"_270":-5},"ENV",{"_222":223,"_224":225,"_226":88,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250},"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 · v16