Re:Comparing SQLite, DuckDB and Arrow with UN trade data
by selimnairb on Wednesday October 27, 2021 @06:24AM
(#29011369)
Here’s hoping that DuckDB will add support for spatial data, indexing, and query predicates. It would be great if this were a first-class feature instead of bolted on like SpatiaLite is to SQLite.
[ Parent
| on HN ]
Re:Comparing SQLite, DuckDB and Arrow with UN trade data
by loxias on Wednesday October 27, 2021 @06:32AM
(#29011405)
It could! But those are not exactly "easy things to do" ;) I'm sure it could happen, for a sufficiently large grant.
Re:Comparing SQLite, DuckDB and Arrow with UN trade data
by selimnairb on Wednesday October 27, 2021 @11:09AM
(#29014322)
Are you a contributor? Is there a way to bring this up with the team? Perhaps a place to start would be to add support for storing OGC Simple Features and corresponding to/from conversion functions. I don’t have a lot of spare time, but may want to take a stab at a proof of concept if some developers could help orient me to the code.
Re:Comparing SQLite, DuckDB and Arrow with UN trade data
by mytherin on Wednesday October 27, 2021 @03:50PM
(#29018237)
DuckDB developer here - we absolutely welcome outside contributions. Feel free to open an issue or discussion on our github for a feature request, and we would be happy to point you in the right direction!
Re:Comparing SQLite, DuckDB and Arrow with UN trade data
by selimnairb on Wednesday October 27, 2021 @06:25AM
(#29011372)
Maybe I should get involved and try to help this…however DB hacking is a bit out of my depth at the moment…