I'm working on a solution to solve an existing inconvenience. Some "smart" containers send an alarm via text message when they're full. The number it sends to is a personal phone number from a worker in the company. The ideal would be to send some e-mails alarming the chosen people and maybe save the history on an local database.
To solve this, I thought I would use a GSM modem with a sim card connected to a computer or Raspberry via RS232-USB and program it using Java. When I was in the Uni I used the Siemens Tc65 on a very similar application, but I think that's kinda of old now and still a bit expensive. Which newer alternatives are there right now using 3G or 4G? I'm familiar with the SIMcom modules, I'm using the Sim800L on a different project, but they're a pain in the ass to work with and it's just a little board, I want something more reliable like the Tc65.
Also, is there a better/easier/more professional way to approach this?