What is the difference between MYSQL & SQLite?

Started by Xavier Africa, June 18, 2016, 05:41:02 AM

Previous topic - Next topic

Xavier Africa

What is the difference between MYSQL & SQLite?

tinoest

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

Kindred

Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Advertisement: