sheet.git
12 months agotermcol: cga appearance on IBM-5153 monitors
Mischa POSLAWSKY [Mon, 27 Mar 2023 00:08:01 +0000 (02:08 +0200)]
termcol: cga appearance on IBM-5153 monitors

12 months agotermcol: retro palette pyxel derived from pico8
Mischa POSLAWSKY [Thu, 16 Feb 2023 21:27:34 +0000 (22:27 +0100)]
termcol: retro palette pyxel derived from pico8

12 months agodieren: found specific rivier(donder)pad species
Mischa POSLAWSKY [Sat, 8 Apr 2023 11:50:54 +0000 (13:50 +0200)]
dieren: found specific rivier(donder)pad species

12 months agocodec: page specific keywords from include data
Mischa POSLAWSKY [Sun, 19 Mar 2023 14:27:25 +0000 (15:27 +0100)]
codec: page specific keywords from include data

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.

13 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

13 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.

13 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.

21 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

21 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

21 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

21 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

21 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

21 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

21 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

21 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.

21 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

21 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

21 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

21 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

21 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

21 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

21 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

21 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

21 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

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

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

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

21 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

21 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.

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

21 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

22 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

22 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

22 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

22 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

22 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

22 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.

22 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

22 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

22 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.

22 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

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

22 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

22 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

22 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].

22 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.

22 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.

22 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.

14 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.

14 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.

14 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.

14 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.

22 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.

22 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

22 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

22 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)

22 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.

22 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.

22 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.

22 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>