headers
John Zoetebier | 3 Jan 2005 22:06
Picon
Favicon

OpenOffice 2.0 chooses HSQLDB as embedded database

Hi all,

Have a look at this web page: 
http://dba.openoffice.org/miscellaneous/dba20.html

As far as I can see are all arguments used to choose HSQLDB are also 
applicable to McKoi.
However McKoi is not even mentioned as an option.
Does someone know why this is ?
Can we push McKoi in OpenOffice 2.0 ?

--

-- 
John Zoetebier
Web site: http://www.transparent.co.nz

---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com
Permalink | Reply | 13 comments |
headers
Geert Bevin | 3 Jan 2005 22:31
Favicon

Re: OpenOffice 2.0 chooses HSQLDB as embedded database


Maybe the restrictions of the GPL license has an impact?

On 03 Jan 2005, at 22:06, John Zoetebier wrote:

> Hi all,
>
> Have a look at this web page:
> http://dba.openoffice.org/miscellaneous/dba20.html
>
> As far as I can see are all arguments used to choose HSQLDB are also
> applicable to McKoi.
> However McKoi is not even mentioned as an option.
> Does someone know why this is ?
> Can we push McKoi in OpenOffice 2.0 ?
>
> -- 
> John Zoetebier
> Web site: http://www.transparent.co.nz
>
>
>
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com
>
>
--
Geert Bevin                       Uwyn bvba
"Use what you need"               Avenue de Scailmont 34
(Continue reading)

Permalink | Reply | 0 comments |
headers
John Zoetebier | 5 Jan 2005 09:49
Picon
Favicon

Does BLOB field affect performance ?

Does a BLOB field in a record affect response time, even if the BLOB field is 
null ?

I am pondering about adding a BLOB field to a record for future use.
If however there is a significant performance issue, I may add an additional 
table to store the BLOB field.
The record in that table is read only of I know that the BLOB field is 
present.

--

-- 
John Zoetebier
Web site: http://www.transparent.co.nz

---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com
Permalink | Reply | 1 comment |
headers
Tobias Downer | 6 Jan 2005 00:17

Re: OpenOffice 2.0 chooses HSQLDB as embedded database

John,

This may be licensing issues, or it may be that they simply are not 
aware of Mckoi.  Does anyone know what license OpenOffice Base is 
distributed under?  I am going to send an email to them and suggest they 
consider Mckoi.

Toby.

John Zoetebier wrote:

> Hi all,
> 
> Have a look at this web page: 
> http://dba.openoffice.org/miscellaneous/dba20.html
> 
> As far as I can see are all arguments used to choose HSQLDB are also 
> applicable to McKoi.
> However McKoi is not even mentioned as an option.
> Does someone know why this is ?
> Can we push McKoi in OpenOffice 2.0 ?
> 

---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com
Permalink | Reply | 11 comments |
headers
Tobias Downer | 6 Jan 2005 00:22

Re: Does BLOB field affect performance ?

It does somewhat depend on what you do, but a BLOB field does not 
significantly reduce performance for SELECT operations.  If you have a 
table such as;

   CREATE TABLE a_table ( a INTEGER, b INTEGER, c INTEGER, d BLOB );

And your query is;

   SELECT a, b, c FROM a_table;

It will be exactly the same performance regardless of whether you have 
BLOB column 'd' defined or not.  Creating a table just to store BLOB 
data is not necessary.

Toby.

John Zoetebier wrote:

> Does a BLOB field in a record affect response time, even if the BLOB field is 
> null ?
> 
> I am pondering about adding a BLOB field to a record for future use.
> If however there is a significant performance issue, I may add an additional 
> table to store the BLOB field.
> The record in that table is read only of I know that the BLOB field is 
> present.
> 

---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
(Continue reading)

Permalink | Reply | 0 comments |
headers
John Zoetebier | 6 Jan 2005 03:49
Picon
Favicon

Re: OpenOffice 2.0 chooses HSQLDB as embedded database

On Thu, 06 Jan 2005 12:17, Tobias Downer wrote:
> John,
>
> This may be licensing issues, or it may be that they simply are not
> aware of Mckoi.  Does anyone know what license OpenOffice Base is
> distributed under?  I am going to send an email to them and suggest they
> consider Mckoi.

Please have a look here : http://www.openoffice.org/FAQs/faq-licensing.html
=>
Which licenses does the OpenOffice.org project use? 

OpenOffice.org uses a dual license strategy for the source code. These 
licenses are the GNU Lesser General Public License (LGPL) and the Sun 
Industry Standards Source License (SISSL). OpenOffice.org also uses the 
Public Documentation License (PDL) for modifiable documentation that will not 
be included in any final product but will be of service to users. Please see 
the section below on that license for more information.
=>

There is more information online.

The LGPL license does not require the product in which the LGPL code is used 
to be made public, while GLP requires the code to be made public.
However does using mckoidb.jar mean that the client must be made available as 
GPL ?
I don't think so.
From my point of view does GPL mean that any changes made to the original code 
must be made public.
However using the GPL code as a library does not make my code GPL.
(Continue reading)

Permalink | Reply | 10 comments |
headers
Luigi Bai | 6 Jan 2005 04:04

Re: OpenOffice 2.0 chooses HSQLDB as embedded database


[snip]
> 
> The LGPL license does not require the product in which the LGPL code is used 
> to be made public, while GPL requires the code to be made public.
> However does using mckoidb.jar mean that the client must be made available as 
> GPL ?
> I don't think so.
> From my point of view does GPL mean that any changes made to the original code 
> must be made public.
> However using the GPL code as a library does not make my code GPL.
> That is my interpretation of GPL.
> If my interpretation is correct there are no obstacles for using McKoi.
>

Your interpretation of the GPL is not correct: 
http://www.fsf.org/licenses/lgpl-java.html

Only Toby and Diehl and Associates know their intent in licensing, and 
they can certainly provide an alternate license to users with OO 2.0. 
However, it seems pretty clear that the OO team cannot integrate/ship OO 
with McKoi as long as they can only procure/provide McKoi under the GPL. 
If you want to integrate McKoi with your application *and distribute it* 
then your application must be GPL as well.

Nothing stops an *end user* from using McKoi with OO (they can integrate 
but not distribute), and OO can provide documentation on how to do that; 
they just can't distribute McKoi themselves.

At least that's my understanding. IANAL.
(Continue reading)

Permalink | Reply | 9 comments |
headers
Okyere, Emmanuel II | 6 Jan 2005 12:02

RE: OpenOffice 2.0 chooses HSQLDB as embedded database

Luigi is correct; there was a long thread on this on /. Sometime back
[http://developers.slashdot.org/article.pl?sid=03/07/17/2257224]

Brad Kuhn's update: "LGPL's S. 6 allows you to make new works that link with
the LGPL'ed code, and license them any way you see fit. Only the LGPL'ed
code itself must remain Free. Such 'client code' can even be proprietary; it
need not be LGPL'ed."

With McKoi's (GPL) license, however, client code becomes GPLed too.

- eokyere

---

Emmanuel OKYERE II
CTO - AKUABA, LLC
Phone/Fax:  703.815.4702
PGP Key ID: 0xA7FD6168
MSN: compubandit
AIM: compubndit

http://www.okyere.org/

| -----Original Message-----
| From: mckoidb <at> mckoi.com [mailto:mckoidb <at> mckoi.com] On Behalf Of Luigi Bai
| Sent: Wednesday, January 05, 2005 10:04 PM
| To: mckoidb <at> mckoi.com
| Subject: Re: OpenOffice 2.0 chooses HSQLDB as embedded database
| 
|
(Continue reading)

Permalink | Reply | 8 comments |
headers
n/a | 6 Jan 2005 14:50
Picon
Favicon

RE: [OWNERSHIP]OpenOffice 2.0 chooses HSQLDB as embedded database


My code is mine, you can't have it.
Farewell, McKoi.

 --- On Thu 01/06, Okyere, Emmanuel II < chief <at> okyere.org > wrote:
From: Okyere, Emmanuel II [mailto: chief <at> okyere.org]
To: mckoidb <at> mckoi.com
Date: Thu, 6 Jan 2005 06:02:51 -0500
Subject: RE: OpenOffice 2.0 chooses HSQLDB as embedded database

Luigi is correct; there was a long thread on this on /. Sometime
back<br>[http://developers.slashdot.org/article.pl?sid=03/07/17/2257224]<br><br>Brad
Kuhn's update: "LGPL's S. 6 allows you to make new works that link with<br>the LGPL'ed code, and license
them any way you see fit. Only the LGPL'ed<br>code itself must remain Free. Such 'client code' can even be
proprietary; it<br>need not be LGPL'ed."<br><br>With McKoi's (GPL) license, however, client code
becomes GPLed too.<br><br>- eokyere<br><br>---<br><br>Emmanuel OKYERE II<br>CTO - AKUABA,
LLC<br>Phone/Fax:  703.815.4702<br>PGP Key ID: 0xA7FD6168<br>MSN: compubandit<br>AIM:
compubndit<br><br>http://www.okyere.org/<br><br>| -----Original Message-----<br>| From:
mckoidb <at> mckoi.com [mailto:mckoidb <at> mckoi.com] On Behalf Of Luigi Bai<br>| Sent: Wednesday, January
05, 2005 10:04 PM<br>| To: mckoidb <at> mckoi.com<br>| Subject: Re: OpenOffice 2.0 c
 hooses HSQLDB as embedded database<br>| <br>| <br>| [snip]<br>| ><br>| > The LGPL license does not
require the product in which the LGPL code is<br>| used<br>| > to be made public, while GPL requires the
code to be made public.<br>| > However does using mckoidb.jar mean that the client must be made<br>|
available as<br>| > GPL ?<br>| > I don't think so.<br>| > From my point of view does GPL mean that any changes
made to the<br>| original code<br>| > must be made public.<br>| > However using the GPL code as a library
does not make my code GPL.<br>| > That is my interpretation of GPL.<br>| > If my interpretation is correct
there are no obstacles for using McKoi.<br>| ><br>| <br>| Your interpretation of the GPL is not
correct:<br>| http://www.fsf.org/licenses/lgpl-java.html<br>| <br>| Only Toby and Diehl and
Associates know their intent in licensing, and<br>| they can certainly provide an
  alternate license to users with OO 2.0.<br>| However, it seems pretty clear that the OO team cannot
(Continue reading)

Permalink | Reply | 0 comments |
headers
John Zoetebier | 6 Jan 2005 21:41
Picon
Favicon

Re: OpenOffice 2.0 chooses HSQLDB as embedded database

Toby,

Can you please confirm the intentions you or Diehl have with regard to the GPL 
licensing ?
Until now it looked to me I could use McKoi as a database in a non GPL 
product ?
Regards,

-- 
John Zoetebier
Web site: http://www.transparent.co.nz

On Fri, 07 Jan 2005 00:02, Okyere, Emmanuel II wrote:
> Luigi is correct; there was a long thread on this on /. Sometime back
> [http://developers.slashdot.org/article.pl?sid=03/07/17/2257224]
>
> Brad Kuhn's update: "LGPL's S. 6 allows you to make new works that link
> with the LGPL'ed code, and license them any way you see fit. Only the
> LGPL'ed code itself must remain Free. Such 'client code' can even be
> proprietary; it need not be LGPL'ed."
>
> With McKoi's (GPL) license, however, client code becomes GPLed too.
>
> - eokyere
>
> ---
>
> Emmanuel OKYERE II
> CTO - AKUABA, LLC
> Phone/Fax:  703.815.4702
(Continue reading)

Permalink | Reply | 7 comments |

Gmane