New to WIP?

We're a group of makers shipping together. We help each other stay accountable and reach our goals.

Apply for access
Topics
πŸ‘¨β€πŸ’» Developers
Other questions
What steps are included in your CI pipeline you should have added sooner? 11 answers
AI to work with a lot of data (two usecases) 8 answers
Customer Support SaaS with unlimited brands support 2 answers
Does investing time and effort in social media marketing still make sense? 9 answers
Back
 Question
Asked

Is SQLite the easiest and fastest way to store data for a growing amount of data?

For #studiolist I want to store and access data as easily as possible. I thought about storing in large text files but the performance is probably not that good. Using SQL I would not be able to store the data in simple text files (as far as I know). Except for user-sensitive data these text files would contain publicly available data. Is SQLite then the best way?

Alexander Kluge
@alexanderkluge

πŸ‘‹ Join WIP to participate

Andres Inc22222
@z0dman

only if you had a SSD disk can be possible. Exist a lot of information on google. Sqlite database not support atomic transactions and can be lock when writing

 Reply