I doubt if I am going to make it through 2026 without more efficient memory stack pointers.
Well, you may not want to spend the money, but I am very happy with my Mac Studio M2 Ultra I bought in 2023. So are most users (although now the latest version is M3 Ultra). In my case (may not apply to you), I would get it with 2Tb internal instead of 1Tb internal, because some things have to go on the internal drive. You can spend time to go in and and trash old caches and trash files, but it's a little time consuming from time to time, but I get by. I have 64G of memory and I only max out on that if I am doings some gigantic complex join on say all the houses in a county, or doing neural networks. Still building my system is at times a bit slow and I plan on buying the new M5 Ultra when it comes out (I guess this year) and will probably get that with 96-256G of RAM).
It's mostly the Unified Memory unique to Apple, the large bandwidth, plus silent operation and low power consumption that makes it competitive when it comes to AI. Well, that's on the hardware side. Also, a lot of MacOS software is very good and solid. Oh, and never forget their Time Machine, which is always saving the day for me when Claude Code (the Genuis/Idiot) suggests deleting some enormous data base I have with all the MLS data from counties around the SF Bay Area, - or some folder with Terabytes of data - or something else. I have to baby it like a child, scold it like child, and put guardrails around it. Yet, it will still manage to delete something important if I drop my guard for a second and the click approval without closely reading what it intends to do. And it can never be counted on to remember the right way to do something, without forcing it to keep written notes in Markdown files, and then crossing your fingers that it has reread the Markdown notes and not compressed them out of existence. Still it's smooth operation for me. Much better than the crashing Windows system.
I also use Synology 100Tb drive for large downloads, such as MLS photos. MLS Photos - if you are collecting MLS data for multiple counties in California going back 25 years, we are talking many Terabytes - then you will want a backup. Also, of course I have MLS property data for a number of very large counties in PostgreSQL/PostGIS databases. PostgreSQL is free of course. And with PostGIS - nothing can touch it. And I download from PostgreSQL to SQLite to create multiple snapshots for each project/appraisal. I have a number of high speed SSDs connecting over Thunderbolt 4, plus some cheaper Terrabyte hard drives. The main Apple Apps I use are: Finder, ForkLift,DaisyDisk,CleanMyMac,Obsidian,Proton Mail, Adobe Creative Suite, Microsoft VS Code, Microsoft 365 Office, Libre Office, DBeaver, DB Browser for SQLite, QGIS, OrbStack, Postico 2, Micro (text editor), Terminal,RStudio, R, Claude Code, ChatGPT, Grok, Little Snitch, Repo Prompt, Photo Mechanic, Neo Finder, ....
Note: If you are considering migrating from MS SQL Server to PostgreSQL, you really need to move from Pascal Case (BestBuy) to Snake Case (best_buy). The other option is embedding all table and column names in quotes ("BestBuy") - which is not worth the trouble. Take my word, Snake Case in the long run, is the way to go.
And when the day comes that I get my new Mac Studio M5 Ultra, you can be sure I will split Docker containers between the two machines and then manage them with Kubernetes.