[Effexion]

Let's say I need to store a dataset of around 16 columns and each user needs their own database or table. I obviously can't hardcode the database's name:

https://pastebin.com/9Xa5jB0y

So, I was thinking of making "DATABASE_NAME" a variable but I just can't fathom how I would do this (after a little research it seems this would be the easiest solution).

Anyone have any solutions?

[tweety]

Let's say I need to store a dataset of around 16 columns and each user needs their own database or table. I obviously can't hardcode the database's name:

https://pastebin.com/9Xa5jB0y

So, I was thinking of making "DATABASE_NAME" a variable but I just can't fathom how I would do this (after a little research it seems this would be the easiest solution).

Anyone have any solutions?

just use a random string?

[Effexion]

just use a random string?

That wouldn't work as it would still be hardcoded. I need it to be dynamic.

[sdk]

That wouldn't work as it would still be hardcoded. I need it to be dynamic.

He means generate the random string, But personally you could use the usersId to make sure you can make the relation.. If you have todo this for just 16 columns see my later explanation, relationships are you're best friend in databases

Code

db.main {
  table.users {
    id
    email
    ...etc that doesnt need to be in the other DB
  }
}

db.userId {
  ...stuff
}

All though I would personally say this is bad design, most things like this can simply be taken care of with relations

Code

db.main {
    table.users {
        id
        email
        ...etc
    }
    table.usersStuff {
        id
        userId
        ...etc
    }
}

[Quad]

There usually isn't a reason to give each user their own database, and my best guess is that you don't it either. Explain your problem in detail here, and we can give you a good database design, or look up some tutorials on relational database design.

[Nachfolger]

There usually isn't a reason to give each user their own database, and my best guess is that you don't it either. Explain your problem in detail here, and we can give you a good database design, or look up some tutorials on relational database design.

This.

Either I missed your point OP, or there is not even a reason to randomly generate a database name. Reconsider your application design before it's too late.