Sensor network (arduino nano + nrf24l01 + ds18b20)

Hello
I am going to do a sensor network project at home.
I mean 1-40 independent devices (node), because in the future I would also like to add switches and google asistanc, but in the future.

Now I am at the stage of creating the concept that in the future I will be able to develop my basic network of several temperature sensors that I want to do now, what I want in the future and without changing the database and applications.

1 My main question is whether raspberry pi will be able to support so many devices (of course, some devices will send data once in a while)

2What to use to think about the creation of the node are esp-01s and NRF24L01
I do not hide I'm inspired

but will it actually work so easily?

3How to collect data from the node? I've read something about MySQL or will it be a good choice?

I am considering many options if you have something that could help me thank you in advance. I am counting on your opinions as to what I want to do

Your problem or question is not at all clear. One moment you are talking about a RaspberryPi, then about nRF24L01+ transceivers and then about ESP8266 WiFi modules.

I suspect the greatest future flexibility would be to set up a WiFi server with an RPi and use ESP8266 (or ESP32) WifI modules to collect data from each sensor and send it to the RPi. I reckon that would be no more difficult and a lot more future-flexible than a network of nRF24 modules.

Every nRF24 will need to be coupled with an Arduino whereas the ESP modules can operate standalone. And you will also need some means to get the nRF24 data into the RPi for the database.

You can easily run MySQL on an RPI, though, IMHO SQLIte would be perfectly adequate and a lot simpler.

...R

Thank you for your response and accurate observations.
Are you talking about ESP8266 that big one? because it seems to me that this ESP8266-01s will also be ok and even smaller.

AFAIK the only difference between the ESP8266 modules is the number of available I/O pins. If the ESP8266-01 has enough I/O pins then use it.

You can also get the ESP8266 modules without a PCB if you want a really small device. This pic is an ESP8266-07. Note that the header pins I used have 2mm spacing and I cut off the pins I did not need.

Boards like the Wemos D1 make connecting and programming easier.

...R