Supabase is like an open-source version of Firebase. It gives you backend services like real-time databases, authentication, and storage. Since it uses PostgreSQL, you can do bulk insert operations too.

Before you dive in, make sure you've got these ready:

• An existing Supabase project.
• A table where you'll be inserting data in bulk.
• Your data, ready and properly formatted.

First up, create an array of JSON objects. Each JSON object will be a row in your dataset.

Here's an example where “products” is an array of JSON objects:

const products = [
  { product_id: 1, product_name: 'Product 1', price: 100 },
  { product_id: 2, product_name: 'Product 2', price: 150 },
  // Add more products here...
]

Supabase suggests using the upsert function for bulk data inserts. This will update existing records if there are any conflicts.

Run the upsert function and point it to your Supabase table. Pass the array of data as the parameter.

Here's how you do it:

supabase
  .from('products')
  .upsert(products)

But if you just want to add new records and ignore conflicts, use the insert function:

supabase
  .from('products')
  .insert(products)

These functions return a Promise, so you can handle any immediate responses, errors, or follow-ups.

Supabase sends different responses based on the situation. Adding code to handle these scenarios is a good idea.

If the insert request is successful, the Promise resolves to an object with a “data” key containing the inserted records.

If there's an error, the Promise resolves to an object with an “error” key describing the error.

Here's an example of how to handle responses:

supabase.from('products').upsert(products).then(response => {
  if (response.error) {
    console.error('An error occured: ', response.error)
  } else {
    console.log('Inserted data: ', response.data)
  }
})

Remember, Supabase has a payload limit of 5MB for the REST API. Make sure your total data size doesn't exceed this limit. If it does, split the data and perform multiple insert or upsert operations.