apr_dbd

[Rick Keiner <ri...@yahoo.com>]

Here is some work I've done on the SQLite driver for
apr_dbd. It's based on the work Ryan Phillips had
done. I've changed the select to build a linked list
of the result set so that the number of tuples will be
correct. The subsequent get rows retrieve the data
from the linked list. This works only if there is one
select in the query.

I have a general question about the query How should
the results be returned if there are multiple selects
in the query? Should it just return an array of
apr_results_t *. 

Regards,

Rick Keiner

Re: apr_dbd

[Nick Kew <ni...@webthing.com>]

Rick Keiner wrote:
> Here is some work I've done on the SQLite driver for
> apr_dbd. It's based on the work Ryan Phillips had
> done.

Thanks for reminding me: I've been meaning to look at Ryan's patch,
but round tuits have been very difficult (illness followed by house
move).

I notice this is sqlite3, whereas sqlite2 is in svn ... ??

>  I've changed the select to build a linked list
> of the result set so that the number of tuples will be
> correct. The subsequent get rows retrieve the data
> from the linked list. This works only if there is one
> select in the query.

Was that solely to implement the NOTIMPL functions, or have
you made other changes?

> I have a general question about the query How should
> the results be returned if there are multiple selects
> in the query? Should it just return an array of
> apr_results_t *.

Can you give an example of what you mean?  You may be going
beyond the scope of what apr_dbd is designed for, in which case
we need to decide whether it's important enough to merit a
review of the existing API.

-- 
Nick Kew

Re: apr_dbd

[Paul Querna <ch...@force-elite.com>]

Rick Keiner wrote:
> Here is some work I've done on the SQLite driver for
> apr_dbd. It's based on the work Ryan Phillips had
> done. I've changed the select to build a linked list
> of the result set so that the number of tuples will be
> correct. The subsequent get rows retrieve the data
> from the linked list. This works only if there is one
> select in the query.
> 
> I have a general question about the query How should
> the results be returned if there are multiple selects
> in the query? Should it just return an array of
> apr_results_t *. 
> 
> Regards,
> 
> Rick Keiner
> 

Can you please provide this in a .patch format?

eg, svn diff.

Thanks,

Paul