Skip Navigation

InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)MA
Posts
11
Comments
427
Joined
2 yr. ago

  • I think there is a catch-22.

    pg_dump needs to connect to a running PostgreSQL instance.

    But if you upgrade the binaries and try to start up, you can’t because the old data format doesn’t work. Because you can’t start up, pg_dump can’t connect.

  • I’ve spend more than a decade supporting both Postgres and MongoDB in production.

    While they each have quirks, I prefer the quirks of Postgres.

    I just spent a massive amount of time retooling code to deal with a MongoDB upgrade. The code upgrade is so complex because that’s where the schema is defined. No wonder MongoDB upgrades are easier— the database has externalized a lot of complexity that now becomes some coders problem to deal with.

  • For minor version upgrades, the database remains binary compatible. Nothing to do.

    The dump/restore required during major upgrades allows format changes which enable new features and performance improvements without dragging around cruft forever to stay backwards compatible.

    For professionals running PostgreSQL clusters in production there is a way to cycle in the new server version with zero user-visible downtime.

  • It doesn’t improve security much to host your reverse proxy outside your network, but it does hide your home IP if you care.

    If your app can exploited over the web and through a proxy it doesn’t matter if that proxy is on the same machine or over the network.

  • I like batcat aka bat, but nominate the humble ‘cat’ instead.

    Want to copy a disk image to a device? You can use cat for that: cat file.iso>/dev/sdf

    What to copy local stdout over ssh? Use cat.

    ls -l | ssh myhost 'cat >out.txt'

    That’s simple and surprisingly powerful.