Greetings Gentlemen Since Eric appears to have returned, I'd like to bring up a subject that was postponed. The possibility of modifying the database schema for gui interfaces.
I've taken the opportunity to install bweb and look at what it does from an interface point of view and taken some time looking at the querries it performs. So I may be in a better position to make a recommendation at what I would do to change the core code to make it easier to have gui interfaces which query for information about the files in the catalog. I would recommend the following: Add a table identical to brestore_pathhierarchy. This data would be invaluable to having querries in a gui to identify parent child relationships between directories. It's simple and very effective. The addition of this table could be configurable for those admins that have a strong desire to keep the database size small. Which gets to the second and more difficult part, how to solve the root of a backup issue. Like those filesets that only back up one file such as a default catalog fileset. My recommendation is to change bacula's core to always add the directories back to the / of the filesystem or on a windows machine, all the way back to the x:/. Another option that would seem to work well but would add another table, would be to have a roots table. It could be a 2 column table with jobs and root path id's. So if a job has a single file, it could be one entry. Or if a fileset is more complex with many roots, there may need to be many more records. Overall though, the size of this table would not grow too large. Hope this recommendation helps, I'm open to anything that I can get to work well. I'm pretty sure we could make something exactly like what Eric has done and I could get it to work well. The framework is after all allready there. :-) Dirk On Tue, 2009-06-16 at 22:39 -0400, Dirk Bartley wrote: > Greetings > > below is a previous message of a topic I would like to revive. > > I'm wondering if it's a week after stabilizing the release yet. I've > installed bweb and just started taking a look at it: > The use of it. > The updating process adding new data to the database. > The queries it does of the database. > > Dirk > ------------------------------------------------------------------------------ _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
