-
Finding all rows within a radius in SQLite
Where :lat and :lng are the latitude and longitude of the point of interest, and :radius is the radius in kilometres:
-
Configuring ULIDs for SQLite in rails+litestack
ULIDs are Universally Unique Lexicographically Sortable Identifiers, a sortable and more compact alternative to UUIDs that are appropriate in certain use cases.