Sagar Lama sagarPakhrin

## conventional_commit_messages.md

      
              1 file
            
          
              320 forks
            
          
              61 comments
            
          
              1658 stars
            
          
                qoomon
                / conventional_commit_messages.md
            
            
              Last active
              April 27, 2024 03:58
            
              
                Conventional Commit Messages
              
          
    Conventional Commit Messages 

See how a minor change to your commit message style can make a difference.
Tip
Have a look at git-conventional-commits , a CLI util to ensure these conventions and generate verion and changelogs

Commit Message Formats

Default


## 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
	---
	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