01-24-2009, 08:32 AM
I just read that one of the advantages of SQLite is that everything in the database is essentially all in one file and that file can be up to around a Terabyte.
This would be probably be sufficient but could imagine in the scenario where I do store lots of images, that the users could exceed that. So I think I will figure out a way to do it as you suggested with separate media files location but the "index" and regular text informaiton in the sqlite database. Just ordered online some books about sqlite and databases in general so hopefully can make some progress here.
Thanks for your suggestion!
Stuart
ps. Thanks again for QM - the successes I have had in programming with it is are one of the most enjoyable and gratifying things in my life (I don't know what that says about my life!!!!
, but true nonetheless!!
This would be probably be sufficient but could imagine in the scenario where I do store lots of images, that the users could exceed that. So I think I will figure out a way to do it as you suggested with separate media files location but the "index" and regular text informaiton in the sqlite database. Just ordered online some books about sqlite and databases in general so hopefully can make some progress here.
Thanks for your suggestion!
Stuart
ps. Thanks again for QM - the successes I have had in programming with it is are one of the most enjoyable and gratifying things in my life (I don't know what that says about my life!!!!
, but true nonetheless!!