SQLite Vs MySQL:Better RDBMS for desktop application?

I think you should better go with MySql. you will get more knowledge about configuring and using a widely used DB.
If resource crunch then SqlLite can be better option.

Thanks for the reply.Will go with MySQL then!

Mridusmita RoySo I am creating a Java+SQL desktop application.Which is a better RDBMS?SQLite or MySQL ? I Googled it and in one site it says that SQLite is an embedded RDBMS and better for desktop applications.Yet in several others it says that MySQL is most popular and better than sqlite,but no one has a definite answer on why one is better than the other.
According to you which is better.Which will be able to support a database of about 500 students.Which is faster?Pros and cons of both?

I would say it depends on application, if your application is having server side database which is to be accessed frequently and the load will be high and most importantly, the no. of simultaneous db connections are more, then go with mysql, but if it's a desktop application and you are going to maintain db's on each computer (instead of db's on a central db server) and less load, better to go for SQLite, as the best thing about SQLite is that it's simple and lightweight.
Hope it helps!

I want create data base to store govt. holiday date in database and this date retrieved from data base and compare to current date if true then send the email to the student.
conclusion is automatically send the message to the student on govt. holiday...
please reply fast

Shubham danewalaI want create data base to store govt. holiday date in database and this date retrieved from data base and compare to current date if true then send the email to the student.
conclusion is automatically send the message to the student on govt. holiday...
please reply fast

Okay, we got what you want. But, what is your question?

Also you can try your hands on postgres dbms