Currently, I am storing entities in a JSON array / list. every element in this list corresponds to one instance of that entity.
I could express a many-to-many relationship as just another field in that entity that happens to be a list / array, or I can imitate a SQL join table by creating a separate JSON list to log an instance of that relation.
The list would still allow a many-to-many relationship. Let demonstrate:
entity A and entity B both have 2 members: A-1, A-2, B-1, and B-2.
we add a "relations" field to entity A, which is a list of IDs from B, describing the list of B's that A is related to.
A-1 has the relations field as: [B-1, B-2] and A-2 has [B-1, B-2].
As you can see, this is a many-to-many relationship. Each of our entities is tied to multiple entities. So this is many on both sides, hence many to many
The reason I am using JSON is so I can have a flat file, sorta plaintext. This way, the storage is easily readable by the user without any special tools, and can even be debugged or modified directly, or using a tool like jq. All this without the need for a heavy database engine, indexing, etc (I am not operating at a large scale). I dont believe MongoDB would be suitable for me based on this, but please let me know if you think I am wrong.
I recognize this will vary depending on how much you self-host, so I'm curious about the range of experiences from the few self-hosted things to the many self-hosted things....
It's as much or as little as you want to. If you don't want to change anything, you can use something like debian and only maintain once every 5 years (and you could even skip that).
I personally spend a little more, by choice, because I use gentoo. But if I'm busy, I can avoid maintenance by only running routine updates every couple of weeks or so.
Please post one top-level comment per complaint about Lemmy. You can reply with ideas or links to existing GitHub issues that could address the complaints. This will help identify both common complaints and potential solutions....
This certainly helps, but I think is not enough. If I go to the "All" feed, I get everything indiscriminately. I wish there was some in between mechanism. I don't claim to have the answer.
If you are interested in sharing book recommendations with other, or just manage your books, then bookwyrm is great for that! The .world team also has a bookwyrm instance up and running at bookwyrm.world with a community here on lemmy as well at !bookwyrm. Read Ruuds original post about it here: https://lemmy.world/post/5904792...
By free software you mean the FSF or OSI definition. Many people won't care, and some of us actively are against corporate leech on free software, which this license helps with.
Does the fediverse need to maintain its "soul"? As long as it preserves user choice and corporate resistance, the rest isn't required and can be maintained in those specific instances.
This is from last month, but I haven't seen any discussion of it. Seems like Forgejo is now a hard fork of Gitea, instead of being a soft fork like it was over the previous year....
Thanks for the link. But is this really unseen in FOSS? My understanding is some FOSS projects do this so that it is easy to make major decisions without having to bring every person that has ever contributed to the project, kinda like how ZFS is stuck with license issues because they can't bring all contributors together to approve a license change.
While reading Sipser's book on theory of computation, it relies heavily on the concept of formal language, and machines that merely accept or reject an input....
I suppose you're right. But I thought the reason we are using conceptual models of computation is to not concern ourselves with the implementation details of the physical world and real computers. It's why we have an infinite tape, for example.
Representing a "sum a list of numbers" problem in terms of binary logic gates would be the opposite of that. We're complicating the problem. Turing machines as I've seen them are not that low level. Would binary addition be the sensible way to sum a list of numbers in a turing machine?
Your answer is still convincing though... I suppose we can represent functions as series of verifiers. But my only remaining point of confusion is... Is that really the better way?
Didn't say you can't whatever you want. I said "by your logic". That was assuming you don't contradict your own logic, but of course you can otherwise :)
The PDS, in many ways, fulfills a simple role: it hosts your account and gives you the ability to log in, it holds the signing keys for your data, and it keeps your data online and highly available. Unlike a Mastodon instance, it does not need to function as a full-fledged social media service. We wanted to make atproto data hosting—like web hosting—into a fairly simple commoditized service. The PDS’s role has been limited in scope to achieve this goal. By limiting the scope, the role of a PDS in maintaining an open and fluid data network has become all the more powerful.
In the Bluesky app, we hardcode our in-house moderation to provide a strong foundation that upholds our community guidelines. We will continue to uphold our existing policies in the Bluesky app, even as this new architecture is made available. With the introduction of labelers, users will be able to subscribe to additional moderation services on top of the existing foundation of our in-house moderation.
You'll see a lot more on their site. But the point is, this is more about a "distributed infrastructure" than federated control. So much still has to go through their central servers. Hosting your own server has little benefits. Moderation is still very centralized, even after their planned features for moderation.
Reading a book actually. A programmer by craft who never studied CS, so decided to do it on my own. I appreciate the depth of your answer, thank you! :)
So Turing machines cannot be considered equivalent to algorithms when we involve steps like random number generation? How does church-turing address this? Isn't that part of what's "computable"?
I see people talking about doas saying it's just like sudo but with less features. I'm just wondering if there is any situation where you should use doas or if it's just personal preference.
Yes I did, and that's a very good point. What sudo does not allow me to do is grant a user access to modify or read specific files or directories. I can get both that and access to executing specific programs using a users/groups permission system.
Another thing I don't like about sudo is that you end up using the same password for everything, which is also the password for logging in. Putting higher privileges behind my same login password opens me to a single point of failure.
I see. I have little knowledge, but I bet that the "root privileges" part of this process is the reboot. Upon rebooting, system updates are applied from the new image via some privileged process.
That's pretty neat. Unfortunately I haven't ventured deeply enough into that type of system yet (was it called immutable distro or something?). I use gentoo, which doesn't support this out of the box.
Benefits of a join table vs. array to express relations? (outside of SQL)
I am building an application that is using JSON / XML files to persist data. This is why I indicated "outside of SQL" in the title....
Systemd wants to expand to include a sudo replacement ( outpost.fosspost.org )
NixOS forked ( aux.computer )
https://hachyderm.io/@jakehamilton/112355361353931366
What existing platforms do you wish were federated?
Switching to Wayland as a WM user ( feddit.cl )
Hi guys,...
Bluesky backs a project that would let Mastodon apps, like Ivory, work with its network ( techcrunch.com )
[Thread, post or comment was deleted by the author]
Funkwhale - A platform for all your audio ( www.funkwhale.audio )
Funkwhale - A platform for all your audio
How much maintenance do you find your self-hosting involves?
I recognize this will vary depending on how much you self-host, so I'm curious about the range of experiences from the few self-hosted things to the many self-hosted things....
LXQt 2.0.0 released ( lxqt-project.org )
What are your complaints about Lemmy?
Please post one top-level comment per complaint about Lemmy. You can reply with ideas or links to existing GitHub issues that could address the complaints. This will help identify both common complaints and potential solutions....
Anna's Archive is looking for volunteers to run mirrors ( annas-archive.org )
The fediverse Goodreads alternative: Bookwyrm ( bookwyrm.world )
If you are interested in sharing book recommendations with other, or just manage your books, then bookwyrm is great for that! The .world team also has a bookwyrm instance up and running at bookwyrm.world with a community here on lemmy as well at !bookwyrm. Read Ruuds original post about it here: https://lemmy.world/post/5904792...
For a Universal Declaration on Fediverse Rights, or: At the Core of the Threads-Debate lies a deeper problem: how can the Fediverse grow without losing its soul in the process? ( fungiverse.wordpress.com )
GitHub - L4GSP1KE/Upload-Assistant ( github.com )
A simple tool to take the work out of uploading....
VPS provider Vultr Claims Rights to Sell Your Data & Programs ( youtu.be )
What's your take on Bluesky?
I recently finished the episode of The Verge's podcast #Decoder with the interview to Bluesky's CEO and it seems a quite interesting project....
Forgejo forks its own path forward ( forgejo.org )
This is from last month, but I haven't seen any discussion of it. Seems like Forgejo is now a hard fork of Gitea, instead of being a soft fork like it was over the previous year....
Why focus on formal language in theory of computation? Most programs do more than merely accept or reject an input
While reading Sipser's book on theory of computation, it relies heavily on the concept of formal language, and machines that merely accept or reject an input....
Glaucus Linux - simple and lightweight distribution based on musl and toybox. ( glaucuslinux.org )
Probably a long way from being daily-driven, but I really love the idea....
Federation is the future of social media, says Bluesky CEO Jay Graber ( www.theverge.com )
[CompSci] Is the specification / definition of an automaton (like a turing machine) a type of algorithm?
Apologies if the title is confusing, but I couldn't think of better phrasing in short text....
Is there an advantage of using doas over sudo
I see people talking about doas saying it's just like sudo but with less features. I'm just wondering if there is any situation where you should use doas or if it's just personal preference.
Bluesky opens up federation, letting anyone run their own server | TechCrunch ( techcrunch.com )