John Crowley’s Post

View profile for John Crowley, graphic

Full-Stack Developer. C#/.NET, Typescript, React, SQL

My preferred general-purpose web application stack at the moment (ask me tomorrow and you'll probably get a different answer though 😅): Frontend: Typescript + React SPA. Vite for setup, bundling, debugging, and building. React-query for server state, Zustand for client state. Zod for types and validation. Tailwind for styling. Still searching for a routing solution. I'm a bit wary of Next.js at the moment so unless I really need SSR I'm staying away until things feel more stable. Backend: HTTP REST API. I'm leaning towards Go although I also quite like doing backend in Typescript with Express or similar, or C# with .NET minimal API. I'm starting to dislike heavy ORMs and would rather just use a query builder and/or just the raw SQL client. Database: Postgres. I still just don't really "get" NoSQL. Any resources to help me "get" NoSQL would be appreciated. Infrastructure: AWS is confusing and their UI is ugly and clunky. The Azure portal UI is much more attractive but still just as confusing and it's full of bugs whereas AWS at least works reliably. Haven't worked much with GCP. All of my experiences with the various "Platform as a Service" providers has left me frustrated and wishing I had more direct access to my servers. I want to learn Docker and Kubernetes and Terraform and all that jazz but until then I guess I'm just manually admin-ing my own Linux servers on EC2. Miscellaneous tools I love: Git, GitHub, GitHub actions, Visual Studio Code. Discuss.

Benjamin Young

Software Engineer at Zynx Health

6mo

Raw sql is the way, in all of the codebases I've worked in that used an ORM I haven't seen a strong argument in favor of them. Typically the rationale is having more "searchable" code or wanting to avoid SQL altogether, both are nonsensical. If I hadn't grown tired of Reactisms for sure React is good but boy is it over engineered at this point. JSX is great though if someone prefers that over working with HTML+CSS+JS/TS

To view or add a comment, sign in

Explore topics