Playing with Oracle, ocilib and parameter bindings

Hi there,

IDOUtils queries differ quite a lot – some of the are just executed during startup, while others happen all the time. By analyzing the performance on our Oracle database with grid  it came to the top queries just like for

servicechecks, servicestatus hostchecks, hoststatus timedevents programstatus

But how to improve the performance of [...]

Share

Icinga IDOUtils will support Oracle RDBM in 1.0 RC

Hi there,

work was not getting better and getting Oracle to work was on hold. So I decided to push a night of coding after I had prepared the MERGE queries.

And yes, it was successful – initial support for Oracle is done!

Oracle driver requirements

You”ll catch the problems with libdbi and Oracle in [...]

Share

Playing with IDOUtils, Oracle and ocilib

Since I’m very busy at work this time I just wanted to give you some feedback on my current attempt – IDOUtils with Oracle based on ocilib.

Regarding that libdbi currently doesn’t provide a stable Oracle driver and furthermore, the main interface doesn’t allow prepared statements and parameter bindings, ocilib should be used and enabled [...]

Share

Icinga 0.8.4 is out – bugfixes and updates for IDOUtils and Docu

Since we decided to give you the opportunity to test the new IDOUtils with re-engineered code for more RDBMs and Postgres support too we were aware of the fact that there would have been bugfixes to apply ;-)

There were several issues to fix, not only Postgres but also typos and rewritten queries. We [...]

Share

Playing with IDOUtils and Postgresql

After a long time debugging, code re factoring, implementing and testing new stuff another success story for Icinga!

Let’s start with the details :-)

IDOUtils is a “simple” kind of INSERT, UPDATE and DELETE application so no worries about difficult SELECT and JOIN. Meanwhile the biggest problem are the queries which are not normalized and [...]

Share

Playing with IDOUtils, libdbi & Oracle

First of all, since I became one of the maintainers for NDOUtils Oracle I’ve been looking forward to commit this project back to the upstream. It is a bit tricky because current code has been merged from NDOUtils 1.4.b8 (partly) and it is using a self written Library for OCI (Oracle Call Interface, liboci). Even [...]

Share

*knock knock* – Who’s there? Come in!

One point Icinga stands for is the wish to be more open. And we will release the CORE git earlier than we planned to.

Icinga is split up to three sub-projects, the core, the web and the api and now we opened one of the three doors for public review – the core door.

See [...]

Share