Re: Data architecture question

One thing to note - the BLOB field, which will hold anything, can store GIGS of data. Show me an article that big and I'll eat my keyboard. I use a text field which will hold a measly 65535, but long text will hold 2^32, which is 4294967296 (aka a LOT of data). About formatting. I generally set up the main format of the page in PHP and then leave HTML specific to the article up to the user. Miester Code v0.6 will be shipping with an article engine and my searching class by default - it should be out in a few days. You can see it live at www.miester.org --Joe On Wed, Dec 13, 2000 at 04:38:27PM +0000, Ashley T. Howes PhD wrote: > This is not a specific PHP question, but more a data architecture > query. However I guess several of you have considered this more than > once. > > In developing a news site with many articles on it, what is best > practise for storing and administering the content? A specific > problem I have been examining is that each database field can store > only a finite number of characters. If the body of an article is > larger than this, what is the best approach for storage? One > solution might be to save the content in a text file with a unique > filename on the hd - but this must lead to slow queries as the data > is external to the db. > > What about specifying formatting of the content? Is the best > approach to place formatting tags in the copy which are interrupted > on the fly? How about images associated with the copy, should these > be saved to unique filename on hd, or is there a better approach? > > > Thanks for your help, > > > Ashley > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net --- Joe Stump PHP Programmer www.Care2.com