Exploring a Postgres query plan
A technical deep dive into intercepting and walking PostgreSQL query execution plans to reconstruct SQL and enable custom evaluation.
A technical deep dive into intercepting and walking PostgreSQL query execution plans to reconstruct SQL and enable custom evaluation.
A technical guide detailing the author's specific setup process for installing Alpine Linux on a ThinkPad laptop, including btrfs configuration.
Explains how to extract and analyze spatial patterns from categorical raster data using the 'motif' R package and information theory metrics.
An Atlantic article explores how Google's AI-generated Quick Answers, sourced from sites like Emergent Mind, are spreading misinformation.
Author details a fix for TinyTeX installation errors on Windows caused by usernames with spaces or non-ASCII characters, released in tinytex v0.49.
A technical guide on installing and configuring software, firmware, and interfaces for a VORON 3D printer build.
Explains how to integrate Amazon CodeCatalyst with Amazon VPC to deploy and manage resources in private subnets using CI/CD workflows.
A developer troubleshoots Hugo's live-reload feature failing on Mac after switching from Docker Desktop to OrbStack, and finds a workaround.
Exploring the two JDBC driver options for connecting to Apache Flink: the new Flink JDBC driver and the Hive JDBC driver via the SQL Gateway.
Learn how Amazon CodeWhisperer uses generative AI to convert natural language into SQL code, accelerating database development.
An analysis of ChatGPT's knowledge cutoff date, testing its accuracy on celebrity death dates to understand the limits of its training data.
A technical guide exploring the OpenAI Assistants API, covering its core concepts and demonstrating how to create an assistant with the Code Interpreter tool.
Overview of new features in Redux Toolkit 2.0 presented at React Summit US 2023, including video and slides.
Monthly roundup of data streaming trends, featuring Apache Iceberg, Kafka Streams, Flink deployments, and streaming SQL insights.
A detailed, personal account of the challenging wiring phase in building a VORON Trident 3D printer, including troubleshooting and component connections.
Explores the new ConfigureAwait enhancements in .NET 8.0, discussing its history, usage guidelines, and evolving best practices for async/await.
A Hare programming language developer seeks podcast appearances to discuss Hare, the Ares OS, and Himitsu, promoting community-driven tech evangelism.
A developer reflects on the successful technical launch of KeyboardKit 8 but expresses disappointment over the lack of user traction and signups.
Explains how to use C#12's new ExperimentalAttribute to mark and require opt-in for experimental APIs in libraries, preventing accidental usage.
A curated list of the best developer-focused sessions from Microsoft Ignite 2023, highlighting AI, Copilot, and cloud-native topics for ANZ attendees.