pnpm rm @vercel/postgres
pnpm add @neondatabase/serverless ws
pnpm add -D @types/ws

import type { Config } from "drizzle-kit";

if (!process.env.POSTGRES_URL) {
  throw new Error("Missing POSTGRES_URL");
}
- 
- const nonPoolingUrl = process.env.POSTGRES_URL.replace(":6543", ":5432");

export default {
  schema: "./src/schema.ts",
  dialect: "postgresql",
-   dbCredentials: { url: nonPoolingUrl },
+   dbCredentials: { url: process.env.POSTGRES_URL },
  casing: "snake_case",
} satisfies Config;

import { neonConfig, Pool } from "@neondatabase/serverless";
import { drizzle } from "drizzle-orm/neon-serverless";
import { WebSocket } from "ws";

import * as schema from "./schema";

if (process.env.NODE_ENV === "production") {
  neonConfig.webSocketConstructor = WebSocket;
  neonConfig.poolQueryViaFetch = true;
} else {
  neonConfig.wsProxy = (host) => `${host}:5433/v1`;
  neonConfig.useSecureWebSocket = false;
  neonConfig.pipelineTLS = false;
  neonConfig.pipelineConnect = false;
}

const pool = new Pool({ connectionString: process.env.POSTGRES_URL });

export const db = drizzle({
  client: pool,
  schema,
  casing: "snake_case",
});

services:
  postgres:
    image: 'postgres:latest'
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgres
      POSTGRES_DB: postgres
    ports:
      - '5432:5432'
  pg_proxy:
    image: ghcr.io/neondatabase/wsproxy:latest
    environment:
      APPEND_PORT: 'postgres:5432'
      ALLOW_ADDR_REGEX: '.*'
      LOG_TRAFFIC: 'true'
    ports:
      - '5433:80'
    depends_on:
      - postgres

CommandError: No development build (your.bundle.identifier) for this project is installed.

{error?.data?.code === "UNAUTHORIZED" && (
  <Text className="mt-2 text-destructive">
    You need to be logged in to create a post
  </Text>
)}

create: protectedProcedure
  .input(CreatePostSchema)
  .mutation(({ ctx, input }) => {
    return ctx.db.insert(Post).values(input);
  }),

POST /api/trpc/post.create?batch=1 500 in 491ms

>>> tRPC Request from expo-react by undefined
[TRPC] post.create took 479ms to execute
>>> tRPC Error on 'post.create' error: client selected an invalid SASL authentication mechanism
    at eval (webpack-internal:///(rsc)/../../node_modules/@neondatabase/serverless/index.mjs:1359:74)
    ... 30 lines matching cause stack trace ...

npx expo install expo-background-fetch
npx expo install expo-task-manager

  ios: {
    bundleIdentifier: "your.bundle.identifier",
    supportsTablet: true,
+    infoPlist: {
+      UIBackgroundModes: ["fetch"],
+    },
  },

npx expo export:embed \
--entry-file='node_modules/expo-router/entry.js' \
--bundle-output='./ios/main.jsbundle' \
--dev=false \
--platform='ios'

npx expo install react-native-background-fetch

// 追記部分のみ抜粋
export default ({ config }: ConfigContext): ExpoConfig => ({
  ios: {
    infoPlist: {
      UIBackgroundModes: ["fetch", "processing"],
      BGTaskSchedulerPermittedIdentifiers: ["com.transistorsoft.fetch"],
    },
  },
  android: {
    permissions: ["RECEIVE_BOOT_COMPLETED", "WAKE_LOCK", "FOREGROUND_SERVICE"],
  },
  plugins: ["expo-router", "react-native-background-fetch"],
});

export default function Index() {
  // set background fetch
  useEffect(() => {
    const initBackgroundFetch = async () => {
      try {
        const status = await BackgroundFetch.configure(
          {
            minimumFetchInterval: 15, // minutes
            enableHeadless: true,
            stopOnTerminate: false,
            startOnBoot: true,
            requiredNetworkType: BackgroundFetch.NETWORK_TYPE_ANY,
          },
          // main task
          (taskId) => {
            asyncFn
              .then(() => {
                console.log("[BackgroundFetch] taskId: ", taskId);
                BackgroundFetch.finish(taskId);
              })
              .catch((error) => {
                console.error(
                  "[BackgroundFetch] Failed: ",
                  error,
                );
                BackgroundFetch.finish(taskId);
              });
          },
          // timeout fallback
          (taskId) => {
            console.warn("[BackgroundFetch] TIMEOUT task: ", taskId);
            BackgroundFetch.finish(taskId);
          },
        );
        console.log("[BackgroundFetch] configure status: ", status);
      } catch (error) {
        console.error("[BackgroundFetch] Failed to configure: ", error);
      }
    };
    void initBackgroundFetch();
  }, []);

  // ...
}

eas build --profile production --platform ios --local

[RUN_FASTLANE]  Ineligible destinations for the "app" scheme:
[RUN_FASTLANE]          { platform:iOS, id:dvtdevice-DVTiPhonePlaceholder-iphoneos:placeholder, name:Any iOS Device, error:iOS 18.5 is not installed. To use with Xcode, first download and install the platform }
[RUN_FASTLANE] Exit status: 70