[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_351":352,"_353":354},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_255":256,"_49":-7,"_257":-5,"_17":258,"_259":260,"_261":262,"_263":264,"_265":266,"_63":-5,"_267":-5,"_268":-5,"_269":24,"_270":271,"_272":216,"_273":-5,"_274":-5,"_275":276},"routes/_app.x.$handle.$name.branch.$branch.history",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-5},"handle","filipecabaco","name","nanosupabase-demo","branchName","main","project",{"_43":204,"_13":14,"_47":205,"_206":-5,"_207":24,"_208":209,"_210":209,"_211":212,"_213":-5,"_25":77,"_214":87,"_215":216,"_217":-5,"_218":-5,"_219":20,"_51":52,"_220":221,"_222":223,"_224":225,"_226":-5,"_227":228,"_229":228,"_230":231,"_232":231,"_233":231,"_234":228,"_235":228,"_61":236,"_237":238,"_239":240,"_241":24},"page",0,"history",[26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42],"hasNext",false,"userId",{"_43":197,"_45":46,"_47":198,"_49":199,"_51":52,"_53":188,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":200,"_63":201,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":202},{"_43":188,"_45":46,"_47":189,"_49":190,"_51":52,"_53":181,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":191,"_63":192,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":193},{"_43":181,"_45":46,"_47":182,"_49":183,"_51":52,"_53":174,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":184,"_63":185,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":186},{"_43":174,"_45":46,"_47":175,"_49":176,"_51":52,"_53":167,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":177,"_63":178,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":179},{"_43":167,"_45":46,"_47":168,"_49":169,"_51":52,"_53":160,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":170,"_63":171,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":172},{"_43":160,"_45":46,"_47":161,"_49":162,"_51":52,"_53":151,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":163,"_63":164,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":165},{"_43":151,"_45":46,"_47":152,"_49":153,"_51":52,"_53":142,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":154,"_63":155,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":156},{"_43":142,"_45":46,"_47":143,"_49":144,"_51":52,"_53":133,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":145,"_63":146,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":147},{"_43":133,"_45":46,"_47":134,"_49":135,"_51":52,"_53":126,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":136,"_63":137,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":138},{"_43":126,"_45":46,"_47":127,"_49":128,"_51":52,"_53":119,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":129,"_63":130,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":131},{"_43":119,"_45":46,"_47":120,"_49":121,"_51":52,"_53":112,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":122,"_63":123,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":124},{"_43":112,"_45":46,"_47":113,"_49":114,"_51":52,"_53":105,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":115,"_63":116,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":117},{"_43":105,"_45":46,"_47":106,"_49":107,"_51":52,"_53":98,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":108,"_63":109,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":110},{"_43":98,"_45":46,"_47":99,"_49":100,"_51":52,"_53":90,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":101,"_63":102,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":103},{"_43":90,"_45":46,"_47":91,"_49":92,"_51":52,"_53":80,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":93,"_63":94,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":95},{"_43":80,"_45":46,"_47":81,"_49":82,"_51":52,"_53":44,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":83,"_63":84,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":85},{"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70},"id","2630b580-008f-11f1-8893-42dde27851f2","branchId","25cbd9c6-008f-11f1-9237-42dde27851f2","createdAt",["D",1770075024594],"version",1,"orgId","019c2095-952a-746b-bfc7-5bc887fa704c","parentId","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_43":77,"_51":52,"_11":12,"_78":79},"file",{"_72":73,"_13":74,"_75":63,"_76":24},"pull","merge","revert","multiple","commits",[71],{"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5},"fileId","262d019c-008f-11f1-8893-42dde27851f2","README.md","fileType","deleted","019c2095-952a-746b-bfc7-55e9a9eb0683","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOThNTVBUczFxSlc1VnlFM3JMc3h6TEVteUMifQ","264b8d1a-008f-11f1-b6b7-42dde27851f2",["D",1770075024785],2,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":87,"_13":88,"_75":89,"_76":24},[86],{"_43":80,"_45":46,"_47":81,"_49":82,"_51":52,"_53":44,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":83,"_63":84,"_65":-5,"_66":-5,"_67":-5},"264a239e-008f-11f1-b6b7-42dde27851f2","index.ts","script","b68fdeca-0090-11f1-a5f9-42dde27851f2",["D",1770075696303],3,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":87,"_13":88,"_75":97,"_76":24},[96],{"_43":90,"_45":46,"_47":91,"_49":92,"_51":52,"_53":80,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":93,"_63":94,"_65":-5,"_66":-5,"_67":-5},"http","ed0e5e18-0090-11f1-9407-42dde27851f2",["D",1770075787739],4,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":87,"_13":88,"_75":97,"_76":24},[104],{"_43":98,"_45":46,"_47":99,"_49":100,"_51":52,"_53":90,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":101,"_63":102,"_65":-5,"_66":-5,"_67":-5},"ed169cc2-0090-11f1-ac38-42dde27851f2",["D",1770075787747],5,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":73,"_13":74,"_75":63,"_76":24},[111],{"_43":105,"_45":46,"_47":106,"_49":107,"_51":52,"_53":98,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":108,"_63":109,"_65":-5,"_66":-5,"_67":-5},"3c08dbba-0091-11f1-bbae-42dde27851f2",["D",1770075920232],6,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":87,"_13":88,"_75":97,"_76":24},[118],{"_43":112,"_45":46,"_47":113,"_49":114,"_51":52,"_53":105,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":115,"_63":116,"_65":-5,"_66":-5,"_67":-5},"65159da4-0091-11f1-a75c-42dde27851f2",["D",1770075989105],7,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":73,"_13":74,"_75":63,"_76":24},[125],{"_43":119,"_45":46,"_47":120,"_49":121,"_51":52,"_53":112,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":122,"_63":123,"_65":-5,"_66":-5,"_67":-5},"16e1903e-00f0-11f1-928a-42dde27851f2",["D",1770116660104],8,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":73,"_13":74,"_75":63,"_76":24},[132],{"_43":126,"_45":46,"_47":127,"_49":128,"_51":52,"_53":119,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":129,"_63":130,"_65":-5,"_66":-5,"_67":-5},"16e48cb2-00f0-11f1-baff-42dde27851f2",["D",1770116660129],9,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":140,"_13":141,"_75":89,"_76":24},[139],{"_43":133,"_45":46,"_47":134,"_49":135,"_51":52,"_53":126,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":136,"_63":137,"_65":-5,"_66":-5,"_67":-5},"16e3838a-00f0-11f1-baff-42dde27851f2","schema.ts","16e9086e-00f0-11f1-b206-42dde27851f2",["D",1770116660133],10,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":149,"_13":150,"_75":63,"_76":24},[148],{"_43":142,"_45":46,"_47":143,"_49":144,"_51":52,"_53":133,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":145,"_63":146,"_65":-5,"_66":-5,"_67":-5},"16e6836e-00f0-11f1-b206-42dde27851f2","test.sh","16ee9234-00f0-11f1-92cc-42dde27851f2",["D",1770116660108],11,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":158,"_13":159,"_75":89,"_76":24},[157],{"_43":151,"_45":46,"_47":152,"_49":153,"_51":52,"_53":142,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":154,"_63":155,"_65":-5,"_66":-5,"_67":-5},"16ed5c3e-00f0-11f1-92cc-42dde27851f2","persistence.ts","16ff8be8-00f0-11f1-b743-42dde27851f2",["D",1770116660135],12,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":87,"_13":88,"_75":97,"_76":24},[166],{"_43":160,"_45":46,"_47":161,"_49":162,"_51":52,"_53":151,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":163,"_63":164,"_65":-5,"_66":-5,"_67":-5},"b347c0ba-00f0-11f1-a858-42dde27851f2",["D",1770116922480],13,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":87,"_13":88,"_75":97,"_76":24},[173],{"_43":167,"_45":46,"_47":168,"_49":169,"_51":52,"_53":160,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":170,"_63":171,"_65":-5,"_66":-5,"_67":-5},"b34be7f8-00f0-11f1-89a8-42dde27851f2",["D",1770116922514],14,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":158,"_13":159,"_75":89,"_76":24},[180],{"_43":174,"_45":46,"_47":175,"_49":176,"_51":52,"_53":167,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":177,"_63":178,"_65":-5,"_66":-5,"_67":-5},"89869118-00fd-11f1-b9d6-42dde27851f2",["D",1770122435900],15,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":87,"_13":88,"_75":97,"_76":24},[187],{"_43":181,"_45":46,"_47":182,"_49":183,"_51":52,"_53":174,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":184,"_63":185,"_65":-5,"_66":-5,"_67":-5},"a7b0057e-00fe-11f1-b8a6-42dde27851f2",["D",1770122916004],16,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":195,"_13":196,"_75":89,"_76":24},[194],{"_43":188,"_45":46,"_47":189,"_49":190,"_51":52,"_53":181,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":191,"_63":192,"_65":-5,"_66":-5,"_67":-5},"a7ae62f0-00fe-11f1-b8a6-42dde27851f2","local-server.ts","a7f948d8-00fe-11f1-922e-42dde27851f2",["D",1770122916351],17,{"_43":77,"_51":52,"_11":12,"_78":79},{"_72":87,"_13":88,"_75":97,"_76":24},[203],{"_43":197,"_45":46,"_47":198,"_49":199,"_51":52,"_53":188,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":200,"_63":201,"_65":-5,"_66":-5,"_67":-5},"25cb6d6a-008f-11f1-9237-42dde27851f2",["D",1770075023956],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Chat API with nano-supabase","imageUrl","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","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",{"_11":12,"_254":79},"org",{"_11":12,"_250":-5,"_78":79,"_25":77,"_251":252,"_253":24},"branch",{"_49":199,"_13":16,"_43":46,"_242":204,"_243":-5,"_244":-5,"_245":-5,"_246":-5,"_247":-5,"_248":14,"_249":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","tier","free","canRestrictVals","profileImageUrl","path","","adoptOrgId",{"_43":204,"_13":14,"_47":346,"_206":-5,"_207":24,"_208":209,"_210":209,"_211":212,"_213":-5,"_25":77,"_214":87,"_215":216,"_217":-5,"_218":-5,"_219":20,"_51":52,"_220":221,"_222":223,"_224":347,"_226":-5,"_227":228,"_229":228,"_230":231,"_232":231,"_233":231,"_234":228,"_235":228,"_61":348,"_237":349,"_239":350,"_241":24},"tree",[321,322,323,324,325,326],"files",[321,322,323,324,325,326],"counts",{"_311":20,"_312":50,"_313":20,"_314":315,"_316":317},"contents",[277,278,279,280,281,282],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":307,"_13":74,"_72":73,"_53":-5,"_45":46,"_284":128,"_285":216,"_47":308,"_49":92,"_75":63,"_287":309,"_76":24,"_289":-5,"_255":310},{"_43":303,"_13":88,"_72":87,"_53":-5,"_45":46,"_284":199,"_285":216,"_47":304,"_49":121,"_75":97,"_287":305,"_76":24,"_289":-5,"_255":306},{"_43":299,"_13":196,"_72":195,"_53":-5,"_45":46,"_284":190,"_285":216,"_47":300,"_49":20,"_75":89,"_287":301,"_76":24,"_289":-5,"_255":302},{"_43":295,"_13":159,"_72":158,"_53":-5,"_45":46,"_284":176,"_285":216,"_47":296,"_49":50,"_75":89,"_287":297,"_76":24,"_289":-5,"_255":298},{"_43":291,"_13":141,"_72":140,"_53":-5,"_45":46,"_284":135,"_285":216,"_47":292,"_49":20,"_75":89,"_287":293,"_76":24,"_289":-5,"_255":294},{"_43":283,"_13":150,"_72":149,"_53":-5,"_45":46,"_284":144,"_285":216,"_47":286,"_49":20,"_75":63,"_287":288,"_76":24,"_289":-5,"_255":290},"16e6826a-00f0-11f1-b206-42dde27851f2","branchVersion","latest",["D",1770116660133],"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","label",[150],"16e382ea-00f0-11f1-baff-42dde27851f2",["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",[141],"b34a9f24-00f0-11f1-89a8-42dde27851f2",["D",1770116922514],"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",[159],"a7ae6232-00fe-11f1-b8a6-42dde27851f2",["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",[196],"a7f660fa-00fe-11f1-922e-42dde27851f2",["D",1770122916351],"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",[88],"16e01c2c-00f0-11f1-928a-42dde27851f2",["D",1770116660104],"# 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",[74],"pulls","branches","forks","envVars",{"_318":20,"_320":20},"connections",{"_318":20,"_319":20},"count","unfilledCount","emptyCount",{"_43":307,"_13":74,"_72":73,"_53":-5,"_45":46,"_284":128,"_285":216,"_47":343,"_49":92,"_75":63,"_287":309,"_76":24,"_289":-5,"_328":344,"_255":345},{"_43":303,"_13":88,"_72":87,"_53":-5,"_45":46,"_284":199,"_285":216,"_47":340,"_49":121,"_75":97,"_287":305,"_76":24,"_289":-5,"_328":341,"_255":342},{"_43":299,"_13":196,"_72":195,"_53":-5,"_45":46,"_284":190,"_285":216,"_47":337,"_49":20,"_75":89,"_287":301,"_76":24,"_289":-5,"_328":338,"_255":339},{"_43":295,"_13":159,"_72":158,"_53":-5,"_45":46,"_284":176,"_285":216,"_47":334,"_49":50,"_75":89,"_287":297,"_76":24,"_289":-5,"_328":335,"_255":336},{"_43":291,"_13":141,"_72":140,"_53":-5,"_45":46,"_284":135,"_285":216,"_47":331,"_49":20,"_75":89,"_287":293,"_76":24,"_289":-5,"_328":332,"_255":333},{"_43":283,"_13":150,"_72":149,"_53":-5,"_45":46,"_284":144,"_285":216,"_47":327,"_49":20,"_75":63,"_287":288,"_76":24,"_289":-5,"_328":329,"_255":330},["D",1770116660133],"children",[],[150],["D",1770116660129],[],[141],["D",1770116922514],[],[159],["D",1770122916004],[],[196],["D",1770122916351],[],[88],["D",1770116660104],[],[74],["D",1770075023956],["D",1789470042795],{"_11":12,"_254":79},{"_11":12,"_250":-5,"_78":79,"_25":77,"_251":252,"_253":24},{"_49":199,"_13":16,"_43":46,"_242":204,"_243":-5,"_244":-5,"_245":-5,"_246":-5,"_247":-5,"_248":14,"_249":12},"ctx",{"_61":-5,"_274":384,"_385":386,"_387":388,"_389":24,"_390":24,"_391":24,"_392":216,"_393":-5,"_394":-7,"_395":-7,"_396":20,"_397":24,"_398":24,"_399":-5,"_400":24,"_401":24,"_402":24,"_403":-5},"ENV",{"_355":356,"_357":358,"_359":16,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377,"_378":379,"_380":381,"_382":383},"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"]

History