We would like to use Node JS as the backend to interact with sqlite3 databases and provide RESTful APIs from Omega2.
We have both Node JS and npm installed using opkg package manager according to Omega's document: https://docs.onion.io/omega2-docs/installing-and-using-nodejs.html
However, when we try to npm install any package - ex. "npm install sqlite3", the command will take a very long time to execute, and will return with errors containing message such as:
FATAL ERROR: Malloced operator new Allocation failed - process out of memory
(We've tried to installed few other npm packages, but all of them end up with the same error)
It seems that the reason for such failures is that the npm and NodeJS versions provided by the LEDE package feed is too old (v2.14.12), so it won't work with most of the npm packages (are there any plans to support newer versions of NPM and NodeJS?)
It looks like in order to achieve what we need: having the Omega2 interacting with Sqlite3 and providing RESTful APIs, we are only left with PHP implementation, are there any alternatives? and will the PHP work with Sqlite3 as promised?