In Q3 2024, our 12-person platform team slashed log ingestion spend by 35% in 90 days, moving from a brittle Elasticsearch-based pipeline to a tuned Vector 0.30 and Loki 3.0 stack—without losing a single log or breaking our 99.95% SLA. GameStop makes $55.5B takeover offer for eBay (279 points) Talking to 35 Strangers at the Gym (144 points) Newton's law of gravity passes its biggest test (15
When you use window functions in SQL, you can't filter their results directly in a WHERE or HAVING clause — that's a well‑known limitation across many databases. GBase 8a, the China‑domestically developed MPP database from GBASE, solves this elegantly with the QUALIFY clause. Let's break down how it works, what it can do, and where you need to be careful. DROP TABLE IF EXISTS emp; CREATE TABLE emp
As data grows, you'll likely need to add nodes to your existing GBase 8a MPP cluster without downtime. This hands‑on guide walks through the full process of adding a composite GNode to a running GBASE cluster. Existing cluster: A healthy GBase 8a cluster New node: A server with a static IP address configured Network: All nodes must be able to communicate with each other Stop services on all existi
By default, identifiers in GBase 8s are case‑insensitive: uppercase letters are silently treated as lowercase. Setting the environment variable DELIMIDENT=Y changes how double‑quoted identifiers behave, enabling case‑sensitive table and column names. Here's a demonstration and a deep dive into the option, as used in a gbase database. With DELIMIDENT=y exported, execute the following statements: ex
We Cut Compliance Costs by 40% Using Pulumi 3.140 and Chef 18 for Multi-Cloud AWS and GCP Modern multi-cloud environments offer unmatched flexibility, but they also introduce complex compliance challenges. For our team managing hybrid infrastructure across AWS and GCP, manual policy enforcement and fragmented tooling were driving up compliance costs by 22% year-over-year. By integrating Pulumi 3
In Q3 2024, our 12-person platform engineering team reduced confirmed security incidents by 41.7% (from 72 to 42 per quarter) after rolling out Trivy 0.50 for pre-deployment scanning and Falco 0.40 for runtime detection across 142 production microservices. We didn’t rewrite our CI/CD pipeline, we didn’t hire a dedicated security team, and we didn’t spend a dime on enterprise security tools. Here’s
This post walks through setting up a distributed Hadoop cluster from scratch and loading data from HDFS into GBase 8a, GBASE's China-domestically developed MPP database. The full pipeline covers environment prep, config tweaks, cluster verification, and the final load command. Create a hadoop user on all nodes and configure passwordless SSH. Add Java and Hadoop paths to ~/.bash_profile on every no
OPTOFC (optimize-OPEN-FETCH-CLOSE) is a JDBC option in GBASE's GBase 8s that reduces network round trips when executing SELECT statements with PreparedStatement. This post explains how it works and demonstrates the real performance gain with benchmarks. The optimization kicks in only when all of the following are true: The statement is a PreparedStatement instance. The query is a SELECT. The Re