Re: [Babeldoc-devel] Database Tables

[bruce <br...@mc...>]

Erik,  Dejan:

I think I have found a relatively simple solution:

1.  We implement a new URLStreamHandler so that we can have a new protocol 
(lets say, babelsql:) that can access the database just like a filesystem.
2.  We implement the virtual filesystem using three tables - a directory table 
that knows about about its parent directory and maintains an id.  A data 
table that knows about its directory table id and its own id and an "inode" 
table that tracks common stuff for the two tables: permissions, last write, 
access time, modification etc.
3.  Then we simply manage the data in the tables just like a regular 
filesystem and we access them in the same way.

thoughts?

regards,
Bruce.

On Wednesday 26 March 2003 12:29 pm, bruce wrote:
> Dejan,
>
> This sounds just like what we need.   Let me look into it...
>
> regards,
> Bruce.
>
> On Wednesday 26 March 2003 11:34 am, Dejan Krsmanovic wrote:
> > Bruce, in future Babeldoc versions we should really think about using
> > Jakarta Commons VFS project. This component enables accessing data from
> > various sources. Currently local files, ftp files, WebDav, zip files and
> > some others are supported. They plan to include JDBC "file system" as
> > well. When you have a time check that project out. I think it could be
> > valuable in future...
> >
> > Dejan
> >
> > ----- Original Message -----
> > From: "bruce" <br...@mc...>
> > To: "Babeldoc Developers List" <bab...@li...>
> > Sent: Wednesday, March 26, 2003 3:18 PM
> > Subject: Re: [Babeldoc-devel] Database Tables
> >
> > > On Wednesday 26 March 2003 08:23 am, ek...@ba... wrote:
> > > > Well, I need both.  I need to store configuration information in the
> > > > database and I would like to store XSLT scripts (and everything else)
> > > > in the database also.
> > >
> > > The storing of the actual data in the database is the problem.  The
> > > XslTransform pipeline stage expects to be given a filename or URL of a
> >
> > data
> >
> > > source which will contain the XSL data.  Now, if that is not to your
> >
> > liking,
> >
> > > then it will probably be necessary to implement either a general
> > > solution
> >
> > to
> >
> > > this (probably using a URL scheme) or a specific re-implementation of
> > > the pipeline stages to load from a database.
> > >
> > > > Good question though ... is the SQLConfig fully implemented / tested?
> > >
> > > It was working fine - about six months ago - you will have to do a
> > > little prototyping.  I certainly can help you with problems you may
> > > find.
> > >
> > > regards,
> > > Bruce.
> > >
> > > > -------------------------------------------------------
> > > > This SF.net email is sponsored by:
> > > > The Definitive IT and Networking Event. Be There!
> > > > NetWorld+Interop Las Vegas 2003 -- Register today!
> > > > http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
> > > > _______________________________________________
> > > > Babeldoc-devel mailing list
> > > > Bab...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/babeldoc-devel
> > >
> > > -------------------------------------------------------
> > > This SF.net email is sponsored by:
> > > The Definitive IT and Networking Event. Be There!
> > > NetWorld+Interop Las Vegas 2003 -- Register today!
> > > http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
> > > _______________________________________________
> > > Babeldoc-devel mailing list
> > > Bab...@li...
> > > https://lists.sourceforge.net/lists/listinfo/babeldoc-devel
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by:
> > The Definitive IT and Networking Event. Be There!
> > NetWorld+Interop Las Vegas 2003 -- Register today!
> > http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
> > _______________________________________________
> > Babeldoc-devel mailing list
> > Bab...@li...
> > https://lists.sourceforge.net/lists/listinfo/babeldoc-devel
>
> -------------------------------------------------------
> This SF.net email is sponsored by:
> The Definitive IT and Networking Event. Be There!
> NetWorld+Interop Las Vegas 2003 -- Register today!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
> _______________________________________________
> Babeldoc-devel mailing list
> Bab...@li...
> https://lists.sourceforge.net/lists/listinfo/babeldoc-devel