alex (he/him) Posts - Answer Overflow

alex (he/him)

Explore posts from servers

CDCloudflare Developers DTDrizzle Team BABetter Auth

•Created by alex (he/him) on 5/17/2025 in #help

Svelte Kit hooks.server.ts getSession not working

I want to use better-auth with SvelteKit, but I don't use the svelteKitHandler.. I've set-up a custom route apps/frontend/src/routes/api/auth/[...all]/+server.ts with the following code:

import type { RequestHandler } from "./$types";

// const ORPC_ENDPOINT = import.meta.env.VITE_ORPC_ENDPOINT

export const fallback: RequestHandler = async ({ request, platform }) => {
  console.log("Fallback handler called for:", request.url);
  // if (import.meta.env.DEV) {
  //   return await fetch(`${ORPC_ENDPOINT}${new URL(request.url).pathname}`, request)
  // } else {
  const t = await platform!.env.ORM.fetch(`http://localhost:8210${new URL(request.url).pathname}`, request)

  return new Response(t.body, {
    status: t.status,
    statusText: t.statusText,
    headers: t.headers,
  });
};

import type { RequestHandler } from "./$types";

// const ORPC_ENDPOINT = import.meta.env.VITE_ORPC_ENDPOINT

export const fallback: RequestHandler = async ({ request, platform }) => {
  console.log("Fallback handler called for:", request.url);
  // if (import.meta.env.DEV) {
  //   return await fetch(`${ORPC_ENDPOINT}${new URL(request.url).pathname}`, request)
  // } else {
  const t = await platform!.env.ORM.fetch(`http://localhost:8210${new URL(request.url).pathname}`, request)

  return new Response(t.body, {
    status: t.status,
    statusText: t.statusText,
    headers: t.headers,
  });
};

This is because it uses two Cloudflare Workers, one running the server and the other just a proxy. Now i want to use inside hooks.server.ts the following code

const addGraphQLClient: Handle = async ({ event, resolve }) => {
  const { data: session } = await authClient.getSession({
    query: {
      disableCookieCache: true,
      disableRefresh: false
    },
    fetchOptions: {
      headers: event.request.headers
    }
  });
}

const addGraphQLClient: Handle = async ({ event, resolve }) => {
  const { data: session } = await authClient.getSession({
    query: {
      disableCookieCache: true,
      disableRefresh: false
    },
    fetchOptions: {
      headers: event.request.headers
    }
  });
}

The cookie inside event.request.headers does include the etter-auth.session_token=, but it still always return null.. I can't use auth.api.getSession because the auth instance runs in a different worker, but according to the docs it should work with https://www.better-auth.com/docs/reference/faq I think I'm maybe missing some setup, which is needed if I use a custom api route and note the svelteKitHandler, but I'm a bit lost. Can anyone help?

4 replies

DTDrizzle Team

•Created by alex (he/him) on 12/12/2024 in #help

How to set opclass for index with custom sql column

we do have following definitions, after we used drizzle-kit pull

uniqueIndex("sap_id_upper_trim_idx").using("btree", sql`upper(TRIM(BOTH FROM sap_id))`),

uniqueIndex("sap_id_upper_trim_idx").using("btree", sql`upper(TRIM(BOTH FROM sap_id))`),

Now the issue is that, drizzle-kit generate thinks it needs to drop the index and recreates it, because it doesn't understand that the opclass is optional. This is the initial state from introspection

CREATE UNIQUE INDEX "sap_id_upper_trim_idx" ON "companies" USING btree (upper(TRIM(BOTH FROM sap_id)) text_ops);--> statement-breakpoint

CREATE UNIQUE INDEX "sap_id_upper_trim_idx" ON "companies" USING btree (upper(TRIM(BOTH FROM sap_id)) text_ops);--> statement-breakpoint

This is what drizzle generates as a migration

DROP INDEX "sap_id_upper_trim_idx";--> statement-breakpoint
CREATE UNIQUE INDEX "sap_id_upper_trim_idx" ON "companies" USING btree (upper(TRIM(BOTH FROM sap_id)));--> statement-breakpoint

DROP INDEX "sap_id_upper_trim_idx";--> statement-breakpoint
CREATE UNIQUE INDEX "sap_id_upper_trim_idx" ON "companies" USING btree (upper(TRIM(BOTH FROM sap_id)));--> statement-breakpoint

I know for other columns we can use .op('text_ops'), but that doesn't work for the custom index column with sql?

1 replies

CDCloudflare Developers

•Created by alex (he/him) on 11/14/2023 in #pages-help

Help understanding routing with a custom `_routes.json`

Hey I'm debugging an user bug report for Astro. The user has the following _routes.json

{
  "version": 1,
  "include": [
    "/404",
    "/_image"
  ],
  "exclude": []
}

{
  "version": 1,
  "include": [
    "/404",
    "/_image"
  ],
  "exclude": []
}

And the following file-tree:

dist
├── _redirects
├── _routes.json
├── _worker.js
├── favicon.svg
└── index.html

dist
├── _redirects
├── _routes.json
├── _worker.js
├── favicon.svg
└── index.html

If he now tries to access his webpage using the following url: https://example.com/unknown, the index.html is returned. Would like to understand the why, so we can offer a fix in Astro?

12 replies

CDCloudflare Developers

•Created by alex (he/him) on 10/20/2023 in #pages-help

`pages.dev` is limited compared to custom domain

We have enabled CF Fonts & CF Image Resizing on a zone, which also is setup as a custom domain for our pages project. That works fine for the main production branch. However accessing the preview deployments at hash.pages.dev, both system do not work. What is the best way to make them work with the pages.dev urls, or get individual preview urls on the custom domain automatically?

6 replies

CDCloudflare Developers

•Created by alex (he/him) on 7/3/2023 in #pages-help

`rss.xml` Error 1101

trying to access: https://baae285e.test-ef9.pages.dev/rss.xml But get strange issue, can someone help?

{
  "outcome": "exception",
  "scriptName": "pages-worker--1063707-production",
  "exceptions": [
    {
      "name": "Error",
      "message": "internal error",
      "timestamp": 1688404914662
    }
  ],
  "logs": [],
  "eventTimestamp": 1688404914662,
  "event": {
    "request": {
      "url": "https://baae285e.test-ef9.pages.dev/rss.xml",
      "method": "GET",
      "headers": {
        "accept": "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7",
        "accept-encoding": "gzip",
        "accept-language": "en-US,en;q=0.9,de;q=0.8",
        "cache-control": "max-age=0",
        "cf-connecting-ip": "31.17.112.38",
        "cf-ipcountry": "DE",
        "cf-ray": "7e10cebc98ffcad1",
        "cf-visitor": "{\"scheme\":\"https\"}",
        "connection": "Keep-Alive",
        "dnt": "1",
        "host": "baae285e.test-ef9.pages.dev",
        "priority": "u=0, i",
        "sec-ch-ua": "\"Not.A/Brand\";v=\"8\", \"Chromium\";v=\"114\"",
        "sec-ch-ua-mobile": "?0",
        "sec-ch-ua-platform": "\"macOS\"",
        "sec-fetch-dest": "document",
        "sec-fetch-mode": "navigate",
        "sec-fetch-site": "none",
        "sec-fetch-user": "?1",
        "upgrade-insecure-requests": "1",
        "user-agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36",
        "x-forwarded-proto": "https",
        "x-real-ip": "31.17.112.38"
      },
    },
    "response": {
      "status": 500
    }
  },
  "id": 2
}

{
  "outcome": "exception",
  "scriptName": "pages-worker--1063707-production",
  "exceptions": [
    {
      "name": "Error",
      "message": "internal error",
      "timestamp": 1688404914662
    }
  ],
  "logs": [],
  "eventTimestamp": 1688404914662,
  "event": {
    "request": {
      "url": "https://baae285e.test-ef9.pages.dev/rss.xml",
      "method": "GET",
      "headers": {
        "accept": "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7",
        "accept-encoding": "gzip",
        "accept-language": "en-US,en;q=0.9,de;q=0.8",
        "cache-control": "max-age=0",
        "cf-connecting-ip": "31.17.112.38",
        "cf-ipcountry": "DE",
        "cf-ray": "7e10cebc98ffcad1",
        "cf-visitor": "{\"scheme\":\"https\"}",
        "connection": "Keep-Alive",
        "dnt": "1",
        "host": "baae285e.test-ef9.pages.dev",
        "priority": "u=0, i",
        "sec-ch-ua": "\"Not.A/Brand\";v=\"8\", \"Chromium\";v=\"114\"",
        "sec-ch-ua-mobile": "?0",
        "sec-ch-ua-platform": "\"macOS\"",
        "sec-fetch-dest": "document",
        "sec-fetch-mode": "navigate",
        "sec-fetch-site": "none",
        "sec-fetch-user": "?1",
        "upgrade-insecure-requests": "1",
        "user-agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36",
        "x-forwarded-proto": "https",
        "x-real-ip": "31.17.112.38"
      },
    },
    "response": {
      "status": 500
    }
  },
  "id": 2
}

7 replies

DTDrizzle Team

•Created by alex (he/him) on 6/19/2023 in #help

drizzle-kit@win still not working. What am I doing wrong?

/Users/alexanderniebuhr/Developer/Projects/alexanderniebuhr_blog/packages/db/drizzle.config.ts

import type { Config } from 'drizzle-kit'

export default {
    schema: './src/schema/*.ts',
    out: './drizzle',
} satisfies Config

import type { Config } from 'drizzle-kit'

export default {
    schema: './src/schema/*.ts',
    out: './drizzle',
} satisfies Config

❯ moon run db:generate
▪▪▪▪ db:generate
drizzle-kit: v0.19.2
drizzle-orm: v0.27.0

No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/alexanderniebuhr/Developer/Projects/alexanderniebuhr_blog/packages/db/drizzle.config.ts'
node:internal/errors:496
    ErrorCaptureStackTrace(err);
    ^

Error [ERR_MODULE_NOT_FOUND]: Cannot find module '/Users/alexanderniebuhr/Developer/Projects/alexanderniebuhr_blog/packages/db/drizzle.config.ts__drizzle__' imported from /Users/alexanderniebuhr/Developer/Projects/alexanderniebuhr_blog/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/index.cjs
    at new NodeError (node:internal/errors:405:5)
    at finalizeResolution (node:internal/modules/esm/resolve:224:11)
    at moduleResolve (node:internal/modules/esm/resolve:837:10)
    at defaultResolve (node:internal/modules/esm/resolve:1035:11)
    at DefaultModuleLoader.resolve (node:internal/modules/esm/loader:269:12)
    at DefaultModuleLoader.getModuleJob (node:internal/modules/esm/loader:153:32)
    at DefaultModuleLoader.import (node:internal/modules/esm/loader:245:28)
    at importModuleDynamically (node:internal/modules/cjs/loader:1185:37)
    at importModuleDynamicallyWrapper (node:internal/vm/module:428:21)
    at importModuleDynamically (node:internal/vm:105:46) {
  code: 'ERR_MODULE_NOT_FOUND'
}

Node.js v20.3.0
▪▪▪▪ db:generate (97ms)
Error:   × Process drizzle-kit failed with a 1 exit code.

❯ moon run db:generate
▪▪▪▪ db:generate
drizzle-kit: v0.19.2
drizzle-orm: v0.27.0

No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/alexanderniebuhr/Developer/Projects/alexanderniebuhr_blog/packages/db/drizzle.config.ts'
node:internal/errors:496
    ErrorCaptureStackTrace(err);
    ^

Error [ERR_MODULE_NOT_FOUND]: Cannot find module '/Users/alexanderniebuhr/Developer/Projects/alexanderniebuhr_blog/packages/db/drizzle.config.ts__drizzle__' imported from /Users/alexanderniebuhr/Developer/Projects/alexanderniebuhr_blog/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/index.cjs
    at new NodeError (node:internal/errors:405:5)
    at finalizeResolution (node:internal/modules/esm/resolve:224:11)
    at moduleResolve (node:internal/modules/esm/resolve:837:10)
    at defaultResolve (node:internal/modules/esm/resolve:1035:11)
    at DefaultModuleLoader.resolve (node:internal/modules/esm/loader:269:12)
    at DefaultModuleLoader.getModuleJob (node:internal/modules/esm/loader:153:32)
    at DefaultModuleLoader.import (node:internal/modules/esm/loader:245:28)
    at importModuleDynamically (node:internal/modules/cjs/loader:1185:37)
    at importModuleDynamicallyWrapper (node:internal/vm/module:428:21)
    at importModuleDynamically (node:internal/vm:105:46) {
  code: 'ERR_MODULE_NOT_FOUND'
}

Node.js v20.3.0
▪▪▪▪ db:generate (97ms)
Error:   × Process drizzle-kit failed with a 1 exit code.

6 replies

DTDrizzle Team

•Created by alex (he/him) on 6/4/2023 in #help

Type Declaration with TypeScript in Monorepo failes

I am trying to setup a monorepo with moon and pnpm, where shema lives in an additional package and is imported by other apps. Is there any monorepo example? Currently I get following error:

../db/src/schema/products.ts(4,14): error TS2742: The inferred type of 'products' cannot be named without a reference to '../../node_modules/drizzle-orm/db.d-a6fe1b19.js'. This is likely not portable. A type annotation is necessary.

../db/src/schema/products.ts(4,14): error TS2742: The inferred type of 'products' cannot be named without a reference to '../../node_modules/drizzle-orm/db.d-a6fe1b19.js'. This is likely not portable. A type annotation is necessary.

There is an GitHub Issue already, can anyone help with workarounds or fixes, explanations? https://github.com/drizzle-team/drizzle-orm/issues/656

6 replies

Gaming

Programming