Subject | Re: [firebird-support] Re: Is there an FB alternative for the "filestream"option of MS SQL |
---|---|
Author | Thomas Steinmaurer |
Post date | 2011-07-22T07:50:56Z |
> That's clear (but nog very satisfying...). Do you know if it is on a wish list?I don't think so. What do you like to achieve?
While you can bloat the database size with blob data, I usually tend to
have binary content (e.g. compressed documents, imagees ...) inside the
database in BLOB columns and not file names in character fields pointing
to files in the file system. This way, Firebird has everything under
control in respect to:
* Data changes in context of ACID transactions
* Access control via GRANT
* I don't have to backup two things (database and filesystem)
* Restoring is easier as well, especially if you store absolute paths in
character fields
Of course, an increasing database size usually means backup/restore
cycles take longer etc ...
--
With regards,
Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!