sheet.git
12 months agocodec: some random additional image and audio features
Mischa POSLAWSKY [Sun, 15 May 2022 23:30:24 +0000 (01:30 +0200)]
codec: some random additional image and audio features

AFAICT.

14 months agoperl: reduce dt column width for small 400-640px screens
Mischa POSLAWSKY [Mon, 13 Feb 2023 11:31:32 +0000 (12:31 +0100)]
perl: reduce dt column width for small 400-640px screens

14 months agoperl: grid layout of dl columns
Mischa POSLAWSKY [Mon, 13 Feb 2023 11:24:00 +0000 (12:24 +0100)]
perl: grid layout of dl columns

Same results without floats, being more manageable and adjustable.

14 months agodieren: fix function name to read table data
Mischa POSLAWSKY [Fri, 10 Feb 2023 09:12:51 +0000 (10:12 +0100)]
dieren: fix function name to read table data

Written using a preliminary variant which was later renamed.

14 months agoword/finder: prepare category references
Mischa POSLAWSKY [Mon, 11 Jul 2022 00:52:50 +0000 (02:52 +0200)]
word/finder: prepare category references

14 months agoword: declare postgresql sequences as identities
Mischa POSLAWSKY [Sun, 23 Oct 2022 22:29:26 +0000 (00:29 +0200)]
word: declare postgresql sequences as identities

14 months agodieren: less wolfish wolf alternative (bijenwolf)
Mischa POSLAWSKY [Sat, 24 Dec 2022 12:50:35 +0000 (13:50 +0100)]
dieren: less wolfish wolf alternative (bijenwolf)

14 months agolatin: improve tap code slash styling
Mischa POSLAWSKY [Sun, 23 Oct 2022 23:35:42 +0000 (01:35 +0200)]
latin: improve tap code slash styling

14 months agoword/quiz: decode uri-encoded location hash
Mischa POSLAWSKY [Tue, 17 Jan 2023 18:21:55 +0000 (19:21 +0100)]
word/quiz: decode uri-encoded location hash

Separator # not recognised in correct browsers like chrome.

14 months agoword/edit: consistent image height in download popup
Mischa POSLAWSKY [Tue, 17 Jan 2023 17:45:52 +0000 (18:45 +0100)]
word/edit: consistent image height in download popup

14 months agoword/edit: retain json columns to compare image source
Mischa POSLAWSKY [Tue, 17 Jan 2023 01:38:00 +0000 (02:38 +0100)]
word/edit: retain json columns to compare image source

Prevent downloads of unaltered images.

18 months agotermcol: translate zxarne orange to corresponding cga hue
Mischa POSLAWSKY [Mon, 17 Oct 2022 01:35:27 +0000 (03:35 +0200)]
termcol: translate zxarne orange to corresponding cga hue

Bright purple looks more like brown than dark yellow.

18 months agounicode: extipa glyphs introduced in unicode 14.0
Mischa POSLAWSKY [Tue, 16 Aug 2022 13:30:05 +0000 (15:30 +0200)]
unicode: extipa glyphs introduced in unicode 14.0

Replace some combining accents by precomposed upgrades.

18 months agotermcol: record personalised shiar terminal style
Mischa POSLAWSKY [Sun, 16 Oct 2022 01:49:28 +0000 (03:49 +0200)]
termcol: record personalised shiar terminal style

Designed in 2016 with common Linux compatibility.

18 months agotermcol: modern 4-bit including tic80 in legacy
Mischa POSLAWSKY [Sun, 16 Oct 2022 01:36:31 +0000 (03:36 +0200)]
termcol: modern 4-bit including tic80 in legacy

Reselect only distributed systems and useful retro creations, adding
sweetie16 and endesga data from lospec.

22 months agoword/quiz: objects to access row array elements
Mischa POSLAWSKY [Sun, 19 Jun 2022 00:20:22 +0000 (02:20 +0200)]
word/quiz: objects to access row array elements

22 months agomap/numbers: prefix describing emoji where possible
Mischa POSLAWSKY [Sun, 26 Jun 2022 14:50:36 +0000 (16:50 +0200)]
map/numbers: prefix describing emoji where possible

22 months agotermcol: pico8 (in game) and r/place palettes
Mischa POSLAWSKY [Fri, 8 Jul 2022 16:04:18 +0000 (18:04 +0200)]
termcol: pico8 (in game) and r/place palettes

22 months agomap: generic page to show data tables
Mischa POSLAWSKY [Sun, 26 Jun 2022 13:39:28 +0000 (15:39 +0200)]
map: generic page to show data tables

22 months agomap: additional and reordered dutch number mnemonics
Mischa POSLAWSKY [Wed, 4 Mar 2009 15:57:48 +0000 (16:57 +0100)]
map: additional and reordered dutch number mnemonics

22 months agomap: import 10x10 dutch numbers mnemonic
Mischa POSLAWSKY [Thu, 5 May 2005 00:47:19 +0000 (02:47 +0200)]
map: import 10x10 dutch numbers mnemonic

22 months agoword: restrict image size on wide screens
Mischa POSLAWSKY [Sat, 18 Jun 2022 13:07:14 +0000 (15:07 +0200)]
word: restrict image size on wide screens

22 months agoword: remove html fallback of gallery page
Mischa POSLAWSKY [Mon, 6 Jun 2022 22:10:55 +0000 (00:10 +0200)]
word: remove html fallback of gallery page

Transition to feature-complete finder script.

22 months agoword/finder: enable stylesheet on #debug option
Mischa POSLAWSKY [Mon, 6 Jun 2022 21:56:17 +0000 (23:56 +0200)]
word/finder: enable stylesheet on #debug option

22 months agoword/finder: debug styling for extended levels
Mischa POSLAWSKY [Mon, 6 Jun 2022 21:14:04 +0000 (23:14 +0200)]
word/finder: debug styling for extended levels

22 months agoword/quiz: automatic subpage setup including specific css
Mischa POSLAWSKY [Mon, 6 Jun 2022 19:58:24 +0000 (21:58 +0200)]
word/quiz: automatic subpage setup including specific css

22 months agoword/quiz: generic page container setup
Mischa POSLAWSKY [Mon, 6 Jun 2022 19:40:14 +0000 (21:40 +0200)]
word/quiz: generic page container setup

22 months agoword/quiz: dynamic lang(uage) option
Mischa POSLAWSKY [Mon, 6 Jun 2022 19:12:14 +0000 (21:12 +0200)]
word/quiz: dynamic lang(uage) option

22 months agoword/quiz: configuration presets from request hash
Mischa POSLAWSKY [Mon, 6 Jun 2022 18:44:05 +0000 (20:44 +0200)]
word/quiz: configuration presets from request hash

22 months agoword/finder: common method to format caption names
Mischa POSLAWSKY [Mon, 6 Jun 2022 17:00:35 +0000 (19:00 +0200)]
word/finder: common method to format caption names

22 months agoword: localised browser hyphenation instead of poor poc
Mischa POSLAWSKY [Mon, 6 Jun 2022 16:54:35 +0000 (18:54 +0200)]
word: localised browser hyphenation instead of poor poc

22 months agoword: prepare common setup of quizzy subpages
Mischa POSLAWSKY [Mon, 6 Jun 2022 16:53:45 +0000 (18:53 +0200)]
word: prepare common setup of quizzy subpages

22 months agoword: untranslated form column fallback
Mischa POSLAWSKY [Mon, 6 Jun 2022 14:45:51 +0000 (16:45 +0200)]
word: untranslated form column fallback

22 months agoword: missing images in translations
Mischa POSLAWSKY [Sun, 5 Jun 2022 23:24:40 +0000 (01:24 +0200)]
word: missing images in translations

22 months agoword: reference root categories
Mischa POSLAWSKY [Sun, 5 Jun 2022 22:48:31 +0000 (00:48 +0200)]
word: reference root categories

22 months agoword: reload page to apply changed location hash
Mischa POSLAWSKY [Sun, 5 Jun 2022 19:06:41 +0000 (21:06 +0200)]
word: reload page to apply changed location hash

22 months agoword: category references (recursive selection)
Mischa POSLAWSKY [Tue, 31 May 2022 00:43:20 +0000 (02:43 +0200)]
word: category references (recursive selection)

Ordered links instead of javascript calculation from full inventory.

22 months agodieren: primarily dutch page language
Mischa POSLAWSKY [Mon, 6 Jun 2022 16:54:06 +0000 (18:54 +0200)]
dieren: primarily dutch page language

22 months agoperl: resize date subtitles to normal
Mischa POSLAWSKY [Sun, 5 Jun 2022 19:01:16 +0000 (21:01 +0200)]
perl: resize date subtitles to normal

23 months agoapl: silence warning about printf parameters
Mischa POSLAWSKY [Wed, 1 Jun 2022 22:11:26 +0000 (00:11 +0200)]
apl: silence warning about printf parameters

23 months agocommon: silence warning in showlink about unused href
Mischa POSLAWSKY [Thu, 2 Jun 2022 21:53:27 +0000 (23:53 +0200)]
common: silence warning in showlink about unused href

23 months agoindex: abort before body for HEAD requests
Mischa POSLAWSKY [Sat, 29 Aug 2020 16:30:31 +0000 (18:30 +0200)]
index: abort before body for HEAD requests

23 months agodieren: generic extension syntax for secret exceptions
Mischa POSLAWSKY [Mon, 30 May 2022 15:56:33 +0000 (17:56 +0200)]
dieren: generic extension syntax for secret exceptions

23 months agodieren: external word include with prefixed beknopt picks
Mischa POSLAWSKY [Mon, 30 May 2022 15:40:02 +0000 (17:40 +0200)]
dieren: external word include with prefixed beknopt picks

23 months agodieren: map table rows to array dimensions
Mischa POSLAWSKY [Mon, 30 May 2022 15:32:23 +0000 (17:32 +0200)]
dieren: map table rows to array dimensions

Just parse the text data instead of working around qw// list results.

23 months agosc: lotv patch 5.0.9
Mischa POSLAWSKY [Mon, 30 May 2022 02:16:47 +0000 (04:16 +0200)]
sc: lotv patch 5.0.9

23 months agoperl: summarise v5.36 release notes
Mischa POSLAWSKY [Sun, 29 May 2022 21:46:46 +0000 (23:46 +0200)]
perl: summarise v5.36 release notes

23 months agosc: single row >48em width by omitting category column
Mischa POSLAWSKY [Sun, 29 May 2022 13:05:35 +0000 (15:05 +0200)]
sc: single row >48em width by omitting category column

Fit larger styling on intermediate widths below 52em.

23 months agosc: attack order primarily by damage, only fallback to size
Mischa POSLAWSKY [Sun, 29 May 2022 12:25:32 +0000 (14:25 +0200)]
sc: attack order primarily by damage, only fallback to size

23 months agosc: update mode specials metadata
Mischa POSLAWSKY [Sun, 29 May 2022 11:26:56 +0000 (13:26 +0200)]
sc: update mode specials metadata

23 months agosc: separate bonus damage indicators, recognise structure target
Mischa POSLAWSKY [Sun, 29 May 2022 11:26:29 +0000 (13:26 +0200)]
sc: separate bonus damage indicators, recognise structure target

23 months agosc: describe worker abilities notably mineral gathering
Mischa POSLAWSKY [Sun, 29 May 2022 09:52:10 +0000 (11:52 +0200)]
sc: describe worker abilities notably mineral gathering

From Liquipedia [1][2] and other sources [3] for required measurements.

[1] https://liquipedia.net/starcraft/Mining
[2] https://liquipedia.net/starcraft2/Mining_Minerals
[3] https://tl.net/forum/sc2-strategy/140055-scientifically-measuring-mining-speed

23 months agocodec: data expiry dependent on subpage type
Mischa POSLAWSKY [Sun, 15 May 2022 21:45:23 +0000 (23:45 +0200)]
codec: data expiry dependent on subpage type

Filename changed in commit v1.12-163-ge1c15e98e7 (2021-11-09)
[page request overrides image type].

23 months agofont: coverage data as cover array in primary hash
Mischa POSLAWSKY [Thu, 26 May 2022 21:02:23 +0000 (23:02 +0200)]
font: coverage data as cover array in primary hash

Single object for json compatibility.

23 months agoapl: operator data as array reference
Mischa POSLAWSKY [Thu, 26 May 2022 12:22:42 +0000 (14:22 +0200)]
apl: operator data as array reference

Avoid list rows for json storage.

23 months agocharset: split unicode includes from static encodings
Mischa POSLAWSKY [Mon, 23 May 2022 22:54:06 +0000 (00:54 +0200)]
charset: split unicode includes from static encodings

Code only in container charset.inc.pl include, with plp dependency for
common Data() to get most tables more quickly.

15 months agocharset: inline prebuilt characters table
Mischa POSLAWSKY [Mon, 23 May 2022 17:29:30 +0000 (19:29 +0200)]
charset: inline prebuilt characters table

Replace setup code as far as possible to run before static compilation.

15 months agolatin: group aliases similar to termcol ea
Mischa POSLAWSKY [Sat, 14 May 2022 15:41:13 +0000 (17:41 +0200)]
latin: group aliases similar to termcol ea

Replacing pairwise list access for order so the structure can be
represented as a proper hash table.

15 months agolatin: prefer cached json of static data include
Mischa POSLAWSKY [Sat, 14 May 2022 12:50:45 +0000 (14:50 +0200)]
latin: prefer cached json of static data include

Executing perl takes about 23ms (6ms if dumped with perlinc-static)
while parsing the same data from JSON takes just 1.2ms.

15 months agocommon: global Data() to parse perl code includes
Mischa POSLAWSKY [Thu, 26 May 2022 12:15:04 +0000 (14:15 +0200)]
common: global Data() to parse perl code includes

Same error reporting and possible upcoming extension.

23 months agocommon: treat exception references as alert parameters
Mischa POSLAWSKY [Sat, 14 May 2022 14:35:50 +0000 (16:35 +0200)]
common: treat exception references as alert parameters

Pass on debug messages from (possibly trapped) perl/plp errors.

23 months agobump versions of all pages with visible changes since v1.11 v1.13
Mischa POSLAWSKY [Thu, 26 May 2022 21:08:35 +0000 (23:08 +0200)]
bump versions of all pages with visible changes since v1.11

23 months agodieren: smaller title description to fit mobile
Mischa POSLAWSKY [Mon, 30 May 2022 16:32:39 +0000 (18:32 +0200)]
dieren: smaller title description to fit mobile

23 months agodieren: derived additions (leeuwerik, draak*, behemoth)
Mischa POSLAWSKY [Wed, 11 May 2022 21:34:14 +0000 (23:34 +0200)]
dieren: derived additions (leeuwerik, draak*, behemoth)

23 months agosc: redirect subpage aliases to absolute paths
Mischa POSLAWSKY [Sun, 29 May 2022 13:44:25 +0000 (15:44 +0200)]
sc: redirect subpage aliases to absolute paths

Fix root request without trailing slash.

23 months agoemoji: prevent image enlargement (outside of figure elements)
Mischa POSLAWSKY [Sat, 28 May 2022 13:21:18 +0000 (15:21 +0200)]
emoji: prevent image enlargement (outside of figure elements)

Accidentally scaled to full width since commit v1.12-0-g70012d8c59
(2020-05-06) [dieren: image figures captioned by names] not accounting
for these preexisting icons.

23 months agobrowser: numeric order of agent versions >99
Mischa POSLAWSKY [Sun, 22 May 2022 20:04:30 +0000 (22:04 +0200)]
browser: numeric order of agent versions >99

Pad 3 digits (or preferably not at all) to fix recent releases all going up
to unimaginably large numbers.

23 months agoword/edit: preserve unknown json values
Mischa POSLAWSKY [Sun, 22 May 2022 18:28:20 +0000 (20:28 +0200)]
word/edit: preserve unknown json values

Replace only submitted input, keep existing experimental properties.

23 months agolatin: unistrokes circles matched separately
Mischa POSLAWSKY [Sat, 14 May 2022 12:12:55 +0000 (14:12 +0200)]
latin: unistrokes circles matched separately

Code cleanup to silence perl warning about redundant sprintf argument.

23 months agoword/memory: adjust grid count to fit size
Mischa POSLAWSKY [Fri, 25 Mar 2022 15:28:57 +0000 (16:28 +0100)]
word/memory: adjust grid count to fit size

2 years agocommon: sticky table header row
Mischa POSLAWSKY [Tue, 1 Mar 2022 20:15:27 +0000 (21:15 +0100)]
common: sticky table header row

Keep column legends visible while scrolling through larger tables,
especially digraphs and font where cells are much alike.

2 years agodieren: constant cell width for any gallery table
Mischa POSLAWSKY [Mon, 14 Feb 2022 17:09:14 +0000 (18:09 +0100)]
dieren: constant cell width for any gallery table

Common styling without percentage hints, replacing table elements by grid
columns with something resembling 1fr widths.

2 years agocli: frontend page listing commandline parameters
Mischa POSLAWSKY [Fri, 6 Sep 2019 20:54:05 +0000 (22:54 +0200)]
cli: frontend page listing commandline parameters

2 years agocli: mkclioptions core program presets
Mischa POSLAWSKY [Fri, 6 Sep 2019 18:57:42 +0000 (20:57 +0200)]
cli: mkclioptions core program presets

Input group names for selected entries from debian coreutils, bsdmainutils,
git subcommands, others.

2 years agofont: path to roboto fonts changed on debian
Mischa POSLAWSKY [Mon, 21 Feb 2022 11:41:10 +0000 (12:41 +0100)]
font: path to roboto fonts changed on debian

2 years agoword/edit: hide manual crop coordinates input
Mischa POSLAWSKY [Tue, 11 Jan 2022 00:12:17 +0000 (01:12 +0100)]
word/edit: hide manual crop coordinates input

Managed by js interface, values not needed as long as it works correctly.
Being hidden prevents workarounds so bugs are maybe forced to be fixed.

2 years agoword/memory: webkit prefix for turned card faces
Mischa POSLAWSKY [Sun, 20 Feb 2022 17:57:11 +0000 (18:57 +0100)]
word/memory: webkit prefix for turned card faces

Workaround for some versions of Safari where images are always visible.

2 years agoword/finder: .large images with multiple subcategories
Mischa POSLAWSKY [Thu, 10 Feb 2022 03:17:00 +0000 (04:17 +0100)]
word/finder: .large images with multiple subcategories

Automatic subdivision for a result similar to the previous cover attribute
without requiring manual maintenance.

2 years agoword: hover gallery captions only on larger screens
Mischa POSLAWSKY [Sat, 19 Feb 2022 15:37:07 +0000 (16:37 +0100)]
word: hover gallery captions only on larger screens

2 years agodigraphs: fix relative path in shiar include tool
Mischa POSLAWSKY [Thu, 17 Feb 2022 14:35:53 +0000 (15:35 +0100)]
digraphs: fix relative path in shiar include tool

Another one missed in commit v1.10-63-g00ffc9287b (2018-03-05)
[tools: fix includes from relative paths for perl v5.26].

2 years agotools: validate utf8 encoding in stdin/out
Mischa POSLAWSKY [Thu, 17 Feb 2022 14:33:39 +0000 (15:33 +0100)]
tools: validate utf8 encoding in stdin/out

Recommended by perlcritic.  Not likely to be an issue in these cases,
but might yet catch some data errors.

2 years agoword/finder: order by grade within levels
Mischa POSLAWSKY [Thu, 10 Feb 2022 03:21:22 +0000 (04:21 +0100)]
word/finder: order by grade within levels

2 years agoword/finder: caption text width bound to figure box
Mischa POSLAWSKY [Mon, 7 Feb 2022 18:13:36 +0000 (19:13 +0100)]
word/finder: caption text width bound to figure box

2 years agoword/finder: emulate gallery page in javascript
Mischa POSLAWSKY [Tue, 8 Feb 2022 22:04:22 +0000 (23:04 +0100)]
word/finder: emulate gallery page in javascript

Prepare replacement of the server-side index page.

2 years agoword: margin exception in common stylesheet
Mischa POSLAWSKY [Mon, 7 Feb 2022 17:42:16 +0000 (18:42 +0100)]
word: margin exception in common stylesheet

2 years agosource: create missing cache subdirectories
Mischa POSLAWSKY [Thu, 27 Jan 2022 22:45:50 +0000 (23:45 +0100)]
source: create missing cache subdirectories

Fix storage of modules such as Shiar_Sheet::Keyboard.

2 years agoword/edit: read fractional crop coordinates
Mischa POSLAWSKY [Sun, 23 Jan 2022 00:51:12 +0000 (01:51 +0100)]
word/edit: read fractional crop coordinates

Clean up various separators (,-x;:/) from manual input into common comma,
and allow dot for possible future fractions in large numbers:

UPDATE word SET image = jsonb_set(image, '{crop32}',
regexp_replace(image->>'crop32', '[^0-9,]', ',', 'g')
) WHERE image->>'crop32' IS NOT NULL;

Decided against dividing by 1000 to simplify code, but this would do that:

UPDATE word SET image = jsonb_set(image, '{crop32}',
to_jsonb(array_to_string(array(
SELECT unnest(string_to_array(image->>'crop32', ','))::float / 1000
), ','))
) WHERE image->>'crop32' IS NOT NULL;

2 years agoword/edit: fix (vertical) scale with different aspect ratios
Mischa POSLAWSKY [Sat, 22 Jan 2022 20:34:45 +0000 (21:34 +0100)]
word/edit: fix (vertical) scale with different aspect ratios

2 years agoword/edit: image container only needed for source
Mischa POSLAWSKY [Wed, 19 Jan 2022 19:35:36 +0000 (20:35 +0100)]
word/edit: image container only needed for source

2 years agounicode: mathematical hebrew symbols like greek a-b
Mischa POSLAWSKY [Mon, 17 Jan 2022 17:15:59 +0000 (18:15 +0100)]
unicode: mathematical hebrew symbols like greek a-b

2 years agounicode: colour blocks row of hues in unicode 12.0
Mischa POSLAWSKY [Mon, 17 Jan 2022 17:15:50 +0000 (18:15 +0100)]
unicode: colour blocks row of hues in unicode 12.0

2 years agounicode: one set of barb arrows from unicode 7.0
Mischa POSLAWSKY [Mon, 17 Jan 2022 17:13:24 +0000 (18:13 +0100)]
unicode: one set of barb arrows from unicode 7.0

Replace old private use variants by "modern" codepoints.  Limit to one
representative from Arrows-C for now.

2 years agounicode: circled playstation control symbols
Mischa POSLAWSKY [Mon, 17 Jan 2022 17:11:18 +0000 (18:11 +0100)]
unicode: circled playstation control symbols

Variant set completed in Unicode 11.0 with limited font support.

2 years agounicode: precomposed alchemical symbols for elements
Mischa POSLAWSKY [Mon, 17 Jan 2022 17:09:04 +0000 (18:09 +0100)]
unicode: precomposed alchemical symbols for elements

Semantic glyphs have been available since Unicode version 6.0 (2010)
so about time to replace these visual approximations.

2 years agocharset: map classic ti-8x calculators
Mischa POSLAWSKY [Sat, 8 Jan 2022 05:37:06 +0000 (06:37 +0100)]
charset: map classic ti-8x calculators

Closest unicode representations afaict, based on http://shiar.nl/calc/z80
images and guesses from manuals and emulators for unclear semantics.

2 years agocharset: legacy map ansel (and extensions)
Mischa POSLAWSKY [Sat, 8 Jan 2022 04:00:39 +0000 (05:00 +0100)]
charset: legacy map ansel (and extensions)

Reference: Wikipedia, <https://www.gedsite.com/en/character-encoding.htm>

2 years agocharset: compare unknown glyphs in custom tables
Mischa POSLAWSKY [Wed, 29 Dec 2021 18:35:36 +0000 (19:35 +0100)]
charset: compare unknown glyphs in custom tables

Ignore missing classes in Perl v5.28 for Unicode v13.0 legacy computing
symbols, while keeping unassigned code points in unicode blocks (various
gaps in Greek overview).

2 years agocharset: skip empty petscii rows
Mischa POSLAWSKY [Wed, 29 Dec 2021 18:28:12 +0000 (19:28 +0100)]
charset: skip empty petscii rows

Fix startpoint offset.

2 years agocharset: fix unicode name in cell title
Mischa POSLAWSKY [Wed, 29 Dec 2021 18:05:59 +0000 (19:05 +0100)]
charset: fix unicode name in cell title

Broken in commit v1.11-65-g57d7837d68 (2019-07-03)
[charset: silence warning of empty cell arguments].

2 years agocharset: legacy encodings petscii, atascii, msx, zx-spectrum
Mischa POSLAWSKY [Tue, 28 Dec 2021 15:24:38 +0000 (16:24 +0100)]
charset: legacy encodings petscii, atascii, msx, zx-spectrum

Sources now represented by unicode 13.0 legacy computing symbols.
Copied from Wikipedia.