Added in VPOP3 Enterprise v9.1

This allows some messages to be stored in an external message store somewhere, accessed via S3, SFTP or similar

url = "https://s3.eu-central-1.wasabisys.com";
bucket = "<bucket name>";
accesskey = "<access key>";
secretkey = "<secret key>";
prefix = "extstore/";
 
function GetMessagesToMoveToExternal()
    local x = VPOP3.PostgresQuery("SELECT msgdataid FROM messages.msgdata WHERE NOT extmsg ORDER by msgdataid limit 1;")
    if x.Rows > 0 then
        return {x[1]["msgdataid"]}
    else
        return {}
    end
end
 
function DownloadFromExternal(msgid, data, filename)
    ret,retstr = VPOP3Net.S3Get(url, bucket, accesskey, secretkey, prefix .. msgid, filename);
 
    if ret == 0 then
        return true, data
    else
        return false, retstr
    end
 
end
 
 
function UploadToExternal(msgid, filename)
    ret,retstr = VPOP3Net.S3Put(url, bucket, accesskey, secretkey, prefix .. msgid, filename);
 
    if ret == 0 then
        return true, "abc"
    else
        return false, retstr
    end
 
end
 
function DeleteFromExternal(msgid)
    ret,retstr = VPOP3Net.S3Delete(url, bucket, accesskey, secretkey, prefix .. msgid);
 
    if ret == 0 then
        return true, "abc"
    else
        return false, retstr
    end
end
 
function GetTidyLocalHours(h, c)
    return 5, 1
end
 
function GetNextIterationDelay(r, d)
    return 10000;
end