Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / January 2004

Tip: Looking for answers? Try searching our database.

Which database to choose

Thread view: 
tommy - 25 Jan 2004 14:12 GMT
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


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.