cpilat97

🙈 It's 11 PM. I'm trying to explain my sister in law why I'm so excited: I managed to run a little R shiny app INSIDE a quarto report rendered _statically_ using Github: holtzy.github.io/quarto-tricks/… 🎉 Now she believes I'm a weirdo 🙂

Post your favorite #rstats blog sites below please :) I want to do something cool with the entries:

@JosiahParry Fwiw my use cases for promises have been allowing users to execute a long running SQL query without clogging up the session for other users. I've been eyeing the new ExtendedTasks features in Shiny to see if that can supplement what I need to do and not use promises

@JosiahParry I use promises in my role.... And I still get confused whenever I use it. The docs are pretty rough tbh, idk if this is helpful but This was the last article I read that I remember having a simple example that was helpful hypebright.nl/index.php/en/2…

@JosiahParry Essentially what my boss did a few years back where I work now. Now we have many teams using R, have internal R teaching sessions, and build really cool things really quickly. He solved problems, now we have 40+ R users from beginning to advanced.

@JosiahParry Clock is really underrated and everytime I see a duckdb post it's just more awesome stuff they're adding in

@tiddlydump @JosiahParry @tjmahr @RyanPlain fwiw though, i was using duckdb + dbplyr :) and slacking my colleague every little nugget of duckdb info i found on this journey haha i was loving it more and more regardless the rstudio crashes after hitting 25gbs of ram usage along the way 😄

@tiddlydump @JosiahParry @tjmahr @RyanPlain and here is where i read more about getting it to spill to disk - #spilling-to-disk" target="_blank" rel="nofollow noopener">duckdb.org/docs/guides/pe… but I felt like i had to do a lot of docs reading (which is fine!) to get to that point and get my process to work.

@tjmahr @JosiahParry @RyanPlain @tiddlydump When I updated the connection to the screenshot it ran fine and didn't crash which I was learning the hard way lol

@tjmahr @JosiahParry @RyanPlain @tiddlydump Something I wish was more clear in docs - the default dbcConnect(duckdb()) will still utilize RAM when running expensive calls... I found out this week using this connection to force it to spill onto disk and cap the memory. I needed a distinct over 500million rows

@beeonaposy Warwick NY is nice - in Orange County, has a nice town center (coffee shops, restaurants, some boutique shops) schools aren't bad, but close enough to the city that there are daily commuters. Chester ny is nice as well but not as walkable

I’m interested in learning more about towns outside of NYC (in NY or CT) as a potential move option. Hoping for good schools and some walkability (like coffee shops or restaurants). Longer commute is fine (I’m remote). Anyone have suggestions on places to check out?

@CFlensburg @rstatstweet This posit/rstudio article might be of some help. I've done a similar setup for when I share an RProject / common parent folder. (though we generally turn the rdata option off to limit that) support.posit.co/hc/en-us/artic…

What is best practice for multiple people working in R in the same directory on a shared space? In particular avoiding loading each others .RData. #RStats I lost some time today to default-loading a colleagues session, meaning I always started with the same random seed.

@zevross @rstats_tweets I've written something like that for myself.... Might not be the most elegant of code but hey it works lol I have it mapped to my Ctrl + alt +v shortcut. github.com/cpilat97/fixFi…

Way back, when I used a Windows machine, I had a utility that automatically converted copied path backslashes to forward slashes for #rstats. Does something like that still exist? Eg right click on a file, copy the path and when pasted backslashes are magically forward slashes?

@JulienMouchnino @rstatstweet I haven't used this, but they have a blog post on their website for something like this - posit.co/blog/real-time…

Is there a tool such as Posit Cloud that allows two people to code on the same file at the same time❓ Does Posit Cloud allows this by the way?🤔 #rstats #rstudio

@sharoz I see this all the time now that I've been using Windows more, but (in general) RStudio doesn't become unresponsive for me when I start to move my mouse. Never saw it on my MacBook. I thought I was the only one seeing this because it'd disappear before I got screenshots

I occasionally have to restart #RStudio because it becomes unresponsive and a black square appears. I just lost analysis results that took all night to run. This has happened over many years across multiple computers (all PCs). It's never predictable. Anyone else?

@dgkeyes update original to have it say "done" or something like that? Depending on how long it takes report to render, could set CRON schedule to check every 10 min, 30, etc...

@dgkeyes Might be clunky - but use a CRON schedule to run 1/min and check a googlesheet. Have them sub a google form with the name to that sheet. When script runs, if it sees a new entry, have it render/source the other script that emails them w/ report? then update the original sheet

Anyone ever set up a way for a non-R user to trigger an R script to run? I'm thinking something like the non-R user submitting a form that triggers a GitHub Action that sends them an email with a report. #rstats

@tanya_shapiro as interviewee: If I were to start today, what are the short and medium (~6ish month) term goals I'd be working on. Gives me a sense of the type of work i'd be engaging in and their priorities of that moment.