X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D51139DC851 for ; Thu, 9 Feb 2006 11:23:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61619-04 for ; Thu, 9 Feb 2006 11:23:50 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from moonunit2.moonview.localnet (wsip-68-15-5-150.sd.sd.cox.net [68.15.5.150]) by postgresql.org (Postfix) with ESMTP id 5196F9DC81C for ; Thu, 9 Feb 2006 11:23:43 -0400 (AST) Received: from [192.168.0.3] (moonunit3.moonview.localnet [192.168.0.3]) by moonunit2.moonview.localnet (8.13.1/8.13.1) with ESMTP id k19EQu0r001820; Thu, 9 Feb 2006 06:26:56 -0800 Message-ID: <43EB5D59.1030207@modgraph-usa.com> Date: Thu, 09 Feb 2006 07:18:49 -0800 From: "Craig A. James" User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Nate Byrnes CC: pgsql-performance@postgresql.org Subject: Re: Storing Digital Video References: <3cf983d0601311632t4a2f068au1f958746c2b092a7@mail.gmail.com> <200602060930.31144.albert@sedifa.com> <43EB475C.3040708@qabal.org> In-Reply-To: <43EB475C.3040708@qabal.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.093 required=5 tests=[AWL=0.093] X-Spam-Score: 0.093 X-Spam-Level: X-Archive-Number: 200602/78 X-Sequence-Number: 17064 Nate Byrnes wrote: > I must claim some ignorance, I come from the application world... but, > from a data integrity perspective, it makes a whole lot of sense to > store video, images, documents, whatever in the database rather than on > the file system external to it. Personally, I would use LOB's, but I do > not know the internals well enough to say LOBs or large columns. > Regardless, there are a lot of compelling reasons ranging from software > maintenance, disk management, data access control, single security layer > implementation, and so on which justify storing data like this in the > DB. Am I too much of an Oracle guy? Yes, you are too much of an Oracle guy ;-). Oracle got this notion that they could conquer the world, that EVERYTHING should be in an Oracle database. I think they even built a SAMBA file system on top of Oracle. It's like a hammer manufacturer telling you the hammer is also good for screws and for gluing. It just ain't so. You can store videos in a database, but there will be a price. You're asking the database to do something that the file system is already exceptionally good at: store big files. You make one good point about security: A database can provide a single point of access control. Storing the videos externally requires a second mechanism. That's not necessarily bad -- you probably have a middleware layer, which can ensure that it won't deliver the goods unless the user has successfully connected to the database. Craig