my dog learned polymorphism
The moose likes General Computing and the fly likes free database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "free database" Watch "free database" New topic

free database

ankur rathi
Ranch Hand

Joined: Oct 11, 2004
Posts: 3830
Can I get any free database online like MSSQL or Oracle or DB2 or any other?

Please provide me the link.

David O'Meara

Joined: Mar 06, 2001
Posts: 13459

I believe DB2 and Oracle provide limitted versions that can be used for free. Hopefully someone can correct me, but I think the Oracle one is called 'Oracle Personal'
Hussein Baghdadi
clojure forum advocate

Joined: Nov 08, 2003
Posts: 3479

Check PostgreSQL.
I put this database in the same level with Oracle.
Chris Hendy
Ranch Hand

Joined: Mar 04, 2006
Posts: 98
The free version of Oracle10g is called

Oracle Database 10g Express Edition

Links to download the Windows and Linux versions are at the top of

There are some limitations:

1. Express Edition is limited to a single instance on any server;
2. Express Edition may be installed on a multiple CPU server, but may only be executed on one processor in any server;
3. Express Edition may only be used to support up to 4GB of user data (not including Express Edition system data);
4. Express Edition may use up to 1 GB RAM of available memory.

If this is for evaluation purposes and not deployment, I believe Oracle allow you to download the full database product with none of the above limitations. You can download that from the same page.
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63865

Originally posted by John Todd:
Check PostgreSQL.
I put this database in the same level with Oracle.


[Asking smart questions] [About Bear] [Books by Bear]
Lasse Koskela

Joined: Jan 23, 2002
Posts: 11962
PostgreSQL and MySQL are, in my opinion, far more enjoyable to setup and use than Oracle, DB2 or MSSQL (although I have almost zero experience with MSSQL).

You might also consider HSQLDB, which is 100% Java, very lightweight and can even be embedded in in-memory mode into your Java application.

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
Masoud Kalali
Ranch Hand

Joined: Jul 08, 2004
Posts: 531

Add Derby and ingres to that list
derby is pure java hosted in apache and ingres can be found at
which was CA database some times.

Masoud Kalali
Software Engineer - My Weblog - GlassFish Security
Henry Wong

Joined: Sep 28, 2004
Posts: 20532

Originally posted by rathi ji:
Can I get any free database online like MSSQL or Oracle or DB2 or any other?

I guess I'll answer the MS-SQL Server part of this question. Microsoft offers a complete line of versions of SQL server. At the high end, is the enterprise edition which runs about $8000 per server. At the other end, is the express edition (formally called msde) which is available for free.

The express edition is really limited -- in terms of size and features.

Now... If you just want to setup SQL server for development purposes -- meaning no deployment to production. Another option is the developer edition. The developer edition is basically the enterprise edition for development purposes only -- and at $40, it is a really deep discount from $8000 ...


Books: Java Threads, 3rd Edition, Jini in a Nutshell, and Java Gems (contributor)
anand phulwani
Ranch Hand

Joined: Sep 10, 2005
Posts: 242
I will rather prefer My-SQL which is supported by most of the linux based web-servers its light, and fulfills all the basic needs,cant tell you about the advanced one,because i haven't experimented My-SQL till that level.

Thanks and Regards, Anand
SCJP 5.0 310-055 73%, SCWCD 1.4 310-081 78%, IBM DB2 9 Fundamentals 000-730 62%
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968

I absolutely love apachefriends.

ApacheFriends' XAMPP

The download is simple, and you just extract the contents to your file system, and you have a working MySQL, apache web server, FTP server, mail server, and all the php and other plugins you might want to get going with web development.

You'll love it!

-Cameron McKenzie
Peter Rooke
Ranch Hand

Joined: Oct 21, 2004
Posts: 820

Java DB - I have read that this is to be included with Java 6. Database based on the Apache Derby product.

Regards Pete
Jeroen T Wenting
Ranch Hand

Joined: Apr 21, 2006
Posts: 1847
The best: Firebird
Free, small footprint (disk and memory), very fast, and easy to use.

Hung Tang
Ranch Hand

Joined: Feb 14, 2002
Posts: 148
Originally posted by Bear Bibeault:


Pj Murray
Ranch Hand

Joined: Sep 24, 2004
Posts: 194
You need to ask some questions before deciding on the database:

Do you need a relational database or an object database or embedded database?

Is high performance or reliabilty or security the priority?

Does it have to be open source or is just free OK?

What operating systems do you need supported?

What databases does the customer's DBA know?

Will the end user need need deployment support?

Do the end customer have a preferred enterprise database?

PJ Murray -
It is sorta covered in the JavaRanch Style Guide.
subject: free database
jQuery in Action, 3rd edition