Me too! I think the spatial capabilities are going to advance a lot but the good news is that you can keep some data in PostGIS and mix it with DuckDB since they have some Postgres connectivity too!
Thanks for sharing, the nyc dataset seems to be not download though i have registered there but couldnt find to download it. What i am missing here? or if you can share the file on the github repository?
Does this support indexing? Not just your usual spatial index like GIST(geom) but indexes on custom expressions? Also- great that the native geom types are fast. But do they handle change of CRS, proj, geog vs geom etc? AKA what if you need high accuracy distance calc
Happy to see you, Matt! I would love to watch your videos more frequently.
Thanks so much that means a lot!
Nice one! The geo data viewer extension is neat, learned something new :)
Thanks and thank you for your videos too! Learned a lot from you as well!
I’m using postres like everyone :) but i’ll give a try to duckdb. It looks promising and nice.
Me too! I think the spatial capabilities are going to advance a lot but the good news is that you can keep some data in PostGIS and mix it with DuckDB since they have some Postgres connectivity too!
Thanks for the amazing demo!
Appreciate it!
Woah, that's rad as duck! 😉
🦆 More and more I have been using it locally and it’s been great!
Wow, I learned something new. Thanks for the vid.
Glad to hear it!
Thanks for sharing, the nyc dataset seems to be not download though i have registered there but couldnt find to download it. What i am missing here? or if you can share the file on the github repository?
Brightness of the video is 1 million lumens :D
I know…still working on my editing skills!
@@MattForrestnice.
Does this support indexing? Not just your usual spatial index like GIST(geom) but indexes on custom expressions?
Also- great that the native geom types are fast. But do they handle change of CRS, proj, geog vs geom etc?
AKA what if you need high accuracy distance calc
Ah I see it’s GDAL and more coming native, cool :)
I think it doesn’t support CRS yet and yes you can do non spatial indexes.
He has a quack the folder 😮.
Haha
One can use DBeaver to connect duckdb.
Yes definitely
How to make h3? I'm stuck there
also spatial extension doesn't work
Spatial extension now comes native in DuckDB but H3 you have to build locally then use as an unsigned extension.
good lordy, can I buy you a new keyboard? sounds like you're typing on a relic. in all seriousness, thanks for the good videos.
Bad keyboard and bad mic but should be fixed now!
Not supposed to do pip install. Its supposed to be python -m pip install.
😮😢
Good point