On Fri, Mar 29, 2013 at 10:08 AM, Reizinger Zoltán <zreizin...@hdsnet.hu>wrote:
> 2013.03.29. 17:25 keltezéssel, Michael Lam írta: > > On 03/28/2013 01:24 PM, Kay Schenk wrote: >> >>> On Wed, Mar 27, 2013 at 7:56 PM, Andrew Douglas Pitonyak < >>> and...@pitonyak.org> wrote: >>> >>> On 03/27/2013 04:57 PM, Kay Schenk wrote: >>>> >>>> Well Derby does seem to be "embed-able ". See: >>>>> >>>>> http://db.apache.org/derby/****papers/DerbyTut/embedded_****intro.html<http://db.apache.org/derby/**papers/DerbyTut/embedded_**intro.html> >>>>> <http://db.apache.**org/derby/papers/DerbyTut/**embedded_intro.html<http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html>> >>>>> >>>>> >>>>> This has been suggested before, as early as 2006. See: >>>>> >>>>> http://markmail.org/message/****kp5n2d5yzhprgpjm<http://markmail.org/message/**kp5n2d5yzhprgpjm> >>>>> <http://**markmail.org/message/**kp5n2d5yzhprgpjm<http://markmail.org/message/kp5n2d5yzhprgpjm>> >>>>> >>>>> >>>>> Still, is any embedded DB a good thing? Pros and cons... >>>>> >>>>> PRO: >>>> * Very convenient for small things. Imagine if I said that you can >>>> write a >>>> document in Write, but you must first install an external application >>>> that >>>> Write will connect to. This is rather daunting for new users. Also, most >>>> external systems I expect probably use multiple files, so, if I want to >>>> simply create something small and send it to you, well, I can't do that >>>> easily unless I zip up a directory, send it to you, and then expect you >>>> to >>>> install the same DB that I used and then make it work. So, it boils >>>> down >>>> to an ability to create a small single file DB. >>>> >>>> CON: >>>> * Our current Embedded DB works poorly with large DB, and someone who >>>> does >>>> not know better may try to create a very large DB and have performance >>>> issues. >>>> >>>> If it is not reliable, then it is probably better to not exist. >>>> >>>> >>>> >>>> -- >>>> Andrew Pitonyak >>>> My Macro Document: >>>> http://www.pitonyak.org/****AndrewMacro.odt<http://www.pitonyak.org/**AndrewMacro.odt> >>>> <http://www.**pitonyak.org/AndrewMacro.odt<http://www.pitonyak.org/AndrewMacro.odt> >>>> > >>>> Info: http://www.pitonyak.org/oo.php >>>> >>>> >>>> ------------------------------****----------------------------**--**--------- >>>> >>>> To unsubscribe, e-mail: >>>> dev-unsubscribe@openoffice.**a**pache.org<http://apache.org> >>>> <dev-unsubscribe@**openoffice.apache.org<dev-unsubscr...@openoffice.apache.org> >>>> > >>>> For additional commands, e-mail: dev-h...@openoffice.apache.org >>>> >>>> >>>> This has been a very good discussion so far. >>> >>> I would again like to emphasize two things about our current >>> situation/implementation: >>> >>> * the requirement of Java 6 by end users to get acceptable performance >>> from >>> Base. >>> >>> (More testing of builds will be needed to determine if this holds true >>> for >>> Java 7 and HSQL 2.2.9. Perhaps additional changes are needed to the >>> connectivity portions of AOO). >>> >>> * the current and perhaps future issues in terms of development >>> maintenance >>> for the embedded DB >>> >>> In any case, we need to keep in mind this is a volunteer community. >>> >>> I have been working on updating the HSQL to the latest version. I have >> most of the configure and build portion ready but I did run into an issue >> which I addressed here >> >> http://sourceforge.net/**projects/hsqldb/forums/forum/** >> 73674/topic/6842122<http://sourceforge.net/projects/hsqldb/forums/forum/73674/topic/6842122> >> >> I have tested Base with version 2.2.9 and it does address the issues that >> the current patches are created for. Overall, most of the issues seem to be >> within the AOO code. I have tried to look into some of them but having made >> too much progress. Personally I am having a hard time locating the issue, I >> am still trying to get use to the build system and the code structure. For >> example, there is an issue with setting the default date on a column but I >> am unable to locate the UI code for it. >> > Michael -- Great to hear from you again! > >> The all hsqldb 2.0 intagration work finished in Oracle era, OOo3.4 but > the final integration postponed to 3.5 version or later time. > It contains lot of code change. > All code was stored in cws hsqldb19: http://hg.services.openoffice.** > org/hg/cws/hsqldb19/ <http://hg.services.openoffice.org/hg/cws/hsqldb19/> > The code transfer to ASF is not clear to me. > > I did the user side QA work, if I have time will help you. I have no > coding knowledge. > > First need to clarify the cws hsqldb19 code usage, to prevent duplicate > work. > Zoltan and, hi Zoltan -- thanks for this info. I'm not sure how many of us knew about this. > > As a volunteer, I am going to concentrate on Base. I have been meaning to >> ask on the list if others would like to work together to get it back into >> shape. Any takers? >> > Count me in! I too am doing some additional investigative work. I will be back with the procedures I took in a few days. I installed hsqldb 2.2.9 locally and went from there. I need to go over my build logs again to see if I missed something. I may rebuild with debug options etc to help me out. >> Michael >> >> >> >> ------------------------------**------------------------------**--------- >> To unsubscribe, e-mail: >> dev-unsubscribe@openoffice.**apache.org<dev-unsubscr...@openoffice.apache.org> >> For additional commands, e-mail: dev-h...@openoffice.apache.org >> >> >> >> > > ------------------------------**------------------------------**--------- > To unsubscribe, e-mail: > dev-unsubscribe@openoffice.**apache.org<dev-unsubscr...@openoffice.apache.org> > For additional commands, e-mail: dev-h...@openoffice.apache.org > > -- ---------------------------------------------------------------------------------------- MzK "Achieving happiness requires the right combination of Zen and Zin."
