How to enable Short types on supabase gen types typescript?

[piccinnigius]

running npx supabase gen types typescript (1.85.0) generates only Database interface. I'm missing something?

example from launch week post

// Before
let movie: Database['public']['Tables']['movies']['Row'] = // ...

// After
let movie: Tables<'movies'> = // ...

Thanks in advance

[piccinnigius]

I've found more explanations here: js docs

Maybe it's good to update docs in generate types section

[soedirgo]

Thanks @piccinnigius! I think we should clarify that the helper types are manually written in a separate file.

[Saurabhyadav0]

To enable Short types in Supabase-generated types in TypeScript, you can follow these steps:

1. Install supabase-js package:
   Make sure you have the supabase-js package installed in your project. You can install it using npm or yarn:

   npm install @supabase/supabase-js
   # OR
   yarn add @supabase/supabase-js

2. Generate types using Supabase CLI:
   If you haven't already generated types using Supabase CLI, you can do so by running the following command in your terminal:

   npx supabase postgrest --typescript --schema public --url <your_supabase_url> --key <your_supabase_key> > supabase-types.ts

   Replace <your_supabase_url> with your Supabase URL and <your_supabase_key> with your Supabase API key.

3. Modify supabase-types.ts file
   Open the generated supabase-types.ts file in your code editor. Look for the types related to your Short columns in Supabase tables.

4. Define Short types:
   In the supabase-types.ts file, you may need to manually define Short types if they are not generated correctly. For example:

   export interface MyTable {
       id: number;
       name: string;
       age: number;
       // Define Short type for your column
       height: number | null; // Assuming height is a Short column
   }

   Ensure that you correctly map the Short types based on your Supabase table schema.

5. Use the generated types in your code:
   After modifying the supabase-types.ts file, you can import and use the generated types in your TypeScript codebase. For example:

   import { MyTable } from './supabase-types';
   
   const user: MyTable = {
       id: 1,
       name: 'John Doe',
       age: 30,
       height: 160, // Assign Short type value
   };

By following these steps, you can enable and use Short types in Supabase-generated types for TypeScript, ensuring accurate type definitions for your Supabase table columns. Adjust the types and mappings according to your specific Supabase schema and requirements.

[Hallidayo]

Hi everyone, due to inactivity on this issue I've moved the issue over to discussions for future reference.