I think it would nice to put all user content into the database (pictures, comments, everything). With this someone could backup their entire site by a database backup. New versions of nGallery could include sql script(s) to update the schema. This would make
it alot easier for someone to write a webservices interface to manage the galley via a winapp. Jason, Can you add me to the developers mailing list? madmunki(at)ngallery(dot)com > ngallery(at)madmunki(dot)com. Thanks!
We've talked about having pictures stored in the database and decided against this. It creates more complexity than it is worth. There is debate back and forth as to which is "faster"... on the filesystem where you just have to open a file, or in a database
where it is transferred over a network (even if it is on the same machine, it still goes through network transfer components). Some problems are if the DB server is on a different machine, it will be slower, and also, a lot of nGallery users use webhosts and
webhosts could put a cap on the size of rows, which pictures could easily exceed. It would also slow down their DB servers, which they might not like.
It would be a nice feature to have - backups are a lot easier and content is "cleaner". I am aware that there is a lot of work to be done if this is the case though. (Just popping up so that theres another vote for the 'other' side :)
I agree. SQL it. So what if it's a little more complicated to implement. There are ppl out here that can deal with it. Who cares what's faster, i'm willing to wait the couple extra seconds in the time it will save on the other end. I would like to at least
have the option to go SQL especially since I serve up my own pages and would like to learn how to use sql to manage a image database, since I haven't found a good tut for it. Anyone know where I could find one since this doesn't quite cut it?
None
0 Points
5 Posts
sql database all user content?
Dec 23, 2003 02:42 PM|madmunki|LINK
None
0 Points
395 Posts
Re: sql database all user content?
Dec 30, 2003 04:02 AM|qgyen|LINK
None
0 Points
4 Posts
Re: sql database all user content?
Jan 17, 2004 07:04 AM|Zak McKracken|LINK
None
0 Points
5 Posts
Re: sql database all user content?
Jan 21, 2004 08:43 PM|studionnn|LINK