wbolster

i doubt there's a noticeable difference after applying any "dumb" file compression scheme, e.g. brotli/gzip

this can be solved on the file system layer below.

on my laptop with btrfs this requires no special effort: simply copying the files and renaming them suffices. nautilus (gnome file manager) uses copy on write, and coreutils "cp" also defaults to "reflink" these days.

not sure about mysql, but in postgresql an update on a table with a foreign key will take 'FOR KEY SHARE' locks on the referenced table, which is a weaker type of lock. updates on the referenced table that do not update (primary) key columns (changing a pk is very uncommon anyway) will suffice with a 'FOR NO KEY UPDATE' lock, which does not get blocked by 'FOR KEY SHARE' locks. in fact, the main reason postgresql has these weaker 'FOR KEY SHARE' and 'FOR NO KEY UPDATE' lock types is for handing of foreign keys.

thank you, random stranger, for sharing your gnu/extremism.

while i am in no way defending software patents (which I don't like at all), i find the full-frontal attack attitude that you and many other gnu/zealots exhibit towards random strangers on the internet so infuriating that i am writing this comment here to let you know that people like you are exactly what prevents me (and many others) from getting involved in some free (libre) software projects.

thanks so much for your contribution to the advancement of libre software.

yuck.

this is a very important point. i tried swiping in my phone using the colemak keyboard layout which i use on normal keyboards, and found it utterly unusable because the prediction quality dramatically goes down. this is most likely caused by the lack of shapes made with the swiping gestures: colemak has the most common letters on the home row so on practice you're mostly swiping left/right.

thanks for writing this down. i completely agree with you.

i am a happy emacs and magit user. i contribute to emacs packages, and maintain a few myself (emacs-direnv, evil-swap-keys, evil-colemak-basics, evil-text-object-python).

i do all this DESPITE emacs being a fsf/gnu project. i strongly dislike the old-fashioned processes, the extreme stances on things that i do not consider problems, and last but not least, the very negative and non-inclusive community.

the remarks by rms that a magit alternative/competitor would be welcome is POISONOUS. advocating for an unnecessary community divide is destructive for the goodwill of many (potential) contributors to the emacs ecosystem (myself included).

keep in mind that normal keyboard activity is completely different than typing a piece of text from the first letter to the last letter in one go. being efficient with navigation, moving text around, and so on, is just as important, so invest in learning vim, emacs or any other editor that makes sense for you. unfortunately keyboard layout analysers do not capture those key presses, making the results very skewed.