DaMango
Explore posts from serversTTCTheo's Typesafe Cult
•Created by DaMango on 11/4/2023 in #questions
GraphQl and NextJS 13+ for multiple, concurrent/parallel DB queries?
I know this could be a problem with architecture/design, but how would you most efficiently query (read-only) 15-20 MySQL DBs at the same time?
There's a legacy internal tool at work they apparently want me to remake and they explained this is what they're doing with the current version. It can take very long to perform queries related to a single user search, which will usually query 15-20 databases that are on-prem. The internal tool is also hosted with on-prem infrastructure via perl, CGI and an nginx or Apache server (very old, I know....). Only about 30 people will be using this tool. The app itself will only perform read queries, and tracks the history, status and details of their web service API calls throughout all their environments (5 environments with 3-4 DB for each). They suggested graphQL for the queries but I'm not sure if that would actually make it faster. Any ideas?
The architect on my team said to use NextJS or dotnet, whatever I'm more comfortable with for the UI, and gave no acceptance criteria or any sort of official writeup/ticket. Not sure if this is just due to them being busy but they said "we want to see how well you work like this". I'm not sure if these tools would actually solve the problem.
1 replies
TTCTheo's Typesafe Cult
•Created by DaMango on 9/26/2023 in #questions
What are the best CI/CD tools to use?
I know ci/cd might seem a little bloated, but my siblings and are all working together on multiple side projects. I would like to say that these are more serious than typical tinder/twitter app clones and are web apps or projects we intend to make some profit off of. That being said, we are trying to incorporate more enterprise level practices and tools in terms of deployment and scaling. A lot of what we are doing is obviously overkill and not needed, but I think it can help me learn a lot about managing and building larger projects.
I've been using and learning Jenkins but a lot of other people i've talked to on other discords/situations always shake their heads when I bring it up and say that Jenkins is waaaay outdated and a pain to work with. I've heard (from my brother who did contracting work for) doordash and other companies use Jenkins servers where they run thousands of builds a day, but I can see this being due to them being tied to legacy infrastructure. I personally feel Jenkins is mostly fine other than potentially a few security issues and some configuration hell, but I haven't worked intensely with other CI/CD tools. It would be nice, interesting and hopefully useful to learn some common CI/CD tools that won't be super dated, but are still flexible and configurable.
Would any of you mind describing an ideal, scalable and enterprise level ci/cd pipeline you would use for (deploying, building, testing...) webapps and any other sort of large scale project? I know most of this may depend on the nature of the project and situation itself, but I am looking for pros and cons, as well as common practices/tools.
8 replies