Join us

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

Self-replicating worm hits 180+ npm packages in (largely) automated supply chain attack

A supply chain worm called **Shai-hulud** is loose in the npm wild. It's not just lurking—it’s replicating through npm packages, lifting developer tokens, and injecting tainted versions of real, maintained libraries. Once in, it grabs GitHub secrets, flips private repos public, and piggybacks on Gi.. read more  

Self-replicating worm hits 180+ npm packages in (largely) automated supply chain attack
Link
@faun shared a link, 3 months ago
FAUN.dev()

Experimenting with local LLMs on macOS

Running **open-weight LLMs locally on macOS**? This post breaks it down clean. It compares **llama.cpp**—great for tweaking things—to **LM Studio**, which trades control for simplicity. Covers what fits in memory, which quantized models to grab (hint: 4-bit GGUF), and what’s coming down the pipe: *.. read more  

Experimenting with local LLMs on macOS
Link
@faun shared a link, 3 months ago
FAUN.dev()

GitHub Copilot Custom Chat Modes: AI Personas that Match Your Needs

GitHub Copilot Chat just jot better in **VS Code 1.101** with **Custom Chat Modes**. Devs can now drop Markdown files into their workspace to shape Copilot’s persona—tone, tools, constraints, the works. Want an AI buddy for security audits? Or a test-writing machine with zero patience for flaky cod.. read more  

GitHub Copilot Custom Chat Modes: AI Personas that Match Your Needs
Link
@faun shared a link, 3 months ago
FAUN.dev()

How In-Memory Caching Works in Redis

Redis isn’t just a cache anymore. Sure, it still owns the in-memory speed game—with **key expiration**, **data persistence**, and **horizontal scaling** via **replication** and **clustering**. But if you're only using it to stash a few keys, you're missing the point. This thing handles **streams**,.. read more  

How In-Memory Caching Works in Redis
Link
@faun shared a link, 3 months ago
FAUN.dev()

MCP vulnerability case study: SQL injection in the Postgres MCP server

A nasty SQL injection bug in Anthropic’s now-retiredPostgres MCP serverlet attackers blow past read-only mode and run whatever SQL they wanted. The repo got archived back in May 2025—but it’s far from dead. The unpatched package still racks up21,000 NPM installsand1,000 Docker pullsevery week... read more  

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

You Vibe It, You Run It?

Vibe Coding lets developers create software by chatting with AI, skipping traditional coding. But the non-determinism of AI prompts poses significant risks for reliability and maintainability, potentially leading to addiction-like dependence on this new tool. Think twice before fully embracing this .. read more  

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

Using Claude Code to modernize a 25-year-old kernel driver

A long-dead Linux kernel driver for QIC-80 tape drives just got dragged into the present—with help from **Claude Code** and a lot of tinkering. It now builds cleanly and runs as a **standalone module** on **Linux 6.8**, playing nice with modern setups like **Xubuntu 24.04**. **The bigger picture:**.. read more  

Using Claude Code to modernize a 25-year-old kernel driver
Link
@faun shared a link, 3 months ago
FAUN.dev()

TIOBE Programming Index News September 2025: Perl Regains the Spotlight

Perl 5 has risen to **10th place in the TIOBE Index**, increasing in popularity even though the exact reason is unknown. Perl 6, or Raku, lags behind Perl 5 in rankings and has not seen the same rise in attention. Other top languages like C and Java have experienced slight falls in rankings... read more  

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

Building an AI Server on a Budget ($1.3K)

A developer rolled their own AI server for $1.3K—Ubuntu 24.04.2 LTS, an Nvidia RTX GPU, and a sharp eye on Tensor cores, VRAM, and resale value. The rig handles small models locally and punts big jobs to the cloud when needed. Local-first, cloud-when-it-counts... read more  

Building an AI Server on a Budget ($1.3K)
Link
@faun shared a link, 3 months ago
FAUN.dev()

GitHub Copilot on autopilot as community complaints persist

GitHub's biggest debates right now? Whether to shut down AI-generated "noise" fromCopilot—stuff like auto-written issues and code reviews. No clear answers from GitHub yet. Frustration is piling up. Some devs are ditching the platform altogether, shifting their projects toCodebergor spinning upself-.. read more  

GitHub Copilot on autopilot as community complaints persist
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).