Wins Lin wrote in post #1107488: > Hassan Schroeder wrote in post #1107485: >> On Wed, May 1, 2013 at 8:09 AM, Wins Lin <[email protected]> wrote: > >> Not really. You can run MySQL locally and use PG on Heroku. > > I prefer to use raw sql anywhere where it not possible to use > Model.find or Model.where. So it is quite a problem for me to separate > server > and local versions.
While there may be some circumstances where it may be necessary to wrote raw SQL, doing so should be extremely rare. Arel (which the where method derives) is a very powerful query language and AFAIK can do practically anything that SQL can do. One major advantage of using Arel is that it produced database agnostic queries. I generally design my applications using SQLite in development, then choose a production database based on my deployment needs. I make every effort to create database agnostic code. >> Maybe it's a Windows thing? > > Agree, maybe. They say all rake and rails tasks are so slow only on > Windows. So it can be the reason. > >> Why would you start and stop it at all? If that's what you're using, >> start it at boot time and forget about it. > > I have batch files that create a specific DB environments only when I > run them. It is more convenient to me. Sounds to me like you put great effort into making things less convenient for yourself. Like developing Rails in Windows, using database specific SQL embedded into your applications, etc. > It is not a big problem with PG. It was a little unexpected after MySQL. I find it extremely convenient using SQLite for development, on a UNIX based OS, and having the flexibility of choosing whatever database I want when it comes time to deploy my applications. But, to each his own I suppose. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
