Re: [Tutor] File storage vs DB storage.

2007-04-11 Thread Christopher Arndt
OkaMthembo schrieb: > Indeed, using directories may be a better bet when there are many files > involved. At least, this has been my feeling, and i gather the same from > your replies. I suggest that you take a look at a database abstraction layer or ORM like SQLAlchemy [1], that makes handling th

Re: [Tutor] File storage vs DB storage.

2007-04-11 Thread Alan Gauld
"OkaMthembo" <[EMAIL PROTECTED]> wrote > I'll be using Lighttpd + FastCGI + Python + MySQL on > Win. XP SP2. Any known caveats of this combo > before i plunge? That should be fine I think. Alan G. ___ Tutor maillist - Tutor@python.org http://mail.

Re: [Tutor] File storage vs DB storage.

2007-04-11 Thread OkaMthembo
Thanks, gentlemen. Indeed, using directories may be a better bet when there are many files involved. At least, this has been my feeling, and i gather the same from your replies. I'll be using Lighttpd + FastCGI + Python + MySQL (maybe PostGRE here) on Win. XP SP2. Any known caveats of this combo

Re: [Tutor] File storage vs DB storage.

2007-04-10 Thread Alan Gauld
"OkaMthembo" <[EMAIL PROTECTED]> wrote > Ok, to get to the point: when building a web app that should store > an > retrieve photos, what would be more efficient between the app > storing the > files on a local hard disk, or saving blobs/ binary data to a > database? > Someone toldme that databa

Re: [Tutor] File storage vs DB storage.

2007-04-10 Thread Hugo González Monteverde
Hi, Managaing a lot of files is not a nightmare if you use/build the right tools. Why not saving filenames in the DB and then just using the ordinary web server to deliver them? Getting the blob out of the DB and then serving it through the web app is going to be a lot slower than letting, say

[Tutor] File storage vs DB storage.

2007-04-10 Thread OkaMthembo
Hello all, Im a newbie and am currently going through the Python Tutorial for the second time. At work, i use C#, but what a delight Python is! Ok, to get to the point: when building a web app that should store an retrieve photos, what would be more efficient between the app storing the files on