gquittet

SELECT
  TABLE_NAME AS `Table`,
  ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = "my_database"
ORDER BY
  (DATA_LENGTH + INDEX_LENGTH)
DESC;

gquittet

Replace Docker Desktop with Colima

1. Install required dependencies

brew install colima docker docker-credential-helper docker-buildx docker-compose docker-completion

2. Edit the docker configuration to use extensions and credentials helper (otherwise everything will be stored in clear)

gquittet

set commentary
set highlightedyank
set ideajoin
set surround

set scrolloff=5 sidescrolloff=10

" Line number
set relativenumber
set number

gquittet

#!/usr/bin/env bash
docker image ls -a | awk -F ' ' '{ print $7 }' | tail +2 | sed 's/B/i/' | numfmt --from=auto | awk '{n += $1}; END{print n}' | numfmt --to=iec-i

gquittet

(function () {
    'use strict';

    const feedContent = document.querySelector('.feed-content')
    const feedMain = document.querySelector('.feed-main')
    const sidebar = document.querySelector('.feed-right-sidebar')

    feedContent.style.maxWidth = "unset"
    feedMain.style.maxWidth = "100%"
    sidebar.style.maxWidth = "unset"

gquittet

import zlib from 'node:zlib';
import example from './example.json' assert { type: "json" };

const text = JSON.stringify(example);

const compressed = zlib.gzipSync(text).toString('base64').replace(/\//g, '_').replace(/\+/g, '-').replace(/=/g, '');

// H4sIAAAAAAAAE-3KsQ2AIBCG0V3-GhPu1ObmsJJQkGBhb2fcXRZggy955Suv7q7Y9qTenkshz74u2YfDLMyHU1_i8Xg8Ho_H4_F4PB6Px-PxeDwejzd99Qd5g3u1cRcAAA

gquittet

<!-- percent to deg => Math.round(((value / 100) * 180 - 45) * 10) / 10 -->

<div class="relative flex aspect-[2] items-center justify-center overflow-hidden rounded-t-full bg-blue-400">
  <div class="absolute top-0 aspect-square w-full rotate-[calc(72deg-45deg)] bg-gradient-to-tr from-transparent from-50% to-white to-50% transition-transform duration-500"></div>
  <div class="absolute top-1/4 flex aspect-square w-3/4 justify-center rounded-full bg-blue-100"></div>
  <div class="absolute bottom-0 w-full truncate text-center text-[20vmax] leading-none">40%</div>
</div>

gquittet

.Slot.middleCentre { 
    border-radius: 1rem;
    padding: 2rem 5rem;
    background-color: rgba(0, 0, 0, .20);
    backdrop-filter: blur(5px);
    box-shadow: 1px 0px 10px rgba(0, 0, 0, .20);
}

gquittet

#!/bin/sh
# you might want to add some user authentication here
mysql -uuser -ppassword -h127.0.0.1 -e "show variables; show status" | awk '
{
VAR[$1]=$2
}
END {
MAX_CONN = VAR["max_connections"]
MAX_USED_CONN = VAR["Max_used_connections"]
BASE_MEM=VAR["key_buffer_size"] + VAR["query_cache_size"] + VAR["innodb_buffer_pool_size"] + VAR["innodb_additional_mem_pool_size"] + VAR["innodb_log_buffer_size"]

gquittet

{
  "PresetList" : [
    {
      "AlignAVStart" : true,
      "AudioCopyMask" : [
        "copy:aac"
      ],
      "AudioEncoderFallback" : "ca_aac",
      "AudioLanguageList" : [