20 May
2011
20 May
'11
3:40 p.m.
On Thu, 19 May 2011 17:51:50 +0300, Tõnu Samuel <tonu@jes.ee> wrote:
I think best way to implement this is to introduce field type "file" which is stored outside of usual data storage. Only his physical location on disk is stored in MyISAM or similar. This is exactly same as people keep file name in CHAR currently but we provide method to fetch file contents with same query. Also we can implement cool replication to keep same file on all servers consistent, way to backup things via mysqldump etc....
Have you seen PrimeBase Blob Streaming? It does this. stores blobs sep from main table, gives http interface. -- Stewart Smith