I have heard of SQLite, MySQL and other dialects of SQL.

How do they differ?

Where do you use which one?

Which ones are the most used?

What is the purpose of this?