maxxen

6 ms·

1.
by maxxen 1y ago
Soo… usearch? Its literally one header file (of what use to be strict c++11). Funnily enough that is what is used in the official duckdb-vss extension. Disclaimer: I wrote duckdb-vss
2.
by maxxen 1y ago
This is cool. My only worry is that the implementation complexity will prevent widespread adoption outside of maplibre. Although getting write support upstreamed into PostGIS might be all thats needed to make sure it trickles down into all
3.
by maxxen 1y ago
Actually, they do https://www.esri.com/arcgis-blog/products/arcgis-pro/announc...
4.
by maxxen 1y ago
I think this is just cause it hasn't been implemented in spatial yet. DuckDB is currently going through a pretty big refactor of the way we glob/scan/union multiple files with all the recent focus on data lake formats, but my
5.
by maxxen 1y ago
Im inclined to agree, but unfortunately a huge amount of the existing data and processes in this space does not assume a spheroidal earth and come provided with a coordinate reference system. Ultimately there are also some domains where you
6.
by maxxen 1y ago
I replied to another comment, but I think a big part is that duckdbs spatial extension provides a SQL interface to a whole suite of standard foss gis packages by statically bundling everything (including inlining the default PROJ database o
7.
by maxxen 1y ago
I think a big part is that duckdbs spatial extension doesnt have any transitive dependencies (except libc). It statically packages the standard suite of foss gis tools (including a whole database of coordinate systems) for multiple platform
8.
by maxxen 2y ago
I still need to update the docs and there's probably going to be a blog post on it in the future, but for now there are some more details in the PR https://github.com/duckdb/duckdb_spatial/pull/383
9.
by maxxen 2y ago
Thanks! I've been wanting to add this since I first started out working on DuckDB almost two years ago but I finally managed to accumulate the time (and the skills required!) to finish it up over the summer. It still has a long way to
10.
by maxxen 3y ago
We’re currently 16~ software engineers at DuckDB Labs! I think its a good size to be productive but also stay nimble.
11.
by maxxen 3y ago
It does push down filters! Not sure if other nodes are pushed down, I think for now the database boundary is at the scan node, but you could add additional optimizer/rewrite rules in the postgres/sqlite/mysql extensions to pu
12.
by maxxen 3y ago
Kdb(been around since the 90s) https://code.kx.com/q/ref/aj/
13.
by maxxen 4y ago
Yes! I'm working hard on it, I've been distracted with other work for some of our clients but hopefully have something to show soon.