johtso Posts - Answer Overflow

johtso

Explore posts from servers

CDCloudflare Developers DDeno DTDrizzle Team

•Created by johtso on 6/28/2024 in #help

Monorepo and schemas, how to structure

I was wondering if anyone had any advice/thoughts on how best to structure a monorepo project when it comes to schemas. I currently have a single "database" package that has all my schemas and migrations. Is there a "better" way to do it? It seems wrong to have the schemas separate form the package that it relates to, but at the same time it seems simpler than trying to figure out a way to manage schemas and migrations across multiple packages..

1 replies

CDCloudflare Developers

•Created by johtso on 6/23/2024 in #workers-help

pointing a custom subdomain to worker

I'm struggling to figure out how I can get a custom subdomain connected to my worker when my DNS is hosted externally Is this impossible without a business plan? There must be some way to get this to work. I currently have my subdomain pointing at a netlify site and it works fine.

18 replies

DTDrizzle Team

•Created by johtso on 3/31/2024 in #help

How to make a text based timestamp type for sqlite with zod schema inference

When I use the built in integer with mode timestamp, the generated zod schemas correctly declare that inserts take a Date and selects produce a Date. When I try and write a custom type like this:

const timestamp = customType<
  { data: Date; driverData: string; }
>({
  dataType() {
    return 'text';
  },
  fromDriver(value: string): Date {
    return new Date(value);
  },
  toDriver(value: Date): string {
    return value.toISOString();
  },
});

const timestamp = customType<
  { data: Date; driverData: string; }
>({
  dataType() {
    return 'text';
  },
  fromDriver(value: string): Date {
    return new Date(value);
  },
  toDriver(value: Date): string {
    return value.toISOString();
  },
});

The zod schema looks like this:

myIntegerDateColumn: ZodDate;
myTextDateColumn: ZodAny;

myIntegerDateColumn: ZodDate;
myTextDateColumn: ZodAny;

1 replies

DTDrizzle Team

•Created by johtso on 3/31/2024 in #help

How do I access config in fromDriver and toDriver when defining a custom type using customType?

None of the examples do this so it's not clear how/if this is possible?

11 replies

Gaming

Programming