All
Articles 161,071Blog Posts 155,570Tech Tutorials 42,485Research Papers 31,730News 21,029
⚡ AI Lessons
Dev.to · Michael
⚡ AI Lesson
3w ago
Managing the FoundationDB Cluster in GCDW: Start/Stop, Scale, Replace, and Upgrade
FoundationDB serves as the metadata backbone for GCDW (GBase Cloud Data Warehouse). Keeping it...
Dev.to · Michael
⚡ AI Lesson
3w ago
Monitoring FoundationDB in GCDW: A Deep Dive into the status Command
GCDW (GBase Cloud Data Warehouse) relies on FoundationDB (FDB) for metadata storage. The fdbcli...
Dev.to · Michael
⚡ AI Lesson
3w ago
GBase 8a Load vs. Export Syntax Comparison
GBase 8a provides robust data loading (LOAD DATA INFILE) and data export (SELECT INTO OUTFILE)...
Dev.to · Michael
🔧 Backend Engineering
⚡ AI Lesson
3w ago
Temporarily Changing Session‑Level Parameters in GBase 8a
Some parameters in GBase 8a can be modified at the session level, affecting only the current...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Loading JSON Data Files in GBase 8a
Starting from version 9.5.3.28, GBase 8a supports loading JSON files directly into tables. By...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
GBase 8a initcap: Capitalizing the First Letter of Every Word
The initcap function in GBase 8a capitalizes the first letter of each word in a string and converts...
Dev.to · Michael
⚡ AI Lesson
3w ago
GBase 8a date_trunc: Truncating Date/Time to a Specified Precision
The date_trunc function in GBase 8a truncates a date/time value to the specified precision....
Dev.to · Michael
⚡ AI Lesson
3w ago
GBase 8a Mirror Cluster: Using Fewer High‑Spec Nodes for Backup
In a GBase 8a mirror cluster, the standard recommendation is to keep the primary and backup clusters...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Exporting Fixed‑Length Data Files in GBase 8a
Fixed‑length (or "positional") exports eliminate the need for field delimiters, which is especially...
Dev.to · Michael
⚡ AI Lesson
3w ago
Does GBase 8a V95 SetSysEnv.py Require the root User?
In GBase 8a V8, installation, upgrades, and service management all required root privileges. Starting...
Dev.to · Michael
🔐 Cybersecurity
⚡ AI Lesson
3w ago
GBase 8a sha2: Built‑in SHA‑224, SHA‑256, SHA‑384, and SHA‑512 Hashing
The sha2 function in GBase 8a provides native support for multiple SHA‑2 hash algorithms. You can...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
GBase 8a Pivot: Turning Rows into Columns
GBase 8a provides the pivot function for data pivoting — converting multiple rows into columns. This...
Dev.to · Michael
⚡ AI Lesson
3w ago
Fixing Rebalance Stuck During GBase 8a Mirror Cluster Expansion
When you scale out or scale in a GBase 8a mirror cluster, the operation changes the number of primary...
Dev.to · Michael
📣 Digital Marketing & Growth
⚡ AI Lesson
3w ago
Accessing an IPv4 GBase 8a Cluster from IPv6 via the Gateway and dblink
During the transition from IPv4 to IPv6, you may have two GBase 8a clusters running on different IP...
Dev.to · Michael
⚡ AI Lesson
3w ago
Checking Whether a View's Underlying Tables Still Exist in GBase 8a
When you create a view in GBase 8a, all referenced tables or other views must exist. However, if...
Dev.to · Michael
⚡ AI Lesson
3w ago
GBase 8a: DateDiff and TimestampDiff Have Opposite Parameter Orders
Both DATEDIFF and TIMESTAMPDIFF in GBase 8a calculate the difference between two dates, but their...
Dev.to · Michael
⚡ AI Lesson
3w ago
Troubleshooting gcluster_rsynctool IP Mapping Errors in GBase 8a
The gcluster_rsynctool utility synchronises tables between two GBase 8a clusters. When the clusters...
Dev.to · Michael
🧠 Large Language Models
⚡ AI Lesson
3w ago
I built a CLI that tells you if your codebase fits an LLM's context window
Every time I wanted to paste a whole project into Claude or ChatGPT, I ended up guessing whether it...
Dev.to · Michael
⚡ AI Lesson
4w ago
GCDW K8s 9.8.0.4.1 Multi‑Tenant Edition Overview
The GCDW (GBase Cloud Data Warehouse) 9.8.0.4.1 release introduces multi‑tenant support. Compared to...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4w ago
GBase 8a unpivot Function: Turning Columns into Rows
unpivot is the counterpart of the pivot function in GBase 8a. It transforms multiple columns into...
Dev.to · Michael
🔧 Backend Engineering
⚡ AI Lesson
4w ago
Using Python with GBase 8a: Connection, CRUD, Stored Procedures, and Data Loading
This guide demonstrates how to interact with a gbase database using Python. It covers driver...
Dev.to · Michael
⚡ AI Lesson
1mo ago
Fixing "Can't get distribution attribute of table" in GBase 8a
When a gbase database cluster experiences an unclean shutdown — a sudden power loss or kernel panic —...
Dev.to · Michael
⚡ AI Lesson
1mo ago
GBase 8a Load Performance Degradation: Root Causes and Diagnostic Steps
When loading data into a gbase database cluster, throughput can drop either gradually over months or...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Using LAST_VALUE in GBase 8a for OLAP Analysis
LAST_VALUE is a window function in GBase 8a that returns the last value in an ordered window,...
DeepCamp AI