Re: [libdbi-users] prepared statements

2015-06-11 Thread Alex Bligh

On 11 Jun 2015, at 08:12, Simon Walter si...@gikaku.com wrote:

 If the application I'm writing can benefit from prepared statements, I
 would like to eventually either add that feature to libdbi or I may have
 to use something else in the future.

Not much use I know, but I can confirm it doesn't support prepared
statement currently. You might consider APR, i.e.

http://apr.apache.org/docs/apr/2.0/group___a_p_r___util___d_b_d.html

-- 
Alex Bligh





--
___
libdbi-users mailing list
libdbi-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-users


Re: [libdbi-users] prepared statements

2015-06-11 Thread Simon Walter
On 06/11/2015 06:07 PM, Alex Bligh wrote:
 
 On 11 Jun 2015, at 08:12, Simon Walter si...@gikaku.com wrote:
 
 If the application I'm writing can benefit from prepared statements, I
 would like to eventually either add that feature to libdbi or I may have
 to use something else in the future.
 
 Not much use I know, but I can confirm it doesn't support prepared
 statement currently. You might consider APR, i.e.
 
 http://apr.apache.org/docs/apr/2.0/group___a_p_r___util___d_b_d.html
 


That looks like an awful lot of nice C code. Thank you for the tip!

Looking at projects that use APR, many seem to include the entire thing
in their code base. I'm guessing that one of the drawbacks is that APR
comes with a lot of baggage so to speak.

Have you used both libdbi and the database bits of APR? Is there any
advantage to using libdbi compared to APR?

Simon

--
___
libdbi-users mailing list
libdbi-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-users


Re: [libdbi-users] prepared statements

2015-06-11 Thread Alex Bligh

On 11 Jun 2015, at 12:00, Simon Walter si...@gikaku.com wrote:

 Looking at projects that use APR, many seem to include the entire thing
 in their code base. I'm guessing that one of the drawbacks is that APR
 comes with a lot of baggage so to speak.

You can dynamically link to an APR library.

 Have you used both libdbi and the database bits of APR? Is there any
 advantage to using libdbi compared to APR?

I've either used one or the other. I expect you can use both but
can't see any reason to.

apr is more frequently updated, has many other functions (e.g.
a complete memory pool manager), and works on a wider range of
platforms I believe (including Windows).

libdbi is simpler than APR to get used to, and has a smaller memory
footprint.

You should also compare the choice of backends if you care about
that.

-- 
Alex Bligh





--
___
libdbi-users mailing list
libdbi-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-users


Re: [libdbi-users] prepared statements

2015-06-11 Thread Markus Hoenicka
At 2015-06-11 09:12, Simon Walter was heard to say:
 Hi all,
 
 I'm new to using libdbi and C in general. I am wondering why libdbi has
 no support for prepared statements.
 
 Is it that because the way libdbi is written, a prepared statement 
 would
 not provide any benefit? Or is it just lacking that feature? If it's
 just lacking the feature, are there plans to add that?
 
 If the application I'm writing can benefit from prepared statements, I
 would like to eventually either add that feature to libdbi or I may 
 have
 to use something else in the future.
 
 I haven't taken a deep look at the libdbi code. So any insight is
 appreciated.
 
 Kind regards,
 
 Simon
 
 PS
 
 If I should have sent this to the development list, please let me know.
 Thanks.

Hi,

I can't tell if prepared statements would speed up things when accessing 
databases through libdbi. As in many free software projects, the main 
reason for the lack of prepared statements is that nobody invested his 
time in implementing them. This includes myself, although I can't recall 
many requests for this feature. However, I think libdbi could support 
prepared statements if someone takes care of it. My commitments to my 
dayjob and to my family do not leave much dev time currently.

If you think about helping to implement this feature, you need to 
consider both libdbi and libdbi-drivers. libdbi needs a generic 
interface to prepared statements that covers all database backends. The 
drivers have to implement the feature using the functions of their 
respective client libraries. Therefore, it is best to design and discuss 
the interface first, and then to move on from there.

regards,
Markus

-- 
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38


--
___
libdbi-users mailing list
libdbi-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-users


Re: [libdbi-users] prepared statements

2015-06-11 Thread Simon Walter
On 06/12/2015 01:07 AM, Alex Bligh wrote:
 
 On 11 Jun 2015, at 12:00, Simon Walter si...@gikaku.com wrote:
 
 Looking at projects that use APR, many seem to include the entire thing
 in their code base. I'm guessing that one of the drawbacks is that APR
 comes with a lot of baggage so to speak.
 
 You can dynamically link to an APR library.
 
 Have you used both libdbi and the database bits of APR? Is there any
 advantage to using libdbi compared to APR?
 
 I've either used one or the other. I expect you can use both but
 can't see any reason to.
 
 apr is more frequently updated, has many other functions (e.g.
 a complete memory pool manager), and works on a wider range of
 platforms I believe (including Windows).
 
 libdbi is simpler than APR to get used to, and has a smaller memory
 footprint.
 
 You should also compare the choice of backends if you care about
 that.
 

OK, that's very helpful. Thank you. I'm not sure I want to change my
code around too much until I have more tests written. It's good to know
there is another usable option.

--
___
libdbi-users mailing list
libdbi-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-users