db design for hosting site

2004-08-31 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- I have a web hosting picture gallery service at http://web-folio.net/ and am thinking about how to do the next version, which will store the media files in the filesystem but pretty much every thing else in a database (like it should

Re: db design for hosting site

2004-08-31 Thread Martijn Tonies
Since I want the ability to mirror, it seems that I'll probably want one single DB replicated across my hosts so that comments and so on stay up to date (I still haven't crossed the bridge of how to keep the library itself in sync thru something like unison or rsync, but I do know that I

Re: db design for hosting site

2004-08-31 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Martijn, et al -- ...and then Martijn Tonies said... % % Since I want the ability to mirror, it seems that I'll probably want one ... % really don't want to keep the files in the DB itself). I'm open to ideas % of why I wouldn't, though. % %