• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Which Database to use for Web Application ?

 
Karn Kumar
Ranch Hand
Posts: 153
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I wanted suggestion from you guys that which Database i should use for the web application.

I searched for some free (open source ) databases like MySQL , but i don't know their advantages/disadvantages over one another.

Please suggest some best open source databases which i can use for my web application.

Also another doubt is that Is MsSQL is open source ?

Thanks in advance....


- Chetan
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A web application is too broad a term to be useful. Generally, any mainstream database will do. You might want to read a database comparison charts. If you already have some experiences setting up and administering a database, that would be your obvious choice.

And while MsSQL - if you actually mean MS SQL Server - is not Open Source (it is Microsoft's), if offers a free (albeit a little bit limited) edition you could use as well, and so do some other database vendors.

I personally like databases which use multiversioning for concurrency, such as PostgreSQL (open-source) or Oracle (commercial, but with a limited free edition available), because they make use of fewer locks and this decreases deadlocks and locking problems in general. On the other hand, Oracle is sometimes said to be difficult to manage.
 
Tim McGuire
Ranch Hand
Posts: 820
IntelliJ IDE Tomcat Server VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Chetan Dorle wrote:Hi All,
I wanted suggestion from you guys that which Database i should use for the web application.

I searched for some free (open source ) databases like MySQL , but i don't know their advantages/disadvantages over one another.

Please suggest some best open source databases which i can use for my web application.

Also another doubt is that Is MsSQL is open source ?
Thanks in advance....
- Chetan


This is impossible to answer in a forum like this. You will have to research each open source database to see if it meets your needs. I can only relate my experience. I've been using PostgreSQL happily for almost 10 years. One thing I have found is that other open source projects (Drupal, Liferay) often assume you are using MySQL or a proprietary database and so the scripts and especially plugins have some syntax wrong for the PostgreSQL branches. From my experience, Hibernate/JPA work seamlessly with PostgreSQL.

Read the Wikipedia entry for MySQL for examples of huge and highly visible projects that use MySQL. http://en.wikipedia.org/wiki/MySQL

According to This Guy, we are now entering the PostgreSQL era. Maybe he's right.
 
Karn Kumar
Ranch Hand
Posts: 153
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I suppose Microsoft SQL express edition is free . Is this edition can be used for large web application... ?

One more thing what will be advantages of MySQL and PostGres over one another .

So that i can use in my web application .


Thanks....
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Chetan Dorle wrote:I suppose Microsoft SQL express edition is free . Is this edition can be used for large web application... ?

This page might help. You're limited to one CPU of four cores max, 1 GB of memory and 10 GB of total database size. It's debatable what "large" means, but generally I'd be afraid that a large web application would hit some of these limits.

At the same time, I'd expect a large application to use professional hosting services. It can be a demanding task to manage all the infrastructure (and a large application means 7x24, right?).
 
Karn Kumar
Ranch Hand
Posts: 153
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Martin & Tim,


I didn't get what is mean by
"You're limited to one CPU of four cores max, 1 GB of memory , 10 GB Total Database Size"


Is it like 10 GB of Total database size which can be used , but i didnot get 1 CPU of 4 core max and 1 GB of memory..

If you will explain it will be helpful for me .....


Thanks....
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'd say that page explains it better than me, but: the Express Edition will use only one CPU (one socket), and it will not use more than four cores on a CPU. So if you have a server with two CPUs, or one CPU with, say, 8 cores (each CPU "core" can execute a thread, so in theory there could be 8 different threads running at once on such CPU), the database won't utilize them fully. If you have one dual-core or quad-core CPU, it will be utilized fully.

Similarly, even if you have a lot of memory installed, the Express Edition won't use more than 1 GB of available memory. You can, however, have more memory and CPU power and simply run other things (web server, app server) in the remaining space (I'm not a system architect, not sure this is a good idea, I just say it is technically and legally possible).

I'm not sure how this applies if you run the thing on a virtualized platform.

These limitations are in place to force you buy a licence for serious business (ie. once you outgrow these limits). If you go this path and hit the limits, you might be pretty much forced to pay. I'm not sure you could simply throw in a new instance of Express Edition server (assuming it would even be technically feasible), you'd better read a licence agreement first.
 
Karn Kumar
Ranch Hand
Posts: 153
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Martin ,


Thanks a lot for your such a detail explanation....


I refered the chart for comaparision you provided in earlier post .

Seems that PostgreSQL has more features than MySQL.... One feature he don't have is parallel query .. Is this is execution of queries concurrently / Parallel time ?


Thanks in advance ....

 
Karn Kumar
Ranch Hand
Posts: 153
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Martin & Tim,


Thanks a lot . Finally i set up postgres DB and is working .

Now trying to configure hibernate with it.


Thanks again...

- Chetan
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic