Re: [libdbi-users] prepared statements
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
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
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
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
[libdbi-users] prepared statements
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. -- ___ libdbi-users mailing list libdbi-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-users
Re: [libdbi-users] prepared statements
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