Member Avatar for jckb188

Hello,

I am somewhat new to databases and just had a quick question on database structure when incorporating users.

When building the schema, does anybody have a best practice as whether to put users in a separate database apart from the content, or to put the users into the same database in a different table?

Thanks for any info you might be able to provide.

  • 2 Contributors
  • 1 Reply
  • 101 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by rch1231
Member Avatar for rch1231

Hello,

Generally you put them in a different table in the same database but you do not have to. You can use a different database but you have to establish a connection to that database too. It is easier to connect to one database and make the table only readable for login.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.