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

On Fri, 06 Oct 2000, Giovanni Tummarello wrote: > 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. You could do that. The large difference is that BLOBs are covered by transactions while files are not. You could wind up with stray files that don't show up in tables, and the opposite: missing files. The site that I am working on is quite heavy on text messages, and I think that user-files would be worse than using text BLOBs in my case. / Johan -- johan@tiq.com -- http://www.obsession.se/johan/ --