• 1 Post
  • 19 Comments
Joined 1 year ago
cake
Cake day: July 4th, 2023

help-circle









  • pixxelkick@lemmy.world
    cake
    OPtoSelfhosted@lemmy.worldSelf Hosted Database ERD Manager?
    link
    fedilink
    English
    arrow-up
    1
    arrow-down
    2
    ·
    9 months ago

    I was able to connect to the DB with Cloudbeaver, but it straight up wasn’t providing the diagram tab in the way the picture said it outta. The example pic even specifically is using a postgres DB as its example!

    I pretty much had the exact same view, but no diagram tab. Unfortunately the wiki article doesn’t go into much detail, it just says:

    “(if the tab is not presented then the object does not support the diagram presentation)”

    With no information provided further listing off what is, and is not, supported for diagram presentation.

    Lack of documentation it seems, which is unfortunate. It seemed like it has potential but I spent a good 20 minutes fiddling with it, trying different configurations and settings, nothing made it start working and it seems like (as is the case on a few of these tools) the ERD tooling is often a bit of an afterthought and poorly supported.

    Many of the tools are sql first, ERD… third? fourth? forgotten and lacking most features :(



  • pixxelkick@lemmy.world
    cake
    OPtoSelfhosted@lemmy.worldSelf Hosted Database ERD Manager?
    link
    fedilink
    English
    arrow-up
    1
    arrow-down
    2
    ·
    9 months ago

    Trying it out, the wiki says it has an ERD editor, but its documentation is kind of lacking.

    It’s example image here: https://github.com/dbeaver/cloudbeaver/wiki/Entity-Diagrams

    Shows it interacting with a postgres database, but when I try the same I am not getting a Diagram tab. Its also proving to be pretty awkward to try and work with.

    So far best I have found is Azimutt, which is pretty close to what I want but its interface is lacking atm, and I couldnt get it to successfully connect to my postgres database in the end (kept giving NOT FOUND errors even though I tested inside the docker image to validate the connection and it could indeed TCP the postgres database’s port)






  • My understanding is “immutable” is a bit of a misnomer and avoids the “point” of using these distros.

    “Layered Distros” is a better terminology, where you can imagine the OS as multiple layers, and you can swap 1 layer out for another without modifying the others and still have a functional operational machine.

    Now some of those layers have to be immutable ones at runtime for this concept to work, so thats where that part of the name comes from, but thats an implicit result from the actual point/use case of these distros, not the selling point.

    So you can swap versions/releases of your OS very cleanly at boot, without modifying userland, and it will continue to function just the same. This lets you do stuff at the admin level like broadly releases a version update merely by having users just reboot their machines, and next time they boot up their machine will now be running on the new OS layer, with their local “user” layer being unchanged.


  • I have a K3OS cluster built out of a bunch of raspberry pis, it works well.

    The big reason I like kubernetes is that once it is up and running with git ops style management, adding another service becomes trivial.

    I just copy paste one if my e is ting services, tweak the names/namespaces, and then change the specific for the pods to match what their docker configuration needs, ie what folders need mounting and any other secrets or configs.

    I then just commit the changes to github and apply them to the cluster.

    The process of being able to roll back changes via git is awesome



  • When the raspberry pi (running pi hole) is down for any reason

    You can have 2 DNS servers provided over DHCP assignment, if this is really an issue for you (ideally it shouldnt) you should be running 2x PiHoles for failover protection, that way you can take 1 offline and all devices will auto swap to the second one for DNS.

    This will also horizontally scale your DNS querying, as devices will just 50/50 flip flop between the two while both are online and it will sort of auto-load balance.

    Largely speaking thats your best bet though, just 2x PiHoles for failover protection.

    For DHCP just use one of the pi-holes DHCP, or your routers, or whatever, they all largely perform the same but I personally find the pi-hole’s DHCP settings to be easiest to work with (you can even super fast modify them by SSHing in and using nano/vim to text edit the config file, so instead of using a UI you can just copy-paste all the entries in quickly)

    If you need to take the DHCP pi-hole offline, you can just flip DHCP on for the second one, however as long as new devices arent connecting you don’t actually need the DHCP server online once everyone has an IP assigned until their registration time is up (24 hours by default) so as long as you get the pi-hole back online quickly, you’re network typically wont even have a problem.