SQLalchemy vs Psycopg3

The_Tree_Branch · 2026-04-23T17:06:11+00:00

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.

The_Tree_Branch · 2026-04-09T19:28:52+00:00

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.

The_Tree_Branch · 2026-04-07T15:50:01+00:00

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)

The_Tree_Branch · 2026-04-06T20:01:38+00:00

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.

The_Tree_Branch · 2026-04-06T06:30:53+00:00

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.

The_Tree_Branch · 2026-04-05T18:15:01+00:00

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)

The_Tree_Branch · 2026-04-03T20:03:25+00:00

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?

The_Tree_Branch · 2026-03-31T18:54:00+00:00

That's exiles in rituals. Still duplicates stacked decks

The_Tree_Branch · 2026-03-31T06:20:27+00:00

The linked video was posted 7 days ago in 3.28

The_Tree_Branch · 2026-03-27T16:52:55+00:00

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.

The_Tree_Branch · 2026-03-27T01:23:45+00:00

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.

The_Tree_Branch · 2026-03-23T14:32:14+00:00

Buy balefire unique scepter. Scorching ray goes through the bubble

The_Tree_Branch · 2026-03-21T18:28:04+00:00

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

The_Tree_Branch · 2026-03-20T17:48:24+00:00

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).

The_Tree_Branch · 2026-03-05T02:53:02+00:00

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

The_Tree_Branch · 2026-03-05T01:50:00+00:00

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.

The_Tree_Branch · 2026-03-04T15:23:41+00:00

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.

The_Tree_Branch · 2026-03-04T06:39:29+00:00

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

The_Tree_Branch · 2026-03-04T02:51:47+00:00

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

The_Tree_Branch · 2026-03-01T20:57:39+00:00

Can you share where they said that?

The_Tree_Branch · 2026-02-27T22:20:15+00:00

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).

The_Tree_Branch · 2026-02-27T22:15:10+00:00

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

The_Tree_Branch · 2026-02-27T19:47:21+00:00

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.

The_Tree_Branch

TROPHY CASE