• 0 Posts
  • 74 Comments
Joined 2 years ago
cake
Cake day: June 12th, 2023

help-circle


  • It’s voice and video calling with chat and screensharing. I intend to use it for a language school. It’s extendable, for instance you can also self-host a whiteboard, where everyone can draw. You can see the drawing in real time, which is good for asian languages, where direction of the stroke is important.

    Free, open-source, packaged in Debian, runs without issues, used it with friends for multi-hour voice chats during gaming nights.

    On the server you can configure things like FPS for screenshare. I have yet to adjust that and try streaming video/game through it.



  • It’s from a game called Dwarf Fortress - where you play in a simulated world trying to keep your dwarves alive.

    They get bored of eating the same food, so with farming and hunting there’s also fishing.

    In the past, carps were added with some default settings, which made them overpowered. They would wipe entire squads of Dwarves that would approach any body of water with a carp in them.

    (They were nerfed later on.)

    The game has a very complex fighting system, so when creatures fight, sometimes they fall down, after a big hit with a hammer, or getting knocked unconscious. If they are not fatally wounded, they will get back up. There’s a lot of actions that happen inside the game, but not always in the ‘correct’ context, as the game is still in development.

    And somewhere on the internet, there was a screenshot with combat log showing:

    The Carp attacks the Miner but She jumps away! The Carp stands up.

    So carps were already a challenge, and then you read they can stand up!? Imagine the terror of an army of strong beasts marching down to your fort from a nearby river.

    There were many bugs in the game, if you like rabbitholes, this is a good one.






  • Postgres is far superior in every way.

    We used MySQL (and Percona XtraDB) servers at work, and it is so bad. So I made several presentations showing generic and specific reasons why Postgres is better. I had to cut a lot of content because MySQL is just that bad.

    Some things may not seem relevant now, but as you keep the DB around long enough, you will appreciate the whole package of Postgres.

    Things that will help a lot, but are extensions:

    • pg_partman - for automatic partition management
    • patroni - management of replicas, automatic failover - it does everything for you with simple commands

    There is a DB comparison matrix, but hasn’t been updated in over a year, which is a shame, but still gives you the idea of how different databases support SQL features: link.

    Spoiler: postgres has the most support, with a huge lead

    Edit: MySQL is dead last, btw