@douenergy.bsky.social
Reposted
We just launched Foursquare Spatial Desktop – a geospatial analysis tool powered by embedded DuckDB and built on sqlrooms.org. Everything runs locally: your data stays on your machine, no cloud needed. A modern reimagining of Kepler.gl. Mac only for now. More coming.
foursquare.com/products/spa...
foursquare.com/products/spa...
July 31, 2025 at 10:39 AM
We just launched Foursquare Spatial Desktop – a geospatial analysis tool powered by embedded DuckDB and built on sqlrooms.org. Everything runs locally: your data stays on your machine, no cloud needed. A modern reimagining of Kepler.gl. Mac only for now. More coming.
foursquare.com/products/spa...
foursquare.com/products/spa...
Reposted
If you spend your days staring at DuckDB's EXPLAIN output, you may find our DuckDB execution plan visualizer helpful (which we have derived from DALIBO's PostgreSQL-specific PEV2, built on Alex Tatiyant's excellent PEV).
In its early stages, but already workable: db.cs.uni-tuebingen.de/explain/
In its early stages, but already workable: db.cs.uni-tuebingen.de/explain/
db.cs.uni-tuebingen.de/explain
Visualizing and understanding your DuckDB execution plans made easy.
db.cs.uni-tuebingen.de
February 25, 2025 at 4:33 PM
If you spend your days staring at DuckDB's EXPLAIN output, you may find our DuckDB execution plan visualizer helpful (which we have derived from DALIBO's PostgreSQL-specific PEV2, built on Alex Tatiyant's excellent PEV).
In its early stages, but already workable: db.cs.uni-tuebingen.de/explain/
In its early stages, but already workable: db.cs.uni-tuebingen.de/explain/
Reposted
New blog post – Query Engines: Gatekeepers of the Parquet File Format
In this post, Laurens Kuiper argues that we are wasting a lot of bits by not using the Parquet format to its full extent – a limitation caused by the lack of support for Parquet features in some systems.
duckdb.org/2025/01/22/p...
In this post, Laurens Kuiper argues that we are wasting a lot of bits by not using the Parquet format to its full extent – a limitation caused by the lack of support for Parquet features in some systems.
duckdb.org/2025/01/22/p...
Query Engines: Gatekeepers of the Parquet File Format
Mainstream query engines do not support reading newer Parquet encodings, forcing systems like DuckDB to default to writing older encodings, thereby sacrificing compression.
duckdb.org
January 23, 2025 at 8:09 AM
New blog post – Query Engines: Gatekeepers of the Parquet File Format
In this post, Laurens Kuiper argues that we are wasting a lot of bits by not using the Parquet format to its full extent – a limitation caused by the lack of support for Parquet features in some systems.
duckdb.org/2025/01/22/p...
In this post, Laurens Kuiper argues that we are wasting a lot of bits by not using the Parquet format to its full extent – a limitation caused by the lack of support for Parquet features in some systems.
duckdb.org/2025/01/22/p...
Reposted
New blog post! Spatially filter Foursquare's >100.000.000 rows (10Gb GeoParquet file) in 22 seconds with DuckDB.
geo.rocks/post/duckdb_...
#gischat #duckdb #geopandas
geo.rocks/post/duckdb_...
#gischat #duckdb #geopandas
DuckDB for Geospatial
Learn how to dramatically speed up your geospatial data workflows by using DuckDB instead of GeoPandas. We'll explore loading, filtering, and spatial analysis with the Foursquare dataset and more.
geo.rocks
January 12, 2025 at 1:56 PM
New blog post! Spatially filter Foursquare's >100.000.000 rows (10Gb GeoParquet file) in 22 seconds with DuckDB.
geo.rocks/post/duckdb_...
#gischat #duckdb #geopandas
geo.rocks/post/duckdb_...
#gischat #duckdb #geopandas
Reposted
New blog post by @hannes.muehleisen.org and @markraasveldt.bsky.social:
Runtime-Extensible SQL Parsers Using PEG
duckdb.org/2024/11/22/r...
This post discusses how parsers in DBMSs could be re-designed using Parser Expression Grammars for extensibility and improved error reporting.
Runtime-Extensible SQL Parsers Using PEG
duckdb.org/2024/11/22/r...
This post discusses how parsers in DBMSs could be re-designed using Parser Expression Grammars for extensibility and improved error reporting.
Runtime-Extensible SQL Parsers Using PEG
Despite their central role in processing queries, parsers have not received any noticeable attention in the data systems space. State-of-the art systems are content with ancient old parser generators....
duckdb.org
November 22, 2024 at 1:55 PM
New blog post by @hannes.muehleisen.org and @markraasveldt.bsky.social:
Runtime-Extensible SQL Parsers Using PEG
duckdb.org/2024/11/22/r...
This post discusses how parsers in DBMSs could be re-designed using Parser Expression Grammars for extensibility and improved error reporting.
Runtime-Extensible SQL Parsers Using PEG
duckdb.org/2024/11/22/r...
This post discusses how parsers in DBMSs could be re-designed using Parser Expression Grammars for extensibility and improved error reporting.