free database

[ankur rathi]

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]

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]

Check PostgreSQL.
I put this database in the same level with Oracle.

[Chris Hendy]

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]

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

+1

[Lasse Koskela]

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]

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]

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]

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]

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]

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

[Jeroen T Wenting]

The best: Firebird http://www.firebirdsql.org
Free, small footprint (disk and memory), very fast, and easy to use.

[Hung Tang]

Originally posted by Bear Bibeault:


+1

+1

[Pj Murray]

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?