Boris Köln

if (fs.existsSync('ssl/cert.key') && fs.existsSync('ssl/cert.crt')) {
    options = {
      key: fs.readFileSync('ssl/cert.key'),
      cert: fs.readFileSync('ssl/cert.crt')
    };
    server = require('https').Server(options, express);
  } else {
    server = require('http').Server(express);
  }

  io = require('socket.io').listen(server);

-- выполнять по cron или trigger
DROP TABLE IF EXISTS my_table_pos;
CREATE TABLE my_table_pos (id int, pos int NOT NULL AUTO_INCREMENT, KEY `my_table_pos_id` (`id`));
INSERT INTO id_pos (id) SELECT id FROM my_table ORDER BY my_sort;


SELECT my_table_pos.pos FROM my_table, my_table_pos WHERE my_table.id = my_table_pos.id AND my_table.username = 'Женя';

литературу вроде прочитал