Categories
Mastering Development

What would cause this youtube embed string to stop working?

I save youtube links in a datastore for viewing in batches according to topic. I basically save the videoid with a caption note and the length data. I used php to construct a custom viewer. I’ve been using it for at least 10 months exactly the way I want. One breaking change to the format […]

Categories
Mastering Development

Python Pandas: Drop rows from data frame if list of string value == [none]

I have a column in my data frame that contains lists of values. Tags [marvel, comics, comic, books, nerdy] [new, snapchat, version, snap, inc] [none] [new, york, times, ny, times, nyt, times] [today, show, today, show, today] [none] [mark, wahlberg, marky, mark] I don’t know how to remove this [none] list from the data frame. […]

Categories
User Help

How do I simply replace a visual mode selection I’ve made in Vim with any amount of new words?

Today, I’m in a line and need to replace a few words to clarify an idea, like so: Superuser is THIS IS THE TEXT I WANT TO REPLACE awesome. After visual selection, however, being the novice I am, I hit r and type my intended replacement text: Superuser is aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa awesome. Uh oh! It’s singularly […]

Categories
Android User Help

How to enable treble support in old devices?

Today, I am back to challenge you all. As you would have guessed from the question title, this post is to know about enabling treble support on old phones. Of course, there are a lot of guides on the internet about this and I "will" explain how this post is different from them. First, we […]

Categories
Mastering Development System & Network

Unable to resolve IP address of our nameserver

Today, we suddenly started having intermittent problems checking our email, then getting to our web site. After some checking, we discovered it was a DNS problem. We were suddenly not able to resolve domain names externally – everything is fine on the local network. A dig +trace identified our nameservers, "ns3.ourdomin.net" and "ns4.ourdomain.net" but then: […]

Categories
Linux Mastering Development Ubuntu

How to install guest addition in ubuntu 20.04 LTS?

Today, i had installed ubuntu 20.04 LTS on latest virtualbox. everything is fine except Fullscreen. I tried to install guest addition by clicking on " Insert guest addition CD image ". At first , it said gcc make perl is not install on your ubuntu. i checked the installation step of gcc make perlon askubuntu […]

Categories
Mastering Development System & Network

Network Threat Protection

Today, my Database server unexpectedly restarted. After checking it, I found that since the start of December, I was getting this event, Network Threat Protection Event. Here’s the event Object detected. Object name: 64.76.157.3:51747 (different IP every time). Object type: N/A. Severity level: high. Certainty level: complete signature match. Detected object type: network attack. Detected: […]

Categories
User Help Web Apps

GOOGLE FINANCE SHEET

PLEASE EXPLAIN THE FOLLOWING FORMULA FOR GOOGLE FINANCE EXCEL SHEET. IT IS ACTUALLY FOR EVALUATING "MINIMUM" PRICE OF A STOCK IN LAST SIX MONTHS. WILL BE THANKFULL IF YOU CAN PLEASE ; (1) : CAN U EXPLAIN THE FORMULA IN PLAIN EGNLISH. (2) : ALSO, WHEN I PUT THIS IT SHOWS ERROR AND NOT WORKING. […]

Categories
User Help Web Apps

Get historical stock price in another currency

This formula returns the daily stock prices of A1 in the last two years: =GOOGLEFINANCE(A1,"Price",today()-(365*2),today(),"DAILY") This formula returns the daily conversion rate from USD to EUR: =GOOGLEFINANCE("Currency:USDEUR", "price", today()-(365*2),today()) I would like to put the two formulas together so that the historical stock prices are automatically given in EUR and not in USD. Is there […]

Categories
Database Development

AWS Aurora for PostgreSQL strange vacuum cost parameters

Today, I found out that in AWS Aurora for PostgreSQL 11 the default cluster parameter vacuum_cost_page_miss = 0 whereas vacuum_cost_page_hit = 1. I’d love to understand the logic behind pricing a page miss as cheaper than a page hit.