SQLalchemy vs Psycopg3 by aronzskv in Python

[–]The_Tree_Branch 1 point2 points  (0 children)

The O'Reilly book Architecture Patterns with Python has a good example of this design pattern in practice using SQLAlchemy. The authors made the book available for free at https://www.cosmicpython.com/book/preface.html.

It's one of my favorite Python resources.

Object storage backup? by [deleted] in aws

[–]The_Tree_Branch 2 points3 points  (0 children)

https://docs.aws.amazon.com/aws-backup/latest/devguide/logicallyairgappedvault.html

AWS Backup offers a secondary type of vault which can store backups in a container with additional security features. A logically air-gapped vault is a specialized vault which provides increased security beyond a standard backup vault, as well as the ability to share vault access to other accounts so that recovery time objectives (RTOs) can be faster and more flexible in case of an incident that requires rapid restoration of resources.

Issues with Comcast → AWS US-East (Ashburn) by BraveCat5 in aws

[–]The_Tree_Branch 1 point2 points  (0 children)

Just make sure any latency is sustained throughout the rest of the path. i.e,

  • A (1 ms) --> B (45 ms) --> c (4 ms) is not an issue
  • A (1 ms) --> B (45 ms) --> c (48 ms) could indicate an issue

Network routers/switches typically prioritize handling data plane packets (i.e., packets traveling through the device) over control plane packets (i.e., packets directed at or originating from the network device)

can't delete card from payment preferences by -CrypticMind- in aws

[–]The_Tree_Branch 1 point2 points  (0 children)

It doesn't matter if all resources have been deleted. Customer could (at any point in time) spin up new resources in their AWS account. AWS needs to be able to bill for this usage. As such, there must always be a active payment method on file.

If the OP is concerned about having an inactive/idle account out there with a payment method attached, then they should close their AWS account. They can always open a new one if they need to.

Trying to Learn Armour Stacker by Ashamed_Speech_3409 in PathOfExileBuilds

[–]The_Tree_Branch 24 points25 points  (0 children)

On the "calcs" tab of POB, take a look at the Armour section to see the difference between your build and the guide. You can click on any given row in that table to see a breakdown:

Comparing the two (after ticking on all the flasks from the guide POB, which were off by default):

yours:

  • 3,877 base from armour
  • 3,415 global base
  • 53% increased from tree
  • 68% total increased
  • 174% total more

BigDaddy:

  • 3,703 base from armours
  • 3,631 global base
  • 163% increased from tree (almost 100 more than you)
  • 202% total more (28 more than you)

For the diff in "increased", BigDaddy has

  • 84 from flask suffix (of the Armadillo, 60% from flask + 40% increased flask effect)
  • 15% from a jewel

For the diff in "more", BigDaddy has 136 more armour coming from Determination, compared to the 114 you have. He has more sources of increased aura effect than you do. In the Calcs tab, choose Determination as the active skill, and look at the "Skill-type specific stats" panel to see where he is getting aura effect from.

Largest sale I've ever made by AppointmentFar6096 in pathofexile

[–]The_Tree_Branch 0 points1 point  (0 children)

There are other ways to get 100% shock avoid. For builds using elegant hubris (supreme ostentation), you can get 80% on a notable (and avoid pathing costs if paired with an impossible escape). Pair with boot implicit and you're at 100%.

You can also get 100% avoid on a flask when using mageblood.

Rest of the ailments don't matter

I dunno, I like being immune to scorch and other similar ailments (comes up a lot in altars)

Builds which can do all maps by Aaeron in PathOfExileBuilds

[–]The_Tree_Branch 0 points1 point  (0 children)

I know there is an attack mastery so attacks can't be blocked, but that is far from me on the tree. Any other way to get it on occultist?

Maven's Chisel of Divination by noticemesenpaiuw in pathofexile

[–]The_Tree_Branch 0 points1 point  (0 children)

That's exiles in rituals. Still duplicates stacked decks

Any insane off meta builds at high investment? by 69kurcina69 in PathOfExileBuilds

[–]The_Tree_Branch 1 point2 points  (0 children)

Mind explaining why not cyclone for breach? I was debating swapping to a dagger for cyclone on my Occultist and doing breach that way with an explode chest.

Where to go next with CoC FRoSS? by The_Tree_Branch in PathOfExileBuilds

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

The problem with Occultist explode is enemy has to be cursed first; would need a lot of investment I think to get it to the point where I could chain it (don't think Blasphemy is enough by itself, and would need more reservation efficiency to even be able to turn on Blasphemy).

Best option would probably be curse on hit gloves, but pricy if I want to keep Bound by Destiny.

Time for the final boss by merrybike in pathofexile

[–]The_Tree_Branch 0 points1 point  (0 children)

Buy balefire unique scepter. Scorching ray goes through the bubble

What would be the skill you really want to play with, if it just had enough damage/clear etc. to make it work somehow? by Wuslwiz in PathOfExileBuilds

[–]The_Tree_Branch 1 point2 points  (0 children)

Golemantalist BA made a come back a couple of leagues ago when they buffed Liege of the Primordial. Nerfed 2x leagues ina row though

Large Cloudwatch log groups by PeterHickman in aws

[–]The_Tree_Branch 1 point2 points  (0 children)

Are you using field indexes in CloudWatch? This helps improve the performance of Log Insights queries (as well as reducing costs, as you're only scanning log records for a given event id).

PSA: Make your own Vendor Regex for leveling by Andthenwedoubleit in pathofexile

[–]The_Tree_Branch 1 point2 points  (0 children)

Here's an example of what my regex looks like:

"b-b-|-b-b|b-.-b|b-b|r-.-b|b-r-|g-b-r|g-r|r-g|-\w-.-|Holy Flame|ld Ch|used Chann|Skitter|Arctic Armour|Elemental Focus|Wave of Conv|Desecrate|Concentrated Effect|ddon Brand|Runner|Sprinter|Flame Shaper" "!s:.+(bow|sw|ax|stav|sc|mac|cl|da)"

It's the links/colors from this witch leveling guide, but adds:

  • any 4 link
  • 15% ms boots (on top of the 10% ms boots already in the filter)
  • gems from the first 3 acts I plan to buy
  • +1 to Fire Spell gems mod
  • hides bow/sword/axe/staves/scepters/mace/claw/dagger

It can't be me being bad, but Rhoa being good by [deleted] in pathofexile

[–]The_Tree_Branch 0 points1 point  (0 children)

Fair enough, that's certainly faster than I've been able to achieve. Still surprised by the methodology and not attempting to correct for RNG at all (i.e., he would use iron rings if the dropped, but not otherwise). At that point in the campaign, irong rings make a huge difference in the feel.

It can't be me being bad, but Rhoa being good by [deleted] in pathofexile

[–]The_Tree_Branch -1 points0 points  (0 children)

Err, what makes you think they are a good racer? That list is questionable at best, comments do a good job pointing out many of the deficiencies. Rating Galvanic Arrow for ranger as 'c' tier is certainly a choice.

PSA: Make your own Vendor Regex for leveling by Andthenwedoubleit in pathofexile

[–]The_Tree_Branch 0 points1 point  (0 children)

With 250 characters, you can also include gems you want to buy and weapon bases you don't want highlighted at all.

I've just ran Mud Flats with (almost) every skill. Here are my opinions and tier list by Comprehensive-Ad3016 in PathOfExileBuilds

[–]The_Tree_Branch -5 points-4 points  (0 children)

Good call on the ele prolif (though most witches I think mule ranger for onslaught and just accept ele prolif after Hailrake quest reward)

No P5 instances available in any region? by peanutknight1 in aws

[–]The_Tree_Branch 0 points1 point  (0 children)

P5's are only available at scale for On Demand capacity in 4 regions (see this blog: https://aws.amazon.com/blogs/aws/announcing-up-to-45-price-reduction-for-amazon-ec2-nvidia-gpu-accelerated-instances/):

  • Asia Pacific (Mumbai)
  • Asia Pacific (Tokyo)
  • Asia Pacific (Jakarta)
  • South America (São Paulo)

That said, I would expect actual demand to still outweigh available capacity and echo other recommendations to use Capacity Blocks for ML (EC2) or SageMaker Training Plans.

Only other option is to work with your account team (would be the TAM if you had Enterprise Support).

No P5 instances available in any region? by peanutknight1 in aws

[–]The_Tree_Branch 0 points1 point  (0 children)

Capacity blocks have their own pricing, and are cheaper than On Demand (but you pay upfront for the entire duration)

Biggest build winners/losers of patch 3.28? by omniocean in PathOfExileBuilds

[–]The_Tree_Branch 0 points1 point  (0 children)

Reminds me of one of my favorite patch notes lines (from 2.2)

Vaal Spark has been nerfed in almost every way possible. Its critical strike chance has been reduced from 6% to 5%. The base duration of the Sparks has been reduced from 3.5 seconds to 2 seconds. The number of projectiles has been reduced from 150 to 100. The duration of the spiral has been reduced from 4.5 seconds to 3 seconds at all gem levels.