Changing project id [May 02]

Discord-Discussions
21

:raising_hand_man: Shard replied

Unrelated: Can nocodb ā€œrememberā€ the external database so I donā€™t have to add credentials for every project I create?

22

:raising_hand_man: wkw replied

but you wanna create multiple projects with the same db?

23

:raising_hand_man: Shard replied

I guess that is the easier solution. Not sure if smart

24

:raising_hand_man: Shard replied

Just feels like a lot of work to create a new db for each project :thinking:

25

:raising_hand_man: wkw replied

what is your use case?

26

:raising_hand_man: Shard replied

So far I have separated into projects anything that feels like it makes sense to group together.

27

:raising_hand_man: wkw replied

lets say u hv a database dbA with 10 tables

if u create a project connecting to dbA, u ll see those 10 tables

if u create another project connecting to dbA, u ll see the same 10 tables

28

:raising_hand_man: wkw replied

changes done in first project will be reflected in the second project as well - as u change sth in db

29

:raising_hand_man: wkw replied

or your case s like u hv a db with 10 tables

first 5 tables r for project A

second t tables r for project B

?

30

:raising_hand_man: Shard replied

I use nocodb projects as groups only. So for example I could have a project named Bills with tables: electricity water heating etc.

31

:raising_hand_man: Shard replied

Then another project named Sports with tables named: running cycling swimming etc.

32

:raising_hand_man: Shard replied

and for those two projects I donā€™t really care if they are on same db or not. As long as they are grouped separately in nocodb

33

:raising_hand_man: Shard replied

or I mean I actually do care: as I donā€™t want to create 2 separate databases for these as it is simpler if they are on the same db

34

:raising_hand_man: Shard replied

maybe Iā€™m just approaching this bit weird. Maybe the ā€œcorrectā€ way to do that in this case is to have a project named ā€œMyNameā€ and then have all those 6 tables be under it.

35

:raising_hand_man: wkw replied

the ideal approach would be separate them - then 2 projects connecting to 2 differenet dbs

36

:raising_hand_man: wkw replied

if u reli wanna put them together - creating 2 projects to the same database s still possible

37

:raising_hand_man: wkw replied

but u ll see all tables

38

:raising_hand_man: wkw replied

there s another approach

39

:raising_hand_man: Shard replied

Yeah, ultimately I need to figure out where to draw the line for myself. How many projects will I potentially have and how granular I want the ā€œgroupingā€ to be.

40

:raising_hand_man: wkw replied

you can still store all tables under the same database n have multiple nocodb project