Example api with nodejs and express framework

express_random.js

express = require('express');
sqlite3 = require('sqlite3').verbose();
http = require('http');
exec = require('child_process').exec;

db = new sqlite3.Database('/var/www/apps/shared/songs.db');
app = express();

app.listen(9999);

app.get('/songs/random', function(req, res) {
  db.get('SELECT * FROM songs ORDER BY RANDOM() LIMIT 1;', function(err, row) {
    res.send(row);
  });
});

app.get('/words/random', function(req, res) {
  exec('shuf /usr/share/dict/words | head -1', function(err, stdout, stderr) {
    res.send({ word: stdout.trim() });
  });
});