- Published on
Transforming raw data into something that's more meaningful - how I optimized the app via lazily-evaluated vectorized polars operations and by pushing the filtering up in the data pipeline
Sql
All Posts
- tech (37)
- thoughts (25)
- til (24)
- ntit (21)
- featured (21)
- photos (19)
- tcwotd (19)
- list (18)
- raleigh (16)
- hokkien (14)
- data (14)
- theatre (11)
- options (11)
- very-random (10)
- languages (10)
- meta (9)
- aisb (8)
- plotly (8)
- wip (8)
- music (7)
- fashion (7)
- data-visualization (7)
- projects (7)
- announcement (7)
- questdb (6)
- videos (6)
- pet-project (6)
- review (5)
- dance (5)
- trading (5)
- geography (5)
- finance (5)
- animals (5)
- interlinking (5)
- 20240805 (4)
- amazingshowtw (4)
- market (4)
- tools (4)
- musuem (4)
- vol-surface (4)
- menswear (4)
- memory (4)
- funny (4)
- substack (4)
- garments (3)
- transportation (3)
- automation (3)
- untitled-sections (3)
- relationships (3)
- cloudflare (3)
- story (3)
- command-line (3)
- psychology (3)
- play (3)
- llm (3)
- government (3)
- french (3)
- polars (3)
- ncsu (3)
- medicine (3)
- social-media (3)
- health (3)
- food (3)
- forex (3)
- movies-tv (3)
- made-by-llms (3)
- cities (2)
- cars (2)
- opinion (2)
- communication (2)
- tv-series (2)
- black-mirror (2)
- shanghai (2)
- futures (2)
- visualization (2)
sql (2)
- performance (2)
- poetry (2)
- learning (2)
- data-analysis (2)
- investing (2)
- mandarin (2)
- bond (2)
- life (2)
- sports (2)
- ocean (2)
- growth (2)
- neologisms (2)
- culture (2)
- history (2)
- persia (2)
- prompt-engineering (2)
- spot-vol-correlation (2)
- china (2)
- books (2)
- diet (2)
- linux (2)
- distro (2)
- microfeed (2)
- web-publishing (2)
- github (2)
- gradio (2)
- python (2)
- outfits (2)
- computing (1)
- urban-planning (1)
- anxiety (1)
- trade-analysis (1)
- tv (1)
- japanese (1)
- journal (1)
- transformation (1)
- bunny (1)
- database (1)
- stream-processing (1)
- task-scheduling (1)
- redpanda (1)
- prefect (1)
- sqlite (1)
- slurm (1)
- hpc (1)
- exploration (1)
- failure (1)
- horror-stories (1)
- datasette (1)
- macos (1)
- sysadmin (1)
- hike (1)
- house-md (1)
- web (1)
- tax (1)
- mistakes (1)
- empty (1)
- charts (1)
- vertical-spreads (1)
- dash (1)
- movies (1)
- refactoring (1)
- mountains (1)
- ncmh (1)
- vintage (1)
- ncsu-csc (1)
- running (1)
- brain-washing (1)
- metal (1)
- songs (1)
- youtube (1)
- video-essay (1)
- video-review (1)
- philosophy (1)
- web-app (1)
- scirpt-reading (1)
- people (1)
- people-skills (1)
- perplexity (1)
- country (1)
- sensations (1)
- puclic-health (1)
- management (1)
- technical-analysis (1)
- volatility (1)
- rick-n-morty (1)
- therapy (1)
- fasion (1)
- dating (1)
- festival (1)
- allergy (1)
- sugar (1)
- tooling (1)
- greeks (1)
- security (1)
- darknet-diaries (1)
- cybercrime (1)
- horrow-stories (1)
- novel (1)
- sci-fi (1)
- unicode (1)
- danish (1)
- cheese (1)
- considered-harmful (1)
- skincare (1)
- book (1)
- english (1)
- plants (1)
- club (1)
- sex (1)
- anime (1)
- economy (1)
- wall-of-shame (1)
- payment (1)
- grocery-stores (1)
- proxy (1)
- items (1)
- quality-of-life (1)
- quotes (1)
- censorship (1)
- website (1)
- static-site-generator (1)
- politics (1)
- migrations (1)
- himi (1)
- tariff (1)
- better-call-saul (1)
- fuck-cars (1)
- cloudflare-workers (1)
- openai (1)
- gpts (1)
- rts (1)
- me (1)
- gallery (1)
- law (1)
- ballroom (1)
- dj (1)
- board-games (1)
- film-making (1)
- measurements (1)
- lock-picking (1)
- city (1)
- outdoors (1)
- tailoring (1)
- public-speaking (1)
- toastmasters (1)
- matplotlib (1)
- graph (1)
- easygraph (1)
- multileg (1)
- fudan (1)
- cheerleading (1)
- college-life (1)
- volunteering (1)
- tables (1)
- productivity (1)
- clothing (1)
- go (1)
- taiwan (1)
- slang (1)
- planning (1)
- fomo (1)
- tech-trivia (1)
- event (1)
- astronomy (1)
- etf (1)
- egypt (1)
- hardware (1)
- personal-finance (1)
- acting (1)
- patterns (1)
- methodology (1)
- llm-assisted-posts (1)
- hack (1)
- derivatives (1)
- securities (1)
- security-regulations (1)
- canada-geese (1)
- trains (1)
- what-i-read (1)
- sherryning (1)
- detention (1)
- ncma (1)
- Published on
AKA "How to grab the best GPU instance in a slurm-managed HPC cluster faster than anyone else"