Re: [Rails] Databases (mysql vs postgres)

2019-01-07 Thread Walter Lee Davis
> On Jan 7, 2019, at 4:47 AM, Greg Navis wrote: > > Walter, out of curiosity, why different databases? Is this due to licensing > reasons? I once led a project where we used SQLite in development and MySQL > in production and we were struck by SQLites dynamic typing (i.e. column types >

Re: [Rails] Databases (mysql vs postgres)

2019-01-07 Thread Greg Navis
IIRC PostgreSQL is the most popular choice among Rails developers but this of course doesn't mean it's the right choice for you. You can Google "Postgres vs MySQL" to understand differences between them. My personal preference is PostgreSQL. Walter, out of curiosity, why different databases? Is

Re: [Rails] Databases (mysql vs postgres)

2019-01-05 Thread Walter Lee Davis
All databases have some unique characteristics and capabilities, but they are all pretty equal in the eyes of an ORM like ActiveRecord. In fact, that's one of the selling points of Rails -- you can write once and deploy mostly anywhere. At Penn, we use SQLite for our tests and CI, and Oracle