chapmanjacobd

// ==UserScript==
// @name         Table Click Filter
// @namespace    http://tampermonkey.net/
// @version      0.1
// @description  Click a table cell, filter the column based on input.
// @author       You
// @match        *://*/*
// ==/UserScript==

(function() {

chapmanjacobd

// ==UserScript==
// @name         Auto-Activate Text Field on Hover
// @namespace    http://tampermonkey.net/
// @version      0.3
// @description  Automatically activates text fields when the mouse hovers over them, and only removes focus if not clicked.
// @author       You
// @match        *://*/*
// @grant        none
// ==/UserScript==

chapmanjacobd

CREATE TABLE all_data_types (
      id INTEGER PRIMARY KEY,
      boolean_col BOOLEAN,
      tinyint_col TINYINT,
      smallint_col SMALLINT,
      integer_col INTEGER,
      bigint_col BIGINT,
      utinyint_col UTINYINT,
      usmallint_col USMALLINT,
      uinteger_col UINTEGER,

chapmanjacobd

┌──────────────────────────────────────────────────────────────┬──────────┐
│                           license                            │ count(*) │
├──────────────────────────────────────────────────────────────┼──────────┤
│ https://rightsstatements.org/vocab/CNE/1.0/                  │ 2249     │
├──────────────────────────────────────────────────────────────┼──────────┤
│ https://rightsstatements.org/vocab/UND/1.0/                  │ 2902     │
├──────────────────────────────────────────────────────────────┼──────────┤
│ https://rightsstatements.org/vocab/InC-RUU/1.0/              │ 3526     │
├──────────────────────────────────────────────────────────────┼──────────┤
│ https://rightsstatements.org/vocab/InC/1.0/                  │ 23436    │

chapmanjacobd

PhotoPrism, LibrePhotos, Damselfly, and Immich

I chose to compare PhotoPrism, LibrePhotos, and Damselfly, because they seemed like the strongest freely available candidates for a large library of photographs.

I am mostly interested in face clustering (DBSCAN) and other "AI" capabilities like auto-categorization. Import speed is not as important to me as "playback" speed. I don't mind if it takes a few days but once everything is indexed and processed then it should be fast to explore everything.

The dataset that I used for this comparison was under 22GiB but over 750,000 images. Mostly AVIF files but some PNG and some JPEG.

Ease of installation

chapmanjacobd

def un_json(input_dict: dict[str, str | float]):
    processed_dict = {}
    for key, value in input_dict.items():
        if isinstance(value, str) and value.startswith(('{', '[')):
            try:
                processed_dict[key] = json.loads(value)
            except json.JSONDecodeError:
                processed_dict[key] = value
        else:
            processed_dict[key] = value

chapmanjacobd

function is_sparse_file
    set actual_size (du --block-size=1 "$argv" | awk '{print $1}')
    set apparent_size (du --block-size=1 --apparent-size "$argv" | awk '{print $1}')

    if test $actual_size -eq $apparent_size
        return 1
    else
        return 0
    end
end

chapmanjacobd

• reboot
• sudo btrfs rescue zero-log /dev/sdf1
• sudo btrfs check -s 1 -b /dev/sdf1
• sudo mount -o ro,rescue=all /mnt/d1

chapmanjacobd

aaliyah
abbatis
abbrevs
abditos
abdominousness
abductee
abductees
abductive
aber
abest

chapmanjacobd

// ==UserScript==
// @name         Hide Seen Rows
// @namespace    http://tampermonkey.net/
// @version      0.31
// @description  Remember and hide unique rows based on URL
// @author       Jacob Chapman
// @match        *://*/*
// @grant        none
// ==/UserScript==