Skip Navigation
Is there a way to automatically clean my home directory of app-specific directories?
  • That looks pretty good! Though the automatic part I think is pretty important, know if there are any tools that do that? I tried searching, but didn't find much, just this bubblejail that would at least make things a little easier I guess

  • [SQL/MariaDB] How will the YEAR data type transform in the future?
  • That does make sense! I like the point about older systems, I didn't even stop to think about how much storge space has exploded in such a short amount of time and how it started from incredibly small capacities at very high prices that could have been hard to justify for any company that realistically just needed to keep some records

  • [SQL/MariaDB] How will the YEAR data type transform in the future?
  • That's really interesting!

    The good news is it sounds like this issue is being taken into account.

    Is there a part in that page that says so? I wasn't able to find it

    I wouldn’t be surprised if they added a YEAR2 though. T-SQL has a datetime2, after all.

    Ok I wasn't expecting that, it sounds like a meme, but it's actually real lol

  • [SQL/MariaDB] How will the YEAR data type transform in the future?
  • Yes 2 bytes is absolutely fine for me in fact (waiting for this comment to age like milk in my cryo pod), but then if YEAR will just stay the same forever, will it become a relic of the past? If so, why YEAR in the first place, who would actually make use of it?

  • [SQL/MariaDB] How will the YEAR data type transform in the future?

    I was looking to implement a year column and while researching I stumbled on the YEAR data type which sounded just right by its name, I assumed that it would just be something like an integer that can maybe hold only 4 digits, maybe more if negative? But then I noticed while actually trying it out that some years I was inputting randomly by hand never went through giving an out of range error, so I went to look at the full details and, sure enough, it's limited to years between 1901 and 2155, just 2155! In terms of life of an application 2155 is just around the corner, well not that any software has ever lived that long, but you get what I mean in the sense that we want our programs to be as little affected by time within what's reasonable given space constraints. So what will they do when they get close enough to that year, because you don't even have to be in that year to need it accessible, there could be references that point to the future, maybe for planning of some thing or user selected dates and whatnot; will they change the underlying definition of it as time passes so it's always shifted forward? If that's the approach they'll take, will they just tell everyone who's using this type that their older dates will just not be supported anymore and they need to migrate to a different type? YEAR-OLD? Then YEAR-OLDER? Then YEAR-OLDER-BUT-LIKE-ACTUALLY? Or, that if they plan to stay in business, they should move to SMALLINT? Or will they take the opposite approach and put out a new YEAR datatype every time the 256 range is expired like YEAR-NEW, YEAR-NEW-1, YEAR-FINAL, YEAR-JK-GUYS-THE-WORLD-HASNT-COLLAPSED, etc.?

    So I wonder, what's the point of this data type? It's just so incredibly restricted that I don't see even a hypothetical use. There exist other questions like this (example) but I think they all don't address this point: has anyone from MariaDB or MySQL or an SQL committee (I don't know if that's a thing) wrote up some document that describes the plan for how this datatype will evolve as time passes? An RFC or anything like that?

    11
    The 2nd Canvas is upon us! What will you be doing? | 12th July 2024

    What is this?

    For all you Reddit refugees this is like r/place. For all who don't know what that is either, this is a public, well, canvas, that will be freely accessible to anyone with a Fediverse account (specifics on the main post, don't worry, Lemmy is included). You'll be able to place (this is not place!!!) one pixel every certain amount of time on the canvas, either in an empty or an already used spot, overwriting it in the latter case.

    Where is this happening?

    Right over on https://canvas.fediverse.events/

    Announcement post and other related stuff:

    When can we participate?

    On the 12th July 2024, or 2024-07-12 for all you ISO lovers!

    Why should I care?

    I don't know, it could be fun and it's not like you have to do it alone, it's actually way more fun to partecipate alongside your fellow fediversers, sooo... monke together strong? If you have some particular interest and you want it represented, try to look for your people in the right communities, and organize together to make the best fricking piece of pixel art the world has ever seen!!

    From here I guess we can invite you to maybe make a little something for our lemy.lol instance's community, claiming a patch of land for ourselves as the (certified) best instance of the Fediverse (full disclosure: am admin of said instance). If we want to make something, we can probably make a Matrix room to coordinate our efforts! Otherwise, just go ahead and have fun with your loved <insert niche game/anime/film/any piece of media> and make something out of it!

    ---

    Lastly here's last year's final canvas to try to win you over (or scare you): !2023 Fediverse Canvas - Final state

    4
    Is there a way to automatically clean my home directory of app-specific directories?

    I saw that there's this nifty xdg-ninja that informs you on what you have installed that doesn't respect the XDG spec, if it has support for it or not and what you can do to make it comply. But now I was wondering if there was any tool to do the actual work automatically, I believe I have once seen a program that spoofed your home directory to non-complying apps so that you could transparently override their whole app data location to a path you wanted so they can keep functioning, but I can't for the life of me find it again. It would be double awesome if it did both, i.e. auto-applying any changes to apps that support XDG but need to be configured to enable it and, for those who don't, forcefully spoofing the home directory

    3
    [home manager] [solved] Is there a way to automatically import all .nix files in a directory?

    My solution:

    ```nix let

    nixFilesInDirectory = directory: ( map (file: "${directory}/${file}") ( builtins.filter ( nodeName: (builtins.isList (builtins.match ".+\.nix$" nodeName)) && # checking that it is NOT a directory by seeing # if the node name forcefully used as a directory is an invalid path (!builtins.pathExists "${directory}/${nodeName}/.") ) (builtins.attrNames (builtins.readDir directory)) ) );

    nixFilesInDirectories = directoryList: ( builtins.concatMap (directory: nixFilesInDirectory directory) (directoryList) );

    ...

    in { imports = nixFilesInDirectories ([ "${./programs}" "${./programs/terminal-niceties}" ]);

    ...

    } ``` snippet from the full source code: quazar-omega/home-manager-config (L5-L26)

    credits:

    ---

    I'm trying out Nix Home Manager and learning its features little by little. I've been trying to split my app configurations into their own files now and saw that many do the following:

    1. Make a directory containing all the app specific configurations: programs/ └── helix.nix
    2. Make a catch-all file default.nix that selectively imports the files inside: programs/ ├── default.nix └── helix.nix Content: nix { imports = [ ./helix.nix ]; }
    3. Import the directory (picking up the default.nix) within the home-manager configuration: ```nix {

    some stuff...

    imports = [ ./programs ];

    some other stuff...

    } ```

    I'd like to avoid having to write each and every file I'll create into the imports of default.nix, that kinda defeats the point of separating it if I'll have to specify everything anyway, so is there a way to do so? I haven't found different ways to do this in various Nix discussions.

    ---

    Example I'm looking at: https://github.com/fufexan/dotfiles/blob/main/home/terminal/default.nix

    My own repository: https://codeberg.org/quazar-omega/home-manager-config

    14
    jk, we still love you Gitea ..for now

    We all know who's the real steward of free software and federation

    \smiles in anticipation\

    --- legit had to draw the vector logo of Gogs for this, smh

    edit: actually... it already exists, oopsie (ᵕ—ᴗ—) smh my head

    38
    Can Filelight analyze MTP devices (Android phone)?

    I was trying to analyze my phone's storage through Filelight, but it just gets frozen after I select the phone's folder. I didn't find anything in Bugzilla regarding this problem. Is the protocol supported at all in the app?

    22
    How can I get automatic installation of updates?

    I've mostly been using the official F-droid app, but I've become tired of having to click install every single time there's a new update for an app. On a new phone I tried starting right away with Neo Store, which I know has that functionality, and in fact I haven't had to confirm installation of updates since on there, but on my old devices where I started with F-droid how can I get that to work? I believe I read somewhere that for this to work, the apps I want to update automatically need to be installed the first time from within the same app and, even then, only some apps that target Android SDKs from a certain point forward support that, so not all can benefit from this feature. So how can I make this change, do I have to uninstall every application from F-droid I have and reinstall them from Neo Store or is there an easier way?

    Edit: One other thing, even in Neo Store it seems I can't update without confirmation if I manually update only one app at a time and instead it works if I let it update everything by having "Auto-update" enabled

    20
    [Kate] [solved] How do I make sessions save the chosen folder?

    There's something I don't understand here: why when I do "Open Folder" and then save the session, closing it and opening it again I'm left with nothing? Instead, if I open some files in subdirectories, the next time I reopen the session I'm just presented with the parent folders of those files, but I really needed to have the topmost directory to be able to access the whole tree structure whenever I reopen the session.

    Is it possible? Or do I have to make a project?

    9
    Any Markdown editor that can convert to PDF?

    I've been using Quillnote for a long time now and this is a feature I've been sorely missing, are there other apps that can help me do the conversion?

    11
    How will forge federation affect issue tracking/reporting?

    I was thinking, with the recent news of a contributor to GitLab adding support for forge federation, given some time we could see that being enabled in the KDE instance as well, I hope. So that brings me to a question, if it will be used, will we be able to largely move to reporting and discussing issues on the specific project pages without signing up rather than going to the more generic Bugzilla? I was really hoping for something like this to happen because I find Bugzilla to be very dispersive and it feels hard to find the issues that you want, unless you remember the syntax needed to filter the results correctly every single time, so much so that I never signed up on there (but maybe I'm just too lazy and I never took the time to actually understand it). On the other hand I think most other issue trackers integrated in software forges are way more intuitive, as well as having better discoverability, since they're right there by the code base.

    If, instead, you won't do it and prefer to keep Bugzilla as the main issue tracking platform, could you tell us why? Is it to keep the developer discussions separate from the user ones so as to keep your GitLab more focused? Or would there be other reasons?

    3
    What is the best dark mode extension?

    In terms of the most balanced in speed, consistency in page rendering and good default settings, is there a clear winner?

    Personally I've been using both Dark Reader and Midnight Lizard on different devices and I can't say I noticed much of a difference in terms of performance, what I did notice is that Dark Reader seems to have better defaults, but many complain that it slows down page loading a ton, I haven't heard the same about Midnight Lizard, but maybe that is by virtue that it has way way fewer installations and therefore fewer people talking about it. Do you know if I've missed one and there is a totally different extension that does even better than both?

    21
    "Free" as in royalty-free

    Reposting this since the original got deleted (except on the instances where it was federated in time) when my beehaw account was erased alongside a week worth of data a few months ago. Came across the image and thought "why not post again?", I don't know if I still stand by the meme, but frankly I don't care...

    I just want to schizopost

    ⠛⠛⣿⣿⣿⣿⣿⡷⢶⣦⣶⣶⣤⣤⣤⣀⠀⠀⠀ ⠀⠀⠀⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣷⡀⠀ ⠀⠀⠀⠉⠉⠉⠙⠻⣿⣿⠿⠿⠛⠛⠛⠻⣿⣿⣇⠀ ⠀⠀⢤⣀⣀⣀⠀⠀⢸⣷⡄⠀ ⣀⣤⣴⣿⣿⣿⣆ ⠀⠀⠀⠀⠹⠏⠀⠀⠀⣿⣧⠀⠹⣿⣿⣿⣿⣿⡿⣿ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠛⠿⠇⢀⣼⣿⣿⠛⢯⡿⡟ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠦⠴⢿⢿⣿⡿⠷⠀⣿⠀ ⠀⠀⠀⠀⠀⠀⠀⠙⣷⣶⣶⣤⣤⣤⣤⣤⣶⣦⠃⠀ ⠀⠀⠀⠀⠀⠀⠀⢐⣿⣾⣿⣿⣿⣿⣿⣿⣿⣿⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠈⣿⣿⣿⣿⣿⣿⣿⣿⣿⡇⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠙⠻⢿⣿⣿⣿⣿⠟

    44
    How can I search text of my own comments?

    Sorry if this is a dumb question, I was looking at the filter feature but I only saw that it can be used to exclude users, instead of including, maybe I overlooked some other option?

    0
    Moments before disaster...

    I won't confirm nor deny my wickedness, mein Fräulein

    0
    Any privacy respecting Instagram frontends?

    Since Bibliogram is dead, has any new project popped up? I found imgsed just now, but it doesn't look like it's open source as far as I can tell

    8
    Happy 32nd birthday to Linux!

    You may wonder: > It's 32 years old, so why does Tux look like a cub?

    To that I say: It's 32 years... young! Linux has never been more in shape than it is today :)

    spoiler

    You may title this as "The Curious Case of Benjamin ButTux", ooor not, that sounds suspiciously like "buttocks"

    ---

    Side note

    I wasn't expecting the birthday to come already, but, as it happens, I was working on my Tux design these past few days, so I felt hard pressed to release some celebratory art today when I found out. You can see the little guy being built right now in my laboratory repository: https://codeberg.org/quazar-omega/tux-reloaded

    I'll be posting a proper announcement when I feel like it's ready (if I don't get burned out before that X﹏X )

    3
    How to keep a history of notifications?

    Background

    I'm using GNOME and it has this problem where it deletes all notifications coming from a single application when they exceed 3, so, without even having many websites that send notifications, I find myself opening the browser, getting a slew of them and most disappear immediately to make way for the others that all come in quick succession, so I don't get the chance to actually read them. That's especially annoying when I spot a notification, try to dig up where it could have come from and don't manage to find anything, either because the website redacted it or because I misread it at a glance so I'm unable to point to which one it could have been

    Actual question

    How do we keep in a log all the notifications that are coming through? Preferably not in a way that is dependent on the OS, with Dbus in this case, but all inside Firefox

    0
    Me and my friend when we have to SYN for a screenshot

    cross-posted from: https://lemy.lol/post/3995572

    > > ::: spoiler (I hope the video link works, otherwise) > > !Genshin TCP > ::: >

    1
    Me and my friend when we have to sync for a screenshot
    (I hope the video link works, otherwise)

    !Genshin TCP

    2
    InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)QU
    QuazarOmega @lemy.lol
    Posts 26
    Comments 1.2K
    Moderates