MicroPosts

All14 Business2 Gif1 Html1 Idea Generation1 JavaScript1 Learning1 Math1 Postgres1 Project Management1 RegExp1 Statistics2 UX1

Convert RDA to CSV with a script

Throw the following into rda2csv.r:

#!/usr/bin/env Rscript

argv <- commandArgs(TRUE)
inFile <- toString(argv[1])
print(paste("Reading:", inFile))

outFile <- gsub(".rda$", ".csv", inFile)
print(paste("Writing:", outFile))

inData <- get(load(inFile))
write.csv(inData, file=outFile)

Make it executable: chmod +x rda2csv.r

And run it on an RDA file: ./rda2csv.r path/to/file.rda

Risking millions on coin flips
Using the Binomial Distribution to tilt the odds in your favor.
I found this pearl in Naked Statistics (chapter 5):

In 1981, the Joseph Schlitz Brewing Company spent $1.7 million for what appeared to be a shockingly bold and risky marketing campaign for its flagging brand, Schlitz. At halftime of the Super Bowl, in front of 100 million people around the world, the company broadcast a live taste test pitting Schlitz Beer against a key competitor, Michelob. Bolder yet, the company did not pick random beer drinkers to evaluate the two beers; it picked 100 Michelob drinkers.

It turns out, Schlitz's marketing department was not a bunch of idiots. And here's why.

If you toss a coin twice you can get either one of the following:
1. heads, heads
2. tails, tails
3. heads, tails
4. tails, heads
Therefore, the probability of getting one tails out of two flips is 2/4 (ie, case 3. and 4.).

That is described by the Binomial Distribution where n is the number of trials (coins) and k is the number of successes (tails):
```
p = n! / [k! * (n - k)!] * (1/2)^n
    2! / [1! * (2 - 1)!] * (1/2)^2
    2  / 1               *  1/4
    1/2 (same as 2/4 from above)
```
The statisticians at Schlitz considered that:
- commercial beers taste the same
- in a blind tasting, a Michelob drinker would say that Schlitz tastes better 50% of the times (it's a coin flip)
- getting 40% or more of Michelob drinkers to say Schlitz is better is worth $1.7 million
But what's the probability?

If you take 10 Michelob drinkers, you need at least 4 successes. In other words, you want to sum the probability of 4, 5, 6, 7, 8, 9, and 10 tails with coin flips:
```
p = 10! / [4! * (10 - 4)!] * (1/2)^10 +
    10! / [5! * (10 - 5)!] * (1/2)^10 +
    ...
    10! / [10! * (10 - 10)!] * (1/2)^10
  = 0,82
```
So there's a 82% chance of succeeding.

And if you raise the number of drinkers to 100, you get to a shocking 98%!
The "opposite" test
When "positioning" something, if the opposite of what you claim is bullshit, what you claim is bullshit.

If you've ever heard any of the following statements:
- Our company is customer-first
- Our product is fast & easy-to-use
Ask yourself:
- Would any company pick customer-last as a strategy?
- Would any product go for slow & hard-to-use?
Nope. Because that's bullshit!
How big things get done
How big things get done published the following breakdown:
- 100% of the mega-projects analyzed
- 47.9% finished on budget
- 8.5% finished on bugdet and time
- 0.5% finished on budget, time, and produced the expected benefits
Later, the book analyzes what are the prerequisites to get into the 0.5% Olympus:
- Know why all the time: is this code rewrite benefitting the product?
- Think slow, act fast:
  - Make mistakes in the planning phase when screw-ups are cheap
  - The more time the execution phase takes, the more you expose yourself to black swans (ie, catastrophic and unexpected events)
- Mitigate risks:
  - Spike code to understand if and how something can be done
  - Ask people who worked on similar features what went wrong/could have been done better
- Estimate using anchors:
  - Hofstadter’s Law: “It always takes longer than you expect, even when you take into account Hofstadter’s Law.”
  - We always estimate with the happy case in mind and, even the most paranoid, cannot prepare for unknown unknowns
  - Ask others what was their experience building a similar thing and use their numbers as a starting point
- Lean on experience:
  - Involve people who've worked on similar features in the past
  - Learn from other similar projects—and no, you are not working on anything so unique that cannot draw from experience
  - Use boring tech: "remove the words custom and bespoke from your vocabulary"
- Build a team
- Iterate:
  - "we're terrible at getting things right the first time"
  - "I have not failed ten thousand times," Thomas Edison said. "I’ve successfully found ten thousand ways that will not work."
  - "If something works, you keep it in the plan. If it doesn’t, you “fail fast,"
  - When talking about the success of the Empire State Building, "workers didn’t build one 102-story building, they built 102 one-story buildings."
The following sentence made me stop and think about my fuck-ups:

When delivery fails, efforts to figure out why tend to focus exclusively on delivery. That’s understandable, but it’s a mistake, because the root cause of why delivery fails often lies outside delivery, in forecasting, years before delivery was even begun.
Learning requires sweating

Learning is not supposed to be fun. It doesn't have to be actively not fun either, but the primary feeling should be that of effort.

If you are not sweating, it's entertainment, not learning.

Source: Andrej Karpathy on X

Horizontally scroll to center an element

<div class="width-full overflow-x-auto">
  <div>...</div>
  <div>element</div>
  <div>...</div>
</div>

const viewportWidth =
  Math.max(document.documentElement.clientWidth, window.innerWidth || 0)

container.scrollLeft =
  element.offsetLeft // scroll to the left edge of element
  + element.offsetWidth / 2 // scroll to center of element
  - viewportWidth / 2 // scroll back half the viewport

Comment your regular expressions

# ❌
usa_postal_code_pattern = /\A\d{5}(-\d{4})?\z/

# ✅
usa_postal_code_pattern = %r{
  \A # Beginning of string
  \d{5} # 5 digits
  ( # ZIP+4
    - # Hyphen
    \d{4} # 4 digits
  )? # ZIP+4 is optional
  \z # End of string
}x

Source: Comment your regular expressions

Dreamweaving unforgettable experiences
Will Guidara hires Dreamweavers in his restaurant.

Their job is to pull legends: creating, automating, and scaling unforgettable experiences.

Source: The Hospitality Solution in Your Business
The 95/5 rule
Balancing out what's best for the user vs what's best for the business

Every decision I made seemed to expose the natural tensions between improving the quality of the experience the guests were having and doing what was best for the business. Restaurant-smart meant leading with trust—including allowing the people who worked for me to do what they felt was best for the guests. Corporate-smart meant running a tight ship. Which was right?

Will Guidara's answers his own question:

Manage 95% of your financials down to the penny while spending the remaining 5% “foolishly”, and “splurging” the 5% on the guest experience to create an unforgettable experience.

Source: Will Guidara: Restaurant Smart vs Corporate Smart
Find unused indexes in Postgres
How to use the `pg_stat_user_indexes` table
SELECT * FROM pg_stat_user_indexes WHERE relname = 'TABLE_NAME':
- idx_scan: how many times the index was used
- idx_tup_read: how many index entries were returned using the index
- idx_tup_fetch: how many rows were returned using the index
You want:
- idx_scan to move up (ie, the index is used)
- idx_tup_read/idx_tup_fetch to move up but not too much (ie, the index is highly selective)
Source: sgerogia.github.io/Postgres-Index-And-Queries/
How to find content ideas
A cheap trick for unlimited inspiration
1. Find a relevant subreddit
2. Google: "how to" site:reddit.com/r/SUBREDDIT/
Here are the top results for "how to" site:https://www.reddit.com/r/javascript/:
- "How to actually Learn from the Documentation?"
- "How do I practice JavaScript?"
- "How did you learn Javascript?"
- "How to become a more well rounded dev"
- "How to develop android apps with javascript?"

Html `<template>`

Hidden and re-usable pieces of Html

In some situations, you may want to render some hidden Html that can be later accessed by JavaScript to use as a template.

For example, a form to create a survey with a title and multiple questions:

<form>
  <input type="text" name="title" placeholder="Enter title" />
  <button type="button" onclick="addQuestion()">Add question</button>
  <p>Question</p>
  <input type="text" name="question" placeholder="Enter question" />
</form>

<template>
  <p>Question</p>
  <input type="text" name="question" placeholder="Enter question" />
</template>

<script>
  function addQuestion() {
    const template = document.querySelectorAll("template")[0].content;
    const clone = template.cloneNode(true);
    document.querySelectorAll("form")[0].appendChild(clone);
  }
</script>

What I used in the past is less elegant:

<form>
  <input type="text" name="title" placeholder="Enter title" />
  <button type="button" onclick="addQuestion()">Add question</button>
  <p>Question</p>
  <input type="text" name="question" placeholder="Enter question" />
</form>

<div class="template" style="display: none;">
  <p>Question</p>
  <input type="text" name="question" placeholder="Enter question" />
</div>

<script>
  function addQuestion() {
    const template = document.querySelectorAll(".template")[0];
    const clone = template.cloneNode(true);
    clone.style.display = "block";
    document.querySelectorAll("form")[0].appendChild(clone);
  }
</script>

Logarithm laws
A quick recap of some fundamental properties of logarithms
Power law

log_bpⁿ = n * log_bp

Proof:

log_bp = a -> b^a = p

Raise to k -> b^k*a = p^k

Apply log_b -> k * a = log_bp^k

Replace a with log_bp -> k * log_bp = log_bp^k

Product law

log_bm*n = log_bm + log_bn

Proof:

log_bm = i -> bⁱ = m & log_bn = j -> b^j = n

Multiply -> bⁱ * b^j = m * n

Simplify -> b^i+j = m * n

Apply log_b -> i + j = log_bm*n

Replace i and j -> log_bm + log_bn = log_bm*n

Quotient law

log_bm/n = log_bm - log_bn

Proof:

log_bm = i -> bⁱ = m & log_bn = j -> b^j = n

Divide -> bⁱ / b^j = m / n

Simplify -> b^i-j = m / n

Apply log_b -> i - j = log_bm/n

Replace i and j -> log_bm - log_bn = log_bm/n
Video to Gif oneliner
Using `ffmpeg` to transform an .mp4 into a .gif
This is how I created the demos for 3v0k4/exit.nvim:
- Recorded the screen with QuickTime into an .mp4
- Transformed into a .gif with ffmpeg
```
ffmpeg \
  -i input.mp4 \
  -vf "fps=10,scale=640:-1:flags=lanczos,split[s0][s1];[s0]palettegen[p];[s1][p]paletteuse" \
  -loop 0 \
  output.gif
```
Source: SuperUser

MicroPosts

Power law

Product law

Quotient law

PinkLetter

Tired of RELEARNING webdev stuff?