• 1 Post
  • 46 Comments
Joined 2 years ago
cake
Cake day: September 6th, 2023

help-circle

  • I use an M1 (Pro 14" 8 core 16GB) with Asahi. It’s extremely usable. WiFi is solid. Sound is solid. I never considered keyboard to be an issue… Its not. Things like brigtheness buttons still work. I have a tonne of USB devices and none of them had issues. I don’t think the fingerprint reader or the built-in camera work but I can test them if that’s a sticking point.

    I very much like it and it’s easy to switch into OSX if you’re so inclined. I do for photo work. I know there are alternatives. I’m working on it.

    The things I would warn about:

    1. in my experience, battery life is worse. Maybe around 1/2 of what OSX gets. With my overall battery health around 80%, I think I’m getting 4 hours in Asahi.

    2. this could actually be a skill issue (Linux newb) but I’ve had trouble installing certain packages in Fedora and Python and I assume it has to do with the M1 being ARM-based

    Edit: remembered some things. As of the newest version, gaming is much MUCH better. I think you can do 720p or on medium or 1080p low with decent frames by just using proton on Stream. That’s wild to me.

    In case you didn’t know, Asahi is the Linux distro designed for Apple Silicon Macs. Its based on Fedora with KDE as the desktop so it has a solid backens and a familiar but customizable interface. Its extremely simple to install and is beginner friendly.

    Reply if you need more info!


  • Microsoft is a collection of fiefdoms, each led by a Lord (Product Manager) who drive projects which have two possible motivations: 1) promotion 2) bonus. Quality is not a factor and hasn’t been for decades. Cohesion? No. The lords sometimes fight amongst themselves. They serve the line go up. Everything is line go up. There is no bottom to the products. Line must go up


  • afk_strats@lemmy.worldtoProgramming@programming.devdatabase greenhorn
    link
    fedilink
    English
    arrow-up
    6
    ·
    edit-2
    2 months ago

    While I get that SO can be monstrously unhelpful, database optimization is a whole profession so I think we need a bit more to help

    A few directions we could go here: Post your SQL query. This could be a structure or query issue. Best case, we could do some query optimization. Also, have you looked into indexing?

    Where are your bottlenecks coming from? Is your server desined for a I/O intensive workload like databases. Sequential read speed is not a good metrix.

    What about concurrency? If this is is super read/write intensive, optimization could depend on where data is written while you’re reading




  • Will my ability to play games be significantly affected compared to Windows?

    No. Thanks to Steam Deck, most popular windows games also work on Linux. See https://www.protondb.com/ for a complete list of 18,000 titles… Someone already mentioned that kernel level anti-cheat is the big, obvious blocker.

    Can I mod games as freely and as easily as I do on Windows?

    Im guessing that most moders target Windows users therefore, don’t think mods would be AS easy. Not saying modding wouldn’t exist or work at all. Edit: see sp3ctr4l’s reply to this comment. They know more than me

    If a program has no Linux version, is it unusable, or are there workarounds?

    There are workarounds. Linux has some great alternative software to popular paid stuff. See LibreOffice or Krita.

    There are also more advanced options to run Windows apps under Linux, see Wine or Virtual Machines

    Can Linux run programs that rely on frameworks like .NET or other Windows-specific libraries?

    Yes. Similar to the above answer/ similar to aforementioned Proton. For .NET specifically, there is a Linux runtime.

    How do OS updates work in Linux? Is there a “Linux Update” program like what Windows has?

    This can depend a lot on what distribution you’re running, but definitely, there are ones with easy buttons for whole-system updates.

    How does digital security work on Linux? Is it more vulnerable due to being open source? Is there integrated antivirus software, or will I have to source that myself?

    It’s different and probably overall better than windows. Most distros are much better out of the box than windows.

    Open source is ususually a security advantage because (long story short) security mistakes can be caught by more people.

    I don’t have a good answer for you on anti virus. I am very privacy and security conscious and I dont use one on linux. My personal opinion is that you don’t need one and shouldn’t need one if you’re not downloading sketch stuff.

    Are GPU drivers reliable on Linux?

    Totally. GPU drivers are much, much better than they used to be.

    Can Linux (in the case of a misconfiguration or serious failure) potentially damage hardware?

    Theoretically. You would have to try really hard, but for normal use, no. More likely, you could lose data or access to the system if you misconfigure stuff (just like with Windows)

    Distro recommendations. My personal opinions, don’t flame me.

    • Bazzite. hard to mess up, gamer focused, super simple updates, and targeted support for gamer hardware. Feels like a cross between steam deck and windows. Less support for tinkering but if you never want to touch the terminal, this is my choice.

    • Pop!OS. Simplified Linux with great driver and steam support with easy updates. More tinkering support than Bazzite

    • Linux Mint. Easy to start on but more traditional back-end. Much more support (forum posts) than the previous two. A lot of what works on Debian or Ubuntu works the same on Mint, so you’ll be able to do all kinds of fiddling








  • I have this exact same setup. Open Web UI has more features than I’ve been able to use such as functions and pipelines.

    I use it to share my LLMs across my network. It has really good user management so I can set up a user for my wife or brother in law and give them general use LLM while my dad and I can take advantage of Coding-tuned models.

    The code formatting and code execution functions are great. It’s overall a great UI.

    Ive used LLMs to rewrite code, help format PowerPoint slides, summarize my notes from work, create D&D characters, plan lessons, etc