Hey everyone! I'm currently working on a web application that's similar to Leetcode. It's my first time diving into creating a web app, and I've already made some progress on the front end. Now, I'm looking to set up a database to store lists of problems for users to solve. I've heard good things about both SQLite and PostgreSQL, but I'm not sure which one would be the best fit for my project. Since the problem lists won't be too large and won't change often, I'm leaning towards using SQLite because I've heard it's pretty straightforward to get started with. However, I'm also considering adding a user account feature, which might require a more robust database like PostgreSQL due to more frequent updates. I've thought about using both databases—SQLite for the problems and PostgreSQL for user management—but I'm unsure if that's a smart move. Any insights on the best approach? Thanks in advance!
1 Answer
I think you’re on the right track! SQLite is great for smaller projects and it’s super easy to set up. Just keep in mind that if your app scales, you might hit some limits with concurrency. If you're just learning and not expecting a huge load, stick with SQLite for now. Also, consider how you're planning to deploy the app; that can affect your database choice too! Let us know more about your setup for better advice!
Right now, I'm focusing on React for the front end and using .NET for the back end, but they will be separate projects for now.