2025-11-30 Tech Briefing | Snowflake query optimization through JoinFilter improves performance and reduces costs.

Sunday

Welcome to this edition, featuring 9 articles.

📚 Contents/📝 TL;DR

📚 Contents

📝 TL;DR

Primary

JoinFilters in Practice: Making Snowflake Queries Faster and Smarter

Snowflake query optimization through JoinFilter improves performance and reduces costs.

JoinFilters in Practice: Making Snowflake Queries Faster and Smarter

Snowflake query optimization through JoinFilter improves performance and reduces costs.

Upgrading to AntD 6: Be the First to Try It

Guidance on how to safely upgrade to Ant Design 6.

Upgrading to AntD 6: Be the First to Try It

Guidance on how to safely upgrade to Ant Design 6.

Google Integrates Colab into Visual Studio Code

Google Colab integrated with VS Code, making AI development more convenient.

Google Integrates Colab into Visual Studio Code

Google Colab integrated with VS Code, making AI development more convenient.

Should Image Tags Use `<img>` or `<picture>`? Many Have Completely Confused!

Clarifying the correct usage of `<img>` and `<picture>` tags.

Should Image Tags Use `<img>` or `<picture>`? Many Have Completely Confused!

Clarifying the correct usage of `<img>` and `<picture>` tags.

Essential

Black Horse Rears Up and Causes a Stir: A Comprehensive Analysis of JavaScript Scope and Scope Chain

Detailed explanation of JavaScript's scope and scope chain mechanisms.

Black Horse Rears Up and Causes a Stir: A Comprehensive Analysis of JavaScript Scope and Scope Chain

Detailed explanation of JavaScript's scope and scope chain mechanisms.

Six Years of Burning Money, Dojo Gets the Death Sentence: How Musk's Self-Designed Supercomputer Dream Went Down the Drain?

Musk's self-developed supercomputer project, Dojo, was terminated after six years of heavy spending, shifting to a collaborative approach.

Six Years of Burning Money, Dojo Gets the Death Sentence: How Musk's Self-Designed Supercomputer Dream Went Down the Drain?

Musk's self-developed supercomputer project, Dojo, was terminated after six years of heavy spending, shifting to a collaborative approach.

General

A New HTML Page to PDF Conversion Technical Solution

The new solution SnapDOM + jsPDF achieves high-quality HTML to PDF conversion, outperforming html2canvas.

A New HTML Page to PDF Conversion Technical Solution

The new solution SnapDOM + jsPDF achieves high-quality HTML to PDF conversion, outperforming html2canvas.

Comparison of Virtualization and Containerization

Brief comparison of virtualization and containerization, overview of API authentication, AirTag, firewall, and Modem/Router.

Comparison of Virtualization and Containerization

Brief comparison of virtualization and containerization, overview of API authentication, AirTag, firewall, and Modem/Router.

Moon Game

A photo of the moon and a mountain church taken in Italy.

Moon Game

A photo of the moon and a mountain church taken in Italy.

Primary

JoinFilters in Practice: Making Snowflake Queries Faster and Smarter

InfoQ - AI & LLM•Published on November 30

Insight•Cloud Computing and Backend•Score: 8/10

SnowflakeJoinFilterQuery OptimizationCost EfficiencyData Warehouse

Source

◆

Upgrading to AntD 6: Be the First to Try It

Juejin Frontend Hottest•Published on November 26

Insight•Frontend Development•Score: 7/10

AntD 6React 18UI Framework UpgradeZeroRuntimeEngineering

Source

◆

Google Integrates Colab into Visual Studio Code

InfoQ - Backend•Published on November 30

News•AI and Frontier Technologies•Score: 7/10

Google ColabVS CodeMachine LearningAI DevelopmentGPU

Source

◆

Should Image Tags Use `<img>` or `<picture>`? Many Have Completely Confused!

Juejin Frontend Hottest•Published on November 28

Insight•Frontend Development•Score: 7/10

HTML ImagesResponsive DesignFrontend Performance<img> Tag<picture> Tag

🔬

Tech Insights

1. The `<img>` Tag's Responsive Capabilities Are Severely Undervalued: Many people don't realize that with srcset and sizes attributes, <img> can handle most responsive image needs on its own, with cleaner code and better performance. This is key to avoiding unnecessary complexity. 2. <picture> is not a replacement for <img>, but rather a complementary solution for specific scenarios: it mainly addresses 'Art Direction' (different crops for different devices) and 'Modern Format Fallback' (e.g., AVIF/WebP compatibility with JPG). This is its 'killer feature'. 3. Performance optimization is a common topic but often overlooked: the article emphasizes the accessibility of alt attributes, lazy loading via loading, priority control with fetchpriority, and specifying width/height to avoid layout shift (CLS). These are all fundamental skills for enhancing user experience.

📈

Perspectives

In my view, many domestic teams in the frontend domain are still at the 'good enough' stage for image optimization, or blindly chasing 'new formats' without considering compatibility and fallback mechanisms. The core value of this article lies in reminding us that performance optimization is one of the highest ROI investments. As user expectations for experience continue to rise, and search engines increasingly prioritize Core Web Vitals metrics, poor image loading performance on websites will lead to 'slow death' in the competitive market. Especially in e-commerce and content-based products, images are core assets, and without mastering image optimization, it's pointless to talk about 'user growth' or 'conversion rate'. The trend is that image optimization will become more intelligent and automated (e.g., through CDN services with built-in image processing), but as architects or product leads, understanding the underlying principles is essential to better evaluate and choose these services, avoiding being 'taken advantage of' by vendors.

Source

Essential

Black Horse Rears Up and Causes a Stir: A Comprehensive Analysis of JavaScript Scope and Scope Chain

Juejin Frontend Hottest•Published on November 28

Insight•Frontend Development•Score: 8/10

JavaScriptScope ChainClosurelet/constLexical Scoping

Source

◆

Six Years of Burning Money, Dojo Gets the Death Sentence: How Musk's Self-Designed Supercomputer Dream Went Down the Drain?

InfoQ - AI & LLM•Published on November 29

News•AI and Frontier Technologies•Score: 8/10

DojoTeslaAI chipSupercomputerMusk

🔬

Tech Insights

1. The Allure and Pitfalls of Self-Designed Chips: Tesla's Dojo project evolved from D1 to D2, and then to AI6, essentially aiming to break free from NVIDIA GPU dependency for cost and performance optimization. However, the reality proved that self-developing AI chips is a high threshold and high-risk endeavor, even for a giant like Tesla. 2. The Necessity of Strategic Shifts: From Dojo to Cortex, and then to collaboration with Samsung on AI6, Tesla has moved from an 'all-in' self-research strategy to a pragmatic approach of open cooperation. This indicates that in high-risk, high-capital AI infrastructure fields, blind self-research is less effective than leveraging external strengths. 3. FSD and the Computational Power Bottleneck in AI Training: The article highlights the massive data and computational power demands of the purely visual FSD approach, as well as the potential bottleneck of 'valuable data exhaustion'. This suggests that AI model training is not just about stacking computational power, but also about the quality and effectiveness of data.

⚠️

Notable

1. Musk's 'big mouth' and repeated failure to deliver on promises with the Dojo project once again demonstrate the vast gap between a tech visionary's aspirations and the realities of engineering implementation. From claiming Dojo was live in June 2023, to stating it would become one of the world's top five supercomputers in February 2024, and finally cutting it off in August 2025, this sequence of events serves as a textbook example of a 'project management worst case'. 2. The article notes that the D1 chip's performance was inferior to NVIDIA's A100, and that nearly all AI software is written for GPUs. This implies that the Dojo chip would need to re-engineer the software stack, which is a self-imposed limitation. This puts it at a disadvantage in both ecosystem and performance, making failure inevitable.

📈

Perspectives

1. In my view, the 'death sentence' of Tesla's Dojo project serves as a warning to the entire industry: attempting to challenge NVIDIA's dominance in the AI chip market through one's own efforts in a money-hungry field is only feasible if there's an absolute technological gap and ecosystem-building capability. Otherwise, it's simply throwing money away. 2. Tesla's decision to collaborate with Samsung on the AI6 chip shows that even Musk has to yield to market realities and specialized division of labor. In the coming years, the AI chip market will remain a battleground for heavy investment by giants, but it will increasingly trend towards win-win cooperation rather than solo battles. This is also a signal for domestic manufacturers: in the AI infrastructure sector, ecosystem development and supply chain integration may be more important than pure self-research.

Source

General

A New HTML Page to PDF Conversion Technical Solution

Juejin Frontend Hottest•Published on November 26

Insight•Frontend Development•Score: 7/10

HTML to PDFsnapdomjsPDFfrontendscreenshot

🔬

Tech Insights

1. **snapdom**'s 'dimensional strike': Compared to the various 'black magic' issues with html2canvas in style fidelity, **snapdom** claims near-perfect support for modern features such as CSS styles, Flexbox, Grid, gradients, and shadows. This is a blessing for frontend engineers. Previously, to solve screenshot distortion, numerous hacks were used, but now there is finally a reliable library. 2. Pagination algorithm is a core challenge: The article thoroughly explains how long images can be paginated at the pixel level using Canvas, and then imported into jsPDF. This 'image pagination' approach cleverly avoids the shortcomings of PDF generation libraries in directly handling complex HTML layouts, simplifying the problem to image processing, which is very practical. 3. The value of a pure frontend solution: The conversion from HTML to PDF can be completed entirely on the browser side without server involvement, significantly reducing deployment and maintenance costs, and enhancing user experience. For applications that frequently generate reports, invoices, chat records, and other documents, this is an efficiency tool.

Source

◆

Comparison of Virtualization and Containerization

ByteByteGo•Published on November 29

Insight•Software Architecture and Engineering Practices•Score: 6/10

virtualizationcontainerizationAPI authenticationnetwork securitysystem design

🔬

Tech Insights

1. Concise comparison of virtualization and containerization: The article distinguishes VMs and containers using "hardware-level isolation" and "OS-level isolation", and highlights the lightweight and fast boot advantage of containers due to their "shared host kernel". This is crucial for understanding the fundamentals of modern cloud-native architecture. 2. Organization of API authentication methods: From Basic Auth to OAuth, the article clearly lists the common five API authentication approaches and specifies their respective use cases. This provides a practical reference framework for security architecture design and API gateway selection. 3. Networking basics education: The distinction between two types of firewall (network-level and host-level) and the separation of responsibilities between Modem and Router are fundamental knowledge in network design. These insights help team members with cross-domain collaboration to establish a shared understanding.

Source

◆

Moon Game

NASA APOD•Published on November 29

News•General News•Score: 2/10

moonphotographyastronomy