Rescuebox: add backend database like postgres or mqsql

we need a backend database that model plugins can use to persist images /data.

current implementation uses chromadb for vectordb , sqllite for frontend , but there is no db for frontend.

we need the db to be open source and supported on windows 11. this is mandatory , mysql / postgres is top choices here.

PostgreSQL + pgvector -this is a powerful combination why not adopt it ?

can we add this db and also provide a py library to make it easy to use from plugin ?

complex task could be to provide py/typescript library to integrate backend and frontend, for exampe , frontend fires off a task, backend runs task and updates status to frontend db. if backend reboots or restarts can fetch pending jobs and run them to completion .