 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / March 2008free database for java
Hello. I am looking for best free database for java & navigator tool (Till I found someone to invest on my software ...) After I have asked some people : I have found Derby db & Squirrel-sql db-navigator. ... but I see some opinions that Derby is not supported, and BTW I didn't understand how I can use major DB that many clients can connect it (I think this is ClientDriver is for that, but I didn't figure out how to start the db outside, since I don't know how can I link to the system-directory, so I assume that may be more then one configuration file in Eclipse and also in squirrel-sql, but I didn't figure out where this configuration file, and how can I use it). I am at the beginning of learning of some Sql's tools (not learning sql, but the tools, since I have got the experience on SQL), so I may give up Derby for my use. I need also Hebrew support on the DB, and good tool like TOAD. My application also need some reports on the future ... Help me decide, please. Thanks :) On Sun, 9 Mar 2008 14:05:03 +0200, "Mr. X." <no_spam_please@nospam_please.com> wrote, quoted or indirectly quoted someone who said : >... but I see some opinions that Derby is not supported, Derby is not part of the JDK, renamed. Sun has also bought MySQL. For possibilities see http://mindprod.com/jgloss/sqlvendors.html -- Roedy Green Canadian Mind Products The Java Glossary http://mindprod.com On Mon, 10 Mar 2008 04:48:18 GMT, Roedy Green <see_website@mindprod.com.invalid> wrote, quoted or indirectly quoted someone who said : >Derby is not part of the JDK, renamed. Sun has also bought MySQL. typo there. that should read "Derby is now part of the JDK" In the DSK layout t and w are adjacent. -- Roedy Green Canadian Mind Products The Java Glossary http://mindprod.com > Hello. > [quoted text clipped - 5 lines] > > ... but I see some opinions that Derby is not supported, Not sure exactly what you mean by this, but you CAN buy a support contract from Sun for Java DB (which is identical to Apache Derby, and is what you find in the JDK). See http://developers.sun.com/javadb/support/ > and BTW I didn't understand how I can use major DB that many clients can > connect it > (I think this is ClientDriver is for that, correct. > but I didn't figure out how to > start the db outside, since I don't know how can I link to the > system-directory, > so I assume that may be more then one configuration file in Eclipse and > also in squirrel-sql, but I didn't figure out where this configuration file, > and how can I use it). I did not get all of that, but in general, starting the Derby NetworkServer is as easy as java -jar /path/to/derbyrun.jar server start [options] See http://db.apache.org/derby/docs/dev/adminguide/ for more info.  Signaturedt Questions about Derby/Java DB? Please visit http://db.apache.org/derby/derby_mail.html Mr. X. pisze: > Hello. > > I am looking for best free database for java & navigator tool > (Till I found someone to invest on my software ...) hello, You may also take a look at www.h2database.com > Mr. X. pisze: >> Hello. [quoted text clipped - 4 lines] > hello, > You may also take a look at www.h2database.com I find PostgreSQL (www.postgresql.org) the best. SignatureLew Lew, 12.03.2008 01:12: > I find PostgreSQL (www.postgresql.org) the best. Yes, me too. So free databases for multi-platform, and java based are listed partly bellow : ----------------------------------------------------------------------------- postgresql mySql Derby h2 database. open-office base. I suppose the above are the most popular free-dbs, and I think that mySql is the most popular of the five. I found Derby, and I am learning using it. I have installed Squirrel-sql, and I think it's good enough. I can learn each of the other free-DB, but it may be endless ... Which do you think is the best of them ? Thanks :o) Mr. X. wrote on 12.03.2008 18:31: > So free databases for multi-platform, and java based are listed partly > bellow : [quoted text clipped - 15 lines] > > Which do you think is the best of them ? Postgres and MySQL are *not* Java "based". Both are written in C, but have good JDBC drivers Personally I think Postgres is the best. It is a lot closer to the SQL standard than MySQL (just thinking about String concatenation...) I don't consider OpenOffice Base as a DBMS. It's a DBMS front-end with a built-in database engine based on HSQLDB. Thomas Thanks ... Where can I find more opinions, that Postgres is the best free db ? Is there any compare-table of free DBs, that list all of the DBs' cons. & pros ? Thanks :) Mr. X. wrote on 12.03.2008 19:29: > Thanks ... > Where can I find more opinions, that Postgres is the best free db ? > Is there any compare-table of free DBs, that list all of the DBs' cons. & > pros ? Simply compare http://sql-info.de/mysql/gotchas.html to http://sql-info.de/postgresql/postgres-gotchas.html although I have to admit that a lot of the MySQL gotchas aren't valid any more. But there are still too many nasty habits that I personally feel should not be in a relational database system. Check out this thread on the PG mailing list: http://www.nabble.com/postgre-vs-MySQL-td15976517.html The PG people aren't too religous about this topic and they have a fair judgement of MySQL (naturally they will think PG to be better than MySQL, but still they aren't bashing MySQL) Note that probably more people think that MySQL is better than Postgres, but then more people think Windows is better than Linux as well :) Mr. X. wrote on 12.03.2008 19:29: > Thanks ... > Where can I find more opinions, that Postgres is the best free db ? > Is there any compare-table of free DBs, that list all of the DBs' cons. & > pros ? Not listing pros and cons, simply comparing the implementation of the SQL language: http://troels.arvin.dk/db/rdbms/ > Mr. X. wrote on 12.03.2008 19:29: >> Thanks ... [quoted text clipped - 6 lines] > > http://troels.arvin.dk/db/rdbms/ I use this resource a lot to compare and translate between RDBMSes. It's invaluable. SignatureLew ... it doesn't pay attantion to derby database. (I have tought this is a popular one, so maybe I will use mysql instead). Thanks :) > ... it doesn't pay attantion to derby database. What are you talking about? As my signature tries to indicate: You are not likely to get that much response to Derby/Java DB related questions in this newsgroup since most of the Derby/Java DB experts hang out at derby-user@db.apache.org (derby-dev@db.apache.org). Since Java DB (Sun's branding of Apache Derby) is included in the JDK I can understand that people come to this newsgroup, but they really should subscribe to (or browse) the Derby mailing lists. > (I have tought this is a popular one, > so maybe I will use mysql instead). MySQL is the most widely used OSS DBMS today. Signaturedt Questions about Derby/Java DB? Please visit http://db.apache.org/derby/derby_mail.html Dyreatnews@sun.com, 17.03.2008 13:26: >> (I have tought this is a popular one, >> so maybe I will use mysql instead). > > MySQL is the most widely used OSS DBMS today. But not the best one ;) > Dyreatnews@sun.com, 17.03.2008 13:26: >>> (I have tought this is a popular one, [quoted text clipped - 3 lines] > > But not the best one ;) What is best depends a lot on the context. Arne >> ... it doesn't pay attantion to derby database. > [quoted text clipped - 6 lines] > can understand that people come to this newsgroup, but they really > should subscribe to (or browse) the Derby mailing lists. I would say that Derby is on topic and Mr. X seems to get many answers here, so it should not be a problem using this forum. Ofcourse he may get even more/better response in a Derby specific forum. But none of the questions has required any knowledge of Derby internals. Arne >>> ... it doesn't pay attantion to derby database. >> [quoted text clipped - 9 lines] > I would say that Derby is on topic and Mr. X seems to get many > answers here, so it should not be a problem using this forum. Agreed. And after my previous post I noticed that you (and others) are providing good and helpful answers about Derby. > Ofcourse he may get even more/better response in a Derby > specific forum. But none of the questions has required > any knowledge of Derby internals. Quite right. I just wasn't sure what the OP meant by "... it doesn't pay attantion to derby database." If he meant that there is little Derby-related traffic in this newsgroup I wanted to point out that much discussion happens elsewhere. Signaturedt Questions about Derby/Java DB? Please visit http://db.apache.org/derby/derby_mail.html >So free databases for multi-platform, and java based are listed partly >bellow : [quoted text clipped - 15 lines] > >Which do you think is the best of them ? How would you judge "best"? Give us some details of your application. I see Derby and H2 as being suitable for quite different applications than PostgreSQL and MySQL although you _could_ use them interchangeably. The only circumstances in which I would choose MySQL is for a web based application because almost all hosting companies provide it. 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.