sheet.git
2 years agoword: allow browser access to json data
Mischa POSLAWSKY [Tue, 27 Apr 2021 23:12:24 +0000 (01:12 +0200)]
word: allow browser access to json data

2 years agofont: ignore data sources for coverage rebuild
Mischa POSLAWSKY [Sat, 3 Jul 2021 00:06:20 +0000 (02:06 +0200)]
font: ignore data sources for coverage rebuild

Assume changes in data/font will refresh the directory mtime, so will
trigger without requiring individual includes which are optional and may not
be able to build (due to broken symlinks or parse errors) which cannot be
resolved.  Manual reinitialisation can also be forced by make data/font/all.

2 years agotools: limit download make rules to once every 2 hours
Mischa POSLAWSKY [Sat, 3 Jul 2021 00:05:29 +0000 (02:05 +0200)]
tools: limit download make rules to once every 2 hours

2 years agoword: database update triggers re-make
Mischa POSLAWSKY [Fri, 2 Jul 2021 19:26:48 +0000 (21:26 +0200)]
word: database update triggers re-make

2 years agoword/edit: story column to store text descriptions
Mischa POSLAWSKY [Fri, 2 Jul 2021 16:54:43 +0000 (18:54 +0200)]
word/edit: story column to store text descriptions

Copy Wikipedia intros as basic summary, for additional details/flavour
after guessing in future quizzes?

2 years agoword/edit: subpage alias to writer functionality
Mischa POSLAWSKY [Fri, 2 Jul 2021 16:54:30 +0000 (18:54 +0200)]
word/edit: subpage alias to writer functionality

2 years agoword: reorder table columns
Mischa POSLAWSKY [Fri, 2 Jul 2021 16:03:55 +0000 (18:03 +0200)]
word: reorder table columns

2 years agoword: translations from _word_ref view coalescing parent values
Mischa POSLAWSKY [Fri, 2 Jul 2021 15:56:16 +0000 (17:56 +0200)]
word: translations from _word_ref view coalescing parent values

2 years agoword: option ?lang selects alternate wordlist includes
Mischa POSLAWSKY [Tue, 20 Oct 2020 20:45:09 +0000 (22:45 +0200)]
word: option ?lang selects alternate wordlist includes

2 years agoword: generate wordlist includes of different languages
Mischa POSLAWSKY [Mon, 26 Oct 2020 03:44:28 +0000 (04:44 +0100)]
word: generate wordlist includes of different languages

2 years agoword: document some ideas for future contents
Mischa POSLAWSKY [Thu, 3 Jun 2021 01:04:19 +0000 (03:04 +0200)]
word: document some ideas for future contents

Start tracking random notes publicly.

2 years agoperl: v5.32 release and additional features
Mischa POSLAWSKY [Tue, 16 Mar 2021 03:48:05 +0000 (04:48 +0100)]
perl: v5.32 release and additional features

3 years agobrowser: ignore metadata columns in usage data
Mischa POSLAWSKY [Tue, 29 Sep 2020 15:33:54 +0000 (17:33 +0200)]
browser: ignore metadata columns in usage data

Fix inflated total or even code errors due to missing values.

3 years agobrowser: fix regexp for case insensitive search
Mischa POSLAWSKY [Tue, 29 Sep 2020 16:04:27 +0000 (18:04 +0200)]
browser: fix regexp for case insensitive search

Ignored when applied to match function, even following a RegExp.

3 years agoword: validate source values as http urls
Mischa POSLAWSKY [Mon, 15 Jun 2020 22:24:42 +0000 (00:24 +0200)]
word: validate source values as http urls

3 years agoword: apply subselection before shuffle
Mischa POSLAWSKY [Tue, 20 Oct 2020 20:36:23 +0000 (22:36 +0200)]
word: apply subselection before shuffle

3 years agoword: make rule to generate perl include
Mischa POSLAWSKY [Fri, 16 Oct 2020 22:33:40 +0000 (00:33 +0200)]
word: make rule to generate perl include

Move to data/ for derived data.

3 years agoword edit: latin language option for scientific names
Mischa POSLAWSKY [Fri, 16 Oct 2020 22:25:18 +0000 (00:25 +0200)]
word edit: latin language option for scientific names

Exact identification of life forms by binomial nomenclature, most similar to
latin and represented by a pin.

3 years agoword edit: translation shorthand slash for alternate names
Mischa POSLAWSKY [Fri, 16 Oct 2020 06:08:18 +0000 (08:08 +0200)]
word edit: translation shorthand slash for alternate names

3 years agoword edit: apply image gravity for empty conversion array
Mischa POSLAWSKY [Fri, 16 Oct 2020 02:42:24 +0000 (04:42 +0200)]
word edit: apply image gravity for empty conversion array

Centered only for NULL values, not defined ARRAY[].

3 years agoword edit: unadvertised search option ?q
Mischa POSLAWSKY [Sat, 20 Jun 2020 15:18:53 +0000 (17:18 +0200)]
word edit: unadvertised search option ?q

3 years agosource: allow external website inclusion of json
Mischa POSLAWSKY [Mon, 17 Aug 2020 16:40:04 +0000 (18:40 +0200)]
source: allow external website inclusion of json

Header to permit data being used in modern browsers.

3 years agosource: keep original file encoding
Mischa POSLAWSKY [Sun, 30 Aug 2020 12:35:52 +0000 (14:35 +0200)]
source: keep original file encoding

Keep original utf8 as binary to prevent reconversion.

3 years agoword: database module to connect to postgres
Mischa POSLAWSKY [Sat, 20 Jun 2020 15:18:46 +0000 (17:18 +0200)]
word: database module to connect to postgres

Single configuration of authorisation details.

3 years agoword: quiz mode omitting titles in random order
Mischa POSLAWSKY [Wed, 17 Jun 2020 22:40:20 +0000 (00:40 +0200)]
word: quiz mode omitting titles in random order

3 years agoword: reduce size of parenthesised form part
Mischa POSLAWSKY [Wed, 17 Jun 2020 22:24:42 +0000 (00:24 +0200)]
word: reduce size of parenthesised form part

Syntax for optional elongation as in "rhino(ceros)" or "chimp(anzee)".

3 years agoword: identify thumbnail image files by id
Mischa POSLAWSKY [Mon, 15 Jun 2020 22:51:35 +0000 (00:51 +0200)]
word: identify thumbnail image files by id

3 years agoword: identify rows by id number
Mischa POSLAWSKY [Mon, 15 Jun 2020 22:34:40 +0000 (00:34 +0200)]
word: identify rows by id number

With the addition of more entries, names are no longer unique:
for example pink (colour and flower) in multiple categories.

3 years agoword edit: separate stylesheet for form styling
Mischa POSLAWSKY [Mon, 15 Jun 2020 22:05:38 +0000 (00:05 +0200)]
word edit: separate stylesheet for form styling

3 years agoword edit: null priority to inherit from parent
Mischa POSLAWSKY [Mon, 15 Jun 2020 21:55:13 +0000 (23:55 +0200)]
word edit: null priority to inherit from parent

3 years agoword edit: image source precede thumbnail convert options
Mischa POSLAWSKY [Mon, 15 Jun 2020 21:18:00 +0000 (23:18 +0200)]
word edit: image source precede thumbnail convert options

Required for combining operations such as -clut; same results otherwise.

3 years agoword: sitewide styling of images gallery
Mischa POSLAWSKY [Sun, 14 Jun 2020 12:05:25 +0000 (14:05 +0200)]
word: sitewide styling of images gallery

Move page styling to base stylesheet with gallery class.

3 years agoword edit: preserve wikipedia links in translation suggestions
Mischa POSLAWSKY [Sat, 13 Jun 2020 17:26:27 +0000 (19:26 +0200)]
word edit: preserve wikipedia links in translation suggestions

3 years agoword edit: present login form on unauthorised request
Mischa POSLAWSKY [Sat, 13 Jun 2020 14:39:46 +0000 (16:39 +0200)]
word edit: present login form on unauthorised request

User-friendly creation of access cookies.

3 years agoword edit: omit empty translation options
Mischa POSLAWSKY [Sat, 13 Jun 2020 14:32:47 +0000 (16:32 +0200)]
word edit: omit empty translation options

3 years agoword edit: user editlang enables language inputs
Mischa POSLAWSKY [Sat, 13 Jun 2020 14:12:09 +0000 (16:12 +0200)]
word edit: user editlang enables language inputs

3 years agoword edit: record entry creator and modification time
Mischa POSLAWSKY [Sat, 13 Jun 2020 14:10:53 +0000 (16:10 +0200)]
word edit: record entry creator and modification time

3 years agoword edit: restrict access by login cookie
Mischa POSLAWSKY [Sat, 13 Jun 2020 11:43:43 +0000 (13:43 +0200)]
word edit: restrict access by login cookie

3 years agoword edit: js appends more multiinput columns
Mischa POSLAWSKY [Sat, 13 Jun 2020 14:32:25 +0000 (16:32 +0200)]
word edit: js appends more multiinput columns

Enter multiple option without requiring intermedia saves.

3 years agoword edit: multiinput styling for configured columns
Mischa POSLAWSKY [Sat, 13 Jun 2020 11:02:38 +0000 (13:02 +0200)]
word edit: multiinput styling for configured columns

3 years agoword edit: convert posted input to unicode
Mischa POSLAWSKY [Sat, 13 Jun 2020 11:00:35 +0000 (13:00 +0200)]
word edit: convert posted input to unicode

3 years agoword: fit column(s) on smaller screen sizes
Mischa POSLAWSKY [Sat, 13 Jun 2020 08:42:41 +0000 (10:42 +0200)]
word: fit column(s) on smaller screen sizes

Minimise page margins to fit common (phone) viewport of 412px,
otherwise no columns to prevent decreased width and padding.

3 years agoword edit: inline style for multiple consecutive inputs
Mischa POSLAWSKY [Tue, 9 Jun 2020 07:41:18 +0000 (09:41 +0200)]
word edit: inline style for multiple consecutive inputs

3 years agoword edit: sql array values in multiple input fields
Mischa POSLAWSKY [Tue, 9 Jun 2020 07:29:03 +0000 (09:29 +0200)]
word edit: sql array values in multiple input fields

3 years agoword edit: -area option crops thumbnails with relative offsets
Mischa POSLAWSKY [Tue, 9 Jun 2020 07:27:21 +0000 (09:27 +0200)]
word edit: -area option crops thumbnails with relative offsets

Preferred viewport configuration replacing unmaintainable combinations of
-crop, -chop, -shave, &al.

3 years agoword edit: hashes for all column definitions
Mischa POSLAWSKY [Sun, 7 Jun 2020 12:18:44 +0000 (14:18 +0200)]
word edit: hashes for all column definitions

Silence warnings during subcolumn handling.

3 years agoword edit: copy translations from wikipedia download
Mischa POSLAWSKY [Sun, 7 Jun 2020 12:17:08 +0000 (14:17 +0200)]
word edit: copy translations from wikipedia download

3 years agocommon: fix double html headers on plp errors
Mischa POSLAWSKY [Sat, 29 Aug 2020 16:29:22 +0000 (18:29 +0200)]
common: fix double html headers on plp errors

The exception added in commit v1.9-254-g560ad76852 (2017-05-29)
[common: html page headers on plp errors] seems unneeded (now?);
maybe for different server/version/environment setup?

3 years agocommon: enable perl stricture and fix resulting errors
Mischa POSLAWSKY [Sat, 6 Jun 2020 02:26:59 +0000 (04:26 +0200)]
common: enable perl stricture and fix resulting errors

3 years agoword edit: delete empty entries if confirmed
Mischa POSLAWSKY [Sun, 31 May 2020 03:37:46 +0000 (05:37 +0200)]
word edit: delete empty entries if confirmed

3 years agoword: two-letter language codes
Mischa POSLAWSKY [Sun, 31 May 2020 03:37:02 +0000 (05:37 +0200)]
word: two-letter language codes

Match Wikipedia subdomains and common browser headers.

3 years agoword: debugging stylesheet to colourise levels
Mischa POSLAWSKY [Fri, 29 May 2020 02:07:26 +0000 (04:07 +0200)]
word: debugging stylesheet to colourise levels

3 years agoword edit: visit button to open linked wikipedia page
Mischa POSLAWSKY [Sat, 30 May 2020 22:22:44 +0000 (00:22 +0200)]
word edit: visit button to open linked wikipedia page

3 years agoword edit: translation entry in referrer form
Mischa POSLAWSKY [Sat, 30 May 2020 22:21:42 +0000 (00:21 +0200)]
word edit: translation entry in referrer form

3 years agoword edit: flags in language selection
Mischa POSLAWSKY [Sat, 30 May 2020 20:30:57 +0000 (22:30 +0200)]
word edit: flags in language selection

3 years agoword edit: columns declare nested suboptions
Mischa POSLAWSKY [Sat, 30 May 2020 18:51:20 +0000 (20:51 +0200)]
word edit: columns declare nested suboptions

3 years agoword edit: named form input options
Mischa POSLAWSKY [Sat, 30 May 2020 16:59:21 +0000 (18:59 +0200)]
word edit: named form input options

Parameters replaced by prefixed -label and -option;
other attributes are appended literally.

3 years agoword edit: common method to determine image paths
Mischa POSLAWSKY [Sat, 30 May 2020 16:45:52 +0000 (18:45 +0200)]
word edit: common method to determine image paths

3 years agoword edit: common function to format form input
Mischa POSLAWSKY [Sat, 30 May 2020 07:02:32 +0000 (09:02 +0200)]
word edit: common function to format form input

3 years agoword edit: enlarge and align columns, thumbnail
Mischa POSLAWSKY [Sat, 30 May 2020 06:30:56 +0000 (08:30 +0200)]
word edit: enlarge and align columns, thumbnail

3 years agoword edit: list and link translation references
Mischa POSLAWSKY [Sat, 30 May 2020 06:29:30 +0000 (08:29 +0200)]
word edit: list and link translation references

3 years agoword: order siblings by grade
Mischa POSLAWSKY [Sat, 30 May 2020 06:27:30 +0000 (08:27 +0200)]
word: order siblings by grade

Optional precedence before alphabetical neutral.

3 years agoword: restrict by priority level
Mischa POSLAWSKY [Fri, 29 May 2020 05:14:37 +0000 (07:14 +0200)]
word: restrict by priority level

Default to commonly known concepts (level 3) unless overridden by ?v.

3 years agoword edit: group reference input with category
Mischa POSLAWSKY [Fri, 29 May 2020 05:12:47 +0000 (07:12 +0200)]
word edit: group reference input with category

3 years agoword edit: hide original image until requested
Mischa POSLAWSKY [Fri, 29 May 2020 05:10:27 +0000 (07:10 +0200)]
word edit: hide original image until requested

3 years agoword edit: separate javascript include
Mischa POSLAWSKY [Fri, 29 May 2020 05:08:12 +0000 (07:08 +0200)]
word edit: separate javascript include

3 years agoword edit: cover option changes thumbnail
Mischa POSLAWSKY [Wed, 27 May 2020 22:51:55 +0000 (00:51 +0200)]
word edit: cover option changes thumbnail

3 years agoword edit: capture image convert error messages
Mischa POSLAWSKY [Wed, 27 May 2020 17:48:12 +0000 (19:48 +0200)]
word edit: capture image convert error messages

3 years agoword: enlarge marked cover images
Mischa POSLAWSKY [Wed, 27 May 2020 16:44:47 +0000 (18:44 +0200)]
word: enlarge marked cover images

3 years agoword: grid layout to strictly align multiple rows
Mischa POSLAWSKY [Tue, 26 May 2020 09:16:51 +0000 (11:16 +0200)]
word: grid layout to strictly align multiple rows

3 years agoword: distinguish include and images by language
Mischa POSLAWSKY [Tue, 26 May 2020 07:27:17 +0000 (09:27 +0200)]
word: distinguish include and images by language

Prepare for translations with different visualisations.

3 years agoword edit: dynamically aligned form styling (emulate table)
Mischa POSLAWSKY [Tue, 26 May 2020 07:24:43 +0000 (09:24 +0200)]
word edit: dynamically aligned form styling (emulate table)

3 years agoword edit: language input as wikipedia domain
Mischa POSLAWSKY [Mon, 25 May 2020 14:03:38 +0000 (16:03 +0200)]
word edit: language input as wikipedia domain

3 years agoword: form synonyms from alt column
Mischa POSLAWSKY [Thu, 28 May 2020 04:51:01 +0000 (06:51 +0200)]
word: form synonyms from alt column

Support any number of alternatives (for now all shown in small font).

3 years agoword: select mkwordlist forms from _cat_words view
Mischa POSLAWSKY [Mon, 25 May 2020 03:24:51 +0000 (05:24 +0200)]
word: select mkwordlist forms from _cat_words view

3 years agoword edit: prio(rity level) column input
Mischa POSLAWSKY [Mon, 25 May 2020 03:23:02 +0000 (05:23 +0200)]
word edit: prio(rity level) column input

3 years agoword edit: recover form after save error
Mischa POSLAWSKY [Mon, 25 May 2020 03:22:47 +0000 (05:22 +0200)]
word edit: recover form after save error

3 years agoword edit: replace altered source images
Mischa POSLAWSKY [Sun, 24 May 2020 20:33:20 +0000 (22:33 +0200)]
word edit: replace altered source images

3 years agoword edit: hierarchy navigation (parent and children)
Mischa POSLAWSKY [Sun, 24 May 2020 19:48:13 +0000 (21:48 +0200)]
word edit: hierarchy navigation (parent and children)

3 years agoword edit: select wikipedia images from overlay
Mischa POSLAWSKY [Sun, 24 May 2020 08:17:43 +0000 (10:17 +0200)]
word edit: select wikipedia images from overlay

3 years agoword edit: wikipedia copy button
Mischa POSLAWSKY [Sun, 24 May 2020 07:22:56 +0000 (09:22 +0200)]
word edit: wikipedia copy button

Automatically find a matching title and return the first image from article
contents.

3 years agoword edit: copycat button to save and start a similar entry
Mischa POSLAWSKY [Sun, 24 May 2020 04:15:57 +0000 (06:15 +0200)]
word edit: copycat button to save and start a similar entry

Option to retain language and category.

3 years agoword edit: download images from url input
Mischa POSLAWSKY [Sun, 24 May 2020 01:54:24 +0000 (03:54 +0200)]
word edit: download images from url input

3 years agoword edit: form stylesheet for aligned input fields
Mischa POSLAWSKY [Sun, 24 May 2020 01:58:41 +0000 (03:58 +0200)]
word edit: form stylesheet for aligned input fields

3 years agoword edit: fix image convert arrays
Mischa POSLAWSKY [Sun, 24 May 2020 04:16:28 +0000 (06:16 +0200)]
word edit: fix image convert arrays

3 years agoword: writer page to edit database entries
Mischa POSLAWSKY [Sun, 24 May 2020 01:49:31 +0000 (03:49 +0200)]
word: writer page to edit database entries

Initial form to maintain a larger amount of words.

3 years agoword: maintain wordlist in postgres database
Mischa POSLAWSKY [Mon, 25 May 2020 03:25:31 +0000 (05:25 +0200)]
word: maintain wordlist in postgres database

A static perl file is insufficient considering future plans.
Start tracking names and image sources for possible collaboration;
the same include syntax is generated from that.

3 years agoword: mkimg-google from duckduckgo
Mischa POSLAWSKY [Sat, 23 May 2020 03:15:24 +0000 (05:15 +0200)]
word: mkimg-google from duckduckgo

Alternate search engine to maybe find better (maybe more free?) images.

3 years agoword: mkimg-google tool to download images
Mischa POSLAWSKY [Sat, 23 May 2020 03:06:00 +0000 (05:06 +0200)]
word: mkimg-google tool to download images

Automatic population with top results searching each term:

perl -E 'sub flat {map { ref ? flat(@$_) : $_ } @_}
say for flat do "./wordlist.inc.pl"'

Good for testing; definitely requires further moderation to release:
avoiding false friends (e.g. mug commonly isn't a midge), finding better
representations, and at least nicely cropping to aspect ratio.

3 years agoword: hover related parents and children
Mischa POSLAWSKY [Sat, 23 May 2020 03:03:01 +0000 (05:03 +0200)]
word: hover related parents and children

3 years agoword: organism gallery (categorised grid layout)
Mischa POSLAWSKY [Sat, 23 May 2020 02:02:42 +0000 (04:02 +0200)]
word: organism gallery (categorised grid layout)

Expansion of dieren page starting a more complete collection of terms.
Populated by most common animals and plants based on DK visual dictionaries.

4 years agodieren: image figures captioned by names v1.12
Mischa POSLAWSKY [Mon, 4 May 2020 21:01:22 +0000 (23:01 +0200)]
dieren: image figures captioned by names

4 years agodieren: various animal improvements and additions
Mischa POSLAWSKY [Mon, 4 May 2020 20:07:47 +0000 (22:07 +0200)]
dieren: various animal improvements and additions

4 years agodieren: reindent table data to align column names
Mischa POSLAWSKY [Mon, 4 May 2020 18:59:09 +0000 (20:59 +0200)]
dieren: reindent table data to align column names

4 years agodieren: subpage names to indicate verbosity
Mischa POSLAWSKY [Sat, 2 May 2020 23:22:00 +0000 (01:22 +0200)]
dieren: subpage names to indicate verbosity

4 years agodieren: additional words, underscore replaced by space
Mischa POSLAWSKY [Sat, 2 May 2020 22:21:50 +0000 (00:21 +0200)]
dieren: additional words, underscore replaced by space

4 years agodieren: mkimgthumb escape to support colons in parameters
Mischa POSLAWSKY [Sat, 2 May 2020 23:22:11 +0000 (01:22 +0200)]
dieren: mkimgthumb escape to support colons in parameters

Backslash to allow the occasional `-define modulate:colorspace=HSB`
as :-define:module\:colorspace=HSB.

4 years agodieren: mkimgthumb number suffix as crop shorthand
Mischa POSLAWSKY [Sat, 2 May 2020 22:22:01 +0000 (00:22 +0200)]
dieren: mkimgthumb number suffix as crop shorthand

Simplifies vleerhond:-crop:70%x0:-chop:20%x30% to vleerhond:12x30x30x0
and many more.

4 years agodieren: mkimgthumb test option to override parameters
Mischa POSLAWSKY [Sat, 2 May 2020 22:19:30 +0000 (00:19 +0200)]
dieren: mkimgthumb test option to override parameters

Find files regardless of given :* suffixes, so commands can be executed
without having to rename.

4 years agodieren: relay errors during image conversion
Mischa POSLAWSKY [Sat, 2 May 2020 16:43:45 +0000 (18:43 +0200)]
dieren: relay errors during image conversion