James Rissler jrissler

## nearby-coordinates.sql
---
METHOD 1

This should roughly sort the items on distance in MySQL, and should work in SQLite.
If you need to sort them preciser, you could try using the Pythagorean theorem (a^2 + b^2 = c^2) to get the exact distance.
---
SELECT *
FROM table
ORDER BY ((lat-$user_lat)*(lat-$user_lat)) + ((lng - $user_lng)*(lng - $user_lng)) ASC

## upgrade.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                jrissler
                / upgrade.md
            
            
              Created
              October 7, 2017 14:28
                — forked from chrismccord/upgrade.md
            
              
                Phoenix 1.2.x to 1.3.0 Upgrade Instructions
              
          
        
      
        
  
      
    If you want a run-down of the 1.3 changes and the design decisions behidn those changes, check out the LonestarElixir Phoenix 1.3 keynote: https://www.youtube.com/watch?v=tMO28ar0lW8
To use the new phx.new project generator, you can install the archive with the following command:
$ mix archive.install https://github.com/phoenixframework/archives/raw/master/phx_new.ez

Bump your phoenix dep

Phoenix v1.3.0 is a backwards compatible release with v1.2.x. To upgrade your existing 1.2.x project, simply bump your phoenix dependency in mix.exs:
	---
	METHOD 1

	This should roughly sort the items on distance in MySQL, and should work in SQLite.
	If you need to sort them preciser, you could try using the Pythagorean theorem (a^2 + b^2 = c^2) to get the exact distance.
	---
	SELECT *
	FROM table
	ORDER BY ((lat-$user_lat)(lat-$user_lat)) + ((lng - $user_lng)(lng - $user_lng)) ASC