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 license. 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 < coldheart...@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
_______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
