Search code examples
pythoncsvweb-applicationsflask

Somthing wrong with using CSV as database for a webapp?


I am using Flask to make a small webapp to manage a group project, in this website I need to manage attendances, and also meetings reports. I don't have the time to get into SQLAlchemy, so I need to know what might be the bad things about using CSV as a database.


Solution

  • Don't do it, CSV that is.

    There are many other possibilities, for instance the sqlite database, python shelve, etc. The available options from the standard library are summarised here.

    Given that your application is a webapp, you will need to consider the effect of concurrency on your solution to ensure data integrity. You could also consider a more powerful database such as postgres for which there are a number of python libraries.