关于外部树莓派数据库的问题

Question

Okay so I need to have a server with a databse for a smartphone applications I'm working on, and there are a few requirements.

-SQL database

-Returns queries with JSON

So i had this old Raspberry Pi laying around and i wanted to set it up for it. But theres something im uncertain of, and google haven't helped me yet.

I planned on use SQLite on the Pi, and wanted to interact with it in PHP. Then use the PHP to convert into JSON, which would then be retrieved by the smartphone. The thing is i don't know what service i can use on the PI to make this .PHP file able to be found from another device

Answer 1

You can install nodejs by running:

sudo apt-get install nodejs nodejs-legacy npm

For SQL database you can run

sudo apt-get install mariadb-server mariadb-client

Install your nodejs mysql module by:

sudo npm install -g node-mysql

That should get you started.