[openstreetmap/openstreetmap-website] User IDs have inconsistent types in the database (#2211)

Tom Hughes notifications at github.com
Thu Apr 18 07:01:42 UTC 2019

That's exactly what rails does - whenever you run a migration if dumps the schema to that file afterwards - the problem is that different developers have different minor variations in their databases that then get reflected in the SQL file.

All it takes is one minor change to a migration that somebody doesn't rerun against their local database and they wind up with a schema locally that is different to other people and which is reflected in future whenever they make another change. Sometimes I think it even comes down to changes in rails defaults and how old your database is (ie what version of rails was used when running certain migrations).

At the very least you wind up with pathnames in the SQL which are tied to where the user happens to have their 3GL libraries installed.

Yes we could do what you suggest and make travis constantly add new commits to bring the SQL back to a clean version but that will produce horrible churn in the git history unless we can somehow also prevent user changes making it through so that we only get the clean versions.

All this is why rails does not generate that file by default - we had to opt in to that.

You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20190418/14926ab3/attachment.html>

More information about the rails-dev mailing list