For storage purposes, not for frequent reads.
Is there a standard?
If I use simply CSV, all fields would be forced to be strings. Also, it will not be validated. (I can still validate externally, though.)
An easy way would be to use SQLite, will be notify next users about the schema; but does it really validates? (I think I can put INTEGER in TEXT field. But, NOT NULL can be helpful. UNIQUE is +/- helpful.)
So, how about SQLite with .meta table, or are there better options?
Another thought is *.ndjson with JSON schema. XML schema is valid too, but I know too little about XML to use it. -- Both of which, file sizes can be bloated...
Top comments (3)
If you use JSON you can also store multisimensional arrays. It will be saved as a string but you can convert it in your code. What language do you use?
Antother way is to use MySQL. There you can define the type (bool, int,...).
I use primarily Node.js.
MySQL is OK, but I am thinking about export format. Multiple files should be OK, as long as they are zipped.
JSON....or build your own data standard 😉