Data Fundamentals

Data Profiling Isn't Optional: What We Check Before You Build a Workflow

Fill rate, distinct counts, distributions — the questions worth asking about a dataset before you trust a report built on top of it.

PostgreSQL Data Types, and How DataQloo Infers Them

A column's declared PostgreSQL type is only half the story. Here's how DataQloo's Schema tab infers the more useful, semantic type underneath.

PostgreSQL vs. MySQL for Analytical Workflows

Both are solid relational databases. Here's how they actually differ for the kind of filtering and aggregation work a visual workflow tool does.