View Feed
group-icon
Databases
Discuss databases and writing database queries with fellow DB enthusiasts.
296 Members
Join this group to post and comment.
Mridusmita Roy
Mridusmita Roy • Apr 23, 2015

SQLite Vs MySQL:Better RDBMS for desktop application?

So 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?
Anoop Kumar
Anoop Kumar • Apr 23, 2015
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.
Mridusmita Roy
Mridusmita Roy • Apr 23, 2015
Thanks for the reply.Will go with MySQL then!
rahul69
rahul69 • Apr 30, 2015
Mridusmita Roy
So 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 danewala
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
Okay, we got what you want. But, what is your question?
simplycoder
simplycoder • May 3, 2015
Also you can try your hands on postgres dbms

Share this content on your social channels -