I have a very large Postgres database (200MB compressed dump, >1.5TB fully materialized on disk) that I want to run large analytical queries on.

Should I
- Connect with DuckDB postgres scanner (https://duckdb.org/2022/09/30/postgres-scanner)?
- Dump everything to parquet?

It has views and materialized views that I think I do want.

#postgres #DuckDB #RStats

And that just came in… A Japanese copy of #DuckDBInAction and I totally love it. Writing of mine translated for people at the other end of the world. Soooo cool.

#DuckDB

And that just came in… A Japanese copy of #DuckDBInAction and I totally love it. Writing of mine translated for people at the other end of the world. Soooo cool.

#DuckDB

Working with big spatial data sets in #rstats? You should try {duckspatial}. The dev version of #duckspatial (soon on CRAN) uses #duckdb to perform super fast and memory efficient spatial operations cidree.github.io/duckspatial/... In a benchmark against, {sf}....

Working with big spatial data sets in #rstats? You should try {duckspatial}. The dev version of #duckspatial (soon on CRAN) uses #duckdb to perform super fast and memory efficient spatial operations cidree.github.io/duckspatial/... In a benchmark against, {sf}....

Announcing DuckDB 1.4.0

https://duckdb.org/2025/09/16/announcing-duckdb-140.html

#DuckDB #Databases

Data-at-Rest Encryption in DuckDB

https://duckdb.org/2025/11/19/encryption-in-duckdb

#HackerNews #DataAtRestEncryption #DuckDB #CyberSecurity #DatabaseEncryption #DataPrivacy

What are the most exciting trends you’re seeing in spatial data science lately?
Some of mine:

- New file formats (e.g. #GeoParquet)
- Geospatial DBs (e.g. #DuckDB + spatial)
- Global discrete grids

What would you add?

#Geospatial #GISchat #RSpatial #GeoPython

What are the most exciting trends you’re seeing in spatial data science lately?
Some of mine:

- New file formats (e.g. #GeoParquet)
- Geospatial DBs (e.g. #DuckDB + spatial)
- Global discrete grids

What would you add?

#Geospatial #GISchat #RSpatial #GeoPython

@catsalad @cR0w @iagox86 came for details on DuckDB bugs, stayed for the ghost tag talk.

(I use #DuckDB routinely these days but only locally and with more-or-less trusted inputs, so I'm not personally familiar with the attack surface or what attackers would find valuable about this.)

Confirmed a couple of talks. I ( @nicd ) will be talking about #Gleam and #Lustre while Onni will have a presentation about using #DuckDB with #Elixir.

More details at https://trelixir.fi/event-2025-11-17.html

Confirmed a couple of talks. I ( @nicd ) will be talking about #Gleam and #Lustre while Onni will have a presentation about using #DuckDB with #Elixir.

More details at https://trelixir.fi/event-2025-11-17.html

Now that I am super internally torn on the #rstats versus #Python debate for a data science intro class we are developing, I am considering just going nuclear and teaching it all in #duckdb 🦆 😅.

I mean only half-way joking, for a lot of stuff I think you could get very far, although I have not tried duckplot yet 😉. Plus imagine how easy the setup for the class would be, "just download that binary".

Use DuckDB-WASM to query TB of data in browser

https://lil.law.harvard.edu/blog/2025/10/24/rethinking-data-discovery-for-libraries-and-digital-humanities/

#HackerNews #DuckDB #WASM #Data #Query #Browser #Libraries #Digital #Humanities

Relational Charades: Turning Movies into Tables. #DuckDB

https://duckdb.org/2025/10/27/movies-in-databases

ok chat

what are some _disadvantages_ of #DuckDB compared to #SQLite?

Announcing DuckDB 1.4.0

https://duckdb.org/2025/09/16/announcing-duckdb-140.html

#DuckDB #Databases

Is anyone using duckdb with elixir/Phoenix? what are you using it for?

#duckdb #elixir #elixirlang

Abusing DuckDB-WASM by making SQL draw 3D graphics (Sort Of)
https://www.hey.earth/posts/duckdb-doom
#ycombinator #duckdb #sql #wasm #doom