On Fri, Mar 29, 2013 at 11:36 AM, Mechtilde <o...@mechtilde.de> wrote:
> Hello > > Am 29.03.2013 19:07, schrieb Kay Schenk: > > 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. > > > >>>>> 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 > > I can/will also do QA for Base > Kind regards > > Mechtilde > Good. So, any builds should also include junit option for this purpose I assume > > > > > > 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. > > > > > > -- ---------------------------------------------------------------------------------------- MzK "Achieving happiness requires the right combination of Zen and Zin."