BLOB USAGE .. was: [PHP-DB] Interbase and PHP support.

On 5 Oct 00, at 23:44, Johan Hanson wrote: > On Wed, 04 Oct 2000, Giovanni Tummarello wrote: > > Hello all, > > i am about to start a large project that has some heavy requirements and are > > evaluating the use of Interbase. > > The BLOB functionality in the PHP interface is unstable. > The process running the blob function crashes when trying to insert a > blob ID into a table. > That is a pretty large flakiness. > Thanks for your reply.. I was thinking not to use blobs altogether.. but to use links to real files in the filesystem Do you see any serious drawbacks with this approach ? A problem that i see is that you cant really use real filenames since the could collide with each other but rather you shouls store the filename of anything you would otherwise keep in a blob inside a DB field itself.. and to name the file like the unique ID of the record itself. All this should be coupled with a good deisgn that takes care to check that the file its actually there before sending or using it. could you mention a case where using files like this is NOT agood substitute of blobs and therefore is should chose something else beside interbase? :) Thank so much.. Giovanni Tummarello tummarel@ascu.unian.it Fight Spam! Join CAUCE (Coalition Against Unsolicited Commercial Email) at http://www.cauce.org/ and tell your Congresspeople how Spam mailings hurt you. Help protect genuine Internet commerce: Outlaw UCE Spamming.