Support multiple bindings (databases/kv/vectorize) about core

[atinux]

Hey @RihanArfan

We indeed imagined the ability to switch between bindings but I did not want to make it too complex to start with, it's very rare the need for multiple databases / KV / R2 and also it may also complexify the admin.

But if we have to work on it, I would see it this way:

export default defineNuxtConfig({
  hub: {
    database: {
      // alias: BINDING
      default: 'DB', // always added
      users: 'USERS'
    }
  },
})

Then you can do:

const db =  hubDatabase() // default
const usersDb = hubDatabase('users')

We should not have to specify any ID as NuxtHub should take care of this for us.

[nicogenz]

Hey @atinux,

Your proposal looks really good to me. I just wanted to add some notes because I think there are definitely use cases where it makes sense to have multiple D1 instances, for example. Since D1 has a maximum limit of 10 GB (see D1 Limit Documentation), it might be useful to split data into multiple databases. Another use case could be to use one database for each customer in an application.

[atinux]

@nicogenz the main issue for having a use case as "one database for each user" is that you cannot add new database at runtime and you actually need to rebuild your website for the bindings to take effect.

[mendrinos]

@atinux, Can we also explore multiple R2 buckets per project?
For multi-tenant SaaS, isolating file uploads to separate R2 buckets per tenant is crucial for accurate cost mapping.