[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_212":213,"_214":215},"routes/_app.x.$handle.$name",{"_96":95,"_31":44,"_104":86,"_26":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":24,"_119":120,"_121":24,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",8,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","example/schema.ts","latestPath","fileId","cd7f92ca-c8ef-11f0-b29b-42dde27851f2","name","schema.ts","fileType","script","content","/**\n * Example Drizzle Schema\n *\n * Define your database tables here using Drizzle's sqliteTable\n */\nimport { integer, sqliteTable, text } from \"npm:drizzle-orm/sqlite-core\";\n\nexport const users = sqliteTable(\"users\", {\n\tid: integer(\"id\").primaryKey({ autoIncrement: true }),\n\tname: text(\"name\").notNull(),\n\temail: text(\"email\").notNull().unique(),\n\tcreatedAt: integer(\"created_at\", { mode: \"timestamp\" }).$defaultFn(\n\t\t() => new Date(),\n\t),\n});\n\nexport const posts = sqliteTable(\"posts\", {\n\tid: integer(\"id\").primaryKey({ autoIncrement: true }),\n\tuserId: integer(\"user_id\")\n\t\t.notNull()\n\t\t.references(() => users.id),\n\ttitle: text(\"title\").notNull(),\n\tcontent: text(\"content\"),\n\tpublished: integer(\"published\", { mode: \"boolean\" }).default(false),\n\tcreatedAt: integer(\"created_at\", { mode: \"timestamp\" }).$defaultFn(\n\t\t() => new Date(),\n\t),\n});\n","createdAt",["D",1763959271566],"branchVersion","branchId","e6f06124-c8ec-11f0-928c-42dde27851f2","id","e6efa630-c8ec-11f0-928c-42dde27851f2","drizzleMigrations",["D",1763958026076],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Type-safe Drizzle migrations for Val Town (no filesystem needed)","imageUrl","5d1042a9-7b0b-499d-8a72-3a8ac7a4e185","pinnedFileId","cd48db04-c8ef-11f0-8c99-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","5f80108f-7ca4-4327-b77b-089dbe4b5a82","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},"branch",{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"isOwned",31,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","nbbaier","handle","displayName","avatar","https://secure.gravatar.com/avatar/0129a541b7b3574e92c4afd06c5e32da&d=identicon","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":208,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":209,"_80":210,"_82":211,"_84":24},"tree",[164,169,170],"files",[164,165,166,167,168,169,170],"counts",{"_154":62,"_155":136,"_156":62,"_157":158,"_159":160},"contents",[126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":147,"_31":148,"_29":149,"_132":-5,"_40":41,"_39":150,"_134":58,"_37":151,"_13":62,"_33":152,"_35":-5,"_23":24,"_138":-5,"_26":153},{"_42":140,"_31":141,"_29":142,"_132":-5,"_40":41,"_39":143,"_134":58,"_37":144,"_13":62,"_33":20,"_35":145,"_23":24,"_138":-5,"_26":146},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":58,"_37":135,"_13":136,"_33":34,"_35":137,"_23":24,"_138":-5,"_26":139},"cd655428-c8ef-11f0-bd04-42dde27851f2","main.ts","e6f3abfe-c8ec-11f0-928c-42dde27851f2","parentId",7,"latest",["D",1763959271707],1,"/**\n * Lightweight Drizzle Schema to SQL Migration Generator\n * Built for Val Town (no filesystem, no drizzle-kit)\n *\n * Usage:\n * import { generateCreateTableSQL, migrate } from '@YOUR_USERNAME/drizzleMigrations';\n *\n * const sql = generateCreateTableSQL(myTable);\n * // or\n * await migrate(db, { users, posts, ... });\n */\n\n// Symbol keys that Drizzle uses\nconst DRIZZLE_SYMBOLS = {\n\tName: Symbol.for(\"drizzle:Name\"),\n\tColumns: Symbol.for(\"drizzle:Columns\"),\n\tSQLiteInlineForeignKeys: Symbol.for(\"drizzle:SQLiteInlineForeignKeys\"),\n\tExtraConfigBuilder: Symbol.for(\"drizzle:ExtraConfigBuilder\"),\n};\n\ninterface ColumnMetadata {\n\tname: string;\n\tcolumnType: string;\n\tdataType: string;\n\tnotNull: boolean;\n\tprimary: boolean;\n\tdefault?: any;\n\tisUnique: boolean;\n\tautoIncrement?: boolean;\n\tenumValues?: string[];\n\tconfig?: any;\n}\n\ninterface ForeignKeyMetadata {\n\treference: () => any;\n\tonUpdate?: string;\n\tonDelete?: string;\n}\n\n/**\n * Generate CREATE TABLE SQL for a Drizzle table\n */\nexport function generateCreateTableSQL(table: any): string {\n\tconst tableName = table[DRIZZLE_SYMBOLS.Name];\n\tconst columns = table[DRIZZLE_SYMBOLS.Columns];\n\n\tif (!tableName || !columns) {\n\t\tthrow new Error(\"Invalid Drizzle table object\");\n\t}\n\n\tconst columnDefs: string[] = [];\n\tconst constraints: string[] = [];\n\n\t// Process columns\n\tfor (const [_key, column] of Object.entries(columns)) {\n\t\tconst col = column as ColumnMetadata;\n\t\tcolumnDefs.push(generateColumnDef(col));\n\t}\n\n\t// Process foreign keys\n\tconst foreignKeys = table[DRIZZLE_SYMBOLS.SQLiteInlineForeignKeys] || [];\n\tfor (const fk of foreignKeys) {\n\t\tconst fkDef = generateForeignKeyDef(fk);\n\t\tif (fkDef) constraints.push(fkDef);\n\t}\n\n\tconst allDefs = [...columnDefs, ...constraints];\n\treturn `CREATE TABLE IF NOT EXISTS \"${tableName}\" (\\n ${allDefs.join(\",\\n \")}\\n);`;\n}\n\n/**\n * Generate column definition\n */\nfunction generateColumnDef(col: ColumnMetadata): string {\n\tlet def = `\"${col.name}\" `;\n\n\t// Map Drizzle types to SQLite types\n\tswitch (col.columnType) {\n\t\tcase \"SQLiteInteger\":\n\t\t\tdef += \"INTEGER\";\n\t\t\tbreak;\n\t\tcase \"SQLiteText\":\n\t\t\tdef += \"TEXT\";\n\t\t\tbreak;\n\t\tcase \"SQLiteReal\":\n\t\t\tdef += \"REAL\";\n\t\t\tbreak;\n\t\tcase \"SQLiteBlob\":\n\t\t\tdef += \"BLOB\";\n\t\t\tbreak;\n\t\tdefault:\n\t\t\tdef += \"TEXT\";\n\t}\n\n\t// PRIMARY KEY\n\tif (col.primary) {\n\t\tdef += \" PRIMARY KEY\";\n\t\tif (col.autoIncrement) {\n\t\t\tdef += \" AUTOINCREMENT\";\n\t\t}\n\t}\n\n\t// NOT NULL\n\tif (col.notNull && !col.primary) {\n\t\tdef += \" NOT NULL\";\n\t}\n\n\t// UNIQUE\n\tif (col.isUnique) {\n\t\tdef += \" UNIQUE\";\n\t}\n\n\t// DEFAULT\n\tif (col.default !== undefined) {\n\t\tif (typeof col.default === \"string\") {\n\t\t\tdef += ` DEFAULT '${col.default}'`;\n\t\t} else if (typeof col.default === \"number\") {\n\t\t\tdef += ` DEFAULT ${col.default}`;\n\t\t} else if (typeof col.default === \"boolean\") {\n\t\t\tdef += ` DEFAULT ${col.default ? 1 : 0}`;\n\t\t}\n\t}\n\n\treturn def;\n}\n\n/**\n * Generate foreign key constraint\n */\nfunction generateForeignKeyDef(fk: ForeignKeyMetadata): string | null {\n\ttry {\n\t\t// Call the reference function to get FK info\n\t\tconst ref = fk.reference();\n\n\t\t// ref has: columns (local), foreignTable, foreignColumns (referenced)\n\t\tif (!ref || !ref.foreignTable || !ref.columns || !ref.foreignColumns) {\n\t\t\treturn null;\n\t\t}\n\n\t\tconst foreignTableName = ref.foreignTable[DRIZZLE_SYMBOLS.Name];\n\t\tif (!foreignTableName) {\n\t\t\treturn null;\n\t\t}\n\n\t\t// Get column names\n\t\tconst localColumns = ref.columns\n\t\t\t.map((col: any) => `\"${col.name}\"`)\n\t\t\t.join(\", \");\n\t\tconst foreignColumns = ref.foreignColumns\n\t\t\t.map((col: any) => `\"${col.name}\"`)\n\t\t\t.join(\", \");\n\n\t\tlet def = `FOREIGN KEY (${localColumns}) REFERENCES \"${foreignTableName}\" (${foreignColumns})`;\n\n\t\tif (fk.onUpdate) {\n\t\t\tdef += ` ON UPDATE ${fk.onUpdate.toUpperCase()}`;\n\t\t}\n\n\t\tif (fk.onDelete) {\n\t\t\tdef += ` ON DELETE ${fk.onDelete.toUpperCase()}`;\n\t\t}\n\n\t\treturn def;\n\t} catch (_e) {\n\t\t// Silently skip FK generation if it fails - not critical\n\t\treturn null;\n\t}\n}\n\n/**\n * Generate CREATE INDEX SQL for a Drizzle index\n */\nexport function generateCreateIndexSQL(\n\ttableName: string,\n\tindexName: string,\n\tindex: any,\n): string {\n\tconst unique = index.config?.unique ? \"UNIQUE \" : \"\";\n\tconst columns = index.config?.columns || [];\n\n\tconst columnNames = columns.map((col: any) => `\"${col.name}\"`).join(\", \");\n\n\treturn `CREATE ${unique}INDEX IF NOT EXISTS \"${indexName}\" ON \"${tableName}\" (${columnNames});`;\n}\n\n/**\n * Extract all indexes from a table\n */\nexport function extractIndexes(\n\ttable: any,\n): Array<{ name: string; sql: string }> {\n\tconst tableName = table[DRIZZLE_SYMBOLS.Name];\n\tconst columns = table[DRIZZLE_SYMBOLS.Columns];\n\tconst extraConfigBuilder = table[DRIZZLE_SYMBOLS.ExtraConfigBuilder];\n\n\tconst indexes: Array<{ name: string; sql: string }> = [];\n\n\tif (extraConfigBuilder) {\n\t\tconst config = extraConfigBuilder(columns);\n\t\tfor (const [name, index] of Object.entries(config)) {\n\t\t\tconst sql = generateCreateIndexSQL(tableName, name, index);\n\t\t\tindexes.push({ name, sql });\n\t\t}\n\t}\n\n\treturn indexes;\n}\n\n/**\n * Migration system - stores state in SQLite\n */\ninterface MigrationState {\n\tversion: number;\n\ttables: Record; // table name -> SQL hash\n\tappliedAt: string;\n}\n\n/**\n * Initialize migrations table\n */\nasync function initMigrationsTable(db: any): Promise {\n\tawait db.execute(`\n CREATE TABLE IF NOT EXISTS __drizzle_migrations (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n version INTEGER NOT NULL UNIQUE,\n tables TEXT NOT NULL,\n applied_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n}\n\n/**\n * Get current migration state\n */\nasync function getCurrentState(db: any): Promise {\n\tconst result = await db.execute(`\n SELECT version, tables, applied_at\n FROM __drizzle_migrations\n ORDER BY version DESC\n LIMIT 1\n `);\n\n\tif (result.rows.length === 0) {\n\t\treturn null;\n\t}\n\n\tconst row = result.rows[0];\n\treturn {\n\t\tversion: row[0] as number,\n\t\ttables: JSON.parse(row[1] as string),\n\t\tappliedAt: row[2] as string,\n\t};\n}\n\n/**\n * Simple hash function for SQL strings\n */\nfunction hashSQL(sql: string): string {\n\tlet hash = 0;\n\tfor (let i = 0; i < sql.length; i++) {\n\t\tconst char = sql.charCodeAt(i);\n\t\thash = (hash << 5) - hash + char;\n\t\thash = hash & hash; // Convert to 32bit integer\n\t}\n\treturn hash.toString(36);\n}\n\n/**\n * Main migration function\n * Pass in your db instance and an object with all your tables\n */\nexport async function migrate(\n\tdb: any,\n\ttables: Record,\n\toptions: { dryRun?: boolean } = {},\n): Promise<{ applied: string[]; skipped: string[]; version?: number }> {\n\tawait initMigrationsTable(db);\n\n\tconst currentState = await getCurrentState(db);\n\tconst newVersion = (currentState?.version || 0) + 1;\n\n\tconst applied: string[] = [];\n\tconst skipped: string[] = [];\n\tconst newTableHashes: Record = {};\n\n\tconsole.log(`\\n=== Migration v${newVersion} ===`);\n\n\t// Generate SQL for all tables\n\tfor (const [tableName, table] of Object.entries(tables)) {\n\t\tconst sql = generateCreateTableSQL(table);\n\t\tconst hash = hashSQL(sql);\n\n\t\tnewTableHashes[tableName] = hash;\n\n\t\t// Check if this table needs to be created/updated\n\t\tconst previousHash = currentState?.tables[tableName];\n\n\t\tif (!previousHash) {\n\t\t\tconsole.log(`[NEW] Creating table: ${tableName}`);\n\t\t\tconsole.log(sql);\n\n\t\t\tif (!options.dryRun) {\n\t\t\t\tawait db.execute(sql);\n\n\t\t\t\t// Create indexes\n\t\t\t\tconst indexes = extractIndexes(table);\n\t\t\t\tfor (const idx of indexes) {\n\t\t\t\t\tconsole.log(`[INDEX] ${idx.name}`);\n\t\t\t\t\tconsole.log(idx.sql);\n\t\t\t\t\tawait db.execute(idx.sql);\n\t\t\t\t}\n\t\t\t}\n\n\t\t\tapplied.push(tableName);\n\t\t} else if (previousHash !== hash) {\n\t\t\tconsole.log(`[CHANGED] Table schema changed: ${tableName}`);\n\t\t\tconsole.log(\"⚠️ Manual migration required for schema changes\");\n\t\t\tconsole.log(\"New SQL:\", sql);\n\t\t\tskipped.push(tableName);\n\t\t} else {\n\t\t\tconsole.log(`[SKIP] No changes: ${tableName}`);\n\t\t\tskipped.push(tableName);\n\t\t}\n\t}\n\n\t// Save new state\n\tif (!options.dryRun && applied.length > 0) {\n\t\tawait db.execute(\n\t\t\t`\n INSERT INTO __drizzle_migrations (version, tables)\n VALUES (?, ?)\n `,\n\t\t\t[newVersion, JSON.stringify(newTableHashes)],\n\t\t);\n\n\t\tconsole.log(`\\n✅ Migration v${newVersion} applied`);\n\t}\n\n\treturn { applied, skipped, version: newVersion };\n}\n\n/**\n * Generate SQL for an entire schema (useful for inspection)\n */\nexport function generateSchemaSQL(tables: Record): string {\n\tconst statements: string[] = [];\n\n\tfor (const [_tableName, table] of Object.entries(tables)) {\n\t\tstatements.push(generateCreateTableSQL(table));\n\n\t\tconst indexes = extractIndexes(table);\n\t\tfor (const idx of indexes) {\n\t\t\tstatements.push(idx.sql);\n\t\t}\n\n\t\tstatements.push(\"\"); // blank line between tables\n\t}\n\n\treturn statements.join(\"\\n\");\n}\n","label",[130],"cd59b6e0-c8ef-11f0-bdd0-42dde27851f2","README.md","cd59b7bc-c8ef-11f0-bdd0-42dde27851f2",6,["D",1763959271562],"# Type-Safe Drizzle Migrations for Val Town\n\nA complete working example of filesystem-free migrations for Drizzle ORM.\n\n## What's Included\n\nFive vals that work together:\n\n1. **@nbbaier/drizzleMigrations** - Core migration library\n2. **@nbbaier/drizzleSchema** - Example schema definitions\n3. **@nbbaier/runDrizzleMigrations** - HTTP endpoint to run migrations\n4. **@nbbaier/inspectDrizzleSchema** - View generated SQL\n5. **@nbbaier/drizzleExampleApp** - Working API example\n\n## Quick Start (5 minutes)\n\n### 1. Run Migrations\n\nVisit: https://nbbaier-runDrizzleMigrations.web.val.run\n\nYou'll see:\n\n```json\n{\n \"success\": true,\n \"version\": 1,\n \"applied\": [\"users\", \"posts\"],\n \"skipped\": []\n}\n```\n\nThis created the `users` and `posts` tables in your SQLite database.\n\n### 2. Try the API\n\nVisit: https://nbbaier-drizzleExampleApp.web.val.run/users\n\nCreate a user:\n\n```bash\ncurl -X POST https://nbbaier-drizzleExampleApp.web.val.run/users \\\n -H \"Content-Type: application/json\" \\\n -d '{\"name\": \"Alice\", \"email\": \"alice@example.com\"}'\n```\n\n### 3. Inspect Generated SQL (Optional)\n\nVisit: https://nbbaier-inspectDrizzleSchema.web.val.run\n\nYou'll see the actual CREATE TABLE statements that were generated.\n\n## How to Use in Your Project\n\n### Step 1: Fork or Reference the Migration Library\n\n```typescript\nimport {\n migrate,\n generateCreateTableSQL,\n} from \"https://esm.town/v/nbbaier/drizzleMigrations\";\n```\n\nOr fork @nbbaier/drizzleMigrations to your own account.\n\n### Step 2: Define Your Schema\n\nCreate a val with your tables:\n\n```typescript\nimport { sqliteTable, text, integer } from \"npm:drizzle-orm/sqlite-core\";\n\nexport const myTable = sqliteTable(\"my_table\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n name: text(\"name\").notNull(),\n});\n```\n\n### Step 3: Create a Migration Runner\n\n```typescript\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { migrate } from \"https://esm.town/v/nbbaier/drizzleMigrations\";\nimport * as schema from \"https://esm.town/v/YOUR_USERNAME/yourSchema\";\n\nexport default async function (req: Request) {\n const result = await migrate(sqlite, schema);\n return Response.json(result);\n}\n```\n\n### Step 4: Use Your Schema\n\n```typescript\nimport { drizzle } from \"npm:drizzle-orm/better-sqlite3\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport * as schema from \"https://esm.town/v/YOUR_USERNAME/yourSchema\";\n\nconst db = drizzle(sqlite, { schema });\n\n// Now you have full type safety!\nconst results = await db.select().from(schema.myTable);\n```\n\n## Features\n\n- ✅ **Type-safe** - Full TypeScript inference from your schema\n- ✅ **No filesystem** - Works in Val Town's sandboxed environment\n- ✅ **Auto migrations** - Creates new tables automatically\n- ✅ **Change detection** - Warns when schemas change\n- ✅ **Foreign keys** - Handles relationships correctly\n- ✅ **Lightweight** - ~300 lines, zero dependencies beyond drizzle-orm\n\n## API Reference\n\n### `migrate(db, tables, options?)`\n\nRun migrations against your database.\n\n**Parameters:**\n\n- `db` - Val Town SQLite instance\n- `tables` - Object with table definitions\n- `options.dryRun` - (optional) Preview without executing\n\n**Returns:**\n\n```typescript\n{\n applied: string[], // New tables created\n skipped: string[], // Unchanged tables\n version: number // Migration version\n}\n```\n\n### `generateCreateTableSQL(table)`\n\nGenerate CREATE TABLE SQL for a single table.\n\n```typescript\nconst sql = generateCreateTableSQL(myTable);\nconsole.log(sql);\n// CREATE TABLE IF NOT EXISTS \"my_table\" (\n// \"id\" INTEGER PRIMARY KEY AUTOINCREMENT,\n// ...\n// );\n```\n\n### `generateSchemaSQL(tables)`\n\nGenerate SQL for all tables and indexes.\n\n```typescript\nconst sql = generateSchemaSQL({ users, posts });\n```\n\n## How It Works\n\n1. **Reads Drizzle metadata** - Uses Symbol keys to introspect schema\n2. **Generates SQL** - Walks column definitions to build CREATE TABLE\n3. **Tracks state in SQLite** - Stores migration versions in `__drizzle_migrations` table\n4. **Detects changes** - Compares SQL hashes to previous version\n5. **Safe updates** - Only creates new tables, warns about changes\n\n## Schema Changes\n\nWhen you modify an existing table:\n\n1. Update your schema val\n2. Run migrations again\n3. You'll see: `[CHANGED] Table schema changed: users`\n4. Write manual ALTER TABLE or recreate the table\n\nExample manual migration:\n\n```typescript\nawait sqlite.execute(`\n ALTER TABLE users ADD COLUMN bio TEXT;\n`);\n```\n\n## Comparison to Drizzle Kit\n\n| Feature | Drizzle Kit | This Solution |\n| --------------- | ----------- | --------------- |\n| Filesystem | Required | None |\n| Val Town | No | Yes |\n| Size | ~5MB | ~10KB |\n| Auto migrations | Yes | New tables only |\n| Type safety | Yes | Yes |\n\n## Tips\n\n### Add Authentication\n\n```typescript\nexport default async function (req: Request) {\n const auth = req.headers.get(\"authorization\");\n if (auth !== `Bearer ${Deno.env.get(\"MIGRATION_TOKEN\")}`) {\n return Response.json({ error: \"Unauthorized\" }, { status: 401 });\n }\n\n const result = await migrate(sqlite, schema);\n return Response.json(result);\n}\n```\n\nSet `MIGRATION_TOKEN` in Val Town secrets.\n\n### Dry Run\n\nSee what would happen without executing:\n\n```typescript\nconst result = await migrate(sqlite, schema, { dryRun: true });\n```\n\n### Multiple Environments\n\nEach Val Town user has their own SQLite database, so you can test changes before deploying.\n\n## Examples\n\nCheck out:\n\n- @nbbaier/drizzleSchema - Schema definitions\n- @nbbaier/runDrizzleMigrations - Migration runner\n- @nbbaier/drizzleExampleApp - Working API\n\n## License\n\nMIT - Use freely!\n\n## Questions?\n\nOpen an issue or ask in Val Town Discord.\n",[141],"cd3a7c3a-c8ef-11f0-8c99-42dde27851f2","example","cd3a7d20-c8ef-11f0-8c99-42dde27851f2",2,["D",1763959271434],"directory",[148],"pulls","branches","forks","envVars",{"_161":62,"_163":62},"connections",{"_161":62,"_162":62},"count","unfilledCount","emptyCount",{"_42":147,"_31":148,"_29":149,"_132":-5,"_40":41,"_39":150,"_134":58,"_37":205,"_13":62,"_33":152,"_35":-5,"_23":24,"_138":-5,"_172":206,"_26":207},{"_42":198,"_31":199,"_29":56,"_132":149,"_40":41,"_39":200,"_134":24,"_37":201,"_13":62,"_33":34,"_35":202,"_23":24,"_138":-5,"_172":203,"_26":204},{"_42":190,"_31":191,"_29":192,"_132":149,"_40":41,"_39":193,"_134":24,"_37":194,"_13":62,"_33":34,"_35":195,"_23":24,"_138":-5,"_172":196,"_26":197},{"_42":182,"_31":183,"_29":184,"_132":149,"_40":41,"_39":185,"_134":24,"_37":186,"_13":62,"_33":34,"_35":187,"_23":24,"_138":-5,"_172":188,"_26":189},{"_42":178,"_31":32,"_29":30,"_132":149,"_40":41,"_39":14,"_134":58,"_37":179,"_13":62,"_33":34,"_35":36,"_23":24,"_138":-5,"_172":180,"_26":181},{"_42":140,"_31":141,"_29":142,"_132":-5,"_40":41,"_39":143,"_134":58,"_37":175,"_13":62,"_33":20,"_35":145,"_23":24,"_138":-5,"_172":176,"_26":177},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":58,"_37":171,"_13":136,"_33":34,"_35":137,"_23":24,"_138":-5,"_172":173,"_26":174},["D",1763959271707],"children",[],[130],["D",1763959271562],[],[141],"cd7f91ee-c8ef-11f0-b29b-42dde27851f2",["D",1763959271566],[],[148,32],"cd52fb52-c8ef-11f0-aeb7-42dde27851f2","run-migrations.ts","cd52fc06-c8ef-11f0-aeb7-42dde27851f2",5,["D",1763959271591],"/**\n * Migration Runner\n *\n * Visit this endpoint to run migrations:\n * https://nbbaier-runDrizzleMigrations.web.val.run\n *\n * It will:\n * - Create new tables from your schema\n * - Track migration versions\n * - Warn about schema changes\n */\n\nimport { migrate } from \"https://esm.town/v/nbbaier/drizzleMigrations\";\nimport * as schema from \"https://esm.town/v/nbbaier/drizzleSchema\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function (_req: Request) {\n\ttry {\n\t\tconst result = await migrate(sqlite, schema);\n\n\t\treturn Response.json({\n\t\t\tsuccess: true,\n\t\t\tversion: result.version,\n\t\t\tapplied: result.applied,\n\t\t\tskipped: result.skipped,\n\t\t\ttimestamp: new Date().toISOString(),\n\t\t});\n\t} catch (error) {\n\t\treturn Response.json(\n\t\t\t{\n\t\t\t\tsuccess: false,\n\t\t\t\terror: error.message,\n\t\t\t},\n\t\t\t{ status: 500 },\n\t\t);\n\t}\n}\n",[],[148,183],"cd4f91ba-c8ef-11f0-a862-42dde27851f2","inspect-schema.ts","cd4f92a0-c8ef-11f0-a862-42dde27851f2",4,["D",1763959271560],"/**\n * Schema Inspector\n *\n * View the SQL that will be generated from your Drizzle schema.\n * Useful for debugging or manual migrations.\n *\n * Visit: https://nbbaier-inspectDrizzleSchema.web.val.run\n */\nimport { generateSchemaSQL } from \"https://esm.town/v/nbbaier/drizzleMigrations\";\nimport * as schema from \"https://esm.town/v/nbbaier/drizzleSchema\";\n\nexport default function () {\n\tconst sql = generateSchemaSQL(schema);\n\treturn new Response(sql, {\n\t\theaders: { \"Content-Type\": \"text/plain\" },\n\t});\n}\n",[],[148,191],"cd48da28-c8ef-11f0-8c99-42dde27851f2","api.ts",3,["D",1763959271527],"/**\n * Example API with Drizzle ORM\n *\n * This shows how to use your schema with full type safety!\n *\n * Endpoints:\n * GET /users - List all users\n * POST /users - Create user (JSON: { name, email })\n * GET /posts - List posts with authors\n * POST /posts - Create post (JSON: { userId, title, content })\n *\n * Try it:\n * https://nbbaier-drizzleExampleApp.web.val.run/users\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { eq } from \"npm:drizzle-orm\";\nimport { drizzle } from \"npm:drizzle-orm/better-sqlite3\";\nimport * as schema from \"./schema.ts\";\n\nconst db = drizzle(sqlite, { schema });\n\nexport default async function (req: Request) {\n\tconst url = new URL(req.url);\n\n\t// GET /users - List all users\n\tif (url.pathname === \"/users\" && req.method === \"GET\") {\n\t\tconst users = await db.select().from(schema.users);\n\t\treturn Response.json(users);\n\t}\n\n\t// POST /users - Create user\n\tif (url.pathname === \"/users\" && req.method === \"POST\") {\n\t\tconst body = await req.json();\n\n\t\tconst [user] = await db\n\t\t\t.insert(schema.users)\n\t\t\t.values({\n\t\t\t\tname: body.name,\n\t\t\t\temail: body.email,\n\t\t\t})\n\t\t\t.returning();\n\n\t\treturn Response.json(user);\n\t}\n\n\t// GET /posts - List posts with user info\n\tif (url.pathname === \"/posts\" && req.method === \"GET\") {\n\t\tconst posts = await db\n\t\t\t.select()\n\t\t\t.from(schema.posts)\n\t\t\t.leftJoin(schema.users, eq(schema.posts.userId, schema.users.id));\n\n\t\treturn Response.json(posts);\n\t}\n\n\t// POST /posts - Create post\n\tif (url.pathname === \"/posts\" && req.method === \"POST\") {\n\t\tconst body = await req.json();\n\n\t\tconst [post] = await db\n\t\t\t.insert(schema.posts)\n\t\t\t.values({\n\t\t\t\tuserId: body.userId,\n\t\t\t\ttitle: body.title,\n\t\t\t\tcontent: body.content,\n\t\t\t\tpublished: body.published ?? false,\n\t\t\t})\n\t\t\t.returning();\n\n\t\treturn Response.json(post);\n\t}\n\n\t// Home page with instructions\n\tif (url.pathname === \"/\") {\n\t\treturn new Response(\n\t\t\t`\n

Drizzle ORM Example API

Endpoints:

GET /users - List users
POST /users - Create user
GET /posts - List posts
POST /posts - Create post

View users

View posts

\n `,\n\t\t\t{\n\t\t\t\theaders: { \"Content-Type\": \"text/html\" },\n\t\t\t},\n\t\t);\n\t}\n\n\treturn Response.json({ error: \"Not found\" }, { status: 404 });\n}\n",[],[148,199],["D",1763959271434],[165,166,167,168],[148],["D",1763958026076],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"ctx",{"_78":-5,"_123":245,"_246":247,"_248":249,"_250":24,"_251":24,"_252":24,"_253":58,"_254":-5,"_255":-7,"_256":-7,"_257":62,"_258":24,"_259":24,"_260":-5,"_261":24,"_262":24,"_263":24,"_264":-5},"ENV",{"_216":217,"_218":219,"_220":86,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v8