katopz

Get all d/l link as curl

Step

1. open https://huggingface.co/lllyasviel/sd_control_collection/tree/main
2. Run below code in browser console

let temp='';
document.querySelectorAll('a[href*="/resolve/"][href$=".safetensors"]').forEach(link => {
    const href = new URL(window.location.href).origin + link.getAttribute('href');
    temp+=`curl -OJL "${href}"\n`

katopz

// https://www.investing.com/currencies/usd-thb
setInterval(()=>{window.document.title = document.querySelectorAll('span[data-test=instrument-price-last]')[0].innerText}, 1000);

katopz

Find 3 space before any word.

^\s{3}(?=\w)

Find text between tag <h2>$1.1</h2>

const matched_values = text.match(/(">\$)(.*?)</gm)
const value = matched_values.length === 3 ? matched_values[2] : NaN

katopz

// https://gist.github.com/adisib/1e6b429b9bb630fceb170f3fa77c57a3

let ytPlayer = document.getElementById("movie_player") || document.getElementsByClassName("html5-video-player")[0];
let quality = ytPlayer.getAvailableQualityLevels()[0];
ytPlayer.stopVideo();
ytPlayer.setPlaybackQualityRange && ytPlayer.setPlaybackQualityRange(quality)
ytPlayer.setPlaybackQuality(quality);
let storedQuality = localStorage.getItem('yt-player-quality')
if (!storedQuality || storedQuality.indexOf(quality) === -1) {
  let tc = Date.now(),

katopz

# Switch main to head
git branch -f main head

# Force push
git push -f origin main

katopz

docker run --name foo-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres
docker inspect -f '{{ json .Mounts }}' foo-postgres | python -m json.tool

```
[
    {
        "Destination": "/var/lib/postgresql/data",
        "Driver": "local",
        "Mode": "",
        "Name": "8ce3df1ef910ec01686401a1fc8cdfff729aa2cd88ccac852c436badab7f3dea",

katopz

Open console and run this for 0px width ads. (ads still working, adjust width size to suite your need)

document.querySelector("body > div.flexrow.app > div:nth-child(2)").setAttribute('style','max-width:0px')

document.querySelector("body > div.flexrow.app > div").setAttribute('style','width:100%')
document.querySelector("body > div.flexrow.app > div > div.flexrow > div.panelblock.mainblock").setAttribute('style','width:100%')
const style = document.createElement('style');
style.type = 'text/css';
style.innerHTML = '.fixme { min-width:fit-content;overflow:unset; }';
document.querySelector("body > div.flexrow.app > div:nth-child(1) > div.flexrow").appendChild(style)

katopz

Open dev console and run this

document.querySelector(".AkiraPlayer").insertAdjacentHTML('beforebegin', `<div style="
    position: absolute;
    z-index: 999;
    color: black;
    background-color: black;
    width: 1px;
    height: 1px;
 display: block;

katopz

Ref

https://medium.com/google-cloud/bigquery-deduplication-14a1206efdbb

Deduplicate by recreate the Table

Slower

CREATE OR REPLACE TABLE `transactions.testdata`
PARTITION BY date
AS SELECT DISTINCT * FROM `transactions.testdata`;

katopz

fetch('https://covid19.th-stat.com/api/open/timeline')
  .then(response => response.json())
  .then(json => {
    const header = Object.keys(json.Data.shift()).join(',')
    const data = json.Data.map(e=>Object.values(e).join(',')).join('\n')
    console.log(header + '\n' + data)
  })