[bind10-dev] missing C API for PostgreSQL: row-by-row query result retrieval

[João Damas]

On 2 Oct 2012, at 19:10, JINMEI Tatuya / 神明達哉 wrote:

> At Tue, 2 Oct 2012 17:56:20 +0200,
> João Damas <joao at bondis.org> wrote:
> 
>> what would be the cost of supplementing the pgsql code with an in-memory table (like the rbi we already have) to allow for simple name-at-a-time selection for things like axfr. This table would only contain the names, not al the DNS info at each node. It is a crutch but perhaps one that can be put together with mostly existing code
> 
> I'm not sure if I understand the idea correctly, but I wonder how and
> when we build the in-memory table.  If we do it at startup time, it
> can take quite long and would reduce one major advantage of using a DB
> backend.

correct, one option is to not have some operations ready until the table/index exists. Or perform then at the slower speed while it is being created.

>  I'm also not sure how we can effectively keep the in-memory
> table consistent with the DB.

yep, tricky. Pgsql has triggers though

Joao