CrazyEngineers
CrazyEngineers

  • SQLite Vs MySQL:Better RDBMS for desktop application?

    Mridusmita Roy

    Member

    Updated: Oct 26, 2024
    Views: 1.6K
    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?
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • Anoop Kumar

    Member • 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.
    Are you sure? This action cannot be undone.
    Cancel

  • Mridusmita Roy

    Member • Apr 23, 2015

    Thanks for the reply.Will go with MySQL then!
    Are you sure? This action cannot be undone.
    Cancel

  • rahul69

    Member • 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!
    Are you sure? This action cannot be undone.
    Cancel

  • Shubham danewala

    Member • 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
    Are you sure? This action cannot be undone.
    Cancel

  • Vishal Sharma

    Member • 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?
    Are you sure? This action cannot be undone.
    Cancel

  • simplycoder

    Member • May 3, 2015

    Also you can try your hands on postgres dbms
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register