multiple projects on same database

[Héctor Urbina]

Hello,

I'm developing a django project for my office, a small project management system. I'm doing some tries to incorporate a third party document management system, namely mayan-edms, by making use of the same database, so that users maintain theirs credentials. Is that good practice?.

Greetings,
Héctor.

[Camilo Torres]

Hello.

You can use the same DB, but different schema or different user. You can also use the same schema as long as table names (and other objects names) din't match.

I recomend to use diferent schemas for different web apps.

Camilo.

[Héctor Urbina]

Thanks Camilo,

I understand a schema just as a database, so if I use another schema I will be creating a new database and then the auth tables will be duplicated on this new database (or schema). With that, I won't get what I want, that is, only one set of tables with users' information. I'm using mariadb (mysql), I don't know if schemas mean something different in other db engines...

Do you have any examples or places where I could learn more about your solution? I'm surely missing some things.

Greetins,
Hector.

[Camilo Torres]

Hello Hector,

It seems that using 2 different databases will cause duplicate schema (tables) and duplicate data. So in your case I prefer to change my mind and recomend you to use a single database. In general I don't see any problem with that.

Regards,
Camilo.