Jacob Chapman 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

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

	// ==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() {

	// ==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==

	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,

	┌──────────────────────────────────────────────────────────────┬──────────┐
	│ 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 │

	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

	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

	aaliyah
	abbatis
	abbrevs
	abditos
	abdominousness
	abductee
	abductees
	abductive
	aber
	abest

	// ==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==