Using Mysql native functions with ActiveRecord on development environment

Question

Hi. I need to query my database using mysql native functions such as YEAR(date) or NOW().... This works on staging and on production environments but it won't work in my development environment because of SQLite's lack of support to these functions.

Can you help?

Thank you.

Answer 1

you could check for development RAILS_ENV and use native sqlite functions in this cases (datetime('now') instead of now() etc.) but this would just bloat your code - certainly its easier / cleaner to just use a local mysql instance for development ...