-1

I'm trying to build an API for a react project and I'm unsure of how to build an API.

I have a CSV file with all the data.

I've used api-platform via PHP but every time I try to input the CSV into the tables in Sequel Pro it crashes.

I'm now thinking of using node.js.

Very confused as to which technology to use and the best approach to my problem.

Looked at many articles and tutorials that have helped build a basic RESTful API however none of them address how to add a CSV file into the tables or database.

helpmepie
  • 244
  • 1
  • 6
  • 19
  • 2
    Possible duplicate of [Import CSV file into SQL Server](https://stackoverflow.com/questions/15242757/import-csv-file-into-sql-server) – FMK May 07 '19 at 09:31

2 Answers2

0

I think python can handle CSV files better. You can create API using Django.

Sangam Rajpara
  • 652
  • 3
  • 12
0

My personal recommendation when building an RESTful API in Node.js is to use express.js. Easy to get started with and has many plugins.

Other possible frameworks that I can think of right now:

For reading and writing CSV-files, take a look at this article

Jezpoz
  • 179
  • 1
  • 7