I am building a control system for external equipment using an RPi4 box.
I have done a similar system 13-14 years ago on Windows using Delphi7 and ADO connection to a MSSQLServer database.
But that was not interfaced through Apache, I created a dedicated Delphi Windows service program instead.
Today I have moved to FPC/Lazarus on RPi4 and Raspbian and I want to use a web interface for user interaction.
Therefore I planned on using text files (ini format) for handling the user config.
But for other reasons it would be better using a database, and I think that SQLite would be OK because there are not so much data to handle and it is not a massively multiuser thing either. Probably zero external users most of the time...
But it needs to be possible to interface from FPC and PHP (on webserver) and run on RPi4B with Raspbian Buster.
I have found this info:
SQLite with LazarusBut it deals with a GUI program and my program is not, it is a command line program run from cron.
And then there is the web interface through PHP7....
One of the first lines in the doc page I linked to states
SQLite is an embedded (non-server) single-user database
Does this disqualify SQLite as database if I also want it to be reachable from Apache?
If so what could I use instead?
And is there some example of non-GUI use of SQLite in an FPC command line program somewhere?