I have been working on a side project and have been looking at setting up my database in a manner that would allow for increasing scale in the future.

I have been reading up on Azure Elastic Databases and shards, however been unable to really figure out how to implement the entire thing into a web app (.net core). I was wondering what other people do to set up their project for potential increase of scale.

Right now my idea is currently to have one database full of all user accounts and web app specific data, and another database to hold all the information for the users projects they can create. Which would all be linked through a tenantId or something along those lines.

Though was wondering what others use for their side projects and if they even do multiple databases or use a single one and call it good.