Re: Firebird 3 by default [was: minutes of ESC call ...]

On Fri, Dec 02, 2016 at 11:40:27AM +0100, Jan Holesovsky wrote:

> Lionel Elie Mamane píše v St 30. 11. 2016 v 14:55 +0100:

> > The data definition (the name and structure of the tables) is just an
> > SQL script in the ZIP structure of the .odb, so in principle you just
> > replay that against Firebird with the firebird engine... The devil is
> > in the details: If we run into places where the HSQLDB SQL dialect is
> > not a subset of the Firebird SQL dialect, we'll have to deal with
> > those places in some way. And suddenly we have to parse, and
> > "understand", at least to some point, the saved HSQLDB SQL script to
> > convert it to Firebird SQL. <shrug>

> But that sounds that some kind of "best effort" conversion could be
> achieved reasonably simply?  Ie. when there is no HSQLDB installed, try
> to replay it as you suggested, and only report "You don't have HSQLDB"
> in case the replaying failed :-)

For the data structure part, yes. One still needs to read the "cached
format" data without HSQLDB to have the actual data :)

-- 
Lionel