Re: Documents in Database

Tech-Archive recommends: Fix windows errors by optimizing your registry

"Q" <Q@xxxxxxxxx> wrote in message
news:uDBaM7nnFHA.3568@xxxxxxxxxxxxxxxxxxxxxxx
> I want to store all kind of files (pdf, doc, xls, txt) in a database.
> This is no problem.

I find it is often /easier/ to work with such files when they are safely
out in the file system!

> The real problem is opening the files from within a .Net application.
> I tried several ways to do it:
> 1. Creating an object of e.g. word to open a document.
> 2. Taking care of the problem through processes. --> create a process
> and run an instance of word...

3. Get the file out of the database, into the file system, and use
Process.Start to launch the document /itself/, thereby invoking the user's
default application for that type of document.

> these solutions have the same problems. If word is already open
> when you create the object (or the process) and you close
> it afterwards, the documents that were already open are closed also
> (and changes are lost)

Your problem is not in opening the document, but in knowing just
/when/ the user has finished mucking about with it.
Is your application waiting for the Start'ed (editor) process to end?
That would /help/, although it might be waiting a very long time before
the user closed down something like Word.

Take a step back from the technical nitty-gritty for a moment
- What is it you're hoping to achieve with this?

Regards,
Phill W.


.

Relevant Pages

  • Re: Treads in the new 6 core CPU from Intel
    ... Why do you think six cores are "fighting" for resources? ... implications of an asymmetric I/O bus structure on file system I/O? ... Why do you think the file I/O is not taking advantage of the File System Cache? ... What, in fact, do you mean by the phrase "database ...
    (microsoft.public.vc.mfc)
  • Re: Question regarding to store file system metadata in database
    ... database based file system will be useful for archiving. ... but 300 metadata iops is not that fast. ... feature needed by file system is really a small part of database ...
    (Linux-Kernel)
  • Re: If you were inventing CoBOL...
    ... >> The underlying file system is irrelevant. ... The database would work exactly the same. ... tree nodes lived in a table. ... >Well bang goes the only advantage of lists and trees, ...
    (comp.lang.cobol)
  • Re: Question regarding to store file system metadata in database
    ... I agree that people always want to access metadata faster. ... Anybody know how fast a file system can do pathname-to-inode ... am just proposing to store pathanem-to-inode number in database. ... For example, one can setup a database to store file pathname, its ...
    (Linux-Kernel)
  • Re: Question regarding to store file system metadata in database
    ... database can reside on a raw block device. ... but 300 metadata iops is not that fast. ... database based file system could be a secondary file system but ... feature needed by file system is really a small part of database ...
    (Linux-Kernel)