Stream tekst van en naar database met 1 http- en sql-request

source /home/samenty/nodevenv/socket/12/bin/activate && cd /home/samenty/socket

const http = require('https');
const hostname = '127.0.0.1';
const port = 3000;
const server = http.createServer((req, res) => {
  res.statusCode = 200;
  res.setHeader('Content-Type', 'text/plain');
  res.end('Ik kan <b>beginnen</b>.<br>');
}).listen(port);

server.listen(port, hostname, () => {
  console.log('Server running at http://${hostname}:${port}/');
});

{
	"name": "samentypen_socket",
	"description": "De socket die gebruikt wordt bij SamenTypen.nl",
	"version": "12.9.0",
	"dependencies": {
		"express": "^4.15.2",
		   "socket.io-adapter": "~1.1.0",
    "socket.io-client": "2.3.0",
    "socket.io-parser": "~3.4.0"
	},
	"main": "app.js",
	"scripts": {
		"startcode": "const express = require('express');"
	},
	"keywords": [],
	"author": "Eddy Erkelens",
	"license": "ISC"
}

const express = require('express');
const app = express();
const http = require('http').Server(app);
const io = require('socket.io')(http);

app.get('/', function(req, res) {
    res.send('Hello world!');
});

const server = http.listen(8080, function() {
    console.log('listening on *:8080');
});

returncode: 1
stdout:
> [email protected] start /home/samenty/domains/samentypen.nl/public_html/socket
> node index.js
stderr:
npm WARN lifecycle The node binary used for scripts is /home/samenty/nodevenv/domains/samentypen.nl/public_html/socket/10/bin/node but npm is using /opt/alt/alt-nodejs10/root/usr/bin/node itself. Use the `--scripts-prepend-node-path` option to include the path for the node binary npm was executed with.
internal/modules/cjs/loader.js:638
throw err;
^

Error: Cannot find module 'socket.io'
at Function.Module._resolveFilename (internal/modules/cjs/loader.js:636:15)
at Function.Module._load (internal/modules/cjs/loader.js:562:25)
at Module.require (internal/modules/cjs/loader.js:692:17)
at require (internal/modules/cjs/helpers.js:25:18)
at Object.<anonymous> (/home/samenty/domains/samentypen.nl/public_html/socket/index.js:4:12)
at Module._compile (internal/modules/cjs/loader.js:778:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:789:10)
at Module.load (internal/modules/cjs/loader.js:653:32)
at tryModuleLoad (internal/modules/cjs/loader.js:593:12)
at Function.Module._load (internal/modules/cjs/loader.js:585:3)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] start: `node index.js`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] start script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR! /home/samenty/.npm/_logs/2019-12-27T08_43_40_203Z-debug.log