Join us

ContentUpdates and recent posts about BigQuery..
Link
@faun shared a link, 2 months, 3 weeks ago
FAUN.dev()

Authentication Explained: When to Use Basic, Bearer, OAuth2, JWT & SSO

Modern apps don’t just check passwords—they rely on **API tokens**, **OAuth**, and **Single Sign-On (SSO)** to know who’s knocking before they open the door... read more  

Link
@faun shared a link, 2 months, 3 weeks ago
FAUN.dev()

Organize your Slack channels by “How Often”, not “What” - Aggressively Paraphrasing Me

One dev rewired their Slack setup by **engagement frequency**—not subject. Channels got sorted into tiers like “Read Now” and “Read Hourly,” cutting through noise and saving brainpower. It riffs off the **Eisenhower Matrix**, letting priorities shift with projects, not burn people out... read more  

Link
@faun shared a link, 2 months, 3 weeks ago
FAUN.dev()

Uncommon Uses of Common Python Standard Library Functions

A fresh guide gives old Python friends a second look—turns out, tools like **itertools.groupby**, **zip**, **bisect**, and **heapq** aren’t just standard; they’re slick solutions to real problems. Think run-length encoding, matrix transposes, or fast, sorted inserts without bringing in another depen.. read more  

Link
@faun shared a link, 2 months, 3 weeks ago
FAUN.dev()

Privacy for subdomains: the solution

A two-container setup using **acme.sh** gets Let's Encrypt certs running on a Synology NAS—thanks, Docker. No built-in Certbot support? No problem. Cloudflare DNS API token handles auth. Scheduled tasks handle renewal... read more  

Privacy for subdomains: the solution
Link
@faun shared a link, 2 months, 3 weeks ago
FAUN.dev()

Users Only Care About 20% of Your Application

Modern apps burst with features most people never touch. Users stick to their favorite 20%. The rest? Frustration, bloat, ignored edge cases. Tools like **VS Code**, **Slack**, and **Notion** nail it by staying lean at the core and letting users stack what they need. Extensions, plug-ins, integrati.. read more  

Link
@faun shared a link, 2 months, 3 weeks ago
FAUN.dev()

Building a Resilient Data Platform with Write-Ahead Log at Netflix

Netflix faced challenges like data loss, system entropy, updates across partitions, and reliable retries. To address these, they built a generic Write-Ahead Log (WAL) system serving a variety of use cases like delayed queues, generic cross-region replication, and multi-partition mutations. WAL abstr.. read more  

Link
@faun shared a link, 2 months, 3 weeks ago
FAUN.dev()

Implementing Vector Search from Scratch: A Step-by-Step Tutorial

Search is a fundamental problem in computing, and vector search aims to match meanings rather than exact words. By converting queries and documents into numerical vectors and calculating similarity, vector search retrieves contextually relevant results. In this tutorial, a vector search system is bu.. read more  

Link
@faun shared a link, 2 months, 3 weeks ago
FAUN.dev()

5 Free AI Courses from Hugging Face

Hugging Face just rolled out a sharp set of free AI courses. Real topics, real tools—think **AI agents, LLMs, diffusion models, deep RL**, and more. It’s hands-on from the jump, packed with frameworks like LangGraph, Diffusers, and Stable Baselines3. You don’t just read about models—you build ‘em i.. read more  

Link
@faun shared a link, 2 months, 3 weeks ago
FAUN.dev()

Inside NVIDIA GPUs: Anatomy of high performance matmul kernels

NVIDIA Hopper packs serious architectural tricks. At the core: **Tensor Memory Accelerator (TMA)**, **tensor cores**, and **swizzling**—the trio behind async, cache-friendly matmul kernels that flirt with peak throughput. But folks aren't stopping at cuBLAS. They're stacking new tactics: **warp-gro.. read more  

Inside NVIDIA GPUs: Anatomy of high performance matmul kernels
Link
@faun shared a link, 2 months, 3 weeks ago
FAUN.dev()

The productivity paradox of AI coding assistants

A July 2025 METR trial dropped a twist: seasoned devs using Cursor with Claude 3.5/3.7 moved **19% slower** - while thinking they were **20% faster**. Chalk it up to AI-induced confidence inflation. Faros AI tracked over **10,000 developers**. More AI didn’t mean more done. It meant more juggling, .. read more  

The productivity paradox of AI coding assistants
BigQuery is a cloud-native, serverless analytics platform designed to store, query, and analyze massive volumes of structured and semi-structured data using standard SQL. It separates storage from compute, automatically scales resources, and eliminates the need for infrastructure management, indexing, or capacity planning.

BigQuery is optimized for analytical workloads such as business intelligence, log analysis, data science, and machine learning. It supports real-time data ingestion via streaming, batch loading from cloud storage, and federated queries across external data sources like Cloud Storage, Bigtable, and Google Drive.

Query execution is distributed and highly parallel, enabling interactive performance even on petabyte-scale datasets. The platform integrates deeply with the Google Cloud ecosystem, including Looker for BI, Vertex AI for ML workflows, Dataflow for streaming pipelines, and BigQuery ML, which allows users to train and run machine learning models directly using SQL.

Built-in security features include fine-grained IAM controls, column- and row-level security, encryption by default, and audit logging. BigQuery follows a consumption-based pricing model, charging for storage and queries (on-demand or reserved capacity).