[openstreetmap/openstreetmap-website] Future of db/functions? (#3110)

[mmd]

I believe `tile_for_point` is the only function that has been used for back-filling data as part of a migration. A "grep" shows 3 occurrences of that function, all of them are older than 3 years. 

```
$ grep -rin "tile_for_point"
006_tile_nodes.rb:16:             tile_for_point(CAST(ROUND(latitude * 10000000) AS INTEGER),
005_tile_tracepoints.rb:12:      Tracepoint.update_all("latitude = latitude * 10, longitude = longitude * 10, tile = tile_for_point(latitude * 10, longitude * 10)")
20180204153242_tile_users.rb:10:      User.update_all("home_tile = tile_for_point(cast(round(home_lat * #{GeoRecord::SCALE}) as integer), cast(round(home_lon * #{GeoRecord::SCALE}) as integer))")
```



-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/3110#issuecomment-792302628
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20210307/c8801faf/attachment.htm>