Code pointers for replace HSQLDB for Firebird

[Lionel Elie Mamane]

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