[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_210":211,"_212":213},"routes/_app.x.$handle.$name",{"_16":17,"_20":21,"_87":70,"_88":89,"_68":-7,"_90":-5,"_13":91,"_92":93,"_11":94,"_95":96,"_97":98,"_99":-5,"_100":-5,"_101":-5,"_102":26,"_103":104,"_105":38,"_106":-5,"_107":-5,"_108":109},"routes/_app.x.$handle.$name.search.$(branch)",{"_11":12,"_13":14,"_15":-5,"_16":17},"files",[],"project",{"_18":19,"_20":21,"_22":23,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":36,"_37":38,"_39":-5,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":-5,"_52":53,"_54":53,"_55":56,"_57":56,"_58":56,"_59":53,"_60":53,"_61":62,"_63":64,"_65":66,"_67":26},"query","handle","filipecabaco","id","25cb6d6a-008f-11f1-9237-42dde27851f2","name","nanosupabase-demo","createdAt",["D",1770075023956],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","Chat API with nano-supabase","imageUrl","userId","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",{"_16":17,"_86":82},"org",{"_16":17,"_80":-5,"_81":82,"_33":34,"_83":84,"_85":26},"branch",{"_68":69,"_20":70,"_18":71,"_72":19,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":-5,"_78":21,"_79":17},"isOwned","version",17,"main","25cbd9c6-008f-11f1-9237-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOThNTVBUczFxSlc1VnlFM3JMc3h6TEVteUMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_18":19,"_20":21,"_22":205,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":36,"_37":38,"_39":-5,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_49":206,"_51":-5,"_52":53,"_54":53,"_55":56,"_57":56,"_58":56,"_59":53,"_60":53,"_61":207,"_63":208,"_65":209,"_67":26},"tree",[180,181,182,183,184,185],[180,181,182,183,184,185],"counts",{"_170":42,"_171":145,"_172":42,"_173":174,"_175":176},"contents",[110,111,112,113,114,115],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_18":162,"_20":163,"_118":164,"_120":-5,"_121":71,"_122":165,"_124":38,"_22":166,"_68":167,"_126":99,"_127":168,"_129":26,"_130":-5,"_88":169},{"_18":155,"_20":156,"_118":36,"_120":-5,"_121":71,"_122":69,"_124":38,"_22":157,"_68":158,"_126":159,"_127":160,"_129":26,"_130":-5,"_88":161},{"_18":148,"_20":149,"_118":150,"_120":-5,"_121":71,"_122":151,"_124":38,"_22":152,"_68":42,"_126":137,"_127":153,"_129":26,"_130":-5,"_88":154},{"_18":140,"_20":141,"_118":142,"_120":-5,"_121":71,"_122":143,"_124":38,"_22":144,"_68":145,"_126":137,"_127":146,"_129":26,"_130":-5,"_88":147},{"_18":132,"_20":133,"_118":134,"_120":-5,"_121":71,"_122":135,"_124":38,"_22":136,"_68":42,"_126":137,"_127":138,"_129":26,"_130":-5,"_88":139},{"_18":116,"_20":117,"_118":119,"_120":-5,"_121":71,"_122":123,"_124":38,"_22":125,"_68":42,"_126":99,"_127":128,"_129":26,"_130":-5,"_88":131},"16e6826a-00f0-11f1-b206-42dde27851f2","test.sh","fileId","16e6836e-00f0-11f1-b206-42dde27851f2","parentId","branchId","branchVersion",10,"latest",["D",1770116660133],"fileType","content","#!/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","deleted","label",[117],"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",[133],"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",[141],"a7ae6232-00fe-11f1-b8a6-42dde27851f2","local-server.ts","a7ae62f0-00fe-11f1-b8a6-42dde27851f2",16,["D",1770122916004],"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",[149],"a7f660fa-00fe-11f1-922e-42dde27851f2","index.ts",["D",1770122916351],7,"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 return json({ error: error instanceof Error ? error.message : \"Unknown error\" }, 500);\n }\n}\n",[156],"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",[163],"pulls","branches","forks","envVars",{"_177":42,"_179":42},"connections",{"_177":42,"_178":42},"count","unfilledCount","emptyCount",{"_18":162,"_20":163,"_118":164,"_120":-5,"_121":71,"_122":165,"_124":38,"_22":202,"_68":167,"_126":99,"_127":168,"_129":26,"_130":-5,"_187":203,"_88":204},{"_18":155,"_20":156,"_118":36,"_120":-5,"_121":71,"_122":69,"_124":38,"_22":199,"_68":158,"_126":159,"_127":160,"_129":26,"_130":-5,"_187":200,"_88":201},{"_18":148,"_20":149,"_118":150,"_120":-5,"_121":71,"_122":151,"_124":38,"_22":196,"_68":42,"_126":137,"_127":153,"_129":26,"_130":-5,"_187":197,"_88":198},{"_18":140,"_20":141,"_118":142,"_120":-5,"_121":71,"_122":143,"_124":38,"_22":193,"_68":145,"_126":137,"_127":146,"_129":26,"_130":-5,"_187":194,"_88":195},{"_18":132,"_20":133,"_118":134,"_120":-5,"_121":71,"_122":135,"_124":38,"_22":190,"_68":42,"_126":137,"_127":138,"_129":26,"_130":-5,"_187":191,"_88":192},{"_18":116,"_20":117,"_118":119,"_120":-5,"_121":71,"_122":123,"_124":38,"_22":186,"_68":42,"_126":99,"_127":128,"_129":26,"_130":-5,"_187":188,"_88":189},["D",1770116660133],"children",[],[117],["D",1770116660129],[],[133],["D",1770116922514],[],[141],["D",1770122916004],[],[149],["D",1770122916351],[],[156],["D",1770116660104],[],[163],["D",1770075023956],["D",1789470042795],{"_16":17,"_86":82},{"_16":17,"_80":-5,"_81":82,"_33":34,"_83":84,"_85":26},{"_68":69,"_20":70,"_18":71,"_72":19,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":-5,"_78":21,"_79":17},"ctx",{"_61":-5,"_107":243,"_244":245,"_246":247,"_248":26,"_249":26,"_250":26,"_251":38,"_252":-5,"_253":-7,"_254":-7,"_255":42,"_256":26,"_257":26,"_258":-5,"_259":26,"_260":26,"_261":26,"_262":-5},"ENV",{"_214":215,"_216":217,"_218":70,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242},"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"]

Search