ClickHouse Builds a Fully Functional Ray Tracer Using SQL Queries

·1 views

ClickHouse has released an open-source project that implements a ray tracer entirely in SQL. The project, hosted on GitHub, demonstrates that SQL can be used for complex graphical computations beyond traditional data querying. Ray tracing is a rendering technique that simulates how light interacts with objects to produce realistic images. The project serves as a technical showcase of ClickHouse's analytical query capabilities. It has attracted attention in developer communities as an unconventional and creative use of the SQL language.

Read the full story at Hacker News

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Dev Team Builds Lightweight Jira Alternative WannaTrack After Costs Soared

A small development team switched away from Jira after finding its $15-per-user monthly fee hard to justify for their actual usage needs. They built WannaTrack, a lightweight project management tool aimed at small dev teams that want simple issue tracking without enterprise-level complexity. The tool focuses on a minimal agile board, a fast interface, and low setup overhead, stripping out features the team never used. To ease the transition, the team developed a Jira import feature that migrates existing tickets automatically, allowing them to switch without disrupting their workflow. WannaTrack is now being opened to other small teams, indie hackers, and startups seeking a simpler alternative to traditional project management tools.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

MessageFrame: C++17 Library Enables Schema-Free Device Telemetry Serialization

A developer has released MessageFrame, a lightweight C++17 library designed to simplify structured command and telemetry messaging between PCs and embedded devices such as SDR receivers and sensors. The library allows parameters to be addressed dynamically using device and parameter name strings, eliminating the need for schema files or code generation steps required by tools like Protobuf or FlatBuffers. Under the hood, it uses MessagePack as its binary wire format, keeping payloads compact enough for real-time use while remaining decodable by any MessagePack-compatible parser. Parameters are stored in a flat vector for up to 128 entries to optimize CPU cache performance, automatically switching to a hash map beyond that threshold. MessageFrame does not include a transport layer and is not intended as a full replacement for Protobuf, but rather as a flexible payload-structuring solution for systems with dynamic or frequently changing device configurations.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Anthropic Says Claude Now Writes Over 80% of Its Shipped Code

Anthropic revealed in a June 2026 essay that more than 80% of the code it ships is now written by its AI model, Claude, up from low single digits just two years ago. The shift was accelerated by Claude Code, a tool that allows the model to autonomously read codebases, make edits, run tests, and fix errors. Human engineers have moved from writing code to reviewing and approving the model's output, with each engineer reportedly shipping roughly eight times more code per quarter than before. Beyond volume, Anthropic says an unreleased internal model now outperforms its own researchers at choosing research directions, and nearly closed the gap with human experts on an unsolved AI safety problem. However, all key figures come from Anthropic's own internal, unreleased models, meaning the claims have not yet been independently verified.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Why Critical Engineering Decisions Vanish When Senior Developers Leave

When a senior engineer leaves a company, teams often lose the reasoning behind key technical decisions — such as why certain configurations were set or why specific vendors were dropped. Traditional documentation has failed to solve this problem because it requires upfront effort with delayed, uncertain payoff. AI coding tools face a similar gap, as they lack the institutional memory humans build through years of on-the-job experience. One proposed solution is to capture decisions at the moment they are made, recording not just the choice but also the alternatives that were considered and rejected. A tool called Decispher is being developed to address this by preserving reusable, high-stakes engineering decisions before key personnel depart.

0 comments Read more at DEV Community