Re: Need help to locate HSQLDB in Base
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
Re: Need help to locate HSQLDB in Base
But again if we embed PostgreSQL the issue will come again on running .ODB files. On Mon, Aug 6, 2012 at 11:01 PM, Muhammad Waqas Iftikhar coldheart...@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 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 -- Regards Waqas ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Need help to locate HSQLDB in Base
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 ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: Base project in GSoC 2012
The IRC channel is dead Mr. Mutthu the mentor of this project is not replying from his official email. The IRC channel is dead also. I am really intrested in this project and i am already doing this stuff in research center in my university. I can do it. Please can anybody help me contacting the mentor is some other way. I need to get in touch with him. On Fri, Mar 23, 2012 at 11:30 PM, Waqas Iftikhar coldheart...@gmail.comwrote: I am writing about the LibreOffice Base project in GSoC 2012. I am interested in open source development particularly in all ex-Sun Micro systems open source products. I am from Pakistan, currently in my junior year of undergraduate studies in computer sciences at FAST-NU Lahore. I have extensive experience of working on open source systems at Software Engineering Research Centre (SERC) at FAST-NU Lahore under the guidance of Dr. Fakhar Lodhi. At Software Engineering Research Centre in FAST-NU Lahore I have worked inside the source code of MySQL. My team and I have worked on the solution to various bugs in MySQL namely Bug # 20093, Bug #50675, Bug 54034 and Bug# 50507. We have studied the code base of MySQL extensively. Our next project due in SERC is embedding MySQL/SQLite as a default in LibreOffice Base which happens to be the same thing you want to be implemented in GSoC 2012. We have already started scratch work on it (building LibreOffice and SQLite and then embedding SQLite under Base). There are a few queries regarding GSoC 2012. First, my understanding about your GSoC requirement is that you want SQLite working as a default in place of HSQL database in Base of LibreOffice. The pre requisite written on LibreOffice GSoC profile says that you need to solve one of the Easy Hack Programming Tasks but one of the easy hack programming task matches up with the GSoC 2012 idea of Base. Second, I cannot find out the development mailing list for this project. Please clarify these issues to me. -- Regards Waqas -- Regards Waqas ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: Base project in GSoC 2012
I dont know where can i contact Mr. Mutthu the mentor of this project in GSoC can any body help? I have already build LibreOffice and now gonna start studying its code base where it connects with HSQLDB to get information about it. On Fri, Mar 23, 2012 at 11:30 PM, Waqas Iftikhar coldheart...@gmail.comwrote: I am writing about the LibreOffice Base project in GSoC 2012. I am interested in open source development particularly in all ex-Sun Micro systems open source products. I am from Pakistan, currently in my junior year of undergraduate studies in computer sciences at FAST-NU Lahore. I have extensive experience of working on open source systems at Software Engineering Research Centre (SERC) at FAST-NU Lahore under the guidance of Dr. Fakhar Lodhi. At Software Engineering Research Centre in FAST-NU Lahore I have worked inside the source code of MySQL. My team and I have worked on the solution to various bugs in MySQL namely Bug # 20093, Bug #50675, Bug 54034 and Bug# 50507. We have studied the code base of MySQL extensively. Our next project due in SERC is embedding MySQL/SQLite as a default in LibreOffice Base which happens to be the same thing you want to be implemented in GSoC 2012. We have already started scratch work on it (building LibreOffice and SQLite and then embedding SQLite under Base). There are a few queries regarding GSoC 2012. First, my understanding about your GSoC requirement is that you want SQLite working as a default in place of HSQL database in Base of LibreOffice. The pre requisite written on LibreOffice GSoC profile says that you need to solve one of the Easy Hack Programming Tasks but one of the easy hack programming task matches up with the GSoC 2012 idea of Base. Second, I cannot find out the development mailing list for this project. Please clarify these issues to me. -- Regards Waqas -- Regards Waqas ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: Base project in GSoC 2012
Thank you sir! On Fri, Mar 23, 2012 at 11:30 PM, Waqas Iftikhar coldheart...@gmail.comwrote: I am writing about the LibreOffice Base project in GSoC 2012. I am interested in open source development particularly in all ex-Sun Micro systems open source products. I am from Pakistan, currently in my junior year of undergraduate studies in computer sciences at FAST-NU Lahore. I have extensive experience of working on open source systems at Software Engineering Research Centre (SERC) at FAST-NU Lahore under the guidance of Dr. Fakhar Lodhi. At Software Engineering Research Centre in FAST-NU Lahore I have worked inside the source code of MySQL. My team and I have worked on the solution to various bugs in MySQL namely Bug # 20093, Bug #50675, Bug 54034 and Bug# 50507. We have studied the code base of MySQL extensively. Our next project due in SERC is embedding MySQL/SQLite as a default in LibreOffice Base which happens to be the same thing you want to be implemented in GSoC 2012. We have already started scratch work on it (building LibreOffice and SQLite and then embedding SQLite under Base). There are a few queries regarding GSoC 2012. First, my understanding about your GSoC requirement is that you want SQLite working as a default in place of HSQL database in Base of LibreOffice. The pre requisite written on LibreOffice GSoC profile says that you need to solve one of the Easy Hack Programming Tasks but one of the easy hack programming task matches up with the GSoC 2012 idea of Base. Second, I cannot find out the development mailing list for this project. Please clarify these issues to me. -- Regards Waqas -- Regards Waqas ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Base project in GSoC 2012
I am writing about the LibreOffice Base project in GSoC 2012. I am interested in open source development particularly in all ex-Sun Micro systems open source products. I am from Pakistan, currently in my junior year of undergraduate studies in computer sciences at FAST-NU Lahore. I have extensive experience of working on open source systems at Software Engineering Research Centre (SERC) at FAST-NU Lahore under the guidance of Dr. Fakhar Lodhi. At Software Engineering Research Centre in FAST-NU Lahore I have worked inside the source code of MySQL. My team and I have worked on the solution to various bugs in MySQL namely Bug # 20093, Bug #50675, Bug 54034 and Bug# 50507. We have studied the code base of MySQL extensively. Our next project due in SERC is embedding MySQL/SQLite as a default in LibreOffice Base which happens to be the same thing you want to be implemented in GSoC 2012. We have already started scratch work on it (building LibreOffice and SQLite and then embedding SQLite under Base). There are a few queries regarding GSoC 2012. First, my understanding about your GSoC requirement is that you want SQLite working as a default in place of HSQL database in Base of LibreOffice. The pre requisite written on LibreOffice GSoC profile says that you need to solve one of the Easy Hack Programming Tasks but one of the easy hack programming task matches up with the GSoC 2012 idea of Base. Second, I cannot find out the development mailing list for this project. Please clarify these issues to me. -- Regards Waqas ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice