Per User Database Starter - Build database per-user apps with SQLite

I've been fascinated with the ability to create a database per-tenant since I first discovered Turso, even before I joined the team. Soon after I joined I wanted to see if it was possible to push the boundaries of that to "per user". Turso introduced earlier this year a product called "Multi-DB Schemas" which lets you create a database using another databases schema. With this feature, the idea of creating a database per-user isn't so difficult. Almost all of my demos using Turso use this feature, so I decided to put together a repo containing the code to get started! "Multi-DB Schemas" are still in beta, so let us know what you think, and what we can do to improve.

Great product! Been using it for well over a year now, rock solid! Congratulations on the launch @notrab

Cool idea. Would love to give this a try in the future.

Amazing work, @notrab! The concept of having a database per user with the help of Turso’s Multi-DB Schemas is quite innovative. The Next.js boilerplate looks super useful for developers. Are there any specific security considerations we should keep in mind while implementing this?

What are the main advantages of having a database per user, over traditional multi-tenant databases would you say?

Making everything better

This looks great, @notrab I love how much you and the Turso team are constantly innovating. I mean the isolation this provides alone is amazing. I can't wait to check it out!

Cool concept @notrab Good luck with launch today!

Congrats! The flexibility of creating a database per user is incredibly powerful for developers. @notrab

Hey Jamie, The Per User Database Starter sounds like a powerful tool for building multi-tenant applications. How does it handle scaling as the number of users increases? Congrats on the launch!