[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Bacula-devel] bweb & sqlite(3) backend
On Thursday 13 March 2008, Eric Bollengier wrote:
> > yes, I have understood that (for the time being) bweb is not able to work
> > with a sqlite catalog (this is why I'm mailing -devel rather than
> > -users).
> > Does anyone have an overview what would be required (in terms of
> > development work) to get bweb working on an sqlite catalog? What were the
> > reasons to exclude sqlite in the first place?
> I have started some time ago to implement sqlite backend, but sqlite have
> only very basics sql functions.
Depends... :) SQLite did transactions, subselects and some other stuff long
before MySQL did.
> Maybe i'm wrong, but for example, date manipulations have to be done by
ACK, I do understand your point.
> SELECT date_trunc('day', Job.StartTime) FROM Job LIMIT 1; -- Pg
> SELECT DATE_FORMAT(Job.StartTime, '%Y-%m-%d') FROM Job LIMIT 1; -- mysql
> ??? in sqlite
There are a few date/time calculation functions in SQLite; however, they are
undocumented and not really recommended for usage. On the other hand, they
have been there for some time now and might work for some more time... :)
This one is
SELECT strftime('%Y-%m-%d', Job.StartTime) FROM Job LIMIT 1;
> You could check for %sql_func in Bweb.pm, and if you find some way to
> manipulate dates without doing all work yourself, i will be happy to add
> sqlite to Bweb.
ACK. I'll see what else I can find.
Concatenation works just as in PostgreSQL (select foo || bar from baz);
the "STARTTIME_FOO" transformations can be done by strftime() calls (watch
out: strftime is _not_ fully compatible with the Unix/POSIX/whatever
There exists a DBD (DBD::PgLite) which tries to transform PosgreSQL style SQL
statements to SQLite calls. I'm not sure whether it might help here, but it
would definitely be worth a try.
> An other thing, IMHO, Sqlite could be used for small setup, Postgresql (or
> Mysql) is the best candidate for medium and big setup. For a small setup
> (maybe 1 or 2 backups per day), bconsole is sufficient. For big one,
> bweb/bat is very helpful...
Hm... Well, my requirements need SQLite, and I'd still like to use bweb ;) I
do understand what you mean, though.
Thx for your comments, regards and have a nice weekend
Collax GmbH . Burkheimer Straße 3 . 79111 Freiburg . Germany
p: +49 (0) 761-45684-24
f: +49 (0) 761-45684-10 www.collax.com
Geschäftsführer: William K. Hite / Boris Nalbach
AG München HRB 158898 . Ust.-IdNr: DE 814464942
\ "Wenn du siehst, wen einige Mädchen heiraten, weißt du, wie
\ sehr sie es hassen müssen, ihren Lebensunterhalt selbst zu
\ Helen Rowland
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
Bacula-devel mailing list
This mailing list archive is a service of Copilotco.