Difference between mysqlite , mysql and postgresql in ruby on rails?

What are differences among them? Either their queries are same or different for ruby on rails active record. How ruby on rails active record deal with them?