
EAV in PostgreSQL: correct queries before performance
EAV, relational columns or JSONB for custom fields? A reproducible SQL lab in Docker shows how to avoid false matches before testing performance.
Blog / Matteo Vincenti
I write about AI in everyday work, software development and how teams work together. I start with business problems and explore the technical decisions.
20 articles, page 2 of 2

EAV, relational columns or JSONB for custom fields? A reproducible SQL lab in Docker shows how to avoid false matches before testing performance.

Verify AI coding agents from requirements to release: source checks, regression tests, review and deployment evidence, with a runnable example and reusable skill.

Evaluate AI agents at work: quality, complete-task cost, ownership and criteria for adopting, limiting or stopping a pilot.

Organise context, sources and handoffs for AI agents. A real Notion knowledge path, from METR findings to reuse and ongoing maintenance.

Compare LangChain, LangGraph, OpenRouter and Langfuse by role and use case: practical criteria for business AI projects, with technical details.

Research in progress on the cost of Claude and Codex tasks: usage, time and human review, with commands and settings for the workflow variants to compare.

Build a code review skill for Claude and Codex. A lab compares two descriptions across four Codex sessions, with observed results and limits.

What MCP does and when to adopt it: business processes, costs, permissions and decision criteria, with a complete server example.
Contact