[sqlite] How to update field with data in field in many rows?

Hi all, my database has a table ExifPhoto with the fields GPSGeometry and Nearby. For each row I need to Update field Nearby with all coordinates (in the table) within a Distance of 1 degree of the coordinates in field GPSGeometry. The sqllite database has the spatial extension from SpatiaLite

[sqlite] How to enable_load_extension from ruby?

Hi everybody, I am running ruby and need to access sqlite3 with the SpatiaLite spatial extension enabled. Info on SpatiaLite extension: http://www.gaia-gis.it/spatialite Problem is, I can not find any description how to "enable_load_extension" from ruby. And without it no extension can be loaded