openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kay Schenk <kay.sch...@gmail.com>
Subject Re: questions about Base---do we need an embedded DB?
Date Sat, 30 Mar 2013 17:07:53 GMT
On Fri, Mar 29, 2013 at 11:36 AM, Mechtilde <ooo@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 <zreizinger@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 <
> >>>> andrew@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."

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message