Can 1 dmg be roughly estimated in Joules? [closed]

Related to this question: How many Joules does strength values ten through twenty estimate to?.

The same players are curious if the amount of force required to do 1 dmg can be roughly estimated in Joules?

Physics issues:

  • The primary worlds of D&D (Greyhawk, Forgotten Realms, and Dragonlance) have been established as having Earth-similar physics as the default when not overridden by psionics, magic, incarnum, etc..
  • All tests are taking place at sea level and in a gravity normal area (1 atmosphere, and 1G).
  • no special effects are interfering, allowing for normal physics to operate and be measured.
  • average humans are being used to conduct this experiment.
  • no beings were harmed in the process of these experiments.
  • Materials from the hardness / breaking tables are being used as targets, and are of a size and weight to exactly match the values listed on the table.

Though experiment issues:

  • Using the strength values given in the previous question, the Joules of STR bonus could be roughly estimate, however explosive striking force (from a punch or kick) is likely a different value from lifting a weight overhead force.
  • Effects like Control Fire give values of damage for different sizes of fire, and comparing the size of fire with the amount of damage it will do to various objects on the hardness/breaking tables which might serve as a possible yardstick to estimate.
  • HP is a universalized generalization which almost certainly does not equate to real world values of health and/or structural damage capacity of flesh or rock etc, for example, and average first level commoner might have an hp of 2, and a small pebble has 2 hp, but the amount of force required to deal "1 hp" of damage might not be equivalent.

It might not be possible to come up with an estimate value for 1 dmg due to the possibly inconsistent values of hp between different materials, however, please give it a go. Feel free to make whatever assumptions or estimates are necessary to come up with a rough estimate.

Do non-PostgreSQL database softwares use roughly the same “structure” for communicating with them?

Basically, I have developed a PostgreSQL-based application which "in theory" could have its database software swapped out, but probably would cause a million headaches if I actually attempted to. I’m trying to determine if the other SQL database softwares (I frankly don’t care about non-SQL ones in the least, because they seem too different for me to bother with them in this life) have the following concepts:

  1. "hostname"
  2. "port"
  3. "username"
  4. "password"
  5. "handle database" (such as "postgres", which must be used to connect when there is no other database or when certain operations are to be done to the actual database)
  6. "database name"

I guess I’m fairy sure already about all the points except for the 5th. The concept of a "handle database" seems like it might be PG-only. If such is the case, I’m not sure how I should handle that, but I’m awaiting your answers before I make a decision.

I have a good mind to just forget about ever supporting other database softwares, but the way my system is structured basically forces me to at least try to "genericize" the communication with the database with functions called "database_" rather than "PostgreSQL_". (Even when the queries sent to these functions would only work on PG…)

Is there a system that roughly equates to spot checks in 3.x?

I play a lot of AD&D 2nd edition, and it recently occurred to me that there isn’t a spot check or other mechanic for finding hidden items/objects. Later editions have the spot check, but should I use a similar mechanic for 2nd edition? If so, what would you recommend?

Currently, I simply roll to see if the PCs find hidden doors, or let them describe their search and see whether they check wherever I placed something hidden. However, it takes quite some time and gets a little boring by the tenth room they check.

Am I missing a rule or ability of some sort? What do you use, and why?

Please only valid rule quotes from 2nd edition or examples of actual play – I’m planning on sticking with AD&D 2e, and don’t need any system recommendation.

Roughly how much would it cost to hire a team of dwarves to build a home in the mountainside

Since I began dnd I had an idea to try to hire dwarven miners to build it into the cliff side. I am not expecting it to be huge and extravagant but it needs to be big enough for 4 people, one of whom has a large beast companion. This is just something I would be looking for in the future but if the cost is less than I expected I’m going to build it now. Any advice would be greatly appreciated.

Canon Kit Lens at (roughly) 50 mm focal length f/5.6 vs 50 mm f/1.8 Prime Lens stopped at f/5.6

Do prime lenses still have some advantage over kit lenses when the aperture is stopped down? I understand the primary benefit of a prime lens is the fast speed that you can get from wider aperture sizes. But When stopped down (to get a deeper depth-of-view) for example, does it matter which lens you use?

Thanks in advance, Shintaro