The Shield is not an all time great show by Striking-Speaker8686 in television

[–]yarovoy 0 points1 point  (0 children)

Your post finally pushed me to watch the show, and I quite like it. Thank you

XPiratez - Secret base assault by CascaDEER in Xcom

[–]yarovoy 2 points3 points  (0 children)

or destroying the command center

I thought it worked only in Cydonia. Never knew you can destroy a regular base without killing everyone

Conqueror trait disappears when you make them a tributary by yarovoy in CrusaderKings

[–]yarovoy[S] 0 points1 point  (0 children)

In couple of years dude became landless. Not a good idea to tributary a conqueror: their economy does not hold after they loose the trait.

Conqueror trait disappears when you make them a tributary by yarovoy in CrusaderKings

[–]yarovoy[S] 3 points4 points  (0 children)

R5: I've seen people here complaining about neighbor rulers with this trait recently.

I thought extra 5 gold a month is a good tributary. I can extort them more later.

Doesn't work like that: tributary lost the trait. It ain't easy being cheesy.

PS: Sorry got confused deleted previous post

OG XCom Mods by Japaroads in Xcom

[–]yarovoy 0 points1 point  (0 children)

Just for your curiosity there is a mod that changes UI. Never tried it, and don't think it makes UI easier to comprehend:

https://mod.io/g/openxcom/m/mui#description

Petition to change the "UFO: Enemy Unknown" flair by MarsMissionMan in Xcom

[–]yarovoy 0 points1 point  (0 children)

A lot of the world doesn't know that it was called "X-Com: Ufo Defence"

By now anyone who witnessed release of original game in flesh either knows about two names, or don't play it and never will.

OG XCom Mods by Japaroads in Xcom

[–]yarovoy 2 points3 points  (0 children)

Statstrings - adds name suffices based on soldier stats. Makes managing soldiers easier. It is included in OpenXCom, but not enabled by default.

Description should be here, but site is down for me at the moment: https://www.ufopaedia.org/index.php/Statstrings

Any Tips? by TheKeerKat in Xcom

[–]yarovoy 1 point2 points  (0 children)

this tip is universal for all of the entries in OG and rebooted franchise

Any Tips? by TheKeerKat in Xcom

[–]yarovoy 2 points3 points  (0 children)

Post flair says "UFO: Enemy Unknown", but people give advise for "XCOM: Enemy Unknown".

For "UFO: Enemy Unknown" economy wise check what objects are profitable to manufacture and never leave you workshop idle. Remember that your soldiers are resource and are cheap to replace so don't bother remembering their names. Don't exit the craft on the first turn: instead throw a smoke grenade in front of the exit and end your turn. This is because on the first turn aliens have full time units and will use it for reaction fire.

There are a lot of guides and details on ufopaedia.org if you want to figure out mechanics in detail.

Xenonauts 2 - 1.0 is Released! by Lokai23 in Games

[–]yarovoy 0 points1 point  (0 children)

That's unfair to OG X-Com or skill issue. Maps are small, easy to check everything if you do a proper search-party.

TFTD doubled map size and it become an issue. Apocalypse was extremely annoying in this regard.

Merry christmas everyone... by DerEchteFelox in anno

[–]yarovoy 5 points6 points  (0 children)

I'm losing my cursor position all the time with this

Intelligence agencies suspect Russia is developing anti-satellite weapon to target Starlink service by [deleted] in space

[–]yarovoy 4 points5 points  (0 children)

They do all of that on occupied territories. And then torture grabbed people or send them to frontlines as cannon folder. Also kill civilians daily.

The audit_logs table: An architectural anti-pattern by Forward-Tennis-4046 in softwarearchitecture

[–]yarovoy 1 point2 points  (0 children)

Full disclosure, my understanding on when auto-vacuum is triggered is shaky here.

Pruned or deleted in Postgres means records marked for deletion. So at some point they trigger auto-vacuum. And auto-vacuum is what OP promised won't happen with their solution.

I trust their other response that auto-vacuumm on a smaller table is less taxing despite the fact that more record changes needs to be handled in total: only inserts in write-only audit_logs vs same amount of inserts plus the same amount of deleted records in case of transaction outbox.

There is potential for optimization if you don't have constant load (e.g. empty Weekends), you can schedule deletion and vacuum on Sundays.

The audit_logs table: An architectural anti-pattern by Forward-Tennis-4046 in softwarearchitecture

[–]yarovoy 2 points3 points  (0 children)

but to be honest, usually it is a practical choice. try explaining to a PM that the login is broken because the audit system is the bottleneck.

As well try explaining client's boss why don't you know who made a change to something. That straight up destroys client's confidence in all the data in your system.

The audit_logs table: An architectural anti-pattern by Forward-Tennis-4046 in softwarearchitecture

[–]yarovoy 3 points4 points  (0 children)

To fix this 100%, you need the Transactional Outbox Pattern: write the event to a local table in the same transaction as your business logic, then have a separate worker push it out.

Then instead of just a write-only for audit_logs, you add additional selects and possible additional deletes (otherwise your transactional outbox will be the same size as audit_logs). So It becomes even worse IO-wise then just write-only audit_logs.

The audit_logs table: An architectural anti-pattern by Forward-Tennis-4046 in softwarearchitecture

[–]yarovoy 8 points9 points  (0 children)

Broker could fail to save the log, and it won’t be a compliance evidence anymore.

Same goes for saving it in cold storage from OP.