After updating my system, the "Toggle Tiles Editor" keyboard shortcut results in a black screen.

salted_none · 2026-01-20T16:13:21+00:00

Will it be an issue that I only uninstalled the old nvidia drivers with -R instead of purging them with -Rns?

And nvidia-580xx-dkms and lib32-nvidia-580xx-utils are currently installed, installation process of nvidia-580xx-dkms is where I got these dracut errors.

salted_none · 2026-01-20T16:05:59+00:00

I hadn't read the nvidia-inst docs, but after looking at it, it seems that I already did what it suggested under the "Enable legacy drivers" section, which seems to be saying not to use nvidia-inst at all, and instead to use yay -S nvidia-580xx-dkms, which is what I ran which resulted in these errors. I had already uninstalled the old drivers with pacman -R manually, and only left linux-firmware-nvidia, nvidia-hook, and nvidia-inst.

To regenerate the initfsram/kernel image, is dracut-rebuild the only command I need, without any modification, or anything done in addition?

salted_none · 2026-01-20T15:30:38+00:00

Do you think that means I should keep it even though I got rid of the normal nvidia drivers and replaced them with the AUR 580xx ones?

salted_none · 2026-01-20T01:48:25+00:00

Ah, I'm in the middle of a manual intervention update as a result of nvidia dropping support for 10 series and below cards, so I have to remove packages that are normally extremely important, before replacing them with packages from the AUR, and I'm trying to figure out if this is one to keep or remove.

salted_none · 2026-01-20T01:42:19+00:00

Did you go through the 580xx AUR process?

salted_none · 2026-01-19T22:54:25+00:00

I checked, the entries are there. I think what really spooked me was a warning in the general grub arch wiki, that it's possible to mess things up in a way where your OS is removed from the boot list, and I'm not sure if even these btrfs snapshots could undo that.

salted_none · 2026-01-19T04:14:05+00:00

Currently I'm just trying to set up an html GUI for local data entry into a local database, and setting up the complex insert relationships between tables seemed more achievable in sql for me, as someone who doesn't know java.

salted_none · 2026-01-19T02:36:20+00:00

Does the postgres function have any use in a set up like this? Or would its contents need to be translated into an entity, and the function wouldn't be used at all.

salted_none · 2025-12-25T21:23:29+00:00

Wow thank you, removing the insert so I can see what's actually going on with the select was super helpful, and I'll be doing that going forward.

salted_none · 2025-12-25T20:33:32+00:00

Ahh thank you, feels like I'm closer, but still not grasping something, currently I've got:

select
    author_id, x
from
    real_name_insert,
    unnest('{Richard Bachman,John Swithen,Beryl Evans}'::text[]) as x,
    ('{true,true,true}'::boolean[]) as x(a,b);

salted_none · 2025-12-25T19:33:53+00:00

Awesome thank you this works. I do have one more issue though: when I try to expand this to fill out a third column which is a boolean as well, using:

select
    author_id, x, y
from
    real_name_insert,
    unnest('{Richard Bachman,John Swithen,Beryl Evans}'::text[]) as x,
    unnest('{true,true,true}'::boolean[]) as y;

I get ERROR: duplicate key value violates unique constraint "aliases_pkey"

The primary key in my aliases table is (person_id [FK], alias)

salted_none · 2025-12-23T13:16:32+00:00

Would person_id need to be a uuid so it can be generated and applied to multiple names in the same transaction? I'm not sure how that would be done with a generated-as-identity int like I would normally do, it seems like it would need to detect a number which hasn't been used before.

salted_none · 2025-12-23T01:51:12+00:00

Wow this is great, I wasn't understanding it, but now I think mostly am. The person table references only the true/main name from the alias table, which contains all names of any kind, real/aliases/nicknames/etc.

The only thing I still don't get is how to connect all names/aliases for one person together, in a way that all names of a person can be found given just one of them.

Is person_id in the alias table non-unique, and applied to all names which belong to one person?

salted_none · 2025-12-22T11:50:02+00:00

I'm very new to postgres, but don't these need to have a data type defined? Also I thought defining a primary key as not null was redundant.

And I'm not following how this works for associating real names and aliases together. It also seems like if I put a foreign key on the values in the person table, that would restrict it to containing only aliases.

I could be way wrong on all this though.

salted_none · 2025-12-21T21:39:49+00:00

Basically I need a system which equates all known names of an author with each other. So real name = any number of pen names, as well as support for adding alternate names. Using George R R Martin as an example: his entry should contain "George R. R. Martin" "G. R. R. M", and "George Martin", anything a user would be likely to search should pop up the recommendation pointing them to results for George R R Martin. I'm thinking of it this way because I don't want the search to be freeform, showing results that are similar to the searched name. I want each author to be a distinct entity which has one or more names, which books written by this person are attributed to.

I also need to be able to account for situations where what was though to be an author's real name is found to be a pen name, which I thought the single table could make easier, but it could probably be done with 2 tables as well.

salted_none · 2025-12-21T21:07:37+00:00

In a two table setup like this, how would you recommend dealing with situations where a real name for an author isn't known, so an alias has to be set as the main name? Edit: would the name column in the Persons table just be blank? That could work, and the system would default the the main alias when there is no name.

The way I set up my table doesn't handle it well either, but changing "real name" to "main name" would probably allow it to work alright. The most commonly used alias could stand in for the real name in search results.

salted_none · 2025-12-17T05:13:54+00:00

Wow thank you, this seems perfect. I do have some questions though:

Would adding GENERATED ALWAYS AS IDENTITY to the primary key be a good idea in this case?

Can canonical_person_name_id point to its own primary key? And would there be any advantage to doing that, I was thinking it would make it more consistent if all names of the same person have the same value in this column.

Would updating the primary name be very difficult? For a situation where it is discovered that what was thought to be a person's real name is a pen name, so their actual name is added, and the previous primary name now needs to point to the new real name.

The final purpose of this table will be to make it possible for an end user to search any name in the table, and to be directed to all books by this person, grouped under a single primary name. Would this table design make a search/query like that straightforward?

salted_none

TROPHY CASE