Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Adrian Klaver
On 12/17/2014 07:37 PM, Arthur Silva wrote: This! I'm surprised it took so long to somebody suggest an object store. I thought they did, a file system:) On Dec 17, 2014 9:22 PM, "Jonathan Vanasco" mailto:postg...@2xlp.com>> wrote: I wouldn't even store it on the filesystem if I could a

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Arthur Silva
This! I'm surprised it took so long to somebody suggest an object store. On Dec 17, 2014 9:22 PM, "Jonathan Vanasco" wrote: > > I wouldn't even store it on the filesystem if I could avoid that. > Most people I know will assign the video a unique identifier (which is > stored in the database) and

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Jonathan Vanasco
I wouldn't even store it on the filesystem if I could avoid that. Most people I know will assign the video a unique identifier (which is stored in the database) and then store the video file with a 3rd party (e.g. Amazon S3). 1. This is often cheaper. Videos take up a lot of disk space. Havin

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Merlin Moncure
On Wed, Dec 17, 2014 at 3:39 AM, VENKTESH GUTTEDAR wrote: > Hello, > > I am using PostGreSQL 9.3.5 and DJango1.7.5 and python 3.3. > > I am working on a application where i will get video files from mobile > app, and i have to store in the server, >so my question is how do i store vide

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread John R Pierce
On 12/17/2014 4:55 AM, Thomas Kellerer wrote: Turns out the Postgres as well isn't really slower at this than the file system. For small files around 50k both perform similar: the average time to read the blob from a bytea column was around 2ms whereas the average time to read the blob from th

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Alan Hodgson
On Wednesday, December 17, 2014 01:55:46 PM Thomas Kellerer wrote: > Albe Laurenz schrieb am 17.12.2014 um 11:07: > > and the performance will be worse than reading files from the file system. > > There is a Microsoft research [1] (from 2006) which tested this "myth" using > SQL Server. It showed

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Vincent Veyron
On Wed, 17 Dec 2014 16:51:10 +0530 VENKTESH GUTTEDAR wrote: Hi Venktesh, [you should not reply directly to me; hit reply all to post your messages to the list] > > can you help me in achieving this, i mean how to store it in a file > system how to fetch it from there. Nope. It's not post

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Vincent Veyron
On Wed, 17 Dec 2014 13:55:46 +0100 Thomas Kellerer wrote: > > Another downside you didn't mentioned is the fact that you have to distribute > the files in the filesystem properly. > Having thousands or even millions of files in a single directory is not going > to be maintenance friendly either

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Albe Laurenz
Thomas Kellerer wrote: > Albe Laurenz schrieb am 17.12.2014 um 11:07: >> and the performance will be worse than reading files from the file system. > > There is a Microsoft research [1] (from 2006) which tested this "myth" using > SQL Server. > It showed that the database might actually be faster

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Alban Hertroys
On 17 December 2014 at 13:55, Thomas Kellerer wrote: > Albe Laurenz schrieb am 17.12.2014 um 11:07: >> and the performance will be worse than reading files from the file system. > > There is a Microsoft research [1] (from 2006) which tested this "myth" using > SQL Server. > It showed that the dat

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Thomas Kellerer
Albe Laurenz schrieb am 17.12.2014 um 11:07: > and the performance will be worse than reading files from the file system. There is a Microsoft research [1] (from 2006) which tested this "myth" using SQL Server. It showed that the database might actually be faster than the file system. As this

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Vincent Veyron
On Wed, 17 Dec 2014 15:09:40 +0530 VENKTESH GUTTEDAR wrote: >so my question is how do i store video's or video files in DB, or do i > need to store only the link of that video file, if yes then where i have to > store the file and how to access that file to display in an html page. If you

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Albe Laurenz
VENKTESH GUTTEDAR wrote: > I am using PostGreSQL 9.3.5 and DJango1.7.5 and python 3.3. > > I am working on a application where i will get video files from mobile app, > and i have to store in the server, > so my question is how do i store video's or video files in DB, or do i need > to store onl

[GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread VENKTESH GUTTEDAR
Hello, I am using PostGreSQL 9.3.5 and DJango1.7.5 and python 3.3. I am working on a application where i will get video files from mobile app, and i have to store in the server, so my question is how do i store video's or video files in DB, or do i need to store only the link of that v