Metabase+DuckDB+SQLite Tables: Metabase Visualize SQLite Tables with DuckDB
https://www.metabase.com/
Fast analytics with the friendly UX and integrated tooling to let your company explore data on their own.
https://duckdb.org/
https://github.com/duckdb/duckdb
DuckDB is a fast in-process analytical database
DuckDB supports a feature-rich SQL dialect complemented with deep integrations into client APIs
Simple
DuckDB is easy to install and deploy. It has zero external dependencies and runs in-process in its host application or as a single binary.
Portable
DuckDB runs on Linux, macOS, Windows, and all popular hardware architectures. It has idiomatic client APIs for major programming languages.
Feature-rich
DuckDB offers a rich SQL dialect. It can read and write file formats such as CSV, Parquet, and JSON, to and from the local file system and remote endpoints such as S3 buckets.
Fast
DuckDB runs analytical queries at blazing speed thanks to its columnar engine, which supports parallel execution and can process larger-than-memory workloads.
Extensible
DuckDB is extensible by third-party features such as new data types, functions, file formats and new SQL syntax.
Free
DuckDB and its core extensions are open-source under the permissive MIT License.
https://github.com/AlexR2D2/metabase_...
https://github.com/MotherDuck-Open-So...
https://www.metabase.com/data_sources...
What Is SQLite?
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day
SQLite source code is in the public-domain and is free to everyone to use for any purpose.