The lie made into the rule of the world

  • 3 Posts
  • 60 Comments
Joined 4 months ago
cake
Cake day: October 22nd, 2024

help-circle



  • In the context of this tweet most important differences are:

    SQL is a language for querying databases.

    Most common used databases are relational databases. With relational databases you can setup, well, relations and constraints.

    Imagine you have 2 tables (2 excel sheets) one with people, and one with home ownership. You can set the following constraint: (1) each person shows up only once in the people table. And the following relation: (2) every home owner must refer to an existing person in people table.

    When modifying the table contents, the system checks if no constraints or relations are violated.

    Excel, just like a badly designed relational databse, would, for example, have no problem with duplicate people, or home ownership referring to non-existant people.


















  • iii@mander.xyztoSelfhosted@lemmy.worldNetwork server/NAS
    link
    fedilink
    English
    arrow-up
    9
    ·
    2 months ago

    I use syncthing to sync folders between phone, tablet, desktop and my home server (a NUC).

    Then rsync on a schedule from the server to a second off-site server (also a NUC) as backup, connected through zerotier.

    I know of truenas, which is a more NAS like solution, but haven’t personally used that.