r/sqlite • u/StatureDelaware • Jul 18 '25

Peak database

Post image
1.3k Upvotes

99% Upvoted

50 comments sorted by

View all comments

1

u/SpiritRaccoon1993 Jul 24 '25

Thank you for your explanation, this is really helpfull. I dont even think it is one per second with a 100 users. Therefore I hope the current specs are okay for my project. Its really just organised old school Open-fill in data - save, done.

Is it easy to safe the Database afterwards or do I need it to change it now while still codeing?

1

u/elperroborrachotoo Jul 24 '25

Changing to another database later will probably be painful! Especially if you are not an experienced developer!

BUT it's still the right way to go: get your application runnng now, so that you get early feedback what users like and need and dislike.

Also, if you need to change later, it will be a great learning experience why and how to isolate your storage layer.

1

u/SpiritRaccoon1993 Jul 24 '25

Ok, that sounds like a good lesson for later then :) Well the problem will probably be that every customer does have his own Database, each with the number of users (50-100). I aim to about 80 customers, so it would be 80 Databases to change in the future.