tag
6 posts
Develop dbt projects inside WSL with pinned adapters, explicit profiles, compiled-SQL review, data tests, and a clean boundary from Windows tooling.
Use DuckDB inside WSL to query Parquet and local datasets, keep database files on ext4, and distinguish embedded analytics tests from server workloads.
Build reproducible R projects in WSL with renv, Linux-native package libraries, verified system dependencies, and explicit restore and test workflows.
Build and test a local Superset dashboard in WSL, isolate Python and metadata state, validate database connectivity, and avoid development-only security settings.
Run a bounded Trino coordinator and worker in WSL, configure a test catalog, query sample data, and separate local SQL tests from cluster guarantees.
Use ClickHouse in WSL to explore MergeTree ingestion, background merges, query plans, and filesystem behavior without assuming production-grade support or uptime.