2009/3/19 Nuno Magalhães <nunomagalh...@eu.ipp.pt>: > Yeah, a religious question, i know, but what's recomended?... > > I have a small site that may have some images for some products. Said > products may also have descriptions. I have other small sites and one > where i'd like to manipulate large texts (say around 5 paragraphs... > ~5000 characters). > > What's recomended: to store strings that are the /path/to/textfile or > /to/image.jpg? Or to store the image file in the database? the text > file in the database? Which datatypes to use?
SQLite has only two relevant dataypes for you... TEXT and BLOB. If you don't have a bazillion records of text and images that are megabytes+ in size, it is likely 6 of one or sqrt(36) of the other. Storing everything in a db will give you the convenience of managing only one file, of not having to cook up a file naming and storing scheme, and so on. Storing them on the filesystem will not tie you down to always using the db to access your files. Try one, then try the other. Use what you prefer. > > TIA, > Nuno Magalhães > LU#484677 > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Carbon Model http://carbonmodel.org/ Open Source Geospatial Foundation http://www.osgeo.org/ Sent from: Madison WI United States. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
