search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.24k stars 212 forks source link

Support Linux named pipes for external tables [CORE4112] #4440

Open firebird-automations opened 11 years ago

firebird-automations commented 11 years ago

Submitted by: Joe Dluzen (jdluzen)

I'd like to request that Linux named pipes be supported when using external tables. The reasoning behind this is to be able to e.g. decompress a text file into the pipe, while Firebird INSERTs it into the real table. Note that I'm only guessing that support is not available, because I've seen references to external tables using fseek, and I'm unable to test it at the moment.

firebird-automations commented 11 years ago

Commented by: Sean Leyne (seanleyne)

If External Table only supported read-only access, then I could (perhaps) agree that defining a decompression/de-serialiser method in the table definition might be worth while, to truly minimize the file storage needs. But given that they are read-write, the need to seek into the file is a requirement, which a pipe would not provide.

Further, file compression is built-in to several file systems, so there is already technique for reducing the filesize of the external data already exists -- one which works with the current functionality.