sqlite support?

[limo]

Could it be interesting for somebody to use sqlite (http://www.sqlite.org) as SQL backend for zabbix?

So zabbix would not depend on any other SQL software and work absolutly standalone.. Sqlite syntax is very similar to postgresql so there is no need to dramaticaly change sources (only change DB* functions).

It is only suggestion which could be used for standalone embeded monitoring systems and smaller networks. I know that SQL server is quicker, but it is next point of failure...

What do you think about this?

[sauron]

I'm think need use libdbi as db engine. For this library exist drivers for MySQL PostgreSQL Oracle and... SQLite. Then choose need backend

[Alexei]

FYI Support of SQLite has been implemented in 1.3.1.

[limo]

Thanx for sqlite !

But there is problem with database locking.. I solved rights to database file (because zabbix_server uses another user than apache) but any insert/update ends with error "database locked". It happens because twoo processes need to update same table. I found some sollutions for sqlite but not sqlite3. There should be parameter busytimeout , which should tell how long to wait before say database locked... But it does not work with sqlite3. Now I am playing with this.

Does it work without touching sources for somebody ?

Thanx.

[Alexei]

The database locking issue will be fixed. SQLite has very poor locking schema which makes SQLite unusable for us without ZABBIX level add-on which we developed specially for SQLite.

The busytimout is a joke for busy (insert/update-wise) SQLite databases. It doesn't help at all!

[limo]

Thanx for sqlite support! I will wait for that locking mechanism, it is not time-critial but when sqlite will be working, it will be very good for small and embeded environments!

Thanx at all,
Lukas