File types
Hi! I am experimenting with datastoring and I am kinda curious what is the best file type for reading, writing, removing and updating records. I am not thinking about some db but for example json, csv or yaml. File type that can be read and written line by line like csv and with possibility to remove and update records like json.
9 Replies
Json is probably going to be the easiest and best supported
But what will be the fastest for more amount of records?
with text it's a lose-lose 😐
You say "I am not thinking about some db", but your problem description makes it sound like you need a database. Just use SQLite and save yourself the headache.
Using json to hold and update a large amount of records, assuming everything is in the same file, isn't going to be very performant.
Okay, thank you guys. I was just curious
wasn't there a mysql text mode? but maybe it was readonly
Json is gonna be fine if you only deserialize and serialize at startup and shutdown
But if that's not the case, then do use a db like suggested
by the way you said json, csv, yaml, but there is also xml
I know