DuckDB 2.0.0 LTS "Cinnamon Teal" is a major feature release focused on server capabilities, performance, extensibility and semi-structured data, with long-term support through at least October 2027. It delivers a polished Quack client-server protocol and a new CONNECT statement to attach and switch to remote databases (including PostgreSQL/MySQL) with a remote pushdown optimizer. The CLI adds -serve and -connect shortcuts, and some clients (CLI, Python) are already available while others will follow. Support windows were adjusted to smooth migration: 1.4 remains supported until November 2026 and 1.5 support was extended to March 2027.
Technical highlights include asynchronous I/O for Parquet and CSV that decouples I/O from execution to boost parallelism and object-storage throughput; a fully integrated VARIANT type that "shreds" semi-structured data for compression and fast columnar execution with Parquet support and variant_* functions; agent mode in the CLI that emits compact outputs, JSON errors and query cost estimates for LLM-driven agents; a new PEG-based, extensible SQL parser as default; a revamped C API v2 and signed extension repository support for hosting trusted extensions; updates to core extensions (DuckLake, Iceberg, Delta); and CREATE TRIGGER support with BEFORE/AFTER and transition tables for audit and incremental maintenance.
Summary generated by AI from the linked article. hn.today is not affiliated with Hacker News or Y Combinator.
Tesla reports unexpected positive cash flow due to lower-than-anticipated AI spending. The company's revenue also exceeds estimates, with a rebound in deliveries and growth in energy storage. (reuters.com)
The CDC did not respond to requests from states to validate a new measles test. This has raised concerns about the testing process and public health response. (nytimes.com)
Plex laid off its entire player team amid ongoing issues with 4K HDR playback on Apple devices, causing frustration among users. The company has not confirmed when these problems will be fixed, leading some to consider switching to alternative media servers. (forums.plex.tv)
Despite Governor Abbott's order to halt data center permits in Texas, the Texas Commission on Environmental Quality continued approving projects. The ongoing development highlights the rapid expansion of data centers and concerns over resource impacts in the state. (fractracker.org)
Elon Musk states that he will identify and confront those truly pulling the strings behind the scenes, not just their puppets. Critics interpret his words as a warning of potential retaliation against political or media adversaries. (twitter.com)
Anthropic is a public benefit corporation committed to developing safe and trustworthy AI that benefits humanity in the long term. Its principles focus on AI safety, regulation, democracy, prosperity, and equitable distribution of AI benefits. (anthropic.com)
Today's best Hacker News stories, summarized and screenshotted, one email a day.