All Posts

This collection of articles explores topics such as securing services, improving workflows, and enhancing data analysis. It also delves into useful tools, software updates, and practical tips for better efficiency.

Grist vs NocoDB: A Practical Comparison for Data-Driven Workflows

Grist and NocoDB are two open-source tools designed to help teams manage structured data, but they cater to very different needs. This post compares their strengths and weaknesses based on UI design, automation capabilities, API support, and access control.

Fixing Paperless API Requests in n8n: Avoiding the Login Page Trap

While building an n8n workflow for Paperless-ngx, I encountered a confusing issue: API requests that worked in curl returned an HTML login page in n8n. Here’s how I diagnosed the problem and found a reliable fix.

Using the Action Button Widget in Grist to Automate Table Operations

Grist’s Action Button widget is a powerful feature that allows users to trigger multi-step operations like adding, updating, or deleting records with a single click. Learn how to use it to simplify your workflows.

Connect to Grist API in Power BI Using Power Query

Learn how to fetch and transform data from a Grist document table directly in Power BI using a parameterized Power Query function.

Data Quality Issues in BAP’s Historical PHP/USD Rates

While BAP’s historical PHP/USD rate sheets are helpful, several data issues—like missing entries, duplicates, and pricing inconsistencies—raise concerns about accuracy.

Comparing the Lightweight, Markdown, Selfhosted Wikis

Looking for a simple, no-database wiki that renders Markdown on the fly? This post compares Wiki-Go, WikiDocs, and Otterwiki based on the features that mattered most in my self-hosted setup.

Samsung Galaxy S24 FE

The Samsung Galaxy S24 FE looks promising, but with the 256GB variant still at Php36,990, it’s a bit too steep for an upgrade from an older FE model. I’m holding off until it drops below Php30,000.

Hugo vs. Material for MkDocs

Hugo and Material for MkDocs are two top choices for building documentation sites. This post compares their installation, customization, image handling, search, navigation, Obsidian integration, performance, and theming to help you decide which one fits your workflow best.

How Logseq can be a better choice over Obsidian

While both Logseq and Obsidian are powerful knowledge management tools, Logseq’s outliner-first approach, bidirectional linking, and built-in task management offer unique advantages that might better suit your workflow.

SharePoint Folder vs. SharePoint List as a Power Apps Data Source

Comparing the limitations and capabilities of using SharePoint folders versus SharePoint lists in Power Apps. Learn when to use each option for optimal performance and functionality.