- CSV is a universally supported, easy-to-generate storage format but has issues like escaping, precision loss, and lack of type safety.
- Sqlite3 is recommended as a robust alternative, offering low overhead, type safety, accessibility, and public domain status.
- Other formats like Parquet, HDF5, JSON, CBOR, and LMDB have specific use cases but often fail in universal accessibility or performance.
- DuckDB provides exceptional analytic performance with columnar compression and multi-core processing, but it is not suitable for concurrent read/write.
- The ideal solution would combine DuckDB's intelligence with Sqlite's ability to allow data access during writing.