DuckDB on a Mac
In-process OLAP database; the SQLite of analytics · Analytics Databases
DuckDB is an embedded analytical database: a single-file, in-process engine (like SQLite, but columnar and vectorized) that queries CSV/Parquet/JSON files, pandas and Polars DataFrames, and even remote S3 data with full SQL; no server to run or administer. brew install duckdb, then duckdb mydb.duckdb for a shell, or duckdb -ui for the bundled local web UI (:4213). The default choice for local analytics before workloads justify a ClickHouse server.
Run DuckDB with FrontierStack
Install or connect DuckDB; then check its status, ports and certificate from FrontierStack. The same screen links to firewall checks, Malware Audit and backups where they apply.
Run it from your Mac.
FrontierStack installs, monitors and secures services on this Mac and on linked servers.
Download FrontierStackApple notarized · Safe & secure · macOS 13 Ventura+