#bytea

When I was trying to work out how to do this, I didn't think there were enough code examples for it. After a while, I did find an example on Stack OverFlow. This is it, but refined a little.

function formatImageForDB(path, callback){ fs.readFile(path,'hex', function(err, data) { if (!err) { data = '\\x'+data; askDatabase('INSERT INTO table_name (image) VALUES (data)', callback); }else{ console.error(err); callback(err); } });

OK. So what does this do? Above is a function called formatImageForDB, it takes the path to the image and a callback. It uses fs to read the contents as hex, if there is an error, it prints it to the console, otherwise it will preppend a '\x' to the start and will insert that data into the database. After inserting it, askDatabase will call the callback. Hex is used here because its super good. It doesn't affect the file contents.

function formatImageForDisplay(req,res){ sql = "SELECT image FROM table WHERE id=1"; askDatabase(sql , function(err, result){ if (err) { console.error(err) } console.log(result); if (result.rowCount === 0){ console.log("not sending image") res.sendFile(__dirname +"/public/test.jpg"); } else if (result.rows[0].image == undefined) { console.log("not sending image") res.sendFile(__dirname +"/public/test.jpg"); } else { fs.writeFile('public/foo.jpg', result.rows[0].image, function (errr) { console.log("sending image"); res.sendFile(__dirname + "/public/foo.jpg"); } }) }