Flutter makes it easy and fast to build beautiful apps for mobile and beyond
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
The landscape of mobile development is shifting beneath our feet. For years, "Smart Apps" were simply thin clients for powerful cloud APIs. If you wanted to understand the sentiment of a sentence or find similar documents, you packaged a JSON request, sent it to a server, and waited for a response. But the era of the "Cloud-First" mandate is being challenged by a new priority: Privacy-Centric, Low
If you've spent any time doing Android development from the command line, you know the rhythm: adb devices, adb logcat, adb shell, repeat. It works, but it's friction — switching between windows, retyping device serials, manually grep-ing through logcat noise. padb is a Python-based terminal UI that wraps all of that into one interactive session. No GUI required, no Android Studio open in the back
Originally published on rohitraj.tech UPI fraud hit ₹805 cr in India last year. Cloud APIs leak data. So I built ScamRakshak — fully on-device scam detection. 3-tier inference engine: Gemma 4 LLM — context-aware classification LiteRT — fast pattern model Regex fallback — when battery low Full architecture write-up: https://rohitraj.tech/en/notes/build-on-device-ai-scam-detector-android-gemma Read
After getting frustrated with news apps designed to keep me scrolling forever, I built Trace - an Android app that aggregates news from 100+ sources and uses AI to create 30-second summaries. The app is free, no ads, no subscription. Just news that respects your time. The Problem Every morning I'd open Google News or Twitter and 30 minutes would vanish. Not because I was learning anything useful,