DT
Drizzle Team•7mo ago
sevenwestonroads

What work is required to support ClickHouse?

I'm a big fan of Drizzle. I'm using Clickhouse on tons of projects, it's one of the best if not the best database for high analytical workload across speed, efficiency, easy of use... They have a Node.js driver that's typed but no schema typing. I'd love to contribute - what can I do to help you support ClickHouse? cc @Andrew Sherman Looks like it'd need a new Driver. Thank you !
3 Replies
Angelelz
Angelelz•7mo ago
It seems like clickhouse has it's own sql dialect Can you confirm?
sevenwestonroads
sevenwestonroads•7mo ago
yes! it's an SQL-like dialect they say they supports a declarative query language based on SQL that is identical to the ANSI SQL standard in many cases.
Angelelz
Angelelz•7mo ago
This will require a lot of work, both researching and implementing. Is there an open issue for it?
Want results from more Discord servers?
Add your server
More Posts
push:pg not creating table schema (pgSchema)Running a local Supabase instance, regular tables and all that work as expected. Just now trying toDrizzle JOIN vs relationsSeems like both Join and relations are equally capable when query data that have relationships. I'd update not working```ts export async function PATCH(request: NextRequest) { const body = (await request.json()) as PHow do I infer type of pgEnumHow can I infer the type of a pgEnum? ```ts export const roleEnum = pgEnum('role', ['A', 'B', 'C', Is drizzle-kit supposed to include existings table in the migration file?is drizzle-kit supposed to include an existing table in the migration file (the sql file)? For conteMySQL Relational CRUDI am the own of issue #1395, it was closed but i don't know way to follow this suggestion: MySql doeJoin does not work?Hello, I nead some help with drizzle d1. I wrote something like this: ```ts const versionAlias = anet::ERR_NAME_NOT_RESOLVED showing multiple times on the consoleHello, I'm trying to do simple database access using drizzle orm. The data got fetched, but my consoWhere should I start?I’m considering using Drizzle on an existing project, but I would like to start with a simple, greenIs it possible to run migrations with the "neon" driver?It's not quite clear from the documentation, and the driver package doesn't export any migrate funct