Datapuddle is a native macOS client for DuckDB that enables fast querying and visualization of large datasets without intermediate copying. It features efficient columnar rendering, automatic column profiling, query plan analysis, SQL completion, secure credential management via Keychain, and local-only data processing with no backend or account requirements.
ClickHouse uses a proprietary storage format developed before open standards like Parquet existed, requiring data duplication from other systems. The authors question whether a modern real-time analytics engine built natively on open formats like Parquet could match ClickHouse's performance, and introduce Pivot, an open-source database that achieves comparable or better speed while using standardized formats.