References:
- Goodbye Docker Desktop for Mac, Hello Colima
- Installing Colima as a Docker Engine provider with Buildx and Compose plugins installed
Colima is container runtimes on macOS (and Linux) with minimal setup, that has M1 macs support.
References:
Colima is container runtimes on macOS (and Linux) with minimal setup, that has M1 macs support.
duckdb ST |
ibis ops |
ibis + duckdb support | Summary |
---|---|---|---|
ST_Area |
GeoArea |
✅ | Returns the area of a geometry. |
ST_Area_Spheroid |
Returns the area of a geometry in meters, using an ellipsoidal model of the earth | ||
ST_AsGeoJSON |
Returns the geometry as a GeoJSON fragment | ||
ST_AsHEXWKB |
Returns the geometry as a HEXWKB string | ||
ST_AsText |
GeoAsText |
✅ | Returns the geometry as a WKT string |
ST_AsWKB |
GeoAsBinary |
TODO next | Returns the geometry as a WKB blob |
ST_Boundary |
Returns the "boundary" of a geometry | ||
ST_Buffer |
GeoBuffer |
✅ | Retur |
Here is a table of what we have in ibis/ibis/backends/base/sql/alchemy/registry.py
compared against DuckDB spatial extension docs
ops |
postgress |
duckdb supported |
postgress docs |
---|---|---|---|
ops.GeoArea |
unary(sa.func.ST_Area) |
✅ | https://postgis.net/docs/ST_Area.html |
ops.GeoAsBinary |
unary(sa.func.ST_AsBinary) |
❌ | https://postgis.net/docs/ST_AsBinary.html |
ops.GeoAsEWKB |
unary(sa.func.ST_AsEWKB) |
❌ | https://postgis.net/docs/ST_AsEWKB.html |
{"$schema":"https://www.speedscope.app/file-format-schema.json","profiles":[{"type":"sampled","name":"Process 87203 Thread 0x100CA0580 \"MainThread\"","unit":"seconds","startValue":0.0,"endValue":3.85,"samples":[[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,27,26,25],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,28],[4,24,23,22,21,20,19,18,17,16,15,27,26,30,29],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24, |
{"$schema":"https://www.speedscope.app/file-format-schema.json","profiles":[{"type":"sampled","name":"Process 85804 Thread 0x1028DC580 \"MainThread\"","unit":"seconds","startValue":0.0,"endValue":0.22,"samples":[[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22, |
<!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<meta charset="utf-8"> |