Daniel Rizk MD MS

@notreallydaniel.bsky.social

UMich Med Internal Medicine resident at UMaryland https://github.com/TidierOrg/TidierDB.jl

To borrow another example, taken from the `dbreg` README: github.com/grantmcdermo... Here I am running a fixed-effects regression on 180 million(!) row parquet dataset... and it completes **< 2 seconds**... on my laptop 🤯 This is powered by @duckdb.org under the hood. #rstats #econsky

Running dbreg::dbreg() on a full year of NYC taxi data... and it takes less than 2 seconds.

dbreg(
   tip_amount ~ fare_amount + passenger_count | month + vendor_name,
   path = "read_parquet('nyc-taxi/**/*.parquet')", ## path to hive-partitioned dataset
   vcov = "hc1"
)
#> [dbreg] Estimating compression ratio...
#> [dbreg] Data has 178,544,324 rows and 24 unique FE groups.
#> [dbreg] Using strategy: compress
#> [dbreg] Executing compress strategy SQL
#> 
#> Compressed OLS estimation, Dep. Var.: tip_amount 
#> Observations.: 178,544,324 (original) | 70,782 (compressed)
#> Standard Errors: Heteroskedasticity-robust
#>                  Estimate Std. Error  t value  Pr(>|t|)    
#> fare_amount      0.106744   0.000068 1564.742 < 2.2e-16 ***
#> passenger_count -0.029086   0.000106 -273.866 < 2.2e-16 ***
#> ---
#> Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Grant McDermott@gmcd.bsky.social · 12mo ago

Nice post by @jamesbrandecon.bsky.social on the scaling benefits that come from offloading your big regression jobs to a database. jamesbrandecon.github.io/blog/posts_h... (Showcasing some new-ish 📦 s that he, @apoorvalal.com & myself have been working on, but haven't really advertised yet.)

In my address to the JuliaCon community, I shared why it’s such an amazing time to be in healthcare - decades-long problems solved in a short time-frame by modern medicine and the whole gamut of basic to clinical research. But for this to work, the NIH needs to focus on science, not politics.

Bild

AI chatbots are increasingly being used by online users as fact-checking tools. But incorrect answers by ChatGPT and Grok are misleading users about the origin of photos showing National Guard troops, sent to Los Angeles during the recent unrest, sleeping on floors.