@david_perell: If you're feeling stuck in your professional life, start writing online. Here's how it can accelerate your career:

1. Building a Network: Writing shrinks the world.

2. Building Expertise: Quality writing begins with clear thinking.

3. Team Truth-Seeking: If you write well about an industry, your readers will respond with ideas of their
   own.

4. High-Level Conversations: Many of the most important ideas aren't shared in public.

5. Build a Personal Monopoly:

The ultimate goal of writing online is to become known for having rare and valuable expertise.

Writer Jenée Desmond-Harris on how to divide your to-do list:

“I started dividing my to-do list into
1) things I have to do
2) things I want to do
3) things other people want me to do.

Life changing! I often don’t get to #3 and I finally realized… this is what it means to have boundaries.”

The accent-color CSS property sets the accent color for user-interface controls generated by some elements.

Physical therapist Dan Giordano demonstrates his 5 favorite foot stretches to promote better mobility and relief pain.

Big Toe Rockback

Only hold until you feel that stretch and then rock out of it and rock back.” Do five to eight of these.

Seated Knee Lift

Half-Kneeling 3D Ankle Series

This exercise moves in three directions. As you stretch out towards your front pinky toe, be sure to keep that heel grounded.

Downward Dog Calf Stretch

Foot Rolling

Do this for 30 to 60 seconds to increase blood flow to the area and give yourself a self-myofascial release.

Paul Klee famously said: “Art does not reproduce the visible but makes visible.” He seems to have meant that art does (or should) not reproduce what we see, but, rather, that it manufactures what we see. Under this interpretation, a painting is not a sort of mechanism that captures and displays existing visible data, but an engine to create a way of looking.

Thus, art does not reproduce the visible—what is commonly seen—but makes visible—what commonly is not seen, but which the artist has intuited in his or her own uncommon seeing, and makes visible to us.

Using one line of Perl, you can grab the price and even a picture of IKEA’s iconic cuddly shark toy!

https://phoenixtrap.com/2022/04/12/how-much-is-that-blahaj-in-the-terminal-window/

$ perl -Mojo -E 'say g("https://sik.search.blue.cdtapps.com/us/en/search-result-page", form => {types => "PRODUCT", q => "BLÅHAJ"})->json->{searchResultPage}{products}{main}{items}[0]{product}->@{qw(currencyCode priceNumeral)}'

5. Modularize Code with Common Table Expressions

CTEs create a temporary table that allow you to “query a query.”
https://www.essentialsql.com/introduction-common-table-expressions-ctes/

The advantage of a CTE (your second statement) over a derived table is that they can reference themselves and be used for recursion.

with avg_female_salary as (
   SELECT       AVG(salary) as avg_salary
   FROM       salaries
   WHERE gender = "Female"
)
SELECT name,  salary
FROM People
WHERE  salary >= (SELECT avg_salary FROM avg_female_salary)

7. Simplify Code using Temporary Functions

https://cloud.google.com/bigquery/docs/reference/standard-sql/user-defined-functions

CREATE TEMPORARY FUNCTION seniority(tenure INT64) AS (
   CASE WHEN tenure < 1 THEN "analyst"
        WHEN tenure BETWEEN 1 and 3 THEN "associate"
        WHEN tenure BETWEEN 3 and 5 THEN "senior"
        WHEN tenure > 5 THEN "vp"
        ELSE "n/a"
   END
);
SELECT name
       , seniority(tenure) as seniority
FROM employees

Free loaders & spinners for your next project. Built with HTML, CSS and a soupçon of SVG. Available for copypasta or as a tree-shakeable React component library.

This brief tutorial describes how can we limit network bandwidth in Linux using wondershaper script.

If you’re willing to be creative, a set of elastic bands can be as effective as a gym full of weights.

Filling out a form can frustrate anyone if it requires a high cognitive effort. A high cognitive effort causes users to think and work harder, increasing the time to complete the task. This experience can lead to page abandonment and lower conversion rates on a checkout form. To prevent this, apply these best practices to […]

In this video I show you how to install vinyl plank in a kitchen. I share several tips that will surely help you during your LVP Home Renovation. You will see how to install vinyl plank around cabinets, appliances and around the dishwasher.
These are tips anyone can use whether you are a pro or a DIY. These tips apply to all vinyl plank including lifeproof vinyl flooring.

<link rel="icon" href="favicon.svg" type="image/svg+xml">
<link rel="mask-icon" href="maskIcon.svg" color="#90FF00">
<link rel="shortcut icon" href="favicon.ico">

SVG FIRST!
I also suggest you get a good SVG editor that has a proper stripping/minimized save feature. For this I like to use Inkscape:
https://inkscape.org

Regularly flushing out your hot water heater is an important task. Getting rid of gunk and mineral deposits that accumulate will help it run more efficiently and prolong its life

PerlCon 2019 Rīga — Day 2 — 8 August 2019

https://perlcon.eu/talk/56

~20:00 - Window functions
~33:45 - CTE
~43:00 - Recursive CTE

This talk shows how to use SQL Window Functions (ISO SQL:2008) and how to use Common Table Expressions (CTE, ISO SQL:1999).

Using these two techniques, you can often avoid munging the query result afterwards. This potentially saves roundtrips between the program and the database.

The presentation assumes an intermediate familiarity with SQL. To get the most of the presentation, youshpuld be familiar with SELECT and JOIN. The Perl level is suitable for the beginner, but there will be very little Perl.

What are Window Functions?

Window functions are functions that perform calculations over multiple rows of the dataset while maintaining the same rows and row count of the original table.

4. CTE > Sub-queries

In most situations you want to use a CTE (common table expression) instead of a sub-query.

5. Using SUM and CASE WHEN Together

select 
     sum(case when allergies = 'Penicillin' and city = 'Burlington' then 1 else 0 end) as allergies_burl
   , sum(case when allergies = 'Penicillin' and city = 'Oakville' then 1 else 0 end)   as allergies_oak

from patients

Start where clause with true

where 1=1
and ...
and ...
and...

7. Don’t Forget About Window Functions

select
    p.*
  , MAX(weight) over (partition by city) as maxwt_by_city
 from patients p

Window functions are a great way to keep all of the data rows and then append another column with important aggregate details.

Converting a MacBook or other laptop into a screen-less "slabtop" is a completely different experience. Although Apple didn’t give us a computer inside a keyboard this year, you can just do it yourself.

Men over 40 can add the scorpion stretch, a floor based mobility exercise, to combat lower back pain and promote better movement.

Spiderman to Scorpion: Eb and Swole

To start, lie face-down on the floor, with your arms extended out on either side. Bend your left knee toward your glute, then squeeze the muscle to raise your left leg straight up, keeping your knee bent. Bring your left leg across your body—if you're able, try to touch the floor on the other side. Your torso will raise off the floor, but don’t let your hands move. Rotate your head along with the movement. When you’ve brought your left foot as close to the ground (and eventually, your right hand) as possible, hold the position for a beat. Then, slowly return to the starting position. Repeat the same movement for the right side of your body to complete one rep.

It’s the secret to high-performing teams — and strong marriages.

The average ratio for the highest-performing teams was 5.6 (that is, nearly six positive comments for every negative one). The medium-performance teams averaged 1.9 (almost twice as many positive comments than negative ones.) But the average for the low-performing teams, at 0.36 to 1, was almost three negative comments for every positive one.

Only positive feedback can motivate people to continue doing what they’re doing well, and do it with more vigor, determination, and creativity.