this post was submitted on 06 Sep 2026
324 points (95.8% liked)
Technology
87877 readers
2730 users here now
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related news or articles.
- Be excellent to each other!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
- Check for duplicates before posting, duplicates may be removed
- Accounts 7 days and younger will have their posts automatically removed.
Approved Bots
founded 3 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Teams, Visual Studio, VS Code are trash, they leak memory like no other
WSL2 is hilarious, just run Linux/UNIX?
SQL Server and SSMS are trash
I run Docker quite a bit but if you’re actually writing the containers efficiently it shouldn’t be sucking down ~64GB of RAM. But I’ve also seen how people shovel things like Java, log rotation, etc. into those containers because they act like it’s a 1994 VPS.
Not everyone does the same development process as you.
And I’m sure we all work at places that allow us to change the entire tech stack and switch away from teams /s
Be realistic, there are many reasons you need all of these things and more. Why are you trashing other people so much?
This is on my work PC, I can't just switch there (:
For .NET development Visual Studio and Rider are the only decent options, everything else is "trash". Teams is the company communication tool (besides Outlook).
And we run SQL Servers in Azure, PostgreSQL would cost the same (but I'd love to switch to it myself).
You don't need 64 GB of RAM, I was happy with 48 GB too, but the headroom is nice. 32 GB would be borderline for my work though, especially as I often have two heavy backend services open (2x Visual Studio) plus a Python project for automated tests (VS Code).
VS has an option that I think was called Launch With, or something like that, so you can run two services together.
Aspire also let's you do this more easily.
Just don't use Teams. There's Zulip, Mattermost, Rocket.Chat, even Matrix and XMPP.
In Windows when you run a docker container a full Linux VM is run, so it uses gigabytes of memory
I got the same impression. That dev work isn’t power hungry, just the stack is. But if IT controls the stack, that explains some of the dilemma.
Why an RDBMS on the local though? Testing shit doesn’t make sense to name it as a regular piece of software.
When you work on backend services you have a local DB running 24/7. Changes don't go onto the actual dev environment until locally tested, or you might just break things for 50 other people.
I always build against a local DB?
For our desktop / LAN software the DB will always be local.
For web, it's easier since I'm likely to burn the DB down over and over during early development / prototyping. But I'm not using cloud hosted DB even in production, and don't expose Postgres outside the DB server, so I find it easier to work on this way.
EDIT: I also think that a default installation of VS includes SQL Server. I don't use it, so always have to adjust the installation and remove all of those bits, but I also have complete control of my environment. I could see an IT department just doing a stock VS installation with the required workloads.
Yeah sorry, that’s what I meant by testing stuff. I suppose if you’re always testing things in the DB, it makes sense. Usually in my case, I would spin up a Postgres instance only for the week or so that I’m developing and testing with it. Eventually I push to cloud though. I don’t keep it running locally unless I’m testing a change. But I’m not testing changes often… I wouldn’t consider it part of my stack for that reason. I might run a local RDBMS a few times a year.
On the other hand, I will use SQLite or DuckDB all the time for local work. Not sure if those count as RDBMS, they are serverless.
I won’t never consider a local RDBMS as having stable data storage, so it falls into a strictly “testing” category for me, I guess “development and testing” is more accurate.
I could totally see that for the web stuff where I only make changes a couple of times a year. Usually when working on those I just delete the local DB before I start to keep it clean, but spinning up a new copy would be more efficient.
For our desktop apps / server Postgres is always installed locally on the machine, so keeping it there mirrors "production".
I spent most of my time working on those apps and services, or working on the Android client (or both at the same time when a feature requires that both change), and often on a copy of actual customer data as we do a lot of custom work for clients.
Yeah, that’s exactly the process- while you are building out a feature it hits a local DB and once it’s ready to integrate you push it to a shared environment.
If you break dev, coworkers be mad