raaden
raaden
PostsComments
DTDrizzle Team
Created by raaden on 9/4/2023 in #help
PostgresError: unrecognized configuration parameter "schema" when creating client for postgres-js
Getting the error when I add schema to the call drizzle(client, {schema}) using version "drizzle-orm": "^0.28.5", "postgres": "^3.3.5", Error goes away when schema is removed.
import { drizzle, type PostgresJsDatabase } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';
const queryClient = postgres(process.env.DATABASE_URL, { max: 10 });
export const dbClient: PostgresJsDatabase<typeof dbSchema> = drizzle(queryClient, { schema: dbSchema });
import { drizzle, type PostgresJsDatabase } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';
const queryClient = postgres(process.env.DATABASE_URL, { max: 10 });
export const dbClient: PostgresJsDatabase<typeof dbSchema> = drizzle(queryClient, { schema: dbSchema });
Appreciate any help.
22 replies
DTDrizzle Team
Created by raaden on 5/21/2023 in #help
Missing 'with' clause additional operators (where, limit, offset, etc)
Have been digging into the docs and the latest update. ❣️ In the docs (https://orm.drizzle.team/docs/rqb#prepared-statements) it shows a similar number of options for 'with' as it does for the base. The options beyond just columns and extras don't look like they are implemented yet.
Are the additional operators coming or is that section just meant to describe how to include different types of placeholders more generally?
I ask because those operators would be huge for my use case and really allow me to simplify my code considerably. Happy to be patient just wondering if i should continue to plan to do things manually. Thanks again for such a great product!
2 replies