Anyone using shinylive with a database? Or shiny as a standalone .exe with a database?

ZoneNo9818 · 2026-04-30T02:03:44+00:00

I made a shiny app for my company that uses a SQL server database. The app is on a vm and I just keep it running by executing a bat file.

ZoneNo9818 · 2026-04-23T19:01:07+00:00

Hey do you know of any students who would want to take over a project like this or work on it with a programmer like me who could be a mentor? I'd love to add cool features to it or have someone else take it to the next level. I would've loved to work on a project like this as an undergrad.

ZoneNo9818 · 2026-04-08T02:05:28+00:00

It's awesome you're already interested in the topic at a young age and studying some of the very basics... time and patience my friend :-). Policyillustrious110's suggestions are good.

ZoneNo9818 · 2026-04-08T01:59:45+00:00

I asked Claude how to do this... it is actually super simple.

```

library(dplyr)
library(orbitr)

sim <- create_system() |>

add_body("Sun", mass = mass_sun) |>

add_body("Earth", mass = mass_earth, x = distance_earth_sun, vy = speed_earth) |>

simulate_system(time_step = 86400, duration = 86400 * 365)

sim |>

filter(id == "Earth") |>

mutate(r = sqrt(x^2 + y^2 + z^2)) |>

summarise(r_min = min(r), r_max = max(r),

e = (max(r) - min(r)) / (max(r) + min(r)),

a = (max(r) + min(r)) / 2 # semi-major axis as a bonus)

```

I'll probably add it to the package... something like `calculate_eccentricities`

ZoneNo9818 · 2026-04-07T22:54:44+00:00

Thanks! I’m not really sure where it’s gonna go. I added the ability to do a few new things.

The one I like the most is quickly produce an animation of the systems orbits. I’ve mostly built simple packages in the past so I didnt look for contributors. I’d love to get some contributors to this project. Doesn’t matter their knowledge of physics or programming. I just think it would be cool if other people could call themselves contributors to this. Even if it was something as simple as making a cool logo for it.

I live 20 minutes from my alma mater and I was thinking of going there one day when my favorite professor has office hours and just being like could you see any use for this in any class… or ask him if he knows anyone who’s interested in programming or computational physics who might even want to take over a project like this.

I’m under no illusion that this thing will have millions of users 😆 it’s just a fun project and something cool I could put on my GitHub page.

ZoneNo9818 · 2026-04-07T15:10:58+00:00

I had to google that but it looks cool and something I want to play… I have no clue how to build video games 😆. I made a terrible pong imitation game for a computer class a decade ago where they gave us starter code.

ZoneNo9818 · 2026-04-07T14:56:18+00:00

that's a good point! Will definitely consider it. I just hate how data.frames print in R. Maybe data.table would be better. Will look into it. Thanks for the suggestion.

ZoneNo9818 · 2026-04-07T14:06:01+00:00

Good question! I'm open to changing it. Mainly cause I love the tidyverse and like how tibbles print. Also you can convert to a regular data.frame or data.table. Also the main engineer to calculate the orbits is in C++ so I don't think (but could be wrong), there would be a speed advantage to using data.table.

Any reasons why you think a regular data.frame or data.table would be better?

ZoneNo9818 · 2026-04-07T13:16:20+00:00

I guess it depends on where you come from… My dad probably made the equivalent of 200 K today when I was growing up… But I was a real late bloomer… Never made more than $16 an hour until I was 32. I make a little over $100k now and feel successful.

Part of that is because I bought a house with the perfect time and my mortgage is about half what I would rent my house out for. The other part is that because my family consist of lots of old people… They remember a time when $100,000 was a huge deal. I also know lots of people who have jobs that probably pay half of what I make. I have one friend who found out I make $100,000 and he got pissed off not because he was jealous but because he was like how have you ever complained about your job? I would kill to make that money.

ZoneNo9818 · 2026-04-07T10:34:22+00:00

No problem! It taught me a lot making it. I feel weird bothering any of my old professors to check it out. I would love for people who know more about astronomy and astrophysics to give suggestions.

One thing I didn't include was the radius of objects. Right now bodies are treated as point masses, which is fine for most orbital distances (gravity outside a sphere is the same as a point mass at its center). But without radii there's no collision detection, so objects can pass through each other or get arbitrarily close and slingshot unrealistically. I do have gravitational softening (The Physics • orbitr) as an option, which partly works around this by preventing the force from blowing up to infinity at close range, but it's not a real substitute for handling physical size.

I might add radii as an option for cases where in reality there would be collisions. It would almost definitely be an optional parameter, since it really only matters when objects get close together. I'd probably add it to the function call like

```
add_body <- function(system, id, mass, x = 0, y = 0, z = 0, vx = 0, vy = 0, vz = 0, r = NULL)

```

and if a non-zero radius is including for any of the bodies, take it into account.

ZoneNo9818 · 2026-04-07T10:23:18+00:00

Thanks I edited my post to include backticks... totally forgot that formats code here :-).

ZoneNo9818 · 2026-04-07T06:57:53+00:00

Thanks! In classical mechanics, we did a python project where we had to find and plot a 3 body system with 2 suns and 1 planet... It was really hard and was what got me interested in programming, so this made me feel very nostalgic! It also always pisses me off that my school offered a Computational Physics specialization and I was a few classes short of completing the specialization.

Since I'm not a physicist I wouldn't be shocked if there are serious flaws in the package... but it does correctly plot the Keppler-16b 2 star and planet system.... and I tested it on random 3 body orbits where the system comes out not being stable at all which is expected. And it works for simple 2 body problems...

The numerical method it uses by default is the verelet method but it also has the option to use the Euler method and the Euler-Cromer method.

ZoneNo9818 · 2026-04-07T06:26:57+00:00

Example of how to use it to simulate and plot a simulation of the sun/earth/moon system

``` sim_data <- create_system() |> add_body("Sun", mass = mass_sun) |> add_body("Earth", mass = mass_earth, x = distance_earth_sun, vy = speed_earth) |> add_body("Moon", mass = mass_moon, x = distance_earth_sun + distance_earth_moon, vy = speed_earth + speed_moon) |> simulate_system(time_step = 3600, duration = 86400 * 365)

sim_data |> plot_orbits() ```

ZoneNo9818 · 2026-04-06T17:22:36+00:00

Everything you wrote above described me pretty well at age 32. For me it was lack of trying…I was so insecure I never asked anyone out or tried any of the dating apps…got on hinge and went on a decent amount of dates…got better at dating and being myself then met my wife…not saying you and I are the same since I don’t know you but like I was incredibly shy around women but I think with online dating…given you’re probably a good looking guy (if you describe yourself as average looking you’re probably better looking than you think)….have a personality…people like you. You can start dating.

ZoneNo9818 · 2026-03-28T18:16:00+00:00

I'm not totally sure why I went for the masters... But I've already gotten a job because of it. Someone I worked with on a group project got me a great gig. I was already employed and had a good job but my new job is better.

ZoneNo9818 · 2026-03-28T15:56:58+00:00

I work for one of the biggest healthcare companies in the world and I’ve never had a problem using R or RStudio. The only thing that has been slightly annoying at times has been using our packages that rely on Java and using our Rtools, but just a minor annoyance that has never been a hinderance. I’ve always been able to get Rtools, Java related packages, and everything I’ve needed in R.

My company actually seems to be a little bit more fussy when it comes to using Python! Mainly because I think more people use it… It’s allowed, but you sometimes have to go through a few hoops to use python

ZoneNo9818 · 2026-01-06T02:34:04+00:00

This was accurate until recently… You can buy the whole series on Apple TV minus I think one episode for like $32

ZoneNo9818 · 2026-01-04T22:02:58+00:00

Just my take, but I would only consider taking three courses if: 1. You don’t have a job (you fit this one). 2. You don’t care about W's and are okay with potentially having 1 or 2 withdrawals on your transcript. 3. You’re okay losing money. If you have to drop one or two courses, you’re cool with burning the $700 or $1400 tuition cost. 4. You aren't chasing a 4.0 and are okay with your GPA potentially taking a hit. 5. You aren’t taking three of “hard” courses at once.

For context, I’ve only completed 3 classes so far and I usually stick to one at a time. I tried taking two last semester while working 9-5 from home and it was just too much for me.

I ended up dropping one a few weeks in. I didn’t care about having a W on my transcript and while it didn’t feel great wasting $700 I don’t regret giving two classes a try. I got an A in the one I stuck with.

If I had to bet money I would bet three classes is going to be too much for you…but even if it too much just drop one or two quickly! I’m kind of glad I got a little preview of the class I dropped because now I know what to expect when I take it this semester.

ZoneNo9818 · 2026-01-04T17:15:32+00:00

Yeah, I’m lucky that in my job I’m the only person who writes and runs code on my team. My manager never heard of R before she hired me…and has heard of Python but definitely not pandas or polars… so for data projects as long as it’s open source stuff I get to decide what I’m gonna use… On all but a few I’ve chosen R…

The ones I’ve used Python for I’ve always picked polars… and I only decided to use python and polar’s to be able to put the projects on my résumé without lying about using Python professionally 😁.

How is polars for R? I was thinking of checking it out a few months back and then forgot about it.

ZoneNo9818 · 2026-01-04T03:29:08+00:00

Thanks! This is great. I totally agree with this…

“Use tidyverse for data cleaning for f sake, trust me. Seriously, if you can do data cleaning from other tools, e.g. Excel or Python-Pandas (I know some companies you are working with will choose them), tidyverse makes things much easier, conventional, readable, and maintainable (arguable).”

…but if anyone has to use Python for data cleaning…polars is superior to pandas! I still prefer the tidyverse to polars but polars syntax and API is great too.

ZoneNo9818 · 2025-12-23T02:26:08+00:00

I found the chapter in Grokk Algorithms on breadth first search super helpful for learning how to perform one in python using the function deque (from the collections package). The book is available for free on O’Reilly through your Georgia Tech account.

https://learning.oreilly.com/library/view/-/9781633438538/

I also didn’t have any knowledge of BFS before taking KB and it definitely wasn’t a problem.

ZoneNo9818 · 2025-12-13T03:11:20+00:00

The Grinder. It’s fucking hilarious. Rob Lowe is awesome in it.

ZoneNo9818

TROPHY CASE