[–] 2 points 5 months ago* (last edited 5 months ago)

Try installing some programs using the Nix package manager. It lets you declare a list of packages in a flake.nix file and then it'll download and update them for you automatically. And if you use git to keep track of the changes to flake.nix, you can easily undo changes if you screw something up.

Home Manager does the same thing but for your app's config files (so you can easily back up and synchronize them)

Both of these make getting set up after a fresh reinstallation much faster! (There's also "NixOS" which is an entire operating system that uses Nix for configuring the whole operating system but I wouldn't recommend that until you've tried "Nix" first)

  • source
  • [–] [S] 8 points 5 months ago (1 child)

    Since I’m relatively new to the Linux game I’ve made a few mistakes along the way. Installed things wrong with Wine, installed multiple versions of the same thing, etc. I figure I can just back up my personal files and then start with a clean install.

  • source
  • parent
  • context
  • [–] 0 points 6 months ago

    Another alternative to a database that will let you practice SQL is duckdb.

    I use it frequently at work with python and parquet files which are type safe, compact, and very performant. I use Python with Positron as my IDE (I'm a data scientist) and it has a built in parquet viewer that makes the data exploration a little less abstract.

  • source
  • [–] 7 points 6 months ago (1 child)

    There’s nothing wrong with using a spreadsheet for that purpose.

    Sure, use a database if you think it’s going to grow very big, need complicated queries or will be the backend of a service. Or, you just want to learn about databases.

    Libre Office will work with native flat files or other db backend. SQLite with a gui app is good for learning SQL.

  • source
  • [–] [S] 2 points 6 months ago

    Dbeaver

    I don't know, but that's kind of cool. It looks like with a driver, it will connect to MS Access. I still have to touch a legacy access database from time to time. Somewhere along the line, Access quit working over a RDP connection for me. I just wrote my own simple front end for it using .net, but the one thing I would like to do is kind of a pain for me to write. I could do it, I just don't want to. lol.

    On the other hand, I don't mind getting a license for a good product just to support them, and it looks like the only options they have are subscription based. That leaves a bad taste in my mouth. I miss the good ol' days.

    Anyway, thanks. Just installed the Linux ce version. It connected to MySQL and seems to do all the things I use Workbench for. So far, it's only asked me for my password when I connect to the database the first time!

  • source
  • parent
  • context
  • [–] [S] 2 points 6 months ago (1 child)

    Ok. That seems important then. Having to type the WiFi password would be even more annoying. :) The other part seems important, too.

    Now it makes me wonder how non technical people who have auto login enabled deal with it. I mean, I'd expect it to work like on Windows.

  • source
  • parent
  • context
  • [–] 3 points 6 months ago

    What if I set autologin in my Desktop Environment (GNOME or KDE), but left LUKS locked down with a passphrase? Wouldn’t that be safe?

    Probably safe enough

  • source
  • [–] 5 points 6 months ago

    I don't have an answer, but I do know that even the Windows version of MySQL Workbench is pretty ass. Probably doesn't hurt to look into something nicer to use.

    Sorry for not having an answer for you though.

  • source
  • view more: ‹ prev next ›