[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_215":216,"_217":218},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_92":-7,"_93":94,"_29":-7,"_95":-5,"_15":96,"_97":98,"_99":100,"_101":102,"_103":104,"_105":-5,"_106":-5,"_107":-5,"_108":38,"_109":110,"_111":50,"_112":-5,"_113":-5,"_114":115},"routes/_app.x.$handle.$name.branches",{"_11":12,"_13":14,"_15":16,"_17":18},"handle","filipecabaco","name","nanosupabase-demo","project",{"_20":28,"_13":14,"_22":36,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":50,"_51":-5,"_52":-5,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":65,"_66":65,"_67":68,"_69":68,"_70":68,"_71":65,"_72":65,"_73":74,"_75":76,"_77":78,"_79":38},"branches",[19],{"_20":21,"_22":23,"_24":25,"_13":26,"_27":28,"_29":30,"_31":-5,"_32":-5,"_33":34,"_35":-5},"id","25cbd9c6-008f-11f1-9237-42dde27851f2","createdAt",["D",1770075023956],"updatedAt",["D",1770122916351],"main","projectId","25cb6d6a-008f-11f1-9237-42dde27851f2","version",17,"forkedBranchId","forkedBranchVersion","lockfileKey","1780699679077-esm.town_v_filipecabaco_nanosupabase-demo@17-main","deletedAt",["D",1770075023956],"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",{"_11":12,"_91":87},"org",{"_11":12,"_85":-5,"_86":87,"_45":46,"_88":89,"_90":38},"branch",{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_80":-5,"_81":-5,"_82":-5,"_83":14,"_84":12},"isOwned","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOThNTVBUczFxSlc1VnlFM3JMc3h6TEVteUMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_20":28,"_13":14,"_22":210,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":50,"_51":-5,"_52":-5,"_53":54,"_55":56,"_57":58,"_59":60,"_61":211,"_63":-5,"_64":65,"_66":65,"_67":68,"_69":68,"_70":68,"_71":65,"_72":65,"_73":212,"_75":213,"_77":214,"_79":38},"tree",[185,186,187,188,189,190],"files",[185,186,187,188,189,190],"counts",{"_176":54,"_17":151,"_177":54,"_178":179,"_180":181},"contents",[116,117,118,119,120,121],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_20":168,"_13":169,"_124":170,"_126":-5,"_127":21,"_128":171,"_130":50,"_22":172,"_29":173,"_132":105,"_133":174,"_135":38,"_136":-5,"_93":175},{"_20":161,"_13":162,"_124":48,"_126":-5,"_127":21,"_128":30,"_130":50,"_22":163,"_29":164,"_132":165,"_133":166,"_135":38,"_136":-5,"_93":167},{"_20":154,"_13":155,"_124":156,"_126":-5,"_127":21,"_128":157,"_130":50,"_22":158,"_29":54,"_132":143,"_133":159,"_135":38,"_136":-5,"_93":160},{"_20":146,"_13":147,"_124":148,"_126":-5,"_127":21,"_128":149,"_130":50,"_22":150,"_29":151,"_132":143,"_133":152,"_135":38,"_136":-5,"_93":153},{"_20":138,"_13":139,"_124":140,"_126":-5,"_127":21,"_128":141,"_130":50,"_22":142,"_29":54,"_132":143,"_133":144,"_135":38,"_136":-5,"_93":145},{"_20":122,"_13":123,"_124":125,"_126":-5,"_127":21,"_128":129,"_130":50,"_22":131,"_29":54,"_132":105,"_133":134,"_135":38,"_136":-5,"_93":137},"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",[123],"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",[139],"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",[147],"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",[155],"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",[162],"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",[169],"pulls","forks","envVars",{"_182":54,"_184":54},"connections",{"_182":54,"_183":54},"count","unfilledCount","emptyCount",{"_20":168,"_13":169,"_124":170,"_126":-5,"_127":21,"_128":171,"_130":50,"_22":207,"_29":173,"_132":105,"_133":174,"_135":38,"_136":-5,"_192":208,"_93":209},{"_20":161,"_13":162,"_124":48,"_126":-5,"_127":21,"_128":30,"_130":50,"_22":204,"_29":164,"_132":165,"_133":166,"_135":38,"_136":-5,"_192":205,"_93":206},{"_20":154,"_13":155,"_124":156,"_126":-5,"_127":21,"_128":157,"_130":50,"_22":201,"_29":54,"_132":143,"_133":159,"_135":38,"_136":-5,"_192":202,"_93":203},{"_20":146,"_13":147,"_124":148,"_126":-5,"_127":21,"_128":149,"_130":50,"_22":198,"_29":151,"_132":143,"_133":152,"_135":38,"_136":-5,"_192":199,"_93":200},{"_20":138,"_13":139,"_124":140,"_126":-5,"_127":21,"_128":141,"_130":50,"_22":195,"_29":54,"_132":143,"_133":144,"_135":38,"_136":-5,"_192":196,"_93":197},{"_20":122,"_13":123,"_124":125,"_126":-5,"_127":21,"_128":129,"_130":50,"_22":191,"_29":54,"_132":105,"_133":134,"_135":38,"_136":-5,"_192":193,"_93":194},["D",1770116660133],"children",[],[123],["D",1770116660129],[],[139],["D",1770116922514],[],[147],["D",1770122916004],[],[155],["D",1770122916351],[],[162],["D",1770116660104],[],[169],["D",1770075023956],["D",1789470042795],{"_11":12,"_91":87},{"_11":12,"_85":-5,"_86":87,"_45":46,"_88":89,"_90":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_80":-5,"_81":-5,"_82":-5,"_83":14,"_84":12},"ctx",{"_73":-5,"_113":248,"_249":250,"_251":252,"_253":38,"_254":38,"_255":38,"_256":50,"_257":-5,"_258":-7,"_259":-7,"_260":54,"_261":38,"_262":38,"_263":-5,"_264":38,"_265":38,"_266":38,"_267":-5},"ENV",{"_219":220,"_221":222,"_223":26,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247},"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"]

Branches1

Branches
1