DT
Drizzle Team•4mo ago
Mr. Seal

Cant use query with pglite + drizzle local

This is my current instance 
import { drizzle } from 'drizzle-orm/pglite'
import { cachedCategories } from './schema'

export const cache = drizzle({ connection: { dataDir: './cache/pglite' }, schema: cachedCategories })
import { drizzle } from 'drizzle-orm/pglite'
import { cachedCategories } from './schema'

export const cache = drizzle({ connection: { dataDir: './cache/pglite' }, schema: cachedCategories })
import { json, pgTable, text } from 'drizzle-orm/pg-core'

export const cachedCategories = pgTable('categories', {
    url: text().primaryKey(),
    data: json().notNull()
})
import { json, pgTable, text } from 'drizzle-orm/pg-core'

export const cachedCategories = pgTable('categories', {
    url: text().primaryKey(),
    data: json().notNull()
})
Error: 
Argument of type '[{ connection: { dataDir: string; }; schema: PgTableWithColumns<{ name: "categories"; schema: undefined; columns: { url: PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; ... 9 more ...; generated: undefined; }, {}, {}>; data: PgColumn<...>; }; dialect: "pg"; }>...' is not assignable to parameter of type '[] | [string | PGlite] | [string | PGlite, DrizzleConfig<Record<string, unknown>>] | [DrizzleConfig<Record<string, unknown>> & ({ ...; } | { ...; })]'.
  Type '[{ connection: { dataDir: string; }; schema: PgTableWithColumns<{ name: "categories"; schema: undefined; columns: { url: PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; ... 9 more ...; generated: undefined; }, {}, {}>; data: PgColumn<...>; }; dialect: "pg"; }>...' is not assignable to type '[string | PGlite] | [DrizzleConfig<Record<string, unknown>> & ({ connection?: string | (PGliteOptions<Extensions> & { ...; }) | undefined; } | { ...; })]'.
    Type '[{ connection: { dataDir: string; }; schema: PgTableWithColumns<{ name: "categories"; schema: undefined; columns: { url: PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; ... 9 more ...; generated: undefined; }, {}, {}>; data: PgColumn<...>; }; dialect: "pg"; }>...' is not assignable to type '[string | PGlite]'.
      Object literal may only specify known properties, and 'connection' does not exist in type 'PGlite'.
Argument of type '[{ connection: { dataDir: string; }; schema: PgTableWithColumns<{ name: "categories"; schema: undefined; columns: { url: PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; ... 9 more ...; generated: undefined; }, {}, {}>; data: PgColumn<...>; }; dialect: "pg"; }>...' is not assignable to parameter of type '[] | [string | PGlite] | [string | PGlite, DrizzleConfig<Record<string, unknown>>] | [DrizzleConfig<Record<string, unknown>> & ({ ...; } | { ...; })]'.
  Type '[{ connection: { dataDir: string; }; schema: PgTableWithColumns<{ name: "categories"; schema: undefined; columns: { url: PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; ... 9 more ...; generated: undefined; }, {}, {}>; data: PgColumn<...>; }; dialect: "pg"; }>...' is not assignable to type '[string | PGlite] | [DrizzleConfig<Record<string, unknown>> & ({ connection?: string | (PGliteOptions<Extensions> & { ...; }) | undefined; } | { ...; })]'.
    Type '[{ connection: { dataDir: string; }; schema: PgTableWithColumns<{ name: "categories"; schema: undefined; columns: { url: PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; ... 9 more ...; generated: undefined; }, {}, {}>; data: PgColumn<...>; }; dialect: "pg"; }>...' is not assignable to type '[string | PGlite]'.
      Object literal may only specify known properties, and 'connection' does not exist in type 'PGlite'.
1 Reply
Mr. Seal
Mr. SealOP•4mo ago
I also cannot do select from 
Argument of type 'PgTableWithColumns<{ name: "categories"; schema: undefined; columns: { url: PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; driverParam: string; notNull: true; hasDefault: false; ... 6 more ...; generated: undefined; }, {}, {}>; data: PgColumn<...>; }; dialect...' is not assignable to parameter of type 'PgTable<TableConfig> | Subquery<string, Record<string, unknown>> | PgViewBase<string, boolean, ColumnsSelection> | SQL<...>'.
  Type 'PgTableWithColumns<{ name: "categories"; schema: undefined; columns: { url: PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; driverParam: string; notNull: true; hasDefault: false; ... 6 more ...; generated: undefined; }, {}, {}>; data: PgColumn<...>; }; dialect...' is not assignable to type 'PgTable<TableConfig>'.
    The types of '_.config.columns' are incompatible between these types.
      Type '{ url: PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: true; isAutoincrement: false; ... 4 more ...; generated: undefined; }, {}, {}>; data: PgColumn<...>; }' is not assignable to type 'Record<string, PgColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>>'.
        Property 'url' is incompatible with index signature.
          Type 'PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: true; isAutoincrement: false; ... 4 more ...; generated: undefined; }, {}, {}>' is not assignable to type 'PgColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>'.
            The types of 'table._.config.columns' are incompatible between these types.
              Type 'Record<string, import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44.2_@types+pg@8.15.4_pg@8.16.0/node_modules/drizzle-orm/pg-core/columns/common").PgColumn<import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44....' is not assignable to type 'Record<string, import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44.2_@electri_56a93c6961ae29128590cae23bab094b/node_modules/drizzle-orm/pg-core/columns/common").PgColumn<import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/dr...'.
                'string' index signatures are incompatible.
                  Type 'import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44.2_@types+pg@8.15.4_pg@8.16.0/node_modules/drizzle-orm/pg-core/columns/common").PgColumn<import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44.2_@types+pg@8.1...' is not assignable to type 'import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44.2_@electri_56a93c6961ae29128590cae23bab094b/node_modules/drizzle-orm/pg-core/columns/common").PgColumn<import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44....'.
                    Property 'config' is protected but type 'Column<T, TRuntimeConfig, TTypeConfig>' is not a class derived from 'Column<T, TRuntimeConfig, TTypeConfig>'.
Argument of type 'PgTableWithColumns<{ name: "categories"; schema: undefined; columns: { url: PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; driverParam: string; notNull: true; hasDefault: false; ... 6 more ...; generated: undefined; }, {}, {}>; data: PgColumn<...>; }; dialect...' is not assignable to parameter of type 'PgTable<TableConfig> | Subquery<string, Record<string, unknown>> | PgViewBase<string, boolean, ColumnsSelection> | SQL<...>'.
  Type 'PgTableWithColumns<{ name: "categories"; schema: undefined; columns: { url: PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; driverParam: string; notNull: true; hasDefault: false; ... 6 more ...; generated: undefined; }, {}, {}>; data: PgColumn<...>; }; dialect...' is not assignable to type 'PgTable<TableConfig>'.
    The types of '_.config.columns' are incompatible between these types.
      Type '{ url: PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: true; isAutoincrement: false; ... 4 more ...; generated: undefined; }, {}, {}>; data: PgColumn<...>; }' is not assignable to type 'Record<string, PgColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>>'.
        Property 'url' is incompatible with index signature.
          Type 'PgColumn<{ name: "url"; tableName: "categories"; dataType: "string"; columnType: "PgText"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: true; isAutoincrement: false; ... 4 more ...; generated: undefined; }, {}, {}>' is not assignable to type 'PgColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>'.
            The types of 'table._.config.columns' are incompatible between these types.
              Type 'Record<string, import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44.2_@types+pg@8.15.4_pg@8.16.0/node_modules/drizzle-orm/pg-core/columns/common").PgColumn<import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44....' is not assignable to type 'Record<string, import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44.2_@electri_56a93c6961ae29128590cae23bab094b/node_modules/drizzle-orm/pg-core/columns/common").PgColumn<import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/dr...'.
                'string' index signatures are incompatible.
                  Type 'import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44.2_@types+pg@8.15.4_pg@8.16.0/node_modules/drizzle-orm/pg-core/columns/common").PgColumn<import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44.2_@types+pg@8.1...' is not assignable to type 'import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44.2_@electri_56a93c6961ae29128590cae23bab094b/node_modules/drizzle-orm/pg-core/columns/common").PgColumn<import("C:/Users/vyrek/Desktop/Vyrek/Development/apps/adihci-scrapping/node_modules/.pnpm/drizzle-orm@0.44....'.
                    Property 'config' is protected but type 'Column<T, TRuntimeConfig, TTypeConfig>' is not a class derived from 'Column<T, TRuntimeConfig, TTypeConfig>'.
await cache.select().from(cachedCategories)

Did you find this page helpful?