the new dogcow logo the new dogcow
About Archives X
  • Finding all rows within a radius in SQLite

    Oct 11, 2024 • rails, sqlite

    Where :lat and :lng are the latitude and longitude of the point of interest, and :radius is the radius in kilometres:

    Read on →

  • Configuring ULIDs for SQLite in rails+litestack

    Aug 27, 2024 • rails, sqlite

    ULIDs are Universally Unique Lexicographically Sortable Identifiers, a sortable and more compact alternative to UUIDs that are appropriate in certain use cases.

    Read on →

© - Powered by Jekyll & whiteglass - Subscribe via RSS