On Thu, Dec 22, 2011 at 02:17:00PM -0700, Brent Wiese wrote: > >Totally agree with this. An option to store attachments on the filesystem, > >however, is database-agnostic, so >RT admins can select this option with > >MySQL, Oracle, Postgres, SQLite, etc. > > What if it wasn't DB agnostic? > > Does any linux/open source DB provide a "FILESTREAM" option like MS SQL? It > sounds like that would be an easy solution if it existed as, to the best of > my knowledge, the app doesn't need to know any different when using > FILESTREAM. The DB handles the disk/DB interaction. > > Brent
I think that PostgreSQL 9.1 includes support for Foreign Data Wrappers that could be used to access the filesystem contents in a similar fashion. Regards, Ken -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
