 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / July 2004Looking 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  SignatureMit freundlichen Gruessen Ruben Storm ######################################################### Storm - NET Heilbronn Tel.: +49 7131 642919 0 Ruben Storm Fax: +49 7131 642919 200 Gartenstrasse 46 E-Mail: office@storm-isp.de 74072 Heilbronn Web: http://www.storm-isp.de ######################################################### > Im looking for a opensource Database, that i could use for Developing Java > Software and distribute with the Software easy. [quoted text clipped - 8 lines] > > Thanx for your help Hsqldb is perfect for embedded usage: <http://hsqldb.sf.net> SignatureKind regards, Christophe Vanfleteren >> Im looking for a opensource Database, that i could use for Developing >> Java Software and distribute with the Software easy. [quoted text clipped - 11 lines] > 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. SignatureMit freundlichen Gruessen Ruben Storm ######################################################### Storm - NET Heilbronn Tel.: +49 7131 642919 0 Ruben Storm Fax: +49 7131 642919 200 Gartenstrasse 46 E-Mail: office@storm-isp.de 74072 Heilbronn Web: http://www.storm-isp.de ######################################################### > 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 [quoted text clipped - 3 lines] > > 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 > >> Im looking for a opensource Database, that i could use for Developing > >> Java Software and distribute with the Software easy. [quoted text clipped - 21 lines] > work with MySQL and i have to know how a DBSystem works to develop a > application. Did you commit the changes? robert > 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. >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. SignatureCanadian Mind Products, Roedy Green. Coaching, problem solving, economical contract programming. See http://mindprod.com/jgloss/jgloss.html for The Java Glossary. Am Tue, 29 Jun 2004 12:01:45 +0200 schrieb Ruben Storm <office@storm-isp.de>: > Im looking for a opensource Database, that i could use for Developing > Java [quoted text clipped - 10 lines] > > Thanx for your help mckoidb may also fit your needs: http://mckoi.com/database/ http://mckoi.com/database/ Written in Java. The simplest to install and run. Free (GPL). > Im looking for a opensource Database, that i could use for Developing Java > Software and distribute with the Software easy. [quoted text clipped - 22 lines] > > ######################################################### > http://mckoi.com/database/ > [quoted text clipped - 27 lines] >> >> ######################################################### Not that free, only for Software under GPL. But what is with Freeware and Shareware?? SignatureMit freundlichen Gruessen Ruben Storm ######################################################### Storm - NET Heilbronn Tel.: +49 7131 642919 0 Ruben Storm Fax: +49 7131 642919 200 Gartenstrasse 46 E-Mail: office@storm-isp.de 74072 Heilbronn Web: http://www.storm-isp.de ######################################################### > > 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 >> > http://mckoi.com/database/ >> > [quoted text clipped - 5 lines] > 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 SignatureMit freundlichen Gruessen Ruben Storm ######################################################### Storm - NET Heilbronn Tel.: +49 7131 642919 0 Ruben Storm Fax: +49 7131 642919 200 Gartenstrasse 46 E-Mail: office@storm-isp.de 74072 Heilbronn Web: http://www.storm-isp.de ######################################################### > 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. > 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). > 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 [quoted text clipped - 3 lines] > 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. > Thanx a lot You are welcome, but check it out with McKoi developers. 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. > http://mckoi.com/database/ > [quoted text clipped - 27 lines] > > > > ######################################################### > 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. [quoted text clipped - 34 lines] >> > >> > ######################################################### 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 SignatureMit freundlichen Gruessen Ruben Storm ######################################################### Storm - NET Heilbronn Tel.: +49 7131 642919 0 Ruben Storm Fax: +49 7131 642919 200 Gartenstrasse 46 E-Mail: office@storm-isp.de 74072 Heilbronn Web: http://www.storm-isp.de ######################################################### > Im looking for a opensource Database, that i could use for Developing Java > Software and distribute with the Software easy. [quoted text clipped - 8 lines] > > Thanx for your help Thanks a lot for all your help. I will look into mckoi. SignatureMit freundlichen Gruessen Ruben Storm ######################################################### Storm - NET Heilbronn Tel.: +49 7131 642919 0 Ruben Storm Fax: +49 7131 642919 200 Gartenstrasse 46 E-Mail: office@storm-isp.de 74072 Heilbronn Web: http://www.storm-isp.de ######################################################### Free MagazinesGet 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 ...
|
Reply to this Message
|
 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.