|
Next: Call for speakers for DataServices World (June 24..
|
| Author |
Message |
External
Since: Dec 27, 2007
Posts: 35
|
(Msg. 1) Posted: Sun Mar 09, 2008 2:05 pm
Post subject: free database for java
Archived from groups: comp>lang>java>databases (more info?)
|
|
|
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  |
|
| Back to top |
|
 | |
External
Since: Feb 12, 2008
Posts: 13
|
(Msg. 2) Posted: Mon Mar 10, 2008 4:48 am
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Feb 12, 2008
Posts: 13
|
(Msg. 3) Posted: Mon Mar 10, 2008 6:39 am
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Mon, 10 Mar 2008 04:48:18 GMT, Roedy Green
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 >> Stay informed about: free database for java |
|
| Back to top |
|
| |
External
Since: Mar 10, 2008
Posts: 4
|
(Msg. 4) Posted: Mon Mar 10, 2008 12:17 pm
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Mr. X." writes:
> 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,
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.
--
dt
Questions about Derby/Java DB? Please visit
http://db.apache.org/derby/derby_mail.html >> Stay informed about: free database for java |
|
| Back to top |
|
| |
External
Since: Mar 11, 2008
Posts: 1
|
(Msg. 5) Posted: Tue Mar 11, 2008 3:52 pm
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Feb 15, 2008
Posts: 43
|
(Msg. 6) Posted: Tue Mar 11, 2008 8:12 pm
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
pietia wrote:
> 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
I find PostgreSQL (www.postgresql.org) the best.
--
Lew >> Stay informed about: free database for java |
|
| Back to top |
|
| |
External
Since: Mar 12, 2008
Posts: 15
|
(Msg. 7) Posted: Wed Mar 12, 2008 8:27 am
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Dec 27, 2007
Posts: 35
|
(Msg. 8) Posted: Wed Mar 12, 2008 7:31 pm
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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  ) >> Stay informed about: free database for java |
|
| Back to top |
|
| |
External
Since: Dec 15, 2007
Posts: 13
|
(Msg. 9) Posted: Wed Mar 12, 2008 7:31 pm
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Mr. X. wrote on 12.03.2008 18:31:
> 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 ?
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 >> Stay informed about: free database for java |
|
| Back to top |
|
| |
External
Since: Dec 27, 2007
Posts: 35
|
(Msg. 10) Posted: Wed Mar 12, 2008 8:29 pm
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Dec 15, 2007
Posts: 13
|
(Msg. 11) Posted: Wed Mar 12, 2008 8:29 pm
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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 >> Stay informed about: free database for java |
|
| Back to top |
|
| |
External
Since: Dec 15, 2007
Posts: 13
|
(Msg. 12) Posted: Wed Mar 12, 2008 8:29 pm
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Feb 15, 2008
Posts: 43
|
(Msg. 13) Posted: Wed Mar 12, 2008 8:29 pm
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thomas Kellerer wrote:
> 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/
I use this resource a lot to compare and translate between RDBMSes. It's
invaluable.
--
Lew >> Stay informed about: free database for java |
|
| Back to top |
|
| |
External
Since: Mar 02, 2008
Posts: 14
|
(Msg. 14) Posted: Thu Mar 13, 2008 6:42 am
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Mr. X." wrote:
>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 ?
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. >> Stay informed about: free database for java |
|
| Back to top |
|
| |
External
Since: Dec 27, 2007
Posts: 35
|
(Msg. 15) Posted: Sun Mar 16, 2008 12:20 pm
Post subject: Re: free database for java [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
FAQ
Search
Profile
Private Messages
Log in
