Val Town Code SearchReturn to Val Town

4import type { Place } from "../models/place-models.ts";
5import { processCheckinEvent as _processCheckinEvent } from "../ingestion/record-processor.ts";
6import { db } from "../database/db.ts";
7import { checkinsTable } from "../database/schema.ts";
8import { eq } from "https://esm.sh/drizzle-orm";
9import type { OAuthSessionsInterface } from "jsr:@tijs/atproto-oauth-hono@^0.2.6";
429    console.log(`✅ Created checkin record: ${checkinResult.uri}`);
430
431    // IMMEDIATELY save to local database for instant feed updates
432    try {
433      const rkey = extractRkey(checkinResult.uri);
443        },
444      });
445      console.log(`✅ Saved checkin to local database: ${rkey}`);
446    } catch (localSaveError) {
447      console.error(
448        "Failed to save checkin to local database:",
449        localSaveError,
450      );

198```
199├── backend/
200│   ├── database/
201│   │   ├── migrations.ts    # Schema definitions
202│   │   ├── queries.ts       # DB query functions
257  ```
258
259### Database Patterns
260- Run migrations on startup or comment out for performance
261- Change table names when modifying schemas rather than altering