💻 Tracker Mirror — SOFTWARE SETUP
| Component | Purpose | Target | Status | Validation Test | Source / Notes |
|---|---|---|---|---|---|
| PostgreSQL | Primary relational DBMS for labs | Current supported major release; program baseline documented in Tech Academy | Not Installed | Create DB/schema/table; run SELECT; inspect constraint | Official PostgreSQL documentation |
| DBeaver Community | Database workbench | Current Community release | Not Installed | Connect to PostgreSQL; browse schemas; run saved SQL | Official DBeaver documentation |
| Python | Scripting/data management | Current supported Python 3 release | Not Installed | python --version; create venv; run script |
python.org docs |
| pandas | Tabular data manipulation | Current compatible release | Not Installed | Read CSV; inspect DataFrame; write result | pandas docs |
| VS Code | Editor/environment | Current stable release | Not Installed | Open project; select interpreter; run/debug script | VS Code docs |
| Git | Version control | Current stable release | Not Installed | init; status; commit; diff | git-scm official book/docs |
| PowerShell | Windows shell | Built-in/current supported | Not Installed | Navigate; inspect PATH; run project commands | Practical literacy only |
| DuckDB | Later analytical file/query lab | Install when Chapter 14 or analytical file work needs it | Deferred | Query CSV/Parquet directly | Later tool |
| Metabase | Later BI lab | Install when Chapter 11 lab is ready | Deferred | Connect to lab DB and build dashboard | Later tool |
| OpenMetadata | Later metadata/catalog lab | Install/sandbox when Chapter 12 lab is ready | Deferred | Catalog assets / glossary / lineage in lab | Later tool |
Installed Version, Config / Location, and Last Checked are currently blank in the live Sheet.