Need help to locate HSQLDB in Base
Muhammad Waqas Iftikhar
coldheartpks at gmail.com
Mon Aug 6 11:04:23 PDT 2012
But again if we embed PostgreSQL the issue will come again on running .ODB
On Mon, Aug 6, 2012 at 11:01 PM, Muhammad Waqas Iftikhar <
coldheartpks at gmail.com> wrote:
> We have been looking on different kind of databses to embed under
> libreoffice base.
> Some few ones we like are:
> Friebird (but has some issues with embedding it under linux it doesnt work
> easily. Not only this you will have to embed Classic under linux and its
> architecture is not suitable for an application like base and it wont be
> 'pure' embedded server)
> MySQL/ libmysqld (GPL issue. What i have derived from difference between
> LGPL and GPL licenses i have come to conclusion that if we use libmysqld
> and as .DLL / .SO there wont be any license issue as Base being "FOSS" free
> open source software has the right to use it libmysld in it if we mention
> that this particular library is under GPL license and no commercial
> organisation can use it without permission of Oracle without changing our
> But we cannot amend any code part of libmysqld if we do this then we will
> be owner of of that amended library and according to LGPL commercial
> organisation will be able to use it. So to do that libre will have to come
> to GPL license. What we derived to make mysql as embedded in base it would
> had to be amended a little run .ODB files and store databases in .ODB
> files. If we are wrong or we can avoid this amendment then i think best
> choice is mysqld. Its footprint is not huge and provides nearly every thing
> one can need. High performance SQL standards etc.)
> We can also embed PostgreSQL. An embedded version is not available but we
> can pack the binaries of postgresql with it. Run it when application starts
> in a new thread and bind it listen to to only local host. Then kill
> the process and wait the thread to join before exiting the application. It
> can also resolve many major f*unctionalities and platform issues.)*
> - Note: if we embed MySQL or PostgreSQL the work would be very less also.
> As their drivers are already written.
> Oracle's berkley db is also very good option for embedded as it is open
> source. Its an SQL dbms but is not relational dbms.)
> SQLite already voted out. Rest all DBMS that can be embedded i saw are
> under commercial license or only runs in Windows based applications).
> On Mon, Jul 23, 2012 at 11:50 PM, Muhammad Waqas Iftikhar <
> coldheartpks at gmail.com> wrote:
>> Me and my friends are trying to work on to embedd SQLite under base
>> instead of hsqldb. For that we are trying to understand how BASE works with
>> HSQLDB for now. We've been debugging Libreoffice for a while now. In our
>> search for code relating to HSQLDB, we've gone through the code in the
>> "load" function of "dbloader2.cxx" found in the "source/filter/xml"
>> directory under the "dbaccess" module as well as the code in
>> "connection.cxx" file found in the "source/code/dataaccess" folder, also
>> under the "dbaccess" module. We've seen how the wizards and the windows for
>> Base are initialized and then displayed and how the connection is
>> established when the tables are to be accessed. However, we haven't been
>> able to locate the portion of code that actually initializes HSQLDB. Please
>> give us an idea of how to proceed further.
>> Regards Waqas
> Regards Waqas
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the LibreOffice