Skip to content
TopicTracker
From HackerNewsView original
TranslationTranslation

ggsql 0.4.1: new release adds spatial plotting and in-layer aggregation

ggsql 0.4.1 has been released, introducing support for spatial plotting and in-layer aggregation. The update enhances the R package's capabilities for creating database-backed graphics directly from SQL queries.

Background

- Posit (formerly RStudio) is the company behind the popular RStudio IDE and the Shiny web framework for data science. They maintain a family of open-source R packages. - ggsql is an R package that lets users write SQL queries directly inside ggplot2 plotting commands — instead of pre-processing data, you can filter, group, and aggregate with SQL syntax right in the plot code. - This release (0.4.1) adds two major features: spatial plotting (maps, geometries like points and polygons) and in-layer aggregation (e.g., computing averages or counts within a specific plot layer without affecting other layers). - The package targets R users who work with large databases and want to visualize data without pulling entire tables into memory — it translates ggplot commands into SQL that runs on the database server. - Earlier versions focused on basic dplyr-style SQL integration; spatial support is a notable step toward making ggsql useful for geographic data workflows common in fields like epidemiology, logistics, and environmental science.

Related stories