oops #til to use #duckdb to query a CSV, generate date ranges, use windowing functions to backfill data and pivot functions to make data that you can easily graph in a spreadsheet.

based upon;
- average #solar radiation distribution per month for my area
- My kwh generation and usage for last month (which #homeassistant gives as data events, not hourly or daily reporting)
- The KWHs I've spent on AC that I expect to increase over the summer

I'm operating at 85% of my generation capacity 🙌

🎸 Tune in to Jelte Fennema-Nio's (@jeltef) talk during #PosetteConf Livestream 2️⃣ to learn about the new pg_duckdb open-source #Postgres extension that makes it easy to run analytics queries straight from within Postgres.🦆

https://posetteconf.com

#postgresql #databases #duckdb

I know jupyter notebook's exist but duckdb's gui mode's notebooks should have graphs, it would be killer.

I can just run #duckdb it's a single binary not a python journey.