ClickHouse 26.3 adds ANSI SQL time keywords to ease database migrations

·1 views

ClickHouse version 26.3 introduces support for standard SQL temporal keywords such as CURRENT_DATE, CURRENT_TIMESTAMP, and NOW without parentheses, improving compatibility with the ANSI SQL standard. Previously, developers migrating from databases like PostgreSQL, MySQL, or Snowflake had to rewrite time-related queries to use ClickHouse-native functions such as today() and now(). The update allows SQL queries from other systems to run in ClickHouse with little or no modification, reducing migration effort across large query sets. BI and reporting tools like Tableau, Metabase, and Apache Superset, which auto-generate ANSI SQL, are expected to benefit directly from this change. The existing native ClickHouse functions remain fully supported and are still the recommended approach for new development.

Read the full story at DEV Community

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

Discussion (0)

Developer Builds Neo4j F1 Graph Database to Link Verstappen to Fangio

A developer used Formula 1 racing data spanning 75 years to learn Neo4j, a graph database technology, by exploring driver connections across generations. Inspired by the 'Six Degrees of Kevin Bacon' concept, the project investigates whether modern drivers like Max Verstappen can be linked to legends like Juan Manuel Fangio through chains of shared teammates. The exercise highlights why graph databases outperform traditional relational databases for querying complex, multi-hop relationships. Using Neo4j's Labeled Property Graph model, the developer built a dataset covering every F1 driver since 1950 and resolved the Verstappen-to-Fangio question in a single query line. The project serves as a practical, beginner-friendly introduction to graph database concepts using real-world sports data.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Builds Stateful AI Video Editor Inside Claude Code Using Google Gemini API

A developer has released an open-source tool called omni-skill-claude that integrates Google's Gemini Omni Flash video model into Claude Code via a lightweight MCP server. The project allows users to generate, animate, and edit videos entirely from a terminal by typing natural language prompts without leaving their coding environment. Unlike most video-generation tools, it leverages Google's stateful Interactions API, meaning the model retains visual context across multiple editing turns so users can refine clips incrementally without re-describing entire scenes. The skill supports five workflows including text-to-video, image animation, keyframe interpolation, subject-consistent generation, and video restyling. Completed videos can also be uploaded directly to YouTube through the same interface.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

React Hook Library react-hook-lab Reaches 1,000 npm Downloads

The open-source React hooks library react-hook-lab has surpassed 1,000 total downloads on npm since its launch. The package was developed to address common shortcomings in existing hook libraries, including heavy dependencies, poor Server-Side Rendering compatibility, and performance issues caused by excessive re-renders. It is built with zero external dependencies, full TypeScript support, and compatibility with frameworks such as Next.js, Remix, and Gatsby. Notable hooks in the library include useCamera, useMicrophone, useLocation, useIdle, and useTimezone, each designed with performance and SSR safety in mind. The project is publicly available on GitHub, where the maintainer is encouraging community contributions and stars to help expand its reach.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

AKS Supports Near-Bare-Metal Workloads, But Platform Teams Face Key Caveats

Azure Kubernetes Service (AKS) allows teams to use isolated VM SKUs that occupy entire physical hosts, reducing hypervisor overhead for demanding workloads like GPU inference and latency-sensitive financial systems. These specialty SKUs can offer predictable NUMA topology, single-tenant hardware isolation, and full access to features like SR-IOV and DPDK, though compatibility with AKS CNI configurations requires validation. However, using such SKUs does not change core AKS node lifecycle behavior — auto-repair, OS upgrades, and cordon-drain-replace mechanics remain in effect. A key risk is that isolated VM families often have limited regional capacity, meaning surge nodes during upgrades may fail to provision, potentially stalling the process. Platform teams are advised to verify current supported VM sizes for their target region and reassess their upgrade and auto-repair assumptions before committing to specialty node pool designs.

0 comments Read more at DEV Community