Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BFA114607 for ; Thu, 23 Jun 2011 03:40:32 +0000 (UTC) Received: (qmail 780 invoked by uid 500); 23 Jun 2011 03:40:30 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 99899 invoked by uid 500); 23 Jun 2011 03:40:21 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 99890 invoked by uid 99); 23 Jun 2011 03:40:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Jun 2011 03:40:18 +0000 X-ASF-Spam-Status: No, hits=0.7 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_HELO_PASS,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [74.208.4.194] (HELO mout.perfora.net) (74.208.4.194) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Jun 2011 03:40:09 +0000 Received: from [192.168.0.103] (71-36-43-201.tukw.qwest.net [71.36.43.201]) by mrelay.perfora.net (node=mrus0) with ESMTP (Nemesis) id 0LgrYU-1RMLbC3nni-00nxuX; Wed, 22 Jun 2011 23:39:47 -0400 Message-ID: <4E02B5B8.1000009@surfworx.com> Date: Wed, 22 Jun 2011 20:40:40 -0700 From: Don Ledford Reply-To: don.ledford@surfworx.com User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.17) Gecko/20110424 Thunderbird/3.1.10 MIME-Version: 1.0 To: user@cassandra.apache.org Subject: Re: Storing files in blob into Cassandra References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:YVelPAs0EbWzHEbL9gld/MHovryvL/lFYqjepADxwrl RHPSZYccltiRuKhnr8E9qlVGviTrG9lCraoMU9j2TZV/UdpOH7 HpuI/u/1vENL/8+dMKvI/QiIZkVE1mJOv0T+DbFd8Kk/77YkwJ GpmKfztNUJcDdFk+9nFvFGbMNvNJk4+3EZPRtJmKSIviFzgZuR Rpe4divy3uHjJpOtwWCTryu5jhAoPIrFNVYSXQvnZY= On 06/22/2011 01:23 AM, Damien Picard wrote: > >store your images / documents / etc. somewhere and reference them > >in Cassandra. That's the consensus that's been bandied about on this > >list quite frequently I store large files in Cassandra using columns for file blocks. I have a simple blob class over the top of this which handles input and output streaming so reads/writes are only one column at a time. I don't have time to post the details, but it's pretty simple - each blob has it's own key and it's blocks are the columns. Column names are essentially the block number. I prefer this since there's no need to deal with yet another disk store and it's associated security, redundancy, and cost. - Don