Working with Drizzle ORM in Edge Functions

[@Supabase]

Learn how to use Supabase with Drizzle ORM: supabase.com/docs/guides/database/connecting-to-postgres#connecting-with-drizzle?utm%5C_term=edge-functions&

[@scaffus]

Man I love supabase and edging with Drizzle is the cherry on top

[@Tanner-cz4bd]

That sounds rather inappropriate 😂

[@scaffus]

@@Tanner-cz4bd 😅

[@PeteStyla]

You came at the right time. I am currently working on this setup and am thankful for the firsthand infos.

[@arnabchatterjee2094]

how to reference to auth.users.id in drizzle??

[@nikhilpsathyanathan]

I guess supabase doesn't have any edge runtime compactable postgress adapter like Neon or Planet scale To use with next.js

[@Supabase]

The Deno Edge Runtime supports TCP out of the box, so no adapter required here. For Vercel Edge Runtime, our Supavisor connection pooler is compatible with the @vercel/postgres package. You can find an example here: github.com/supabase-community/create-t3-turbo/blob/main/.env.example#L8

[@nikhilpsathyanathan]

Thanks, I'll check it. I have tried the postgress package, and it has issues

[@carlosricardoziegler2650]

Nice content, some plan to support another’s js runtimes ? Bun / Node ?

[@thorwebdev]

You mean specifically the runtime of Supabase Edge Functions? We're watching Bun for sure, but no immediate plans. What are you missing in the Deno runtime?

[@budivoogt491]

Would be great to see bun support added. It's become my preferred JS runtime env

[@caseyspaulding]

Does this still support RLS?

[@RexGalilae]

1:10 "Edgy Drizzle" 😳😳😳

[@yourpc]

Need to update instruction after deno released version 2.0

[@alexe.2567]

That guide doesn't seem to be working anymore. I am getting this error when running the deployed edge function: Error: write CONNECT_TIMEOUT undefined:undefined at connectTimedOut (file:///tmp/sb-compile-edge-runtime/node_modules/localhost/postgres/3.4.3/src/connection.js:257:20) at Timeout.done [as _onTimeout] (file:///tmp/sb-compile-edge-runtime/node_modules/localhost/postgres/3.4.3/src/connection.js:1035:8) at cb (ext:deno_node/internal/timers.mjs:64:31) at callback (ext:deno_web/02_timers.js:58:22) at eventLoopTick (ext:core/01_core.js:203:13) { code: "CONNECT_TIMEOUT", errno: "CONNECT_TIMEOUT", address: undefined, port: undefined }