• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

free database

 
ankur rathi
Ranch Hand
Posts: 3830
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can I get any free database online like MSSQL or Oracle or DB2 or any other?

Please provide me the link.

Thanks.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 3479
Clojure Mac Objective C
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check PostgreSQL.
I put this database in the same level with Oracle.
 
Chris Hendy
Ranch Hand
Posts: 98
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

http://www.oracle.com/technology/software/products/database/oracle10g/index.html

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
Marshal
Pie
Posts: 64994
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by John Todd:
Check PostgreSQL.
I put this database in the same level with Oracle.


+1
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Masoud Kalali
Author
Ranch Hand
Posts: 531
Java Mac OS X Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Add Derby and ingres to that list
derby is pure java hosted in apache and ingres can be found at http://opensource.ingres.com/projects/ingres/
which was CA database some times.
 
Henry Wong
author
Marshal
Pie
Posts: 21226
81
C++ Chrome Eclipse IDE Firefox Browser Java jQuery Linux VI Editor Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ...

Henry
 
anand phulwani
Ranch Hand
Posts: 242
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper
Posts: 4968
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 848
1
Java Linux Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Java DB - I have read that this is to be included with Java 6. Database based on the Apache Derby product.
 
Jeroen T Wenting
Ranch Hand
Posts: 1847
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The best: Firebird http://www.firebirdsql.org
Free, small footprint (disk and memory), very fast, and easy to use.
 
Hung Tang
Ranch Hand
Posts: 148
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Bear Bibeault:


+1


+1
 
Pj Murray
Ranch Hand
Posts: 194
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic