Scrapy reversed item ordening for preparing in db
Items in a database are have not a special order if you don't impose it. So you should add a timestamp to your table in the database, keep it up-to-date (mysql has a special flag to mark a field as auto-now) and use ORDER BY in your queries.
I am trying to put the items, scraped by my spider, in a mysql db via a mysql pipeline. Everything is working but i see some odd behaviour. I see that the filling of the database is not in the same order as the website itself. There is like a random order. Probably of the dictionary like list of the items scraped i guess.
My questions are:

how can i get the same order as the items of the website itself.
how can i reverse this order of question 1.

So items on website:

A
B
C
D
E

adding order in my sql:

E
D
C
B
A