Categories
Apple User Help

grep ^\. not working as expected in Mac terminal

if I run the following command in my mac terminal: ls -al | grep ^\. or ls -al | grep ‘^\.’ or ls -al | grep "^\." I get no results back even though there are several files in my home directory that meet this criteria. I tried this in both bash and zsh, and […]

Categories
User Help Web Apps

How to export a Confluence page to Google Docs and apply Template

I would like to export Confluence page(s) directly as a Google Doc and apply Google Docs Templates at the same time. I expected that others would have done this but a google search has been unable to find anything.

Categories
Ask Health Medical

Why are some medicines recommended to be taken with a high dose and low frequency?

Alendronate sodium is an osteoporosis medicine commonly recommended as a once-a-week 70 mg dose. Why not 35 mg twice a week? or 10 mg daily? I am guessing that a more steady intake like this would be just as effective but is not recommended simply because daily doses means a daily burden (e.g., avoiding food, […]

Categories
Game Creation Mastering Development

Sending different message on a game level after different amounts of time

So, I am working on an interactive game to aid with anxiety management. In one of the gameplay options, the player has to press buttons for a certain amount of time. Only after the required time has lapsed (with the player holding the buttons down), will the avatar move. So, for example the instruction will […]

Categories
Database Development

Query tuning update with hash flow distinct operator

Need some help in understanding the slowness in one of the UPDATE statements like below:- UPDATE TOP (100) xyz SET xyz.flag = 1 OUTPUT inserted.Rcode, inserted.EDR, inserted.id, abc.EID,abc.CID,abc.ENID,abc.Cdate FROM dbo.table1 xyz WITH (UPDLOCK, READPAST) INNER JOIN dbo. table 2 abc WITH (NOLOCK) on xyz.id=abc.id WHERE xyz.flag = 0 Indexes available Table 2 : PK_ENID: Clustered […]

Categories
Database Development

mariabackup crashing, help

Hi I’m using mariabackup on one of my MariaDB 10.5.4 nodes from my Galera Cluster and whenever I run it i get this from my output logs: [00] 2020-08-05 11:26:40 Connecting to MySQL server host: localhost, user: mariabackup, password: set, port: 3306, socket: /mdb/mysql-data/mysql.sock [00] 2020-08-05 11:26:40 Using server version 10.5.4-MariaDB-log mariabackup based on MariaDB […]

Categories
Database Development

High autovacuum CPU/IO usage from database with more than 10k append-only tables

In my system I have more than 10k tables that are very similar, I only do insert operations in these tables and delete old data via a cron schedule one time per day. These insertions come each minute, a mean of 5 rows per table which are inserted in a single insert query, meaning something […]

Categories
Database Development

Proxying a Postgres connection

I have a client whose Postgres database I need to connect to periodically. This database is currently hosted on their server, let’s call it psql.example.com, with standard port 5432. They have it configured so that I can connect to it from my "primary" server, let’s say that’s on IP 123.45.67.89, using my_username and my_password as […]

Categories
User Help Web Pro

How to configure Apache to Relay/Proxy Requests to Localhost Port?

Note: I have read several possible solutions to my question but some are old, the syntax of httpd.conf has changed and/or do not correspond exactly to my situation. I am simply trying to find the proper incantations to have Apache forward requests as follows: Port 80 ==> Port 3000 In general, let’s say that there […]

Categories
Ask Games RPG Games

If a dragon becomes a shadow dragon, would it still be subject to a previously cast True Polymorph’s reversal?

Story / example: A Harpy gets Truly Polymorphed into a wyrmling Brass dragon. Over eight centuries she eventually becomes ancient and powerful – albeit a bit weird with her harpy-like personality and alignment. As an avid reader of StackExchange she becomes a bit paranoid. She is concerned: should a Magical Dispelling get past her three […]