Hex08

What I mean really is: when working with relational databases, and you have complex constraints to ensure (not trivial things like notnull but something like: "two tables away" uniqueness, etc..), do you like filling it with tricks using PKs/FKs/UNIQUEs to ensure integrity or do you prefer writing some code that will get executed as you application boots up, that ensures that all the more complex requirements are met?

I've been distro hopping for weeks, both on my desktop and laptop, in hope to find some magic distro that would just work out of the box like mainstream OSes like Windows and macOS do. Maybe not the best strategy but honestly I don't really wish to spend hours to get the audio working just so I can move on and go fix the next issue.

I really want to use Linux for work so bad but all the issues I've encountered are setting me off:

1) Audio not working or distorted playback or recording 2) Not smooth animations and everything feeling jittery and laggy in general 3) Low battery life 4) Running jobs preventing the system shutdown for whathever reason on a fresh install

Also I've had problems with files management (eg: I once needed to copy a 1GB file to my USB drive, KDE showed an instant 100% progress but hanged there for minutes before I got frustrated and gave up) and window managment (eg: some programs are not maximed when I click on their icon in kde).

I've done everything in dual boot alongside Windows and, to be honest, booting back to Windows after trying a new distro made the difference really clear, Windows works much better out of the box. This is unfortunate because Windows will never provide the same development workspace that Linux can. But right now, it seems like the best solution is running an Ubuntu server VM.

Has anyone else experienced the same problems?

Some people (including myself) want or need to run Windows as their main OS, but I'm a strong believer that some things just work best or are easier on Linux: docker, databases, web servers, etc...

I'm in the process of revamping my setup to improve my "linux on windows" experience and I'm not yet completely satisfied with any of the setups I've tried which include:

- running a vm on vmware: it works alright and it's the one I've used so far. it's not a seamless integration though, you have to spin up the vm each time you need it. also unity mode has been discontinued

- running a vm on hyperv: Ubuntu Desktop runs awfully bad in terms of graphics, I'm now currently trying out Ubuntu Server and I'm planning to use it via ssh. I'll see how that goes

- WSL: is very early stages IMO, most of the things might work but I've noticed daemons generally don't work. I've tried docker and postgres and they both don't work. I need Docker really bad. Some people found a fix for this but docker-compose is still not working. WSL looks like the worst choice so far.

So I was just curious to know if there's someone out there that is doing this kind of linux-on-windows integration and how they set-up their environment.