MariaDB views: I want to replace repeated multi-table joins in my queries with a view – are there any issues to watch out for?

Rather than

SELECT a.pk, b.pk, c.pk, d.name  FROM a JOIN b on b.pk = a.fk JOIN c on c.pk = b.fk JOIN d on d.pk = c.fk 

I can do

SELECT a_pk, b_pk, c_pk, d_name  FROM view_a_b_c_d 

I have a lot of this sort of thing through my code.

I’ve done a performance test, and the differences seem to be negligible, and I feel it would greatly tidy my codebase up and remove a lot of repetition.

But before I commit to that (as it’d be a big change with a lot of work and testing), I want to check that this IS a good thing to do. I didn’t study computer science and have no formal DBA training. I’m also a sole dev working on my own closed-source product. So I don’t get much input from the outside world, unless I strike out and ask for it.

Thank you – any opinions/experience appreciated.

Is there another +1 Charisma feat for a half-elf warlock who doesn’t want to be a “face”?

My half-elf warlock has 16 Charisma, and I’m considering taking the Elven Accuracy feat (XGtE, p. 74), which would boost his Charisma to 17. Since I definitely want 20 Charisma eventually, a +2 Cha ASI and a second +1 Cha feat would get me there.

However, every other feat I can find that offers +1 to Charisma falls into one of three categories:

  • Specific to some other race (e.g. Dragon Fear for dragonborn, from XGtE p. 74)

  • Redundant for a warlock (i.e. Resilient choosing Charisma, from PHB p. 168)

  • Related to being a “face” character (e.g. Actor, from PHB p. 165)

Since I am a half-elf warlock, and I’m not really looking to be a face character, these options seem to run counter to the sort of character I’m trying to build. Are there any other options? Charisma for my warlock is all about “spirit” and magic.

Any Wizards of the Coast material, including Unearthed Arcana, might be considered here.

Rewrite a folder name using .htaccess don’t want to work

I am wondering, why folder renaming doesn’t work. RewriteRule ^pl/(.*) public/$ 1

Lets say I have a url like:

site.com/public/index.html 

Now I want to rewrite the url to

site.com/pl/index.html 

"pl" is not a folder rather just a name!

The rest works fine. Why just that one rule doesn’t work?

my .htaccess

RewriteEngine on RewriteRule ^dekoracyjne.html$   decorative.php [NC,L] RewriteRule ^pl/(.*) public/$  1 RewriteRule ^dekoracyjne/(.*) decorative/$  1 RewriteRule ^techniczne.html$   architectural.php [NC,L] RewriteRule ^techniczne/(.*) architectural/$  1 RewriteRule ^show.html/([-\w]+)$   show.php?id=$  {products:$  1} [L] RewriteRule ^p.html$   product_configurator.php [NC,L] RewriteRule ^show_c\.html/([-*\w]+)$   show_c.php?cat=$  {catcolors:$  1} [L] RewriteRule ^(product_configurator)\.html/(\d+)&([-\w]+)$   $  1.php?prometheus_id=$  2&id=$  {products:$  3} [L] RewriteRule ^(ss_c)\.html/(\d+)&([-\w]+)$   $  1.php?prometheus_id=$  2&id=$  {products:$  3} [L] # Rewrite other ".html" requests to ".php" RewriteRule (.+)\.html$   $  1.php [L] 

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

As a sword and board Eldritch Knight do I need to put away my sword on my turn if I want to use Shield as a reaction?

Without Warcaster, I can’t cast spells with somatic components if I have both a shield and a sword in my hands. Putting my sword away or dropping it is a free action, however you can’t do free actions outside your turn. So if I want to be able to cast Shield on myself as a reaction, do I need to always put my sword away at the end of my turn? (This also means I won’t be able to capitalize on opportunity of attacks).