Author

SQLShark

@SQLShark

articles: 11
total claps: 20
top claps: 19
avg read: 6.0 min
active: 2025-08-07 → 2026-04-06

Wiki topics

🔓 · Open Source · 6 🎬 · Film & Television · 4 LLM · Large Language Models · 4 ☁️ · DevOps & Cloud · 3 ECO · Economy · General · 3 🏃 · Running & Endurance · 3 AGT · AI Agents · 2 ⏱️ · Productivity · 1

Top tags

#ubuntu ·6 #prometheus ·4 #grafana ·4 #postgres ·4 #n8n ·4 #metabase ·3 #nextcloud ·2 #tailscale ·2 #finance-dashboard ·1 #trading ·1

ECO AI

SQ SQLShark

Part 9 — Future Improvements: Taking My Market Copilot From “Working” to “Worth Shipping”

By this point in the series, the system is doing the thing I originally wanted: it turns noisy market + news inputs into something I can…

Dec 16, 2025 · 6 min read · 19 claps #n8n #postgres #metabase

Part 9 — Future Improvements: Taking My Market Copilot From “Working” to “Worth Shipping”

TCH

SQ SQLShark

How I built my own private cloud on Ubuntu with Nextcloud

I’ve been meaning to fix my “personal cloud” mess for years.

Apr 06, 2026 · 8 min read · 1 claps #nextcloud #ubuntu #tailscale

How I built my own private cloud on Ubuntu with Nextcloud

SQ SQLShark

Part 6 — The Telegram Analyst Copilot

In Part 5, we built the analyst score engine: a scheduled workflow that crunches 7/30-day features, applies deterministic heuristics, and…

Dec 12, 2025 · 13 min read · 0 claps #n8n #data-analyst #ai-agent

AI ECO

SQ SQLShark

Part 7 — Postgres Data Model for a Near-Real-Time Market Copilot

(n8n schema, idempotent ingestion, agent-friendly views, and materialized views for fast reporting)

Dec 15, 2025 · 9 min read · 0 claps #postgres #n8n #reporting

Part 7 — Postgres Data Model for a Near-Real-Time Market Copilot

ECO MDA SPT

SQ SQLShark

Part 8 — Building a Near-Real-Time Market Dashboard in Metabase

By the time you have a “feeds → signals” pipeline running, the next step is obvious: you want a place where you can see what’s happening…

Dec 16, 2025 · 9 min read · 0 claps #postgres #metabase #n8n

Part 8 — Building a Near-Real-Time Market Dashboard in Metabase

TCH SPT

SQ SQLShark

Configuring my private Nextcloud running on Ubuntu

Once Nextcloud is running, the temptation is to start uploading files and call it a day. I did that… and then quickly realised the admin…

Apr 06, 2026 · 5 min read · 0 claps #nextcloud #ubuntu #tailscale

Configuring my private Nextcloud running on Ubuntu

AI LIF SPT

SQ SQLShark

Maximising Productivity and Creativity: Leveraging Ollama AI Models with Obsidian

In my last couple of articles, we took a look at running AI models locally and getting cosy with Obsidian. Now, it’s time to dive deeper…

Aug 07, 2025 · 4 min read · 0 claps #obsidian #ai #locally

Maximising Productivity and Creativity: Leveraging Ollama AI Models with Obsidian

TCH

SQ SQLShark

Article 1: How to Set Up Prometheus and Grafana on Ubuntu, and Why I’m Using Them for My Home…

If you run a home server seriously, you eventually need answers to very practical questions: which service is using CPU, which mount point…

Apr 03, 2026 · 4 min read · 0 claps #grafana #prometheus #ubuntu

TCH MDA

SQ SQLShark

Article 2: Building an Ubuntu Host Overview Dashboard in Grafana

Once the stack is up, the first dashboard I recommend building is the host view. The reason is simple: before you look at containers or…

Apr 03, 2026 · 3 min read · 0 claps #ubuntu #grafana #prometheus

Article 2: Building an Ubuntu Host Overview Dashboard in Grafana

MDA TCH

SQ SQLShark

Article 3: Building the Disk & Network Dashboard in Grafana

The host overview tells you whether the machine is healthy in general. The disk and network dashboard tells you where slow problems are…

Apr 04, 2026 · 3 min read · 0 claps #ubuntu #grafana #prometheus

Article 3: Building the Disk & Network Dashboard in Grafana

TCH MDA

SQ SQLShark

Article 4: Building the Docker Containers Dashboard in Grafana

Once you can see the host and the network, the final step is to make Docker itself observable. This is where cAdvisor becomes valuable…

Apr 04, 2026 · 3 min read · 0 claps #ubuntu #prometheus #grafana