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.
Max Weinbach says he had early access to OpenAI's new model GPT-5.6 Sol, calling it his favorite model by far. He highlights that it never gives up and will keep reasoning until it's done. OpenAI announced that GPT-5.6 Sol, along with Terra and Luna, will launch publicly on Thursday, with preview access expanding globally now.
The US government ordered Anthropic to suspend access to its Fable 5 and Mythos 5 models for all customers, citing a potential jailbreak technique that involved asking the model to review a codebase for vulnerabilities—a capability Anthropic says is available in other public models. Access was abruptly cut off on June 12.
Andrej Karpathy announces the release of Claude Fable 5, the same underlying model as Mythos but with added safeguards. He calls it a major step forward, particularly for long problem-solving sessions on difficult tasks, and describes it as state-of-the-art on nearly all benchmarks with exceptional performance in software engineering, research, and vision.
Roman Storm warns that the legal theory in his case could set a precedent making open-source developers liable for how others use their code, potentially criminalizing the mere publication of privacy, messaging, or crypto tools. He notes that developer Michael Lewellen cannot publish lawful code due to prosecution fears, and argues this chilling effect extends beyond any single case.
Meta's engineering culture is deteriorating under Mark Zuckerberg and Scale AI CEO Alexandr Wang, who have introduced keyboard tracking, reassignments to data labeling, and AI-centric performance metrics. Critics argue this incentivizes performative AI use, drives away experienced engineers, and contributed to a major Instagram hijacking incident caused by AI-written and AI-reviewed code.