SQLite Vs MySQL:Better RDBMS for desktop application?

@mridusmita-rGaSSi • Oct 26, 2024

Oct 26, 2024

1.8K

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?

Like 0 Replies 6

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

Anoop Kumar

@anoop-kumar-GDGRCn • 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.
0
Mridusmita Roy

@mridusmita-rGaSSi • Apr 23, 2015

Thanks for the reply.Will go with MySQL then!
0
rahul69

@rahul69-97fAOs • 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!
0
Shubham danewala

@shubham-danewala-prWwOv • May 1, 2015

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
0
Vishal Sharma

@vishal-pysGmK • May 1, 2015

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?
0
simplycoder

@simplycoder-NsBEdD • May 3, 2015

Also you can try your hands on postgres dbms
0