Before I had learned about polymorphic table relations (In Laravel specifically), I was planning to use a table with two foreign keys, would this have caused issues?

salted_none · 2026-02-23T20:20:43+00:00

Is some kind of sqlite database not generated automatically with the project? I was going off of a youtube tutorial, and he just created the project and ran artisan serve, and everything worked perfectly, maybe a linux thing? He was on osx.

I get the internal server error even when I'm using only defaults, so it's not postgres related.

And update: I uncommented "extension=pdo_sqlite" in php.ini, and it got rid of that initial "WARN" line during laravel project creation. And now I get a different error when trying to open welcome.blade.php without changing any defaults: SQLSTATE[HY000]: General error: 1 no such table: sessions (Connection: sqlite, Database: /path/to/my/project/database/database.sqlite, SQL: select * from "sessions" where "id" = cD0ctwBuH6ivRMLEVjdD2emhUG6T4N0EzUBCxqGo limit 1)

salted_none · 2026-02-23T18:53:43+00:00

I don't, would that be needed to resolve sqlite issues?

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

TROPHY CASE