 |
AppletTalk.com
Java discussions newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Ruben Storm
Guest
|
 Posted: Tue Jun 29, 2004 10:01 am Post subject: Looking for the right Database |
 |
|
Im looking for a opensource Database, that i could use for Developing Java
Software and distribute with the Software easy.
It has to be multiplattform, fast and easy to install or to be easy to be
distributed in my Application.
It it not supose to be with the legal stuff and high prices, i want to keep
the cost low.
What would you use for a database system??
Thanx for your help
--
Mit freundlichen Gruessen
Ruben Storm
#########################################################
Storm - NET Heilbronn Tel.: +49 7131 642919 0
Ruben Storm Fax: +49 7131 642919 200
Gartenstrasse 46 E-Mail: [email]office (AT) storm-isp (DOT) de[/email]
74072 Heilbronn Web: http://www.storm-isp.de
#########################################################
|
|
| Back to top |
|
 |
Christophe Vanfleteren
Guest
|
| Posted: Tue Jun 29, 2004 10:05 am Post subject: Re: Looking for the right Database |
|
|
Ruben Storm wrote:
| Quote: |
Im looking for a opensource Database, that i could use for Developing Java
Software and distribute with the Software easy.
It has to be multiplattform, fast and easy to install or to be easy to be
distributed in my Application.
It it not supose to be with the legal stuff and high prices, i want to
keep the cost low.
What would you use for a database system??
Thanx for your help
|
Hsqldb is perfect for embedded usage:
<http://hsqldb.sf.net>
--
Kind regards,
Christophe Vanfleteren
|
|
| Back to top |
|
|
Thomas Pfäfflin
Guest
|
| Posted: Tue Jun 29, 2004 10:35 am Post subject: Re: Looking for the right Database |
|
|
Am Tue, 29 Jun 2004 12:01:45 +0200 schrieb Ruben Storm
<office (AT) storm-isp (DOT) de>:
| Quote: |
Im looking for a opensource Database, that i could use for Developing
Java
Software and distribute with the Software easy.
It has to be multiplattform, fast and easy to install or to be easy to be
distributed in my Application.
It it not supose to be with the legal stuff and high prices, i want to
keep
the cost low.
What would you use for a database system??
Thanx for your help
|
mckoidb may also fit your needs:
http://mckoi.com/database/
|
|
| Back to top |
|
|
Ruben Storm
Guest
|
| Posted: Tue Jun 29, 2004 11:19 am Post subject: Re: Looking for the right Database |
|
|
Christophe Vanfleteren wrote:
| Quote: | Ruben Storm wrote:
Im looking for a opensource Database, that i could use for Developing
Java Software and distribute with the Software easy.
It has to be multiplattform, fast and easy to install or to be easy to be
distributed in my Application.
It it not supose to be with the legal stuff and high prices, i want to
keep the cost low.
What would you use for a database system??
Thanx for your help
Hsqldb is perfect for embedded usage:
http://hsqldb.sf.net
|
I was playing with HSQL, but i did not find my Database and tables. I made a
addressbook under Java, did all the insert and querys. Then i looked at the
DB and it shows me 0 byte size. I thought it might be only in the Memory,
so i reboot my PC and restarted the application, all my data was there, but
where was it, the DB still was showing 0 byte.
So i got confused with it, and did not understand how it works. Normally i
work with MySQL and i have to know how a DBSystem works to develop a
application.
MySQL is not the right DB for my Project, because it is not easy to install,
and my Project has to be as simple as posible. I want to give it someone
who bearly know how to start a PC, and he has to be able to install it
without knowing much.
--
Mit freundlichen Gruessen
Ruben Storm
#########################################################
Storm - NET Heilbronn Tel.: +49 7131 642919 0
Ruben Storm Fax: +49 7131 642919 200
Gartenstrasse 46 E-Mail: [email]office (AT) storm-isp (DOT) de[/email]
74072 Heilbronn Web: http://www.storm-isp.de
#########################################################
|
|
| Back to top |
|
|
Thomas Kellerer
Guest
|
| Posted: Tue Jun 29, 2004 11:26 am Post subject: Re: Looking for the right Database |
|
|
On 29.06.2004 13:19 Ruben Storm wrote:
| Quote: | I was playing with HSQL, but i did not find my Database and tables. I made a
addressbook under Java, did all the insert and querys. Then i looked at the
DB and it shows me 0 byte size. I thought it might be only in the Memory,
so i reboot my PC and restarted the application, all my data was there, but
where was it, the DB still was showing 0 byte.
So i got confused with it, and did not understand how it works.
|
Only cached tables go into the .data file. Other tables are stored as a series
of INSERTs in the .script file.
It's not that clear from the documentation but basically it's described here
(for 1.7.1):
http://hsqldb.sourceforge.net/web/hsqlModes.html
1.7.2 comes with a newly structured documentation set which explains the
different files more detailed.
Thomas
|
|
| Back to top |
|
|
Robert Klemme
Guest
|
| Posted: Tue Jun 29, 2004 11:44 am Post subject: Re: Looking for the right Database |
|
|
"Ruben Storm" <office (AT) storm-isp (DOT) de> schrieb im Newsbeitrag
news:2kd1giFu2t9U1 (AT) uni-berlin (DOT) de...
| Quote: | Christophe Vanfleteren wrote:
Ruben Storm wrote:
Im looking for a opensource Database, that i could use for Developing
Java Software and distribute with the Software easy.
It has to be multiplattform, fast and easy to install or to be easy
to be
distributed in my Application.
It it not supose to be with the legal stuff and high prices, i want
to
keep the cost low.
What would you use for a database system??
Thanx for your help
Hsqldb is perfect for embedded usage:
http://hsqldb.sf.net
I was playing with HSQL, but i did not find my Database and tables. I
made a
addressbook under Java, did all the insert and querys. Then i looked at
the
DB and it shows me 0 byte size. I thought it might be only in the
Memory,
so i reboot my PC and restarted the application, all my data was there,
but
where was it, the DB still was showing 0 byte.
So i got confused with it, and did not understand how it works. Normally
i
work with MySQL and i have to know how a DBSystem works to develop a
application.
|
Did you commit the changes?
robert
| Quote: | MySQL is not the right DB for my Project, because it is not easy to
install,
and my Project has to be as simple as posible. I want to give it someone
who bearly know how to start a PC, and he has to be able to install it
without knowing much.
--
Mit freundlichen Gruessen
Ruben Storm
#########################################################
Storm - NET Heilbronn Tel.: +49 7131 642919 0
Ruben Storm Fax: +49 7131 642919 200
Gartenstrasse 46 E-Mail: [email]office (AT) storm-isp (DOT) de[/email]
74072 Heilbronn Web: http://www.storm-isp.de
#########################################################
|
|
|
| Back to top |
|
|
Alex Molochnikov
Guest
|
| Posted: Tue Jun 29, 2004 3:06 pm Post subject: Re: Looking for the right Database |
|
|
http://mckoi.com/database/
Written in Java. The simplest to install and run. Free (GPL).
"Ruben Storm" <office (AT) storm-isp (DOT) de> wrote
| Quote: |
Im looking for a opensource Database, that i could use for Developing Java
Software and distribute with the Software easy.
It has to be multiplattform, fast and easy to install or to be easy to be
distributed in my Application.
It it not supose to be with the legal stuff and high prices, i want to
keep
the cost low.
What would you use for a database system??
Thanx for your help
--
Mit freundlichen Gruessen
Ruben Storm
#########################################################
Storm - NET Heilbronn Tel.: +49 7131 642919 0
Ruben Storm Fax: +49 7131 642919 200
Gartenstrasse 46 E-Mail: [email]office (AT) storm-isp (DOT) de[/email]
74072 Heilbronn Web: http://www.storm-isp.de
#########################################################
|
|
|
| Back to top |
|
|
Roedy Green
Guest
|
| Posted: Tue Jun 29, 2004 3:47 pm Post subject: Re: Looking for the right Database |
|
|
On Tue, 29 Jun 2004 13:19:42 +0200, Ruben Storm <office (AT) storm-isp (DOT) de>
wrote or quoted :
| Quote: | I was playing with HSQL, but i did not find my Database and tables. I made a
addressbook under Java, did all the insert and querys. Then i looked at the
DB and it shows me 0 byte size. I thought it might be only in the Memory,
so i reboot my PC and restarted the application, all my data was there, but
where was it, the DB still was showing 0 byt
|
That DB works in several modes. In one of them the database is not
persistent -- memory only.
--
Canadian Mind Products, Roedy Green.
Coaching, problem solving, economical contract programming.
See http://mindprod.com/jgloss/jgloss.html for The Java Glossary.
|
|
| Back to top |
|
|
Ruben Storm
Guest
|
| Posted: Wed Jun 30, 2004 2:18 pm Post subject: Re: Looking for the right Database |
|
|
Alex Molochnikov wrote:
| Quote: | http://mckoi.com/database/
Written in Java. The simplest to install and run. Free (GPL).
"Ruben Storm" <office (AT) storm-isp (DOT) de> wrote in message
news:2kcsudFgld0U2 (AT) uni-berlin (DOT) de...
Im looking for a opensource Database, that i could use for Developing
Java Software and distribute with the Software easy.
It has to be multiplattform, fast and easy to install or to be easy to be
distributed in my Application.
It it not supose to be with the legal stuff and high prices, i want to
keep
the cost low.
What would you use for a database system??
Thanx for your help
--
Mit freundlichen Gruessen
Ruben Storm
#########################################################
Storm - NET Heilbronn Tel.: +49 7131 642919 0
Ruben Storm Fax: +49 7131 642919 200
Gartenstrasse 46 E-Mail: [email]office (AT) storm-isp (DOT) de[/email]
74072 Heilbronn Web: http://www.storm-isp.de
#########################################################
|
Not that free, only for Software under GPL.
But what is with Freeware and Shareware??
--
Mit freundlichen Gruessen
Ruben Storm
#########################################################
Storm - NET Heilbronn Tel.: +49 7131 642919 0
Ruben Storm Fax: +49 7131 642919 200
Gartenstrasse 46 E-Mail: [email]office (AT) storm-isp (DOT) de[/email]
74072 Heilbronn Web: http://www.storm-isp.de
#########################################################
|
|
| Back to top |
|
|
Alex Molochnikov
Guest
|
| Posted: Wed Jun 30, 2004 2:42 pm Post subject: Re: Looking for the right Database |
|
|
"Ruben Storm" <office (AT) storm-isp (DOT) de> wrote
It is free for aggregation and distribution with commercial applications.
The commercial product that does not have built-in dependencies on McKoi
(that is, can compile and run without it - say, using some other database
instead) does not come under GPL. The keyword here is "aggreagtion" as
defined in the GPL text and confirmed by McKoi developers - see here
http://mckoi.com/database/mail/subject.jsp?id=5579&highlight=aggregation+#MS
G_5583.
AM
|
|
| Back to top |
|
|
Ruben Storm
Guest
|
| Posted: Wed Jun 30, 2004 4:14 pm Post subject: Re: Looking for the right Database |
|
|
Alex Molochnikov wrote:
| Quote: | "Ruben Storm" <office (AT) storm-isp (DOT) de> wrote in message
news:2kg0bpF1ttjsU1 (AT) uni-berlin (DOT) de...
Alex Molochnikov wrote:
http://mckoi.com/database/
Not that free, only for Software under GPL.
It is free for aggregation and distribution with commercial applications.
The commercial product that does not have built-in dependencies on McKoi
(that is, can compile and run without it - say, using some other database
instead) does not come under GPL. The keyword here is "aggreagtion" as
defined in the GPL text and confirmed by McKoi developers - see here
http://mckoi.com/database/mail/subject.jsp?id=5579&highlight=aggregation+#MS
G_5583.
AM
|
Ok,
but what is if the Software does not run without the Database, but it is
freeware??
The other question is, if i have two versions, one with McKoi and one
without a database. The one without the database, someone has to setup his
own Database to use with the software.
What is in that case?
The think is that i will work on the Project, as long as that Protect is not
finished, i will release it as freeware. But the finished one will be
commercial, the last release before that will stay freeware.
In the commercial one i dont have a problem with paying the $50 each sold
lizenz to McKoi, i just recharge it the enduser. But if i have to pay the
$50 it for every freeware lizenz i distribute, i will be badly broke.
Thanx a lot
--
Mit freundlichen Gruessen
Ruben Storm
#########################################################
Storm - NET Heilbronn Tel.: +49 7131 642919 0
Ruben Storm Fax: +49 7131 642919 200
Gartenstrasse 46 E-Mail: [email]office (AT) storm-isp (DOT) de[/email]
74072 Heilbronn Web: http://www.storm-isp.de
#########################################################
|
|
| Back to top |
|
|
Ruben Storm
Guest
|
| Posted: Wed Jun 30, 2004 6:06 pm Post subject: Re: Looking for the right Database |
|
|
Ruben Storm wrote:
| Quote: |
Im looking for a opensource Database, that i could use for Developing Java
Software and distribute with the Software easy.
It has to be multiplattform, fast and easy to install or to be easy to be
distributed in my Application.
It it not supose to be with the legal stuff and high prices, i want to
keep the cost low.
What would you use for a database system??
Thanx for your help
|
Thanks a lot for all your help.
I will look into mckoi.
--
Mit freundlichen Gruessen
Ruben Storm
#########################################################
Storm - NET Heilbronn Tel.: +49 7131 642919 0
Ruben Storm Fax: +49 7131 642919 200
Gartenstrasse 46 E-Mail: [email]office (AT) storm-isp (DOT) de[/email]
74072 Heilbronn Web: http://www.storm-isp.de
#########################################################
|
|
| Back to top |
|
|
Alex Molochnikov
Guest
|
| Posted: Wed Jun 30, 2004 7:06 pm Post subject: Re: Looking for the right Database |
|
|
"Ruben Storm" <office (AT) storm-isp (DOT) de> wrote
| Quote: | Alex Molochnikov wrote:
Ok,
but what is if the Software does not run without the Database, but it is
freeware??
|
First of all, a general disclaimer: for a definitive answer, you should
contact McKoi SQL developers. Having said that, the issue of GPL, or McKoi
licensing has nothing to do with the amount of money you intend to charge
for your product. The only thing that matters here is whether your product
has built-in dependencies on the GPLed software (in this case, McKoi). If
the dependencies do exist, then you have a choice of either releasing your
product under the GPL, or buying a commercial license from McKoi. What you
sell your product for is immaterial.
| Quote: | The other question is, if i have two versions, one with McKoi and one
without a database. The one without the database, someone has to setup his
own Database to use with the software.
What is in that case?
|
To avoid attracting the GPL, you should have one version of your product
that is free of any dependencies on McKoi. You can have an ASCII file that
spells out the name of the JDBC driver, and have your program load it at the
runtime. This way the users can switch from one database to another of their
choosing, and you product's operation does not depend on the presence of
McKoi files in its environment (so long as the users choose another
database).
| Quote: | The think is that i will work on the Project, as long as that Protect is
not
finished, i will release it as freeware. But the finished one will be
commercial, the last release before that will stay freeware.
In the commercial one i dont have a problem with paying the $50 each sold
lizenz to McKoi, i just recharge it the enduser. But if i have to pay the
$50 it for every freeware lizenz i distribute, i will be badly broke.
|
See above. Avoid the built-in dependencies on a particular database (i.e.
use the JDBC and plain-vanilla SQL constructs), and you are free. Make a
direct refence to the proprietory parts of McKoi (or any GPLed product for
this matter) and you are hooked. It all boils down to how you organize your
database-handling code.
You are welcome, but check it out with McKoi developers.
|
|
| Back to top |
|
|
jackie
Guest
|
| Posted: Fri Jul 02, 2004 6:41 am Post subject: Re: Looking for the right Database |
|
|
It looks cool but it seems sub-query is not supported and there are quite a
few development status or user comment described in the web site.
If there are info on the stability/performance and commonly known issues, it
will be great.
Alex Molochnikov <NOBODY (AT) NOSPAM (DOT) COM> wrote
| Quote: | http://mckoi.com/database/
Written in Java. The simplest to install and run. Free (GPL).
"Ruben Storm" <office (AT) storm-isp (DOT) de> wrote in message
news:2kcsudFgld0U2 (AT) uni-berlin (DOT) de...
Im looking for a opensource Database, that i could use for Developing
Java
Software and distribute with the Software easy.
It has to be multiplattform, fast and easy to install or to be easy to
be
distributed in my Application.
It it not supose to be with the legal stuff and high prices, i want to
keep
the cost low.
What would you use for a database system??
Thanx for your help
--
Mit freundlichen Gruessen
Ruben Storm
#########################################################
Storm - NET Heilbronn Tel.: +49 7131 642919 0
Ruben Storm Fax: +49 7131 642919 200
Gartenstrasse 46 E-Mail: [email]office (AT) storm-isp (DOT) de[/email]
74072 Heilbronn Web: http://www.storm-isp.de
#########################################################
|
|
|
| Back to top |
|
|
Ruben Storm
Guest
|
| Posted: Fri Jul 02, 2004 8:47 am Post subject: Re: Looking for the right Database |
|
|
jackie wrote:
| Quote: | It looks cool but it seems sub-query is not supported and there are quite
a few development status or user comment described in the web site.
If there are info on the stability/performance and commonly known issues,
it will be great.
Alex Molochnikov <NOBODY (AT) NOSPAM (DOT) COM> wrote in message
news:KzfEc.902408$Pk3.651487 (AT) pd7tw1no (DOT) ..
http://mckoi.com/database/
Written in Java. The simplest to install and run. Free (GPL).
"Ruben Storm" <office (AT) storm-isp (DOT) de> wrote in message
news:2kcsudFgld0U2 (AT) uni-berlin (DOT) de...
Im looking for a opensource Database, that i could use for Developing
Java
Software and distribute with the Software easy.
It has to be multiplattform, fast and easy to install or to be easy to
be
distributed in my Application.
It it not supose to be with the legal stuff and high prices, i want to
keep
the cost low.
What would you use for a database system??
Thanx for your help
--
Mit freundlichen Gruessen
Ruben Storm
#########################################################
Storm - NET Heilbronn Tel.: +49 7131 642919 0
Ruben Storm Fax: +49 7131 642919 200
Gartenstrasse 46 E-Mail: [email]office (AT) storm-isp (DOT) de[/email]
74072 Heilbronn Web: http://www.storm-isp.de
#########################################################
|
So, im still looking for the right solution. At the moment i look into
Berkeley DB.
I also just had the thought of using a XML Database. But the last test with
XML i did was to slow. The fastest Query i got out been 6 seconds waiting.
The slowest been 35 seconds, that was way to slo i think.
I appriciate you help. Thanks
--
Mit freundlichen Gruessen
Ruben Storm
#########################################################
Storm - NET Heilbronn Tel.: +49 7131 642919 0
Ruben Storm Fax: +49 7131 642919 200
Gartenstrasse 46 E-Mail: [email]office (AT) storm-isp (DOT) de[/email]
74072 Heilbronn Web: http://www.storm-isp.de
#########################################################
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
