this post was submitted on 26 Jul 2024
3 points (100.0% liked)
Asklemmy
43403 readers
1211 users here now
A loosely moderated place to ask open-ended questions
Search asklemmy π
If your post meets the following criteria, it's welcome here!
- Open-ended question
- Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
- Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
- Not ad nauseam inducing: please make sure it is a question that would be new to most members
- An actual topic of discussion
Looking for support?
Looking for a community?
- Lemmyverse: community search
- sub.rehab: maps old subreddits to fediverse options, marks official as such
- [email protected]: a community for finding communities
~Icon~ ~by~ ~@Double_[email protected]~
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
If you have the time, I'd recommend trying it out. Creating a basic webpage isn't too hard, and you probably have the tools to get started on your computer already (you can do it with just Notepad and view it in any web browser! Although I would recommend downloading a free proper code editor such as VS Code).
Bruh, Iβm talking about a crud app. Possibly running on the shiny framework. Itβs not going to be trivial.
Oh, okay. Still more doable than you might think, but of course not trivial. Good luck!
Let me ask, maybe you know: say I want to build a finance app that basically crunches a lot of data accessed from a DB, does some pretty intricate subsetting of the data, and produces Excel reports (XML). I currently do this with about 1300 lines of R code and a SQLite DB. Pretty lean and easy to use (was a bitch to write, tho, really stretched my understanding of lexical scoping and functional programming). If I wanted to webify this, the main challenge that I think I face is finding a framework that allows me to do all that nitty gritty data subsetting and summarizing - this is where R is really excellent, more flexible and expressive than SQL. What framework, if any, might you recommend? What kind of stack would be good for a beginner?
Apologies for the wait!
Most good libraries for interacting with DBs and Excel documents are written for the backend, so you'll probably want to use Node with a simple web server like Express to serve pages, and do your heavy calculations, report generation, and DB stuff on the Node server. Making a server seems complex but Express is quite easy-- you can get a functional web server in like 10 lines of code.
As for what framework would be good to use for the actual calculations, unfortunately I don't have any recommendations. Generally I find that JS has enough by default to do decently complex grouping, summarizing, subsetting, calculating, etc. operations. You'll probably want to use the "new" (now pretty old) array methods Map and Reduce, and new stuff like groupBy could be helpful. If you have any specific questions I should be able to answer them.