How do I load test my http server on azure without getting IP banned automatically

I have an Ubuntu Server VM running on Microsoft Azure and I need to do some custom load testing. I’ve written a Python script that makes the necessary requests. The issue is that I know Azure will block my IP automatically if I send too many requests per second. I don’t know what this threshold is though. I’d like to send as many requests per second as my local network and hardware will allow. I definitely don’t want to have to open a support ticket to get myself unbanned from connecting to the server though.

As far as I can tell everything inside of the VM is configured so that I won’t get blocked.

Does PostgreSQL have some ability to “compare” a backup with the live database automatically and neatly?

I make full backups of my PG databases each day. I store these pg_dumped archives/blobs in a dir on the same computer, as well as on offline disks, up to a year before they are culled.

I’m constantly worried that my “live” data is being either deleted or modified by accident or through malice. It would be extremely useful to be able to do something like:

pg_compare.exe "path to pg_dump of my database X" "Database X" --deletes --updates

And then it would return a JSON array of any records found in the dump but not in the live database, as well as any changes in existing data found between the backup and the live database. (It would not care about new INSERTed rows, of course.)

Basically (translated to human form):

1. The row in table "invoices" with "id" 4825 has changed its numeric "amount" column cell from "49" to "499".
2. The row in table "bookkeeping" with "id" 13459 is no longer present.
3. ...

At the very least, this would help against honest mistakes and severely help against my paranoia and fear. As I’m working in pgAdmin 4, for example, I’m always worried that maybe I had selected a row out of sight or something as I press that “trash can” icon and then the “accept changes” icon. I don’t want to lose data.

It’s important that this can be done in an automated fashion, constantly behind the scenes (or maybe once a day if it’s resource-demanding). It must not involve manual creating of databases and a bunch of complex custom SQL queries etc. And please, no extensions! I hate extensions.

Is there such an ultra-useful feature built into PG?

views – How do I set filters to reset automatically on new search?

I have a search and some filters on a drupal 7 site. If I search a term, for example “stuff”, and there are 30 results, I can click a checkbox filter (let’s call it FilterA) on the side and narrow my results down. But now if I type “things” in the search bar and submit it, FilterA is still clicked when the results come up. I need for all the filters to be unchecked when I perform a new search. I’ve gone through I feel every setting in the view and all the search and filter settings and still nothing. Thank you for any help you can provide.

audio – How do I automatically configure an Adapt Sound profile?

I have configured different audio profiles for each of my Bluetooth devices. How do I automatically configure to set a specific profile for each device?

I didn’t find a option using Bixby Assistant or the Tasker app. The only thing I managed to do was creating a direct shortcut to the setting using the Shotcut Maker app.

plugins – WordPress automatically removes line break

When writting a description for a Woocoomerce Product and inserting a line break with br or p Tag, WordPress automatically removes it. This is really annoying because on some points, i want to have a little line break.

I often found the solution to install TinyMCE. After that now WordPress doesnt removes the p Tag anymore but inserts a &nbsp inside of it and so the line break is way to big.

So i want a line break like a p Tag, because npsb produces way too much space between two sentence.

I also tried following solutions:

  1. add some attributes to the p Tag like <p data-x> </p>

  2. Wrap the p Tag with comments like

<!-- wp:html --> <p class="beer"></p> <!-- /wp:html -->
  1. Added some hooks in the functions.php like
add_shortcode("br", "br_tag"); function br_tag(){ return("<br/>"); }

or

remove_filter('the_content', 'wpautop'); remove_filter('the_excerpt', 'wpautop');

and

remove_filter( 'the_content', 'wpautop' ); remove_filter( 'the_excerpt', 'wpautop' ); function wpse_wpautop_nobr( $content ) { return wpautop( $content, false ); } add_filter( 'the_content', 'wpse_wpautop_nobr' ); add_filter( 'the_excerpt', 'wpse_wpautop_nobr' );
  1. I tried following solution but it doesnt work WordPress automatically adding “&nbsp;”?

The “best” solution i found was to NOT using the visual AND the text editor, but for me thats such a temporary one.

Specs:

WordPress 5.6

Advanced Editor Tools (previously TinyMCE Advanced): 5.6

WooCommerce: 4.6.1 (but in my opinion, its not a WooCommerce problem)

Does anyone know a better solution or a reference for that problem?

sharepoint online – Automatically create folder within multiple document libraries

We have a client who has all their client folders in sharepoint online, they usually every year go ahead and manually create a new folder within each client folder with the year (2021).

They have asked if there is a way to automatically create a folder within each separate client folder rather than doing it manually

Help?!

macos – Big Sur 11.1: AppleScript to Automatically Change Wi-Fi Networks

So, like a user reported here on Stack Exchange, the built-in “networksetup” command in terminal is pretty unreliable at times. It’s slow, and I’ve found for some reason dot1x never actually establishes properly for some types of Wi-Fi networks in my home. The solution: Create an AppleScript to simulate mouse clicks on the menubar to change between Wi-Fi networks.

Why is networksetup so slow compared to manually changing Wi-Fi networks?

The below script has worked fine for me until Big Sur:

use application "System Events"

property process : a reference to application process "SystemUIServer"
property menu bar : a reference to menu bar 1 of my process
property menu bar item : a reference to (menu bar items of my menu bar ¬
    where the description contains "Wi-Fi")
property menu : a reference to menu 1 of my menu bar item
property menu item : a reference to menu items of my menu


to joinNetwork given name:ssid as text
    local ssid
    
    if not (my menu bar item exists) then return false
    click my menu bar item
    
    repeat until my menu exists
        delay 0.5
    end repeat
    
    set M to a reference to (my menu item where the name contains ssid)
    
    repeat 20 times --> 10 seconds @ 0.5s delay
        if M exists then exit repeat
        delay 0.5
    end repeat
    click M
end joinNetwork

joinNetwork given name:"my network ssid"

The reason why it broke is that Wi-Fi is no longer technically a direct option under the main menu bar. Instead, it’s relegated to the Control Center in Big Sur, and I think there may even be another sub-module it’s technically nested it within the UI. I’ve been reading for hours about people trying to overcome this challenge in Big Sur, for example, to automate a click on specific Bluetooth device, but many AppleScripts people wrote apparently broke in the 11.1 update, and I have no easy starting point here for how to figure out how to accomplish what I am trying to do for Wi-Fi.

Any help here would be tremendously appreciated.

Side note: I know the same user also posted a method using AppleScriptObjC, but as people pointed out, it’s a huge security risk because you need to put your password somewhere as plaintext. The UI script is therefore the better option in my mind, so I’d like to get it to work again.

Excel: How to get address of a refered cell automatically, even after changing it’s absolute address?

is ther any way (i.e. function) to show the address of a certain cell in Excel sheet, even after the user inserts or deletes rows or columns or sorts the sheet? For instance, if a cell address is G10, I see this string (“G10”) in another cell, and after inserting a column between A and B, the string changes to “H10”.

I appreciate any help.