Kasper
Kasper
Explore posts from servers
CDCloudflare DevelopersDTDrizzle Team
PostsComments
DTDrizzle Team
Created by Kasper on 6/17/2023 in #help
How do I use "the connection pooler"?
On the docs for Supabase, it says "Connect to your database using the Connection Pooler for serverless environments" but without elaborating. How do I do this? The postgres package does talk about it, but it doesn't seem to mention anything about how to do that vs a direct connection
2 replies
DTDrizzle Team
Created by Kasper on 6/10/2023 in #help
How to insert many rows with one-to-many relationships
I have 100+ rows I want to insert into an artists table, and at the same time insert each artist's songs into a songs table. Each song would be linked to the artist ID, but the artist ID would be generated by the query itself. Any way to accomplish this with Drizzle? Basically, I have data like this I want to insert: 
[
  {
    artist: "example",
    songs: [
      { title: "A" },
      // ...
    ]
  },
  // ...
]
[
  {
    artist: "example",
    songs: [
      { title: "A" },
      // ...
    ]
  },
  // ...
]
3 replies