[syslog-ng] abandon libdbi and write a new sql driver?
Evan Rempel
erempel at uvic.ca
Tue Feb 22 15:49:16 CET 2011
We run ODBC on our systems and there is not another daemon to run. It
is a larger "system" to get installed but when in use it is just the
application and the odbc driver.
The only database that I am aware of that does not have a free odbc
driver is Oracle.
If there is another general purpose database abstraction layer then by
all means explore it. I am only aware of dbi and odbc
Evan
On 2011-02-22, at 6:30 AM, "Balazs Scheidler" <bazsi at balabit.hu> wrote:
> Hi,
>
> The problem with ODBC is that it is a _big_ package, with a separate
> daemon running, and last I've checked database drivers are not
> necessarily free. (this applies to the unixodbc package).
>
> On Sat, 2011-02-05 at 10:08 -0800, Evan Rempel wrote:
>> ODBC allows for prepared statements and is supported on all major
>> databases.
>> ________________________________________
>> From: syslog-ng-bounces at lists.balabit.hu [syslog-ng-
>> bounces at lists.balabit.hu] On Behalf Of Balazs Scheidler
>> [bazsi at balabit.hu]
>> Sent: Saturday, February 05, 2011 5:30 AM
>> To: Syslog-ng users' and developers' mailing list
>> Subject: Re: [syslog-ng] abandon libdbi and write a new sql driver?
>>
>> On Mon, 2011-01-24 at 09:10 -0800, Matthew Hall wrote:
>>> On Mon, Jan 24, 2011 at 12:12:37PM +0100, Balazs Scheidler wrote:
>>>> But I don't see anything against libdbi per-se, within syslog-ng a
>>>> similar API would be needed to cover all database APIs, so why
>>>> reinvent
>>>> the wheel?
>>>
>>> Not having prepared statements means every insert requires a parse.
>>>
>>> That cuts the performance of transactional DBs a lot.
>>>
>>> Particularly Oracle suffers from this because generating too many
>>> statements overflows its memory pools.
>>
>> I see, good to know. Thanks for the information.
>>
>> --
>> Bazsi
>>
>>
>> ______________________________________________________________________________
>> Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
>> Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng
>> FAQ: http://www.campin.net/syslog-ng/faq.html
>>
>> ______________________________________________________________________________
>> Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
>> Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng
>> FAQ: http://www.campin.net/syslog-ng/faq.html
>>
>>
>
> --
> Bazsi
>
> ______________________________________________________________________________
> Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng
> FAQ: http://www.campin.net/syslog-ng/faq.html
>
More information about the syslog-ng
mailing list