I'm using a raspberry pi 2B with raspbian lite. I have made a program that communicates with a LoRa module (RFM95, sx1276 chip) and collects data from a sensor. The data it collects, are stored in a file date.log and goes to Google Drive using third party software. Now I want to make an asynchronous TCP service to collect data remotely but storing data in a single file doesn't sound like a good idea. I'm thinking of using a database instead of simple files, like sqlite3 but I'm not sure about its performance.
Is it possible for a database to perform writes from more than one program?
Is it better to integrate my software into one program? Like the LoRa driver with the TCP listener together.