Blog

ClickHouse is a blazingly fast open source analytical database. We love Clickhouse here at Fiveonefour, and we’re on a mission to make Clickhouse accessible to every developer. If you’re a developer building on ClickHouse, you’ve come to the right place ;) Read on to learn about Fiveonefour's dev tool stack to enable Clickhouse developers... (more)

If you've worked with SQL databases like ClickHouse, you know that changing one object—say, a table—can have ripple effects on dependent objects like Materialized Views (MVs) or other views. Applying these Data Definition Language (DDL) changes in the wrong order often leads to errors and headaches. This post explains how Moose handles these SQL dependencies to make your infrastructure updates reliable during development with moose dev. (more)

Build a real-time GitHub analytics dashboard in a few hundred lines with Moose. Learn to ingest and enrich GitHub data, expose a type-safe API, and deploy a production-ready stack—all with minimal code and maximum speed. Perfect for tracking open-source trends or launching your own analytics project. (more)

Medallion architectures aim to deliver high-quality data products through distinct quality levels but face scalability issues as demand for these products increases. AI agents can address this by automating data quality improvement, speeding up the process from bronze to gold levels while maintaining high standards. Combined with federated data architectures and scalable frameworks, AI agents can significantly enhance data engineering capacity and deliver high-quality data at scale. (more)

The blog explores how Model Context Protocols (MCPs) are emerging as the next evolution beyond traditional APIs, enabling LLMs to interact with systems in flexible, agent-native ways. Just as APIs turned complex backend tasks into simple programmatic calls for apps, MCPs abstract complexity for LLMs, but require handling non-determinism and reasoning, not just static tasks. This shift could create a new wave of "API winners" in domains previously considered too human-centric to automate. (more)

The blog post discusses how the author created a template to ingest Goodreads data from Kaggle to demonstrate the capabilities of their advanced AI tools, including data ingestion and analysis. It provides a detailed guide on how to set up the tools, ingest the dataset, explore the data with AI, and even productionize results . (more)

This blog walks through setting up a Moose project to track military aircraft data using a Moose / Aurora ADS-B template, with a focus on leveraging Aurora MCP tools for data exploration and productionizing APIs. It provides a step-by-step guide to exploring and analyzing transponder data, using Claude Desktop and Cursor for insightful queries and visualizations. (more)

The blog post discusses the challenges of using MCPs in different clients, particularly Claude Desktop and Cursor, with frustrations around config JSON setup, updates, and PATH inheritance. (more)

Discover how F45 Training, the global boutique fitness franchise, rolled out user-facing analytics 10x faster and 50% cheaper with Fiveonefour, unlocking an immersive mobile app experience for their Lionheart biometrics and connected-fitness users. (more)

This post explores the lifecycle of data intensive feature engineering in product organizations, starting from shoe-horning them onto transactional systems, to incurring debt, to an analytical system re-architecture. This post proposes ways to foresee and reduce the friction in such re-architectures and the delivery of these features. (more)

Download and try out Aurora's first workflow: getting data from an API into your clickhouse database! (more)

A hands-on approach to domain-driven data products, automated data pipelines, and scalable governance. (more)

(more)

(more)

(more)

(more)

(more)

(more)

(more)

(more)

(more)