blobstorage

What is the correct way to backup ZODB blobs?

I am using plone.app.blob to store large ZODB objects in a blobstorage directory. This reduces size pressure on Data.fs but I have not been able to find any advice on backing up this data. I am already backing up Data.fs by pointing a network backup tool at a directory of repozo backups. Should I simply point that tool at the blobstorag...

Is there a good application for managing a SQLite 3 database with BLOB data type?

I want to create and manage a database with images and or audio clips. I know it's not the best idea and I know there are better options, but it's the easiest way to have the data separate from the programming and I'm not the one writing the code. So I need an application that will allow me to edit the database that the application is ...

plone.app.blob or z3c.blobfile?

I need a blob file field as part of a content type in plone. plone.app.blob's BlobField should provide this, but I can't find how to get a URL to download the file including the original filename (e.g. http://plone.site/plone/obj/orig-file-name.avi). Is there a way to do this using plone.app.blob? Alternately, there are a few pointers o...

Stroring values in TBlobField using sql

I want to store images into a database using SQL commands, I know other ways using TBlobField.LoadFromFile etc, but we make our own sql commands to update the database that's why I need to do this. Any suggestions / pointers to how I should go about doing this? Sandeep ...

Storing images in DB vs in Folder Structure

I understand it is possible to store images in Databases as Binary large objects. But I used to see in some forum web applications that they are stored as flat files in web server machine and retrieved when needed. What is the advantage and disadvantage in both methods? When to go for which approach? ...

[wxWidgets] How to store wxImage into database, using C++?

I have some wxImages and I would like to store them into a BLOB (Binary Large OBject) field in a MySQL database. There are no methods in wxImage nor wxBitmap for obtaining the binary data as an array of unsigned char so I can load into the database. My current workaround is to write the image to a temporary file, then load the BLOB f...

What are the reasons to store documents into DBMS when using Alfresco CMS

Hello guys! I have interview for an internship with company that wants to implement document management system and they are considering on the first place open source solutions, their top choice being Alfresco, but decision is still not final, part of my work there would be to investigate is Alfresco the best solution. What I have seen...

Can't create blob container on Azure Blob Storage

The following code throws an error on the "CreateIfNotExist" method call. I am attempting to connect to my Azure Blob storage and create a new container called "images" var storageAccount = new CloudStorageAccount( new StorageCredentialsAccountAndKey("my_account_name", "... my shared key ..."), "https://blob.core.windows.net/", ...

Error mounting CloudDrive snapshot in Azure

Hi, I've been running a cloud drive snapshot in dev for a while now with no probs. I'm now trying to get this working in Azure. I can't for the life of me get it to work. This is my latest error: Microsoft.WindowsAzure.Storage.CloudDriveException: Unknown Error HRESULT=D000000D ---> Microsoft.Window.CloudDrive.Interop.InteropCloudDri...

MySQL data is too long for column occuring on LONGBLOB

I have the following MySQL (version 5.1) table (InnoDB): Username varchar(50) Sequence int(11) FileType varchar(10) Photo longblob -- here PhotoSize int(11) Timestamp datetime Attempting to insert a byte[] 96.7KB fails with the error: Data Too Long For Column 'Photo' At Row 1 Inserting byte[] (size 37.2KB) works fine. ...