I am creating an email client that will contain email messages. Now a message may have multiple large attachments.
1.) Would the best way to store these large objects be in an oid field?
2.) I assume for performance reasons I should place these large objects in a separate table called attachments. And create an attachments table for each user?
3.) Only when a user clicks on an attachment to open it, should I use server side SQL functions like lo_export and lo_open to read the data to a file stream for my application to deal with?
Am I on the right track or can anybody recommend a better solution?