Hi
I have got the task to write an application which is going to be sold. In
this app. I need a database to hold datainput from users. Now which databsae
can I use to distribute with the app? I've asked MS and they say that if
Access we must buy a Access licenses for each app. we sell. That would be
too expencive. I see that Filemaker have something to USD 499,- and it could
be a solution. But I woul like to hear I any of you have some better ideas?
TIA
Tommy
PS some of the data we must use in the app is now in a Access database
t
Alex Molochnikov - 25 Jan 2004 23:20 GMT
http://mckoi.com/database/
Freely distributable. Open source. Pure Java. Can be embedded into your app.
GPL.
HTH
Alex Molochnikov
Gestalt Corporation
www.gestalt.com
> Hi
>
[quoted text clipped - 12 lines]
>
> t
tommy - 26 Jan 2004 19:29 GMT
Thanks
I will check it out.
Tommy
David Morse - 27 Jan 2004 18:24 GMT
I don't think McKoi is freely distributable in a commercial app - you better
check that out.
Look at the FirstSQL/J 100% Java ORDBMS - enhanced and optimized for J2EE to
J2ME platforms and everything in between on any JDK 1.1 or greater JVM.
http://www.firstsql.com/ it has commercial distribution costs in the same
range as McKoi.
Dave M.
> Thanks
>
> I will check it out.
>
> Tommy
Alex Molochnikov - 27 Jan 2004 20:01 GMT
> I don't think McKoi is freely distributable in a commercial app - you better
> check that out.
The issue of McKoi licensing is covered in the McKoi mailing archive, as
well as in the FAQ and the license text. In brief: aggregating McKoi (.jar
files + JDBC drivers) with any app - commercial or not - is free. The catch
is to comply with the terms of GPL - i.e. the program making use of McKoi
must not have any built-in dependencies on McKoi. IOW, it must only use
standard JDBC method calls, avoid using McKoi-specific database control API,
and exile the name of McKoi JDBC driver into an external file, rather than
hardcoding the String in the program.
> Look at the FirstSQL/J 100% Java ORDBMS - enhanced and optimized for J2EE to
> J2ME platforms and everything in between on any JDK 1.1 or greater JVM.
>
> http://www.firstsql.com/ it has commercial distribution costs in the same
> range as McKoi.
Huh? You obviously don't know McKoi's distribution rules (see above) - how
can you claim the distribution costs of McKoi to be "in the same range"? One
more time: McKoi IS FREE.
> Dave M.
Alex Molochnikov
Gestalt Corporation
www.gestalt.com
Lee Fesperman - 26 Jan 2004 21:44 GMT
> Hi
>
[quoted text clipped - 4 lines]
> too expencive. I see that Filemaker have something to USD 499,- and it could
> be a solution. But I woul like to hear I any of you have some better ideas?
If you are developing in Java, you should use a Java RDBMS. Check out our product --
FirstSQL/J (see my sig). We provide very reasonable runtime licensing.

Signature
Lee Fesperman, FirstSQL, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)
David Harper - 27 Jan 2004 07:07 GMT
> I have got the task to write an application which is going to be sold. In
> this app. I need a database to hold datainput from users. Now which databsae
> can I use to distribute with the app? I've asked MS and they say that if
> Access we must buy a Access licenses for each app. we sell. That would be
> too expencive. I see that Filemaker have something to USD 499,- and it could
> be a solution. But I woul like to hear I any of you have some better ideas?
MySQL is a good open-source database system. It's free. It's easy to
install and use. It has an excellent JDBC driver. There's a great
book by Paul DuBois.
It's used by big names like NASA.
It's not a Microsoft product, but you *can* run it on Windows if you
don't have a proper operating system.
Visit www.mysql.com for information and downloads.
David Harper
[A satisfied MySQL admin and Java programmer from sunny Cambridge,
England]
Leo Gaggl - 27 Jan 2004 11:38 GMT
I don't think I'd classify MySQL as a database that you would distribute
with your app.
It's a very capable DB Server (although I personally prefer PostgreSQL)
but if I interpret the question correctly an Embedded DB is needed.
You will need to clarify your needs a bit better to get a good answer -
"Which database to choose" is like asking which hammer is the best -
well that's very much going to depend on the task at hand.
http://www.google.com.au/search?q=java+embedded+database&hl=en&lr=&ie=UTF-8&star
t=10&sa=N
will give you quite a few relevant results. Google first - ask later ...
> .... from sunny Cambridge, England
You were joking - were you ;-)
HTH,
--
Leo Gaggl
Adelaide, South Australia <--- now that's SUNNY :)
>> I have got the task to write an application which is going to be sold. In
>> this app. I need a database to hold datainput from users. Now which
[quoted text clipped - 20 lines]
> [A satisfied MySQL admin and Java programmer from sunny Cambridge,
> England]
David Harper - 27 Jan 2004 19:13 GMT
> I don't think I'd classify MySQL as a database that you would distribute
> with your app.
Quite the contrary. At the 2003 MySQL Users Conference and Expo,
Sanjeeev Binaykia presented a talk titled "DynamicCD: Delivering
MySQL-Driven Websites on CD"
The talk described a method for bundling MySQL with the Apache
web server and PHP scripting language to create a complete,
self-contained, database-driven web site that can be run directly
from a CD.
Full details here ...
http://www.mysql.com/events/uc2003/session.html
David Harper
A satisfied MySQL user ("we should have him stuffed!")
Stefan Ortmanns - 27 Jan 2004 12:03 GMT
> Hi
>
[quoted text clipped - 12 lines]
>
> t
Hi,
using a RDBMS may have a few advantages but i prefer alternatives.
Some open source databases:
http://www.prevayler.org
http://www.drjava.de/smyle/
A commercial product with fair pricing:
http://www.db4o.com
Notice that all of the projects i've listed do not support SQL but
real transparent object persistence.
Greetings,
Stefan
tommy - 27 Jan 2004 14:31 GMT
Thank you very much all of you.
I will look at all the links you've provided. But as far as MySQL it's not
free if you embedd it in a commercial product, in this case they charge 80
euros for each copy sold.
But I will now study all the material
From the not so sunny Denmark
8>)
Tommy
Thomas Kellerer - 27 Jan 2004 19:21 GMT
tommy schrieb:
> Hi
>
[quoted text clipped - 4 lines]
> too expencive. I see that Filemaker have something to USD 499,- and it could
> be a solution. But I woul like to hear I any of you have some better ideas?
Have a look at http://hsqldb.sourceforge.net