Paolo RedaelliThanks adamchainz!
You can use “CSV” table storage in (at least) these database backends:
- SQLite: https://www.sqlite.org/csv.html 42
- MySQL/MariaDB via the “CSV” storage engine: https://dev.mysql.com/doc/refman/8.0/en/csv-storage-engine.html 15 . Or MariaDB via the CONNECT storage engine: https://mariadb.com/kb/en/connect/ 1
However these will be slow though. Changes to CSV based tables require a lot of parsing and re-saving.
It’s probably better to import the CSV into a table with an optimized storage engine, and export it again later. django-import-export can help with that: https://pypi.org/project/django-import-export/
Source: Using CSV File as data storage and access