6 replies

How to get good at Drizzle?

Hello I am currently having a huge problem with Drizzle, and relational databases in general.

I start writing my schema, but after finishing a few tables (5-10) I get overwhelmed by the amount of objects and relations happening between them and don't know what to do, and how to properly connect them together.

At this point I just delete my entire schema and start writing it from scratch, in hopes of implementing it correctly this time. This process repeats a few times and I never actually finish the database.

I am also very confused when thinking about the later part of the application, where I would have to insert the data, as nested objects would have to be inserted in multiple layers which sounds so complicated at scale.

Example having a
product
product
with
variants
variants
of that product which have
prices
prices
. I would have to create a price, then assign the price_id to a variant, then do the same for a product. The logic seems backwards, so instead of thinking about inserting a product I first have to insert a price then variant then product. And all that at just 3 levels of nesting.

The example above would be even messier in code, while I am thinking of inserting something more elegant like this:

{
  "product": {
    "id": "b0a0c9f4-a4d0-4f5f-b8b6-e4a5d5c0b1d2",
    "title": "Test Product",
    "description": "This is a test product",
    "variants": [
      {
        "options": [
          {
            "key": "color",
            "value": "red"
          },
          {
            "key": "size",
            "value": "small"
          }
        ],
        "price": {
          "amount": 100,
          "currency": {
            "code": "USD",
            "name": "United States Dollar"
          }
        }
      },
    ]
  }
}

{
  "product": {
    "id": "b0a0c9f4-a4d0-4f5f-b8b6-e4a5d5c0b1d2",
    "title": "Test Product",
    "description": "This is a test product",
    "variants": [
      {
        "options": [
          {
            "key": "color",
            "value": "red"
          },
          {
            "key": "size",
            "value": "small"
          }
        ],
        "price": {
          "amount": 100,
          "currency": {
            "code": "USD",
            "name": "United States Dollar"
          }
        }
      },
    ]
  }
}

Do you have any tips on staying organised and not getting overwhelmed when writing Drizzle schemas?

{
  "product": {
    "id": "b0a0c9f4-a4d0-4f5f-b8b6-e4a5d5c0b1d2",
    "title": "Test Product",
    "description": "This is a test product",
    "variants": [
      {
        "options": [
          {
            "key": "color",
            "value": "red"
          },
          {
            "key": "size",
            "value": "small"
          }
        ],
        "price": {
          "amount": 100,
          "currency": {
            "code": "USD",
            "name": "United States Dollar"
          }
        }
      },
    ]
  }
}

{
  "product": {
    "id": "b0a0c9f4-a4d0-4f5f-b8b6-e4a5d5c0b1d2",
    "title": "Test Product",
    "description": "This is a test product",
    "variants": [
      {
        "options": [
          {
            "key": "color",
            "value": "red"
          },
          {
            "key": "size",
            "value": "small"
          }
        ],
        "price": {
          "amount": 100,
          "currency": {
            "code": "USD",
            "name": "United States Dollar"
          }
        }
      },
    ]
  }
}

Do you have any tips on staying organised and not getting overwhelmed when writing Drizzle schemas?

How to get good at Drizzle?

How to get good at Drizzle?

Similar Threads

Similar Threads

Similar Threads