Re: Code pointers for replace HSQLDB for Firebird

On Thu, Mar 21, 2013 at 08:26:42AM +0100, David Ostrovsky wrote:
> On Wed, 2013-03-20 at 22:44 -0300, Marcos Souza wrote:
> > Hi guys!
> >
> >
> > As suggested by Cecric and Muthu, I'm here to ask some code pointers
> > to work in the HSQLDB replacement for Firebird.
> >
> >
> > I'm reading https://bugs.freedesktop.org/show_bug.cgi?id=51781 from
> > Lionel, and trying to understand what needs to be done to achieve
> > this, but some code pointers are better!

> To be frankly i would divide that task in 2:
> 1. create native connectivity driver for Firebird.
> 2. default to Firebird driver.

I'd add another step between 1 and 2:

1.5: make Firebird embedded in LibreOffice
     subtasks:
       a) redirect Firebird "to disk" writes to our internal ZIP file
          structure; see how it is done for HSQLDB in

          connectivity/com/sun/star/sdbcx/comp/hsqldb/*.java
          connectivity/source/drivers/hsqldb/StorageFileAccess.cxx
          connectivity/source/drivers/hsqldb/StorageNativeInputStream.cxx
          connectivity/source/drivers/hsqldb/StorageNativeOutputStream.cxx

          if that's not possible, write to some temporary file and
          copy that into our internal zip file structure. Can we do
          something intelligent based on mmapped files shared between
          process or some such on each platform?

       b) create sdbc scheme sdbc:embedded:firebird and have it
          recognised; "git grep -i embedded|grep -i hsql" will give
          you code pointers.

-- 
Lionel