• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

free database

 
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.
 
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'
 
clojure forum advocate
Posts: 3479
Mac Objective C Clojure
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check PostgreSQL.
I put this database in the same level with Oracle.
 
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.
 
Sheriff
Posts: 67265
170
Mac Mac OS X IntelliJ IDE jQuery Java
  • 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
 
author
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.
 
Author
Posts: 531
Mac OS X Netbeans IDE Java
  • 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.
 
author
Posts: 23833
140
jQuery Eclipse IDE Firefox Browser VI Editor C++ Chrome Java Linux 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
 
Ranch Hand
Posts: 243
  • 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.
 
author and cow tipper
Posts: 5000
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
 
Bartender
Posts: 1025
18
Mac OS X IntelliJ IDE Oracle Spring VI Editor Tomcat Server Redhat Java Linux
  • 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.
 
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.
 
Ranch Hand
Posts: 148
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Originally posted by Bear Bibeault:


+1



+1
 
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?
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!