[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] Alternative DB proposal


Take a look to 

trunk/gui/bweb/script/bweb-postgresql.sql and bweb-mysql.sql
function base64_decode_lstat();

Bye

Le Tuesday 07 October 2008 20:31:18 John Huttley, vous avez écrit :
> Yes,
> That was next on my list. Not something I've done before so I'm glad to
> hear that someone else has done it.
>
> Where will I find this code?
>
>
> Regards,
>
> John
>
> Eric Bollengier wrote:
> > Hello John,
> >
> > An other solution that doesn't require any additional code and no
> > database structure modification, is to use a PL function to extract
> > mtime, ctime, size, block_size etc... from LStat field.
> >
> > This function is available on Postgresql and now on Mysql (thanks to
> > Kjetil).
> >
> > The only drawback that i see with this PL function, is that you *should*
> > avoid to use it in WHERE or JOIN clauses. But, it works very well for
> > reporting and analysis.
> >
> > Bye
> >
> > Le Tuesday 07 October 2008 04:50:50 John Huttley, vous avez écrit :
> >> Hi
> >> My first test are complete.
> >> To aid in getting all the questions/answers and results in one place,
> >> I've made a wiki entry.
> >>
> >>
> >> http://wiki.bacula.org/doku.php?id=wiki:playground
> >>
> >>
> >> My scripts are attached.
> >>
> >> --John





-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilotco.