• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Which Database to Use ?

 
Abdullah Arslan
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I need a database for a project. I used mysql before but i want another
database which doesnt require server setup.

Can you recommend a database that can be used like ms access( i mean just a datafile and a driver ) ?

Thanks for answers....
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We're not really a fan of Access 'round these parts, we like to say you can use a database or you can use Access

Seriously though, I think it's better to use a DB and try to avoid Access. If you're looking for something light, have a look at HSQLDB (on sourceforge). It can be run several ways, but in general you do not need to maintain a server.
 
Masoud Kalali
Author
Ranch Hand
Posts: 531
Java Mac OS X Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
In addition to HSQL i suggest you check Derby
which is open source and could be used in embeded mode
there are several documentation about embeding it into application servers , and some very good samples too.

checkout :
http://db.apache.org/derby/
you can get a good database manager from IBM , or use Netbeans which has derby module integrated into IDE.

HTH
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34654
365
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Abdullah,
Going back to the original requirement, what do you mean by "doesn't require server setup" ?

Does this refer to a datasource? If so, you can use DriverManager to just get a connection without involving a datasource.
 
Bosun Bello
Ranch Hand
Posts: 1511
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can also look into MYSQL.
 
Scott Selikoff
author
Saloon Keeper
Posts: 4014
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think you should consider money and power before deciding on your database. Some databases are definitely more expensive then others whereas some allow a lot more power, especially in distributed computing.

For example, Oracle is usually more expensive than SQL Server, but often more powerful (although I haven't checked pricing and new features lately so this could be out of date). Then again, if you aren't in a situation where you don't need the power, then you're throwing your money away where you don't need to.

Chances are if you don't know what you want to use, go with MySQL for now since it will save you a lot of money. IBM's Cloudscape database recently became an open source project, although I don't know too many people using it other than to manage WebSphere queues, so it probably has its own pluses/minuses.
[ November 27, 2005: Message edited by: Scott Selikoff ]
 
Dale Smirth
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You could try filemaker pro.
 
Abdullah Arslan
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you for all answers,

I am sorry i could not explain the issue properly,
I think the corrcect phrase was "embedded database".
I knew some about oracle, and quite about mysql. However to use them in my application i must to setup server in addition to my application's setup.

I wanted to create just one setup, put required datafiles to program's folder and using the correct driver, handle all of the database works of the application.

I understand from answers that hsql and derby fulfils my need ( can work as embeded ).

However i am not so sure, if i am wrong please correct me.

Again thanks very much for all answers...
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I can't answer for Derby, but HSQLDB can be embedded in your application so that it does not require separate installation.

Dave
 
Jesper de Jong
Java Cowboy
Saloon Keeper
Posts: 15354
39
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MySQL can also be embedded in your app, but probably HSQLDB would be much easier to use. HSQLDB is written in pure Java, so you can be sure it works on any platform that Java runs on.
 
Abdullah Arslan
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am grateful for your answers.

i liked hsqldb.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic