Delayed or Asynchronous DML Trigger Execution

I have created a DML trigger (AFTER INSERT, UPDATE, DELETE) on a table
Trigger’s logic takes about 30 seconds to execute

So if you change even 1 row, it takes about 30 seconds due to trigger execution
Developer asked me "Is there a chance that the trigger could be a fire & forget action?"

I said no, but is it really so ?

Question:

Can trigger be executed in "asynchronous" mode?
Application updates couple of rows in few ms, and thinks that transaction is completed, and then trigger is silently executed under the hood ?

I understand that this actually does not look good from consistency point of view, but still, is it possible ?

Does Heart of the Storm still trigger if the spell was countered?

The Storm Sorcerer has an ability called Heart of the Storm:

At 6th level, you gain resistance to lightning and thunder damage. In addition, whenever you start casting a spell of 1st level or higher that deals lightning or thunder damage, stormy magic erupts from you. This eruption causes creatures of your choice that you can see within 10 feet of you to take lightning or thunder damage (choose each time this ability activates) equal to half your sorcerer level.

Counterspell is an interrupt:

You attempt to interrupt a creature in the process of casting a spell. If the creature is casting a spell of 3rd level or lower, its spell fails and has no effect.

So I’d argue that the damage from the ability triggers before Counterspell can even be cast, and thus the (relatively small damage at lower levels) still happens. Am I correct?

Can you Ready an attack with the trigger ‘enemy enters my reach’? If so, will you interrupt their movement on a hit?

Without using any feats, can a player with a reach weapon set that weapon to receive a ‘charge’ by the enemy, attacking them when they enter range? Or even a non-reach weapon? That is, can a player commit to using their attack action when an enemy crosses an arbitrary line with their movement? (Examples: Ready my glaive to attack when the orc gets 10′ away from me. Ready my shortbow to attack when the dragon enters 80′ from me. Ready my dagger in case the kobold comes adjacent.)

If this is possible, and the player’s attack hits, does it have any effect on the enemy’s remaining movement or other actions?

I think the answers are yes, and no, respectively.

Can an Unseen Servant trigger an Alarm spell, and can said Alarm be customized?

As an Unseen Servant is "shapeless", its size is not defined. The Alarm spell, however, relies on a creature’s size (Tiny or larger) to be activated. Therefore, I’m not sure if an Unseen Servant, when commanded to walk through a location containing an Alarm, would trigger said Alarm or not. I would think it does, but I might be wrong (maybe the Unseen Servant’s size value is "null"), hence the question.

Also, one of the two ways to receive an Alarm notification is mental. I’m wondering whether that notification can be customized, so that if the Unseen Servant crosses through Alarm #1, you can get a different "ping" than for Alarm #2. Again, I would think so, but it’s better to verify (maybe it’s always the same sound regardless).

Finally, I’m almost certain that if you go back and forth through an Alarm zone, you will repetitively get the "ping", but I just want to be 100% sure.

Can a Wildshaped Druid trigger Dive Attack twice in a turn?

So I have a lizardfolk moon druid and I was curious about the interaction between his bonus action Hungry Jaws ability and the Dive Attack ability of the Quetzalcoatlus.

"Dive Attack. If the quetzalcoatlus is flying and dives at least 30 feet toward a target and then hits with a bite attack, the attack deals an extra 10 (3d6) damage to the target."

"Hungry Jaws. In battle, you can throw yourself into a vicious feeding frenzy. As a bonus action, you can make a special attack with your bite. If the attack hits, it deals its normal damage, and you gain temporary hit points (minimum of 1) equal to your Constitution modifier, and you can’t use this trait again until you finish a short or long rest."

Now if I Dive Attack I can use my action to bite and receive the Dive Attack bonus damage.

My question is if I also use my bonus action Hungry Jaws to bite does it also benefit from the Dive Attack bonus damage?

Does fire shield damage trigger if cloud rune is used

If a wizard cast fire shield and is later hit by a melee attack, then a fighter uses cloud rune to switch targets. Would the fire shield still do damage?

Fire Shield Whenever a creature within 5 feet of you hits you with a melee attack, the shield erupts with flame. The attacker takes 2d8 fire damage from a warm shield, or 2d8 cold damage from a cold shield.

Cloud Rune When you or a creature you can see within 30 feet of you is hit by an attack roll, you can use your reaction to invoke the rune and choose a different creature within 30 feet of you, other than the attacker. The chosen creature becomes the target of the attack, using the same roll. This magic can transfer the attack’s effects regardless of the attack’s range.

Does Brace trigger when an enemy enters my echo’s reach?

The subclass feature Manifest Echo explicitly covers attacking from the Echo’s location when taking the Attack action or when taking a specific reaction:

  • When you take the Attack action on your turn, any attack you make with that action can originate from your space or the echo’s space. You make this choice for each attack.

  • When a creature that you can see within 5 feet of your echo moves at least 5 feet away from it, you can use your reaction to make an opportunity attack against that creature as if you were in the echo’s space.

My Echo Knight picked the fighting style Superior Technique with the Combat Maneuver Brace. This gives my fighter a new trigger for using a reaction:

When a creature you can see moves into the reach you have with the melee weapon you’re wielding, you can use your reaction to expend one superiority die and make one attack against the creature, using that weapon. […]

If I understand correctly, this would mean when an enemy enters my Echo’s reach, it does not trigger Brace, because it isn’t mentioned as possible scenario’s for attack from the Echo’s location. Is this interpretation correct?


Related:

  • Does an Echo Knight fighter's echo provoke an opportunity attack when it moves?
  • Does turning around count as moving for triggering Brace?

I want the game over screen on this super mario bros C++ remake to trigger arduino/batch file

I found a someone who has listed the source code in C++ for their remake of Super Mario and I would like to know how I could edit the code for the "Game over screen" to trigger my Arduino or batch file (which ever is easier). The link to this source code is below. I’m pretty new but am every interested in getting this done. Any information would help. Thank you so much!

Github project link

Does resurrecting a creature killed by the disintegrate spell (or similar) with wish trigger the non-spell replicating penalties of the wish spell?

The first thing that causes me to question this, is the general design of it, which is more of a RAI assessment. From what I can tell, wish’s non-spell replicating punishment is meant to be a limit and punishment to keep players from breaking the game with repeated and frequent uses of wish to reshape the world and break every other rule of the game with a solid mechanical effect that doesn’t put the whole weight of that limitation on the GM’s shoulders.

From this perspective, using wish to resurrect someone killed by a spell that explicitly tells them that they have to use wish (or another 9th level resurrection spell) to resurrect someone is a fully intended system in the game, and thus should not be subjected to wish’s punishment for "trying to break the game"

The RAW argument for the resurrection not triggering the punishment is that, if the person has died within the last 10 days, the spell Reincarnate only requires you touch a piece of them (resurrection does not have the "piece of them" option), which the dust left behind by disintegrate could be argued to be, and the a new body is generated for them. Wish was used to replicate the spell. Therefore you are meeting the requirements of disintegrate (wish) and the requirements of the non-punishing wish (replicating a spell) and the requirements of Reincarnate (touching a piece of the body). So you should not have a chance to lose wish.

The argument for it not working is pretty straight forward. You are casting wish, invoking the text of the disintegrate spell, not replicating a spell of level 8 or less.

Also, this could seem like it is stepping on the toes of True resurrection. However True resurrection has a much longer timeframe, does not change the character’s race, and does not require the party to pick up all the dust if they can’t cast wish before a strong gust of wind picks up. It also only works to counteract disintegrate or other spells with the same effect in the same way that true resurrection does, it does not replace other reasons that true resurrection could be necessary, such as the body being taken out of the party’s reach.

Reincarnate(Relevant):

You touch a dead Humanoid or a piece of a dead Humanoid. Provided that the creature has been dead no longer than 10 days, the spell forms a new adult body for it and then calls the soul to enter that body. If the target’s soul isn’t free or willing to do so, the spell fails.

Wish(Relevant):

The stress of casting this spell to produce any effect other than duplicating another spell weakens you. After enduring that stress, each time you cast a spell until you finish a long rest, you take 1d10 necrotic damage per level of that spell. This damage can’t be reduced or prevented in any way. In addition, your Strength drops to 3, if it isn’t 3 or lower already, for 2d4 days. For each of those days that you spend resting and doing nothing more than light activity, your remaining recovery time decreases by 2 days. Finally, there is a 33 percent chance that you are unable to cast wish ever again if you suffer this stress.

Disintegrate (Relevant):

A disintegrated creature and everything it is wearing and carrying, except Magic Items, are reduced to a pile of fine gray dust. The creature can be restored to life only by means of a True Resurrection or a wish spell.

Personally, if this came up in play, I would not include wish’s punishment due to the first paragraph, however with the benefit of foresight, I am seeking a more informed answer.

Does blocking an attack with the Shield spell still trigger Armor of Agathys?

I am contemplating a Oath of Conquest Paladin / Sorcerer multiclass character, with a 1 level dip in hexblade warlock.

This character will have access to the Armor of Agathys and Shield spells, which potentially allows for a pretty nice combo.

The Shield spell states (PHB 275):

Casting Time: 1 reaction, which you take when you are hit by an attack or targeted by the magic missile spell…

Until the start of your next turn, you have a +5 bonus to AC, including against the triggering attack,

It looks like you are indeed hit by an attack, but since you have a bonus to AC, you can potentially force that attack to miss instead.

Armor of Agathys states (PHB 215),

If a creature hits you with a melee attack while you have these hit points, the creature takes 5 cold damage.

If I cast Shield and cause an attack that "hit" me to miss, does Armor of Agathys still deal damage?

I am leaning toward yes, though this combo seems a little too strong–Shield is already a strong spell, and this character will eventually have 9 1st level spell slots and a 7th level spell slot. Not only can they freely block attacks with Shield, but they can also deal up to 35 (5d10) damage to the attacker without an attack roll or saving throw. While a Warlock would have to spend both of their spell slots to do this once, my character would be able to do this 4 times with spell slots to spare.

Some notes:

  • Related questions ask about reducing the damage from a confirmed hit to zero. This question is asking about what happens when the Shield spell causes the attack to miss entirely.
  • A number of online resources, such as the Roll20 5th edition compendium, seem to be missing the correct casting time for the Shield spell. Answerers should make sure they’re looking at the correct version from the PHB.