Skip site navigation (1) Skip section navigation (2)

Re: foreign data wrappers

From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Zheng Yang" <zhengyang4k(at)gmail(dot)com>, "Guillaume Lelarge" <guillaume(at)lelarge(dot)info>, "Selena Deckelmann" <selena(at)chesnok(dot)com>, "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "pgsql-students" <pgsql-students(at)postgresql(dot)org>
Subject: Re: foreign data wrappers
Date: 2011-03-24 16:55:13
Message-ID: 47676.208.91.122.102.1300985713.squirrel@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-students
On Thu, March 24, 2011 12:49 pm, Alvaro Herrera wrote:
> Excerpts from Zheng Yang's message of jue mar 24 05:49:19 -0300 2011:
>
>> I am quite new to postgresql, but slowly picking up :)  In general
>> context, storing images directly inside DBMS fields as BLOBs was not
>> considered as a good practice.
>> However, storing file directories  or links may cause inconsistency. So
>> I am quite interested in how this datalink concept can be implemented!
>
> I'm not really sure how different would be handling the file linking in
> an FDW.  For example, if a transaction runs that deletes a file through
> the FDW, and the transaction rolls back, how are you going to restore
> the file to life?
>
> (It sounds like you're trying to have a FDW that would present a
> directory as a table, and each file in the dir as a row.  Maybe it's not
> a bad idea but it needs a lot more thought.)
>


Currently FDWs can't store anything. They are read-only.

But I don't really buy this stuff about not storing images in the
database. I've done numbers of apps that do exactly that with great
success. If the images are huge that's another matter, but for small
images it works just fine.

cheers

andrew


In response to

Responses

pgsql-students by date

Next:From: Selena DeckelmannDate: 2011-03-24 20:59:29
Subject: Re: foreign data wrappers
Previous:From: Alvaro HerreraDate: 2011-03-24 16:49:02
Subject: Re: foreign data wrappers

pgsql-general by date

Next:From: Merlin MoncureDate: 2011-03-24 16:57:14
Subject: Re: Deadlock in libpq
Previous:From: Emre HasegeliDate: 2011-03-24 16:54:53
Subject: Re: which view is used another views

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group