Advertisement:

Author Topic: What is the difference between MYSQL & SQLite?  (Read 5026 times)

Offline Xavier Africa

  • Semi-Newbie
  • *
  • Posts: 10
What is the difference between MYSQL & SQLite?
« on: June 18, 2016, 05:41:02 AM »
What is the difference between MYSQL & SQLite?

Offline tinoest

  • Development Contributor
  • Jr. Member
  • *
  • Posts: 183
Re: What is the difference between MYSQL & SQLite?
« Reply #1 on: June 18, 2016, 05:46:49 AM »
SQLite is a embedded database engine, which is usually used by one application accessing it at a time. It's not as scalable as MySQL but its a lot lighter.

SQLite support is being dropped in SMF2.1 so I would suggest using either MySQL or PostgreSQL, both of which are supported.

The following sums up the differences between the three quite well;

https://www.digitalocean.com/community/tutorials/sqlite-vs-mysql-vs-postgresql-a-comparison-of-relational-database-management-systems

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 55,122
  • Gender: Male
    • Kindred-999 on GitHub
Re: What is the difference between MYSQL & SQLite?
« Reply #2 on: June 18, 2016, 07:59:34 AM »
use mySQL - plain and simple...
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.