All
Articles 190,145Blog Posts 171,860Tech Tutorials 50,959Research Papers 36,793News 23,196
⚡ AI Lessons

Dev.to · Michael
1d ago
BeautifulSlop is 8674 faster than Beautiful Soup
The median across all 70 tested cases is 7.7x. BeautifulSlop is the compatibility API on top of a...

Dev.to · Michael
🧠 Large Language Models
⚡ AI Lesson
4d ago
How to Run Local LLMs on Apple Silicon
This is about the model, on its own — what tool to install, what format to pull, and how to actually...

Dev.to · Michael
4d ago
LLM Quantization Explained for Mac Users
The RAM math post treats quantization as an input — "4-bit is roughly 0.5 bytes per parameter" — and...

Dev.to · Michael
4d ago
How Much RAM Do You Need for Local LLMs on a Mac?
This blog already has a tier-by-tier table for the specific models it recommends. This is the math...

Dev.to · Michael
⚡ AI Lesson
1mo 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
1mo 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
1mo 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
1mo 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
2mo 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
2mo 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
2mo 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
2mo 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
2mo 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
2mo 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
2mo 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
2mo 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
2mo 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
2mo 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
2mo 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
2mo 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
2mo 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
2mo 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
2mo 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
2mo 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...
DeepCamp AI