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!

Curious to know, can this setup handle very datasets efficiently?

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!

Awesome work, @notrab! The concept of a database per user is truly innovative, and leveraging Multi-DB Schemas makes it even better. I can already see how this will simplify many developers' workflows. Looking forward to exploring the repo and testing it out, especially the demos you've put together. Any plans for a following AMA to discuss best practices? Keep it up!

Congrats on the launch of the Turso Per User Starter, @notrab! This is a game-changer for multi-tenant applications, especially with the per-user database capability. I'm excited to see how this will enhance scalability and UX. Looking forward to exploring your repo and trying it out! Keep pushing the boundaries!

This sounds incredibly innovative! 🚀 The idea of a database per user using Turso's Multi-DB Schemas is fascinating and opens up so many possibilities for customization and security. 🛠️ Quick question: Are there any specific use cases or industries you’ve found where this "per user" database model shines the most? Would love to hear more insights and check out the repo! 👏 @notrab

Great Product! Now, this is even more amazing! All the Best for the Product Hunt Launch!

Amazing product and work from the Turso team! Using it extensively in our new product.

I stumbled upon this tool through an ad and it's interesting but I'm not convinced yet, multi-DB schemas still being in beta makes me wonder how stable this whole thing is and what if it crashes with many users, also, are there any plans to improve the UI or add support for other database types

So you're saying we should test this "per-user" database thing? Seems cool but honestly the "Multi-DB Schemas" being in beta makes me cautious, any plans on stabilizing that soon or adding more features to it?

This looks like a super useful tool for anyone creating multi-tenant apps, love how you pushed the multi-db concept from per-tenant to per-user, definitely helpful in making database management easier, curious where you see this going in the future, like maybe integrating with other types of databases or adding more customization options, have you looked at similar tools like Supabase or Firebase to see what features they offer?

Found this through a friend's recommendation, saw the potential in creating a database per-user but honestly the whole "Multi-DB Schemas" thing is still pretty confusing, and it's kind of frustrating that it's still in beta, any plans to make this more user-friendly anytime soon?